Module 2 – My SQL Database
- Introduction to SQL
- Introduction to databases and database management systems
- Overview of MySQL
- Installing and getting started with MySQL Workbench
- SQL Database
- Creating databases
- Introduction to tables
- Data types in MySQL
- Data Definition Language (DDL)
- Introduction to DDL commands
- Databases, Data Types, Tables
- Constraints and Indexes
- Views
- Data Manipulation Language (DML)
- Overview of MySQL SELECT statement
- Retrieving data
- Filtering, searching, and sorting
- Joining and combining data
- Updating, Adding, and deleting data
- Inserting data
- Expressions
- Grouping and Aggregate Functions
- MySQL Functions and Joins
- MySQL built-in functions
- Inner, outer, and self joins
- Combining data from multiple tables
- MySQL Subqueries
- Subqueries and nested queries
- Normalization and denormalization
- MySQL Stored Procedures and Triggers
- Creating and using stored procedures and triggers
- Introduction to Stored Procedures
- Changing the Delimiter
- Editing a Stored Procedure
- Variable Scope
- A Data Generating Procedure
- Triggers and transactions