Duration
4 Days
Overview
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
- EXPLAIN ANALYZE
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