AMS-DB124 MySQL for Developers


4 Days 


MySQL for Developers will be appreciated by anyone who wants to truly master SQL using MySQL. The course has no prerequisites and is thus intended for people with no prior experience as well as for those who have already dabbled in the field of databases and SQL. The acquired knowledge will be primarily beneficial for those working on or aspiring for the position of data or business analyst.

Hands On Environment

The course includes hands-on activities, allowing attendees to reinforce the concepts covered in the course content.

Course Outline 

Module 1: Introduction to Relational Databases

  • Why a Relational Database?
  • Relational Database Management Systems
  • Installing MySQL Community

Module 2: SQL Language  

  • About SQL
  • Basic Query Syntax
  • Querying with MySQL Workbench

Module 3 Data Modification

  • Modifying Data
  • Handling Duplicate Values and Rows
  • Handling Transactions

Module 4: Advanced Queries

  • Table Joins and Aliases
  • Grouping and Aggregating
  • Set Operations
  • Subqueries and Derived Tables

Module 5: Data Types and Variables

  • Data Types
  • Variables
  • Data Type Conversion

Module 6: Flow Control and Iteration

  • Operators
  • Decision Making
  • Iteration

Module 7: Viewing Data

  • Views
  • Functions
  • Accessing Metadata

Module 8: SQL Programming

  • Stored Procedures
  • Triggers
  • Python and MySQL

Module 9: Query Optimization 

  • Optimization Overview
  • Optimizing SQL Statements

Module 10: Modeling a Relational Database  

  • What is the Relational Model?
  • The Entity-Relationship Model
  • Designing the Database Schema

Module 11: Implementing Database Design

  • Reviewing the Database Design
  • Creating a Database
  • Creating Tables
  • Creating Indexes

Module 12: Exporting and Importing Data

  • Exporting Data
  • Importing Data
  • MySQL Workbench Wizard

Alliance Micro Solutions | Customer Satisfaction

Leave a Reply