From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Creating the initial schemas

Creating the initial schemas - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Creating the initial schemas

“

- [Instructor] All right, now we're going to be running the SQL file that will create the databases, aka, schemas, that you'll be using throughout the rest of the course. If you haven't already downloaded the Create Maven Consulting SQL file from the course Resources section, go ahead and do that now. And then let's jump into Workbench and I'll show you how to run that file to install the databases. So again, your instance of MySQL Workbench should look very similar to mine, but you won't have the Maven Fuzzy Factory or the Maven Movies databases installed. Those are from my beginner SQL for data analysis courses and my advanced SQL for analytics and business intelligence courses. So don't worry if you don't see those. You will see sys here and you should be in good shape. So let's go up to File and then we'll use Open SQL Script. And I've got the Maven Consulting version April, 2022 file here in a Maven Downloads folder. So just go ahead and open that up. So in this file, we've got a…

Contents