Module 1 Introduction to MySQL

• Instructor Introduction
• Course Goals & Coverage
• About SQL
• About MySQL
• History & Features of MSSQL TimeLine
• What Gartner Says about MYSQL in 2020 ?
• Quiz Self-Check

Modue 2 MySQL Server and Client

• Installation of the MySQL server on Windows
• Setting the root Password
• Starting and stopping the MySQL server
• Connect to the mysql client -MySQL Workbench
• Quiz Self-Check

Module 3 Database Basics

• Basics of Relational Databases
• Entities and Relationships
• Relationship Categories
• SQL data definition language
• SQL data manipulation language
• Quiz Self-check

Module 4  Creating Databases and Tables (DDL)

• Creating a Database
• Using the Sample Data and Schema
• Creating a Table
• Copy Table Structure
• Column Options
• On Keys and Constraints
• Quiz Self-Check

Module 5 Data Types

• Data Types as Part of Database Design
• Numeric Data Types
• Temporal Data Types
• String Data Types
• Character Set and Collation Support
• Data Type Considerations
• The Meaning of NULL and Uses
• Quiz Self-Check

Module 6 Modifying Databases and Tables(DDL)

• Deleting databases and tables
• Creating a New Table Using an Existing Table
• Confirming the Creation of a New Table
• Copying an Existing Table Structure
• Creating a Temporary Table
• Adding, removing and modifying table columns
• Adding, removing and modifying Indexes
• Quiz Self-check

Module 7 Modifying Table Data(DML)

• Manipulating Data
• Inserting records
• Inserting Multiple Rows
• Inserting Hierarchical Rows
• Replacing existing records
• Updating existing Single records
• Updating existing Multiple Rows
• Using Subqueries in Updates
• Deleting records
• Using Subqueries in Deletes
• Multistatement Transactions
• Quiz Self-check

Module 8 Querying Table Data( DQL)

• The SELECT Statement
• Filter Rows and Columns using the Where Clause
• Operators in Select Statement
• Ordering Data
• Aggregate Functions
• Grouping Data
• Use Special Operators Between /Like/Null
• The REGEXP Operator
• Quiz-Self-check

Module 9 SQL Data Type Functions in MYSQL

• Functions in MySQL Expressions
• String Functions
• Date and time functions
• Numeric Functions
• Spaces in Function Names
• Quiz Self Check

Module 10 Joining Tables

• Querying Multiple Tables
• Joining Tables with SELECT
• Inner Joins
• Outer Joins
• Table Name Aliases
• Quiz Self-Check

Module 11 Working with Subqueries

• Uses of Subqueries
• Operators in Subqueries
• Subqueries (Single Value)
• Subqueries (Multiple Values)
• Correlated Subqueries
• Subqueries in DMLS
• Quiz Self Check

Module 12  Import & Exports Tables/Data

• Import/Export Objects to Excel,CSV
• Import/Export Objects to MSACCESS/Oracle

Module 13 Conclusion

• Course Goals
• MySQL Curriculum Path
• MySQL Resources
• Evaluation
• Final Q&A
• Reviews & Feedback