HARTMANN software group

MySQL for Developers Training

We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  
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.
Course Length: 4 Days
Course Tuition: $1890 (US)

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

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.