MySQL for Developers will be useful for anyone who wants to truly master SQL using MySQL. The course covers relational database design, implementation of a database design, and the skills necessary to use a MySQL database as a backend to an application. Along with SQL query skills, the attendee will also learn about query optimization and importing and exporting data.
Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in the creation of a Windows 10 VM configured to support the hands-on activities. A cloud-based VM is also available for the attendees to use, which can be purchased separately.
- Relational Database Design: Create a relational database schema then implement that design in MySQL.
- SQL Queries: Covers both basic and advanced SQL queries. Understanding table joins and aliases, creating grouping based queries using aggregate functions.
- Data Manipulation: Work with INSERT, UPDATE, DELETE and TRUNCATE commands. Discover how to handle duplicate data. Understand handling transaction based commands.
- SQL Programming: Data types, operators, and flow control statements. Using set operators and sub-queries. Accessing MySQL using Python.
- Accessing Metadata: Get information about your schema structure and database objects using the SHOW commands and the INFORMATION_SCHEMA tables.
- MySQL Objects: Create and use Views, Functions, Stored Procedures, and Triggers.
- Query Optimization: Covers analyzing queries, indexing, and understanding query plans in order to create efficient queries.
- Export and Import Data: Move data into and out of your MySQL database.
Module 1: Introduction to Relational Databases
- Why a Relational Database?
- Relational Database Management Systems
- MySQL Community and Workbench
Module 2: Modeling a Relational Database
- What is the Relational Model?
- The Entity-Relationship Model
- Designing the Database Schema
Module 3: SQL Language
- About SQL
- Basic Query Syntax
- Querying with MySQL Workbench
Module 4: Implementing Database Design
- Reviewing the Database Design
- Creating a Database
- Creating Tables
- Creating Indexes
Module 5: Data Modification
- Modifying Data
- Handling Duplicate Values and Rows
- Handling Transactions
Module 6: Advanced Queries
- Table Joins and Aliases
- Grouping and Aggregating
- Set Operations
- Sub-queries and Derived Tables
Module 7: Data Types and Variables
- Data Types
- Data Type Conversion
Module 8: Flow Control and Iteration
- Decision Making
Module 9: Viewing Data
- Accessing Metadata
Module 10: SQL Programming
- Stored Procedures
- MySQL and Python
Module 11: Query Optimization
- Optimizing SQL Queries
- EXPLAIN ANALYZE
Module 12: Importing and Exporting Data
- Importing Data
- Exporting Data
- MySQL Workbench Wizard
No prior knowledge of MySQL or SQL is assumed.