Share Description
With this course, you will learn:
- Creating, modifying and deleting tables in a database (DDL)
- Inserting, updating and deleting data from tables (DML)
- Select queries
- Joins
- Aggregate functions
- Subqueries
- Database design
- Creating databases.
Syllabus :
1. Data Definition Language
- Data Types
- Primary and Foreign Keys
- Creating the Coffee Store Database
- Modifying Tables: Adding and Removing Columns
- Deleting Tables
- Truncating Tables
2. More On Alter Table
- Creating Our Test Database
- Add and Remove Primary Key
- Add and Remove Foreign Key
- Add Unique Constraint
- Change Column Name
- Change Column Data Type
3. Data Manipulation Language
- Inserting Data Into Tables
- Updating Data in Tables
- Deleting Data from Tables
- Completing the Coffee Store Database
4. Selecting from a Table
- Where Clause
- Using Inequality Symbols
- Null Values
- In, Not In
- Between
- Like
- Order By
- Distinct
- Limit
- Column Name Alias
5. Selecting From Multiple Tables
- What Are Joins?
- Inner Join
- Left Join
- Right Join
- Joining more than Two Tables
6. Database Design
- Normalization - What is it?
- 1st Normal Form (1NF)
- 2nd Normal Form (2NF)
- 3rd Normal Form (3NF)
- Relationships
- Relationships - One to One
- Relationships - One to Many
- Relationships - Many to Many
7. Creating a Cinema Booking System Database
- Database Schema Overview
- Create Films Table
- Create Customers Table
- Create Rooms Table
- Create Screenings Table
- Create Bookings Table
- Create Reserved_Seat Table
- Insert the Data
8. Aggregate Functions
- What are Aggregate Functions
- Count
- Sum
- Min and Max
- Average
- Grouping Data
- Having Clause
9.Subqueries
- What Are Subqueries
- Non-Correlated Subqueries
- Correlated Subqueries
10. MySQL Functions - String Functions and Date Functions
- What Are MySQL Functions?
- Concatenation
- Substrings
- Upper and Lower Case
- Date Function
- Month Function
- Year Function
