Course Outline
Module 1: Introduction to Databases and MySQL
- Overview of databases and their significance
- Introduction to MySQL as a relational database management system
- The role of MySQL in data storage and retrieval
- Installing and setting up MySQL on different platforms
Module 2: Getting Started with MySQL Workbench
- Introduction to MySQL Workbench as a graphical user interface
- Navigating the MySQL Workbench environment
- Establishing connections to MySQL servers
- Executing basic SQL commands via MySQL Workbench
Module 3: Understanding Data and Tables
- Concept of data and its representation in MySQL
- Introduction to tables as the primary structure for data organization
- Exploring MySQL-supported data types
- Creating and managing tables in MySQL
Module 4: Inserting and Retrieving Data
- Inserting data into MySQL tables using INSERT statements
- Retrieving data from tables using SELECT statements
- Filtering and sorting retrieved data
- Limiting the number of rows returned by SELECT statements
Module 5: Updating and Deleting Data
- Updating existing data in MySQL tables using UPDATE statements
- Deleting data from tables using DELETE statements
- Truncating tables to remove all data
- The importance of data manipulation operations
Module 6: Introduction to Constraints
- Understanding constraints and their role in data integrity
- Overview of primary keys, foreign keys, unique constraints, and nullability
- Applying constraints to table columns in MySQL
Module 7: Querying Multiple Tables with Joins
- Introduction to relational databases and table relationships
- Understanding the concept of joins in MySQL
- Performing inner, left, and right joins to query multiple tables
- Using aliases to simplify join queries
Module 8: Aggregating Data with Functions
- Introduction to aggregate functions in MySQL (COUNT, SUM, AVG, MIN, MAX)
- Grouping data using the GROUP BY clause
- Filtering grouped data using the HAVING clause
- Performing basic data analysis with aggregate functions
Module 9: Introduction to Transactions
- Understanding the concept of transactions in MySQL
- Initiating and committing transactions
- Rolling back transactions to maintain data consistency
- The importance of transactions in database management
Module 10: Conclusion and Next Steps
- Recap of key concepts covered in the course
- Guidance on further resources and advanced MySQL topics
- Encouragement for continued learning and practice in MySQL
Requirements
No previous experience with MySQL is necessary. However, basic familiarity with computer systems and software interfaces is recommended.
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
