Course Length: 5 days or two 3 day classes

Summary

Section 1: An introduction to MySQL
In this section, you’ll learn the concepts and terms for working with any database. You’ll learn how to use MySQL Workbench to work with a database and run SQL statements. And you’ll learn the basic SQL skills for retrieving data from a database and for adding, updating, and deleting data. When you complete this section, you’ll be able to continue with any of the other sections in the course.

Section 2: More SQL skills as you need them
This section presents the advanced skills for retrieving data from a database. That includes working with summary queries, subqueries, data types, and functions. These skills are also sure to raise your expertise, even if you already have SQL experience.

Section 3: Database design and implementation
In this section, you’ll learn how to use MySQL Workbench to create an EER (enhanced entity-relationship) model for your database. Then, you’ll learn how to implement that design by using the DDL (Data Definition Language) statements that are a part of SQL. When you’re done, you’ll be able to design and implement your own databases, and you’ll have a new perspective on databases that will make you a better SQL programmer, even if you never have to design a database.

Section 4: Stored program development
In this section, you’ll learn how to use MySQL to create stored procedures, functions, triggers, and events. In addition, you’ll learn how to manage transactions and locking. These features let you create stored programs made up of multiple SQL statements that can be stored in the database and accessed as needed, either to run on their own or to use in application programs…a great productivity booster!

Section 5: Database administration
In this section, you’ll learn a starting set of skills for becoming a database administrator (DBA). These skills include how to secure a database, how to back up a database, and how to restore a database.

Who Should Attend?

Application developers
I think it’s fair to say that most developers don’t know enough about SQL and the database management system they’re using. As one customer put it, "I know just enough about SQL to be a little bit dangerous!" That’s why developers often code SQL statements that don’t perform as efficiently as they ought to. That’s why they aren’t able to code some of the queries that they need for their applications. And that’s why they don’t take advantage of all the features that MySQL has to offer. That’s also why our MySQL course should be required for every application programmer who uses MySQL. It shows you how to code the SQL statements that you need for your applications. It shows you how to code these statements so they run efficiently. And it shows you how to take advantage of the most useful advanced features that MySQL has to offer.

Anyone who wants to become a database administrator
This course is also the right first course for anyone who wants to become a database administrator. Although this course doesn’t present all of the advanced skills that are needed by a DBA, it will get you started. Once you’ve finished it, you’ll be prepared for more advanced courses on the subject.

Anyone who wants to learn standard SQL
This course is also a good choice for anyone who wants to learn standard SQL. Since SQL is a standard language for accessing database data, most of the SQL code in this course will work with any database management system. As a result, once you attend this course to learn how to use SQL to work with a MySQL database, you can transfer most of what you have learned to another DBMS such as Oracle, DB2, or Microsoft SQL Server.

What the prerequisites are
Although you will progress through this course more easily if you have some development experience, everything you need to know about databases and SQL is presented in this course. As a result, you don’t need to have any programming background to attend this course.

Course Outline