Module 1: Introduction

• Features and Benefits of MySQL
• MySQL Products and Service
• Community vs. Enterprise
• MySQL Certification Program
• MySQL Website
• MySQL Architecture
• Install and Start MySQL

 Module 2: Database Basics

• SQL Language and MySQL
• Database Design
• Database Modeling
• Keys
• Normalization
• Data Types
• What is NULL?
• Viewing Database Structure

 Module 3: Database Creation

• Create a New Database Structure
• Creating a Database
• Creating a Table

 Module 4: Basic Queries

• The SELECT Command
• MySQL Query Browser
• Troubleshooting

 Module 5: Database Maintenance

• Delete an Entire Database
• Maintaining Tables
• Maintaining Columns
• Indexes and Constraints
• Data Manipulation

 Module 6: Delete/Modify Table row Data

• The INSERT Command
• The REPLACE Command
• The UPDATE Statement
• The DELETE Command

 Module 7: Functions

• Simple Functions
• Grouping With Functions

 Module 8: Joining Tables

• Combining Multiple Tables
• Inner Joins
• Outer Joins

 Module 9: Exporting/Importing Data

• Exporting Data
• Importing Data

 Module 10: Sub queries

• What is a Sub query?
• Categories of Sub queries
• Sub query Types
• Placing Sub queries
• Other Sub query Uses

 Module 11: Supplementary Information

• Creating VIEWs
• Transactions
• Storage Engines
• Retrieving Metadata

 Module 12: Conclusion

• Course Review
• Training and Certification Website
• Course Evaluation
• Thank You
• QA Session

MySQL for Beginners Ed 3 Course Prerequisites:

• Basic computer literacy
• Understanding of database fundamentals
• Knowledge of simple programming
• Familiarity with SQL commands
• Basic math skills
• Problem-solving ability
• Familiarity with the internet and its functions
• No previous experience with MySQL required.