From the course: MySQL Database Administration

Unlock this course with a free trial

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

Challenge: Creating your own schema and tables

Challenge: Creating your own schema and tables - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Creating your own schema and tables

“

- [Instructor] Alright, we are ready for your first assignment. So anytime you see a slide like this, it means it's going to be an assignment that you should take away. You'll work on it and then you can come back and watch the solution video. If you've taken one of my other courses, it's a very similar format, so this will be old hat, but for anybody who's new, this is how it will work. You'll get a prompt from one of your clients here, and remember, you're operating as a database consultant, so you'll have clients from various businesses that need you to do various things. You'll go off and work on it, and then I'll walk you through the solution in the next lecture. for this assignment, you've got Tom Strawberry, who's your first client. He needs some help creating a new schema called "Tom's Marketing Stuff." And then he'd like you to add two tables, a publisher's table, and a publisher spend table. The publisher's table should have a publisher ID, which would be an integer, and a…

Contents