Course Highlights
  • Have a detailed knowledge and understanding of using MySQL, one of the most widely used databases in the world.
  • Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
  • In-depth knowledge of database design will give students an edge over other applicants.
Skills you will learn!
Curriculum

2 Topics
Welcome to the Course
Syllabus Explanation

8 Topics
Section Introduction
Databases SQL and MySQL
Relational Database Management System
MySQL Installation for Windows
MySQL Installation for Mac
MySQL Installation for Linux
MySQL Workbench Overview
Create Database

7 Topics
Section Introduction
Data Types
Primary and Foreign Keys
Creating the Coffee Store Database
Modifying Tables: Adding and Removing Columns
Deleting Tables
Truncating Tables

9 Topics
Section Introduction
Creating Our Test Database
Add and Remove Primary Key
Add and Remove Foreign Key
Add Unique Constraint
Change Column Name
Change Column Data Type
Exercise 4.1
Solution 4.1

5 Topics
Section Introduction
Inserting Data Into Tables
Updating Data in Tables
Deleting Data from Tables
Completing the Coffee Store Database

18 Topics
Section Introduction
Select Statement
Where Clause
Using Inequality Symbols
Null Values
Exercise 6.1
Solution 6.1
In and Not In
Between
Like
Order By
Exercise 6.2
Solution 6.2
Distinct
Limit
Column Name Alias
Exercise 6.3
Solution 6.3

9 Topics
Section Introduction
What Are Joins?
Inner Join
Left Join
Right Join
Joining more than Two Tables
Exercise 7.1
Solution 7.1
Creating Entity Relationship diagrams in Workbench

10 Topics
Section Introduction
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
Constraints

10 Topics
Section Introduction
Database Schema Overview
Create Films Table
Create Customers Table
Create Rooms Table
Create Screenings Table
Create Seats Table
Create Bookings Table
Create Reserved_Seat Table
Insert the Data

12 Topics
Section Introduction
What are Aggregate Functions
Count
Sum
Min and Max
Average
Exercise 10.1
Solution 10.1
Grouping Data
Having Clause
Exercise 10.2
Solution 10.2

7 Topics
Section Introduction
What Are Subqueries
Non-Correlated Subqueries: Part 1
Non-Correlated Subqueries: Part 2
Correlated Subqueries
Exercise 11.1
Solution 11.1

12 Topics
Section Introduction
What Are MySQL Functions?
Concatenation
Substrings
Upper and Lower Case
Exercise 12.1
Solution 12.1
Date Function
Month Function
Year Function
Exercise 12.2
Solution 12.2

14 Topics
Section Introduction
Challenge One
Solution One
Challenge Two
Solution Two
Challenge Three
Solution Three
Challenge Four
Solution Four
Challenge Five
Solution Five
Challenge Six
Solution Six
Should I break normalisation?

3 Topics
Source code
Old Course Information
Bonus Lecture and Information

  Write a Review

SQL for Beginners: Learn SQL using MySQL and Database Design

Go to Paid Course