Data Private

Fundamentals of MySQL (AMS-DB112)

2 days
MySQLDataSQL

Build practical MySQL skills with SQL queries, data modification, joins, transactions, database objects, metadata, and data import and export techniques.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Build a practical foundation in relational databases, SQL, and MySQL. Designed for beginners, this course covers querying and modifying data, working with transactions, joining and aggregating tables, and exploring database metadata using MySQL Workbench.

You will also learn to create and use views, stored procedures, and functions, as well as import and export data. By the end of the course, you will be prepared to work more effectively with MySQL databases and their data.

Course Benefits

  1. SQL Queries: Covers both basic and advanced SQL queries. Understand table joins and aliases, creating grouping based queries using aggregate functions.
  2. Data Manipulation:  Work with INSERT, UPDATE, DELETE and TRUNCATE commands. Discover how to handle duplicate data. Understand handling transaction based commands.
  3. Accessing Metadata: Get information about your schema structure and database objects using the SHOW commands and the INFORMATION_SCHEMA tables.
  4. MySQL Objects: Create and use Views, Functions, and Stored Procedures.
  5. Export and Import Data: Move data into and out of your MySQL database.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. Introduction to RDBMS and MySQL
    1. Why a Relational Database?
    2. Relational Database Management Systems
    3. Relational Database Concepts
    4. About MySQL
  2. SQL Language
    1. About SQL
    2. Basic Query Syntax
    3. Querying with MySQL Workbench
  3. Data Modification
    1. Modifying Data
    2. Handling Duplicate Values and Rows
    3. Handling Transactions
  4. Advanced Queries
    1. Table Joins and Aliases
    2. Grouping and Aggregating
    3. Viewing Metadata
  5. Using MySQL Objects
    1. Views
    2. Stored Procedures
    3. Functions
  6. Exporting and Importing Data
    1. Exporting Data
    2. Importing Data
    3. MySQL Workbench Wizard

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this MySQL class:

No prior experience with SQL or MySQL is required.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant