FA-0493Data & Analytics

Hands-on SQL Databases Course Using MySQL

Introduction

Why this course

This comprehensive 2-day hands-on course is designed to provide participants with a strong foundation in SQL databases using MySQL. The course will cover the essential concepts of database management, data modeling, and SQL query language specific to MySQL. Participants will learn how to create and manipulate MySQL databases, design efficient database schemas, and write powerful SQL queries to retrieve and modify data. Through a combination of theoretical explanations, practical examples, and hands-on exercises, participants will develop the necessary skills to effectively manage and work with SQL databases using MySQL.

Duration : 2 Days

Prerequisites

To get the most out of this course, participants should have:

Basic computer literacy and familiarity with operating systems (Windows, macOS, or Linux).
Familiarity with general programming concepts, although prior programming experience is not mandatory.

Note: Participants who have prior experience with SQL or databases will be able to build upon their existing knowledge, while those with limited or no experience will gain a solid foundation in SQL databases using MySQL through the course.

Learning Outcome

Upon completion of this 2-day hands-on course on SQL Databases using MySQL, participants will be able to:

Understand the importance of databases and the role of SQL in managing data.
Design efficient database schemas using entity-relationship modeling and normalization techniques.
Create and manage MySQL databases, tables, constraints, and indexes.
Write and execute SQL queries to retrieve, manipulate, and aggregate data in MySQL.
Utilize advanced SQL techniques such as joins, subqueries, and performance optimization.
Administer MySQL databases, including user management, backup, recovery, and performance monitoring.
Develop and execute stored procedures and functions in MySQL for data manipulation.
Integrate MySQL with programming languages and other systems for seamless data connectivity.

Training outline

10 modules

01Introduction to SQL Databases and MySQL3 topics

Understanding the role and importance of databases
Overview of SQL and MySQL
Differences between MySQL and other database systems

02Setting Up the MySQL Environment3 topics

Installing and configuring MySQL server
Introduction to MySQL Workbench
Creating a database and connecting to it

03Database Design and Modeling with MySQL3 topics

Introduction to database design principles
Entity-Relationship (ER) modeling with MySQL
Normalization techniques for efficient data structures in MySQL

04Creating and Managing MySQL Databases3 topics

Creating and managing MySQL databases and tables
Understanding and using data types in MySQL
Adding constraints and indexes in MySQL tables

05SQL Data Manipulation Language (DML) in MySQL3 topics

Retrieving data with SELECT statements in MySQL
Inserting, updating, and deleting data in MySQL tables
Working with aggregate functions in MySQL

06Advanced SQL Queries in MySQL3 topics

Writing complex queries with joins in MySQL
Subqueries and nested queries in MySQL
Performance optimization techniques for MySQL queries

07Database Administration in MySQL3 topics

User management and access control in MySQL
Backup and recovery strategies in MySQL
Monitoring and optimizing MySQL database performance

08Session 8: MySQL Stored Procedures and Functions3 topics

Introduction to stored procedures and functions in MySQL
Creating and executing stored procedures in MySQL
Using functions for data manipulation in MySQL

09MySQL Database Connectivity and Integration3 topics

Introduction to database connectivity options with MySQL
Using MySQL with programming languages (e.g., PHP, Python)
Integration with other systems and data sources in MySQL

10Conclusions and Tests0 topics

A programme built around your team.

Share your training goals and requirements.