Course Overview

Today, MySQL is the world’s most popular open-source database, especially for web applications. This course covers the entire range of MySQL fundamentals and concepts, while walking you through explicit examples of each.  Whether you are a beginner at MySQL, or an experienced MySQL developer who has not yet mastered all of its features (especially the ones that have been added in the past few years), this is the course for you.

Key Learning Areas

  • Write SQL statements that retrieve, insert, update, and delete database data
  • Code complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less
  • Handle the problems you typically encounter with various types of data
  • Use MySQL functions for everyday tasks like rounding numbers or formatting dates
  • Use foreign keys to maintain referential integrity
  • Design a database and code the SQL statements that create its tables and indexes, skills that make you a more effective SQL developer, even if these tasks are done by a DBA where you’re working
  • Work with an ER model and its related diagrams
  • Create views that simplify data access and improve data security
  • Use stored procedures, custom functions, triggers, and events to improve developer productivity
  • Use transactions to maintain data integrity
  • Handle basic DBA tasks like database configuration, security, and backups

Course Outline

  • Introduction to relational databases and SQL
  • How to use MySQL Workbench and other development tools
  • Retrieve data from a single table
  • Retrieve data from two or more tables
  • Code summary queries
  • Code subqueries
  • How to insert, update, and delete data
  • Work with data types
  • How to use functions
  • Design a database
  • Create databases, tables, and indexes
  • Create views
  • Language skills for writing stored programs
  • Using transactions and locking
  • Create stored procedures and functions
  • Create triggers and events
  • Introduction to database administration
  • Securing a database
  • How to back up and restore a database

Who Benefits

A good choice for anyone who wants to learn standard SQL.  In fact, 90% of what you learn here can be transferred to another database management system such as Oracle or SQL Server.

For anyone who wants to become a database administrator. Although the course doesn't cover all the issues that DBAs have to deal with, it gives you the solid foundation in database design and management that you need to build on.

Ideal course for application developers who need to work with a MySQL database.

If you’re new to MySQL, it will teach you everything from coding SQL statements to designing databases to using stored programs that save you time and effort.

If you have MySQL experience, the “paired-pages” format will make it easy for you to focus on the MySQL features and coding skills that are new to you.

Prerequisites

Everything you need to know about databases and MySQL is here, so you can gain the MySQL skills you need using this course and the associated book (which is provided when you take the course) alone.