Instructor-led training

MySQL for Developers

Data training from Hartmann Software Group, delivered onsite or live online.

Request a Training Proposal View Course Outline

What you'll learn

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.

Prerequisites

None

Course Outline

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
Variables
Data Type Conversion

Module 8: Flow Control and Iteration

Operators
Decision Making
Iteration

Module 9: Viewing Data

Views
Functions
Accessing Metadata

Module 10: SQL Programming

Stored Procedures
Triggers
MySQL and Python

Module 11: Query Optimization

Optimization
Optimizing SQL Queries
EXPLAIN ANALYZE

Module 12: Importing and Exporting Data

Importing Data
Exporting Data
MySQL Workbench Wizard

Training locations