MySQL Essential Training
Illustration by Don Barnett

MySQL Essential Training

with Bill Weinman

Video: Installing SID on Windows

In this movie, I'll show you how to And that's where everything goes that can be seen by the web server.
Expand all | Collapse all
  1. 4m 22s
    1. Welcome
      1m 3s
    2. Using the exercise files
      1m 31s
    3. What is MySQL?
      1m 48s
  2. 45m 37s
    1. Installation overview
      3m 16s
    2. Installing XAMPP on Windows
      5m 55s
    3. Installing XAMPP on the Mac
      6m 38s
    4. Setting up MySQL users
      11m 31s
    5. Installing SID on Windows
      5m 43s
    6. Installing SID on the Mac
      6m 6s
    7. Installing time zone support in MySQL on Windows
      6m 28s
  3. 45m 43s
    1. The SELECT statement
      3m 57s
    2. Selecting rows
      4m 57s
    3. Selecting columns
      3m 8s
    4. Sorting results with ORDER BY
      2m 58s
    5. Filtering results with WHERE
      3m 52s
    6. Filtering results with LIKE and IN
      3m 41s
    7. Filtering results with regular expressions
      8m 21s
    8. Inserting rows
      4m 9s
    9. Updating rows
      2m 21s
    10. Deleting rows
      2m 25s
    11. Literal strings
      3m 12s
    12. Understanding NULL
      2m 42s
  4. 41m 47s
    1. Creating a database
      4m 30s
    2. Creating a table
      7m 18s
    3. Creating indexes
      6m 8s
    4. Controlling column behavior with constraints
      4m 46s
    5. Creating an ID column
      6m 58s
    6. Using foreign key constraints
      7m 58s
    7. Altering a table
      4m 9s
  5. 28m 56s
    1. What are data types?
      4m 1s
    2. Numeric types
      5m 21s
    3. String types
      2m 58s
    4. Date and time types
      7m 2s
    5. Bit type
      2m 26s
    6. Boolean values
      2m 15s
    7. Enumeration types
      4m 53s
  6. 32m 34s
    1. String functions
      6m 57s
    2. Numeric functions
      6m 2s
    3. Date and time functions
      4m 12s
    4. Time zones in MySQL
      3m 37s
    5. Formatting dates
      1m 51s
    6. Aggregate functions
      5m 45s
    7. Flow control with CASE
      4m 10s
  7. 7m 6s
    1. Maintaining database integrity with transactions
      4m 46s
    2. Using transactions for performance
      2m 20s
  8. 16m 49s
    1. Updating a table with a trigger
      5m 11s
    2. Preventing automatic updates with a trigger
      7m 29s
    3. Logging transactions with a trigger
      4m 9s
  9. 14m 11s
    1. Creating a simple subselect
      3m 23s
    2. Searching within a result set
      3m 53s
    3. Creating a view
      3m 32s
    4. Creating a joined view
      3m 23s
  10. 12m 26s
    1. Understanding MySQL stored routines
      2m 0s
    2. Creating a stored function
      4m 34s
    3. Creating a stored procedure
      5m 52s
  11. 14m 4s
    1. The multi-platform PDO interface
      3m 44s
    2. Executing the SQL
      4m 8s
    3. Implementing auto-increment IDs
      2m 3s
    4. Using a stored funciton
      4m 9s
  12. 1m 3s
    1. Goodbye
      1m 3s

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now
please wait ...
Watch the Online Video Course MySQL Essential Training
4h 24m Beginner May 14, 2014

Viewers: in countries Watching now:

MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines. Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.

Topics include:
  • 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
Bill Weinman

Installing SID on Windows

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. And we're going to install these in the xanp folder and under xanp. See a folder called htdocs. And that's where everything goes that can be seen by the web server. And so that's where our applications are going to get installed, so I'm going to come over here to our exercise files, I'm going to take these two folders, SID and CRUD. I'm holding down the Ctrl key as I select them so that I get both of those folders, and.

There into our HT docs folder I'm just going to drag those. I'm going to hold down the Ctrl key while I drag them so that they get copied, and not moved. So, now we have copies of them and you see that they still exist here in the exercise files. And that's important. Because if, for some reason you make a mistake while editing them or something, you've still got another copy of them. They're not very big. So we'll start in the SID folder. And we're going to edit this sid.php. I've got it configured here so that when I, open a php file it, opens it with, Notepad++.

Or you can right click on this and you can select Open with. And under more options you can find out how to open it with Notepad++ the application. So I'm just going to go ahead and open this with Notepad++ and there's our sid.php and as I scroll down here. Somewhere around line 50 you'll see something that says MySQL pass and you notice that the user's already set to SID but you want to make sure that the user is set to SID and then the password is going to be that password that you entered in the lesson on setting up the users.

And I'm going to enter the silly password that I entered there, press Ctrl+S to save, and again don't use this password, this is just for demonstration purposes. And so I'm going to go ahead and close SID, and I'm going to Open. See if this will give me the same directory. It does. So under htdocs I'm going to come over here to CRUD. And I'm going to open Crud.php and you notice that the user here is Web and the password is going to be whatever password you entered for Web. And I'm going to enter my silly password.

Ctrl+S to Save, close that, close this, close this, and bring up the web browser. Now here I can type in localhost, and I'm going to type a slash and SID in all caps and another slash and sid lowercase .php and that's the path to the SID application there. In the htdocs which is where web server reads all files from. And I press Enter and there we have SID, and SID is working and we can see it's bringing up the database.

I can bring up the album database here and just type in a query, SELECT asterisk FROM track and press Go and there's all the tracks. In our track table in the album database. And I can test each of these different databases here. From the scratch database, I can use the customer table. And I get results. And from the world database, I can use the City table. There's a very long list of over 4,000 cities. You'll notice we have a little status line here.

It tells us how many rows are returned and the elapsed time. And so the SID application's working. I can drag this out onto my toolbar. And now, every time I press that, I get this SID application. And I can go ahead and. Get to the CRUD application, which is all caps CRUD/crud.php press Enter up here, there we go. There's our CRUD application. CRUD of course stands for create, read, update, delete that's the. Four basic functions of any database system.

And here we have, this is authenticating with the web user, you remember. And it's using the album database. And so if I come over here to this album, you notice there's the tracks in the album. And this application is working as well. And I can bring this down here and I can put it in my toolbar. So I've got CRUD and I've got SID, and I can get to those. From my toolbar very easily. So now that SID is installed and working you have everything you need to follow along with the exercises in this course. So, let's get started

There are currently no FAQs about MySQL Essential Training.

Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

* Estimated file size

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.

Mark all as unwatched Cancel


You have completed MySQL Essential Training.

Return to your organization's learning portal to continue training, or close this page.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.