From the course: MySQL Advanced Topics (2019)

Exercise files - MySQL Tutorial

From the course: MySQL Advanced Topics (2019)

Start my 1-month free trial Buy for my team

Exercise files

“

- The Exercise Files are available as part of your subscription. Please download the Exercise Files to your local workstation and remember where you saved them. I've saved them here on my desktop. The Databases folder contains the SQL source for the example databases used throughout this course. The Album, Scratch, and World databases. You'll need to import these databases into your MySQL installation. These are the same databases used by the companion course, MySQL Essential Training, so you may have already imported them. If you have not already done this, please see the lesson Installing the Example Databases in the companion course, MySQL Installation and Configuration. The rest of the Exercise Files contain one file for each chapter. Open the file with the text editor of your choice. Do not use a word processor. You may use Text Edit on a Mac or you may use Notepad or Notepad++ on a PC. I use BBEdit on my Mac. I'll be using the MySQL Workbench to run the exercises. And I'm logging in as an admin user, which I created during the installation movie. I'll just copy these lines here into the Workbench. Sometimes, I'll paste several lines of code into the Workbench. In the Workbench, I can execute one line at a time by pressing Control + Enter on a PC or Command + Enter on a Mac. There, I've executed that one line of SQL. Or I can execute all of the lines in a buffer with Shift + Control + Enter on a PC or Shift + Command + Enter on a Mac. So now, I'll execute all these statements and you notice, I have the result for the Hello, World and the result for the Show Tables. Or I can select a section of the file and execute just those lines with Shift + Control + Enter on a PC or Shift + Command + Enter on a Mac. And here I've just executed these two lines of SQL. These files are here for reference. They contain each of the SQL statements used in the course. I recommend you type the statements for the exercises as much as possible. For larger blocks of code, you may copy and paste. The Exercise Files are here to make your learning experience easier and more powerful. So, take your time, experiment a lot, and happy learning.

Contents