Database Design: Taught by Joe Celko, SQL Expert and Author

• Do you want to learn how to design databases with solid foundations built on good SQL practices?
• Do you want to avoid creating databases with poor structure leading to difficulties in scaling and maintenance?
• Do you want to minimize the potential for inconsistent, inaccurate and corrupt data in your databases?
• Do you want to learn how to translate business rules into SQL constraints to minimize the need for external programming logic?

Then Database Design is for you!

The instructor-led course is designed for developers who wish to use sound database design principles while creating MySQL databases. This course will prepare each student with the skills needed to create databases that maintain data consistency, data integrity and data accuracy while improving SQL efficiency. Students will be provided with demonstrations and performance exercises that will support their ability to apply their learning immediately upon completion of the training.

At the completion of this course, you should be able to:

• Explain the terms associated with database design and the foundational theories they are based on
• Identify the relationship between the data structures and the data to be stored
• Classify constraints and logically connect the tables in the database
• Translate business rules into SQL constraints

Who should Attend

Developers and Database administrators who want to learn how to design a database with a solid foundation built on good SQL practices

Prerequisites

MySQL Beginners course (or equivalent)

Format

Instructor led, with interactive performance exercises

Each student will be provided with a task workbook to complete the performance exercises

Applies to MySQL Version:

4.0, 4.1, 5.0, 5.1

Duration

4 Hours

Upcoming Sessions