Join Bill Weinman for an in-depth discussion in this video Installing SID on Windows, part of MySQL Essential Training.
…In this movie, I'll show you how to…install the SID application on a PC running Windows.…First thing we're going to do is we're going to…bring up php My Admin, we're going to import some databases.…So I bring up Local Host and, I click on php MyAdmin.…I'm going to come over here to Import.…And choose File.…So there is three databases we're going to import.…I'm going to import each of these one at a time, so…I start with album MySQL, want to make sure the character set is…set to UTF-8 and if it's not you want to select that,…and I'll scroll down here and press Go and that import it.…
That first album database.…And now we're going to do the same thing…for the other two so, scratch, open, UTF-8, Go.…And, world.…Open.…UTF-8, and this one takes just a little bit longer.…And there we go.…So now if we come over here to…databases we see these databases that we just imported.…There's the album database, and the scratch database, and the world database.…
So I'l go ahead and close the browser for now, and…now we're going to install SID and another application called CRUD.…
- 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.