MySQL Course Syllabus
- Introduction to Databases
- Data Types in MySQL
- DML (Data Manipulation Language) and DDL (Data Definition Language)
- Aggregate Functions in SQL
- Date and Time Functions in SQL
- Stored Procedures in MySQL
- Subqueries and Joins
- What is MySQL?
- Installing MySQL and Setting up MySQL Workbench
- MySQL Database Structure
- Basic SQL Syntax in MySQL
- Connecting to MySQL from MySQL Workbench
- Using Command Line to Connect to MySQL
- Understanding the MySQL Connection String
- MySQL Connection Options
- Creating Databases
- Creating Tables in MySQL
- Setting Constraints (Primary Key, Foreign Key, etc.)
- Creating Indexes and Views
- Inserting Data into Tables
- Inserting Multiple Rows
- Using Insert Into Select Statement
- Basic Select Query
- Selecting Specific Columns
- Select with Where Clause
- Selecting Distinct Values
- Using the WHERE Clause in SELECT Queries
- Using Comparison Operators (>, <, =, !=)
- Using Logical Operators (AND, OR, NOT)
- Using BETWEEN, IN, LIKE, and IS NULL
- Sorting Data Using ORDER BY
- Sorting in Ascending and Descending Order
- Sorting by Multiple Columns
- Updating Existing Records
- Using WHERE Clause with UPDATE
- Handling Multiple Records Update
- Deleting Records from a Table
- Using WHERE Clause with DELETE
- Deleting All Records from a Table
