Relational Database Management System
| Section 1 – Installation and Setup
1. Databases, SQL and MySQL 2. Relational Database Management System 3. MySQL Installation for Windows 4. MySQL Installation for Mac 5. MySQL Installation for Linux 6. MySQL Workbench Overview 7. Create Database |
Section 2 – Data Definition Language
1. Data Types 2. Primary and Foreign Keys 3. Creating the Coffee Store Database 4. Modifying Tables: Adding and Removing Columns 5. Deleting Tables 6. Truncating Tables
|
| Section 3 – More on Alter Table
1. Creating Our Test Database 2. Add and Remove Primary Key 3. Add and Remove Foreign Key 4. Add Unique Constraint 5. Change Column Name 6. Change Column Data Type 7. Hands on – Exercise 1, Solution 1 |
Section 4 – Data Manipulation Language
1. Inserting Data Into Tables 2. Updating Data in Tables 3. Deleting Data from Tables 4. Completing the Coffee Store Database |
| Section 5 – Selection From a Table
1. Select Statement 2. Where Clause 3. Using Inequality Symbols 4. Null Values 5. Hands on – Exercise 1 , Solution 1 6. In, Not In 7. Between 8. Like 9. Order By 10. Hands on – Exercise 2, Solution 2 11. Distinct 12. Limit 13. Column Name Alias 14. Hands on – Exercise 3, Solution 3 |
Section 6 – Selection From Multiple Table
1. What Are Joins? 2. Inner Join 3. Left Join 4. Right Join 5. Joining more than Two Tables 6. Hands on – Exercise 1, Solution 1
|
| Section 7 – Database Design
1. Normalization – What is it? 2. 1st Normal Form (1NF) 3. 2nd Normal Form (2NF) 4. 3rd Normal Form (3NF) 5. Relationships 6. Relationships – One to One 7. Relationships – One to Many 8. Relationships – Many to Many 9. Constraints |
Section 8 – Database Design
1. Database Schema Overview 2. Create Films Table 3. Create Customers Table 4. Create Rooms Table 5. Create Screenings Table 6. Create Seats Table 7. Create Bookings Table 8. Create Reserved_Seat Table 9. Insert the Data |
| Section 9 – Aggregate Functions
1. What are Aggregate Functions 2. Count 3. Sum 4. Min and Max 5. Average 6. Exercise 1, Solution 1 7. Grouping Data 8. Having Clause 9. Exercise 2, Solution 2 |
Section 10 – Subqueries
1. What Are Subqueries 2. Non-Correlated Subqueries: Part 1 3. Non-Correlated Subqueries: Part 2 4. Correlated Subqueries 5. Exercise 1, Solution 1 |
| Section 11 – MySQL Functions – String functions & Date functions
1. What Are MySQL Functions? 2. Concatenation 3. Substrings 4. Upper and Lower Case 5. Exercise 1, Solution 1 6. Date Function 7. Month Function 8. Year Function Exercise 2, Solution 2 |
|