MySQL for Developers

MySQL for Developers Courseware (AMS-DB124)

DataMySQLSQL

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.

Publisher: Alliance Micro Solutions, Inc.

Benefits

  • 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.

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
     

Required Prerequisites

No prior knowledge of MySQL or SQL is assumed.

License

Length: 4 days | $160.00 per copy

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files
  • PowerPoint Presentation