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.
Introducing the course project - MySQL Tutorial
From the course: MySQL Database Administration
Introducing the course project
- [Instructor] Now, it's time to introduce the course project. Like all of my courses, I try to simulate a real-world experience because I think that's the best way for you to learn. In this situation, you're going to be hired by a small database consulting shop, and you'll be working on projects for a number of clients to help them get their databases built and optimize those databases for their businesses. Sometimes you'll be working with existing databases and you'll be making small improvements, and other times you'll start entirely from scratch and using database design principles from the ground up. You'll use MySQL Workbench to create databases and tables for your clients. You'll use your knowledge of database best practices to implement and optimize database design principles, and you'll update records, create indexes, triggers, and stored procedures, and you'll manage users and permissions to decide who gets access to the database. We'll start off with some pretty easy ones…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.