…MySQL can be complicated to install.…Because of it's client-server architecture, the database…server itself typically installed on a headless…server, that is a server without a screen or keyboard that is managed remotely.…The process of installing the MySQL server software very…significantly, and is dependent upon a number of factors including.…The server operating system, the server environment,…the database application, and many other considerations.…
For our purposes we're using MySQL in a learning environment…so this installation will be on a Desktop operating system.…Either Windows or Mac OS 10.…And it will be the same machine that you'll be using for testing.…So, even though MySQL is a database server, it will be running on…the same machine as the web client you'll be using for testing and learning.…For the purposes of following the exercises in this course, I…provided a web based MySQL client called SID SQL interactive demonstrator.…
SID is written in php.…So, in addition to requiring a MySQL server,…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.