Description

Description

Fundamentals of MySQL is the first step in mastering MySQL, the world’s most popular open-source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. This course is perfect for those interested using MySQL for backend data storage in their applications.

Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in creating a hands-on Windows VM.

Training Objectives

• SQL Queries: Covers both basic and advanced SQL queries. Understand 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.
• 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 and Stored Procedures.
• Export and Import Data: Move data into and out of your MySQL database.

Course Outline

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