From the course: MySQL Advanced Topics

Exercise files - MySQL Tutorial

From the course: MySQL Advanced Topics

Start my 1-month free trial Buy for my team

Exercise files

“

- [Bill] Hi, I'm Bill Weidman. The exercise files are available as part of your LinkedIn Learning subscription. Please download the exercise files to your local workstation and remember where you saved them. I've saved them here on my desktop. Within the ExerciseFiles folder, 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 in the companion course, MySQL Essential Training, so you may already have imported them. If you've not already done this, please see the lesson Installing the Example Databases in the companion course, MySQL Installation and Configuration. 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 your Mac, or you may use Notepad or Notepad++ on a PC. I use BB Edit on my Mac. I'll be using the MySQL Workbench to run the exercises. Sometimes I'll paste several lines of code into the MySQL Workbench. In the Workbench, I can execute one line at a time by pressing ctrl enter on a PC or cmd enter on a Mac. I'll do that now and I'll execute this SELECT Hello World, and you can see it brings up the result. Or I can select a section of the file and execute more than one line at a time with shift ctrl enter on a PC or shift cmd enter on a Mac, and I'll do that now to execute these two lines here, and we've used the scratch database and we've executed the SHOW TABLES command to show the tables in that database. The exercise 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, or for larger blocks of code, you may copy and paste. The exercise files are here to make your learning experience easier and more powerful. Take your time, experiment a lot, and happy learning.

Contents