Fundamentals of MySQL (AMS-DB112)

This course provides a comprehensive introduction to relational database management systems (RDBMS) and MySQL, equipping participants with essential skills for querying, managing, and modifying data using SQL. Ideal for beginners, the course covers fundamental concepts of relational databases, advanced SQL queries, and practical applications within MySQL Workbench.

The course begins with Introduction to RDBMS and MySQL, where you’ll explore the basics of relational databases, including why they are widely used and how they differ from other types of databases. This section covers key concepts of RDBMS and provides an overview of MySQL, one of the most popular open-source database management systems.

In SQL Language, participants will learn about the SQL language and its role in interacting with relational databases. You’ll get hands-on experience with MySQL Workbench, learning the basic query syntax to retrieve and manipulate data. This module lays the groundwork for understanding how SQL functions within a MySQL environment.

Data Modification covers the core skills needed to modify data in a MySQL database. You will learn how to insert, update, and delete records while handling duplicate values and rows. Additionally, this module introduces transaction management to ensure data integrity during complex operations.

In Advanced Queries, you’ll dive deeper into SQL with advanced querying techniques such as table joins and aliases, grouping, and aggregating data to generate insightful results. This section also covers viewing database metadata, allowing you to better understand and navigate the structure of your databases.

The Using MySQL Objects module introduces participants to the use of advanced MySQL objects like views, stored procedures, and functions. These objects help automate complex tasks, simplify query execution, and enhance the performance of database operations, providing a more robust and dynamic interaction with your data.

Finally, Exporting and Importing Data covers essential skills for data migration and backup. You will learn how to export and import data using MySQL Workbench, ensuring smooth transitions of data between different systems or environments. The MySQL Workbench Wizard is introduced to streamline these processes, making data handling more efficient.

By the end of this course, participants will have a solid understanding of relational database concepts, advanced querying techniques, and practical skills for managing data in MySQL. This foundational knowledge will enable you to effectively interact with MySQL databases, perform complex data modifications, and leverage MySQL’s powerful features for data analysis and management.

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

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

Experience in the following is required for this MySQL class: