…In this movie I'll show you how to install the SID application on a Mac.…The first thing we need to do is import…the databases that are going to be used with SID.…So we're going to come over here, I've got…the XAMPP welcome screen up here in my browser.…I'm just going to click on php My Admin.…And some over here to import to import the databases that we're going to use.…There's 3 of them so I'll select choose file and this is…the exercise files that I have on my desktops if I were to…come to desktop exercise files that's the same thing and under sql…there's 3 databases here and these are the sql commands that create the databases.…
So I'll simply select the first one, and you can see a little preview of it there.…If I press the spacebar and I get the quick look, you can see the preview there.…This is just the SQL that's used to create this database.…And I press open.…Now here I want to make sure that I have UTF 8 selected.…So, if it's not selected on yours you'll want to select it.…And come down here and press the go button and that's imported that database.…
- 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.