Test SQL for Beginners: Learn SQL using MySQL and Database Design

About Course

About Course

Discover the Power of SQL & Databases: A Comprehensive Guide for Aspiring Tech-Savvies!

Are You a Student or Professional Eager to Master SQL?

Embarking on a journey into the realm of databases? Yearning to grasp the intricacies of SQL and databases, but unsure where to kick things off? Whether you’re a budding developer, a data enthusiast, or simply someone aiming to amplify your career horizons, understanding SQL and databases is your stepping stone.

Why This Course Stands Out

Dive Deep into SQL & MySQL: Unlock the secrets of SQL and MySQL – the powerhouse among global databases.
Master Database Design & Analysis: Most courses barely scratch the surface; we offer you an immersive dive into database design, a critical skill often overlooked.
Real-world Applications: Engage with a hands-on project – setting up an online cinema booking database, offering you practical exposure to concepts learned.

Core Modules Include:

SQL Basics: The language that’s reshaping the tech landscape.
MySQL In-Depth: One of the world’s most renowned databases.
Database Design & Data Analysis: Equip yourself with these sought-after skills.
Hands-on Tutorials: From creating to modifying databases, we’ve got you covered.
Cross-Platform Installation Guides: Be it Windows, Mac, or Linux, we’ve got your back.

Course Content

1. Course Introduction

1. Welcome to the Course

01:28
2. Syllabus Explanation

03:42

2. Installation and Setup

3. Data Definition Language

4. More On Alter Table

5. Data Manipulation Language

6. Selecting from a Table

Section Introduction

01:14
Select Statement

01:49
Where Clause

00:00
Using Inequality Symbols

00:00
Null Values

00:00
Exercise 1

00:00
Solution 1

00:00
In, Not In

00:00
Between

00:00
Like

00:00
Order By

00:00
Exercise 2

00:00
Solution 2

00:00
Distinct

00:00
Limit

00:00
Column Name Alias

00:00
Exercise 3

00:00
Solution 3

00:00

7. Selecting From Multiple Tables

8. Database Design

Section Introduction

00:00
Normalization – What is it

00:00
1st Normal Form (1NF)

00:00
2nd Normal Form (2NF)

00:00
3rd Normal Form (3NF)

00:00
Relationships

00:00
Relationships – One to One

00:00
Relationships – One to Many

00:00
Relationships – Many to Many

00:00
Constraints

00:00

9. Creating a Cinema Booking System Database

1. Section Introduction

00:00
Database Schema Overview

00:00
Create Films Table

00:00
Create Customers Table

00:00
Create Rooms Table

00:00
Create Screenings Table

00:00
Create Seats Table

00:00
Create Bookings Table

00:00
Create Reserved Seat Table

00:00
Insert the Data

00:00

10. Aggregate Functions

Section Introduction

00:00
What are Aggregate Functions

00:00
Count

00:00
Sum

00:00
Min and Max

00:00
Average

00:00
Exercise 1

00:00
Solution 1

00:00
Grouping Data

00:00
Having Clause

00:00
Exercise 2

00:00
Solution 2

00:00

11. Subqueries

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

1. Course Introduction

1. Welcome to the Course

2. Syllabus Explanation

2. Installation and Setup

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

3. Data Definition Language

Section Introduction

Data Types

Primary and Foreign Keys

Creating the Coffee Store Database

Modifying Tables Adding and Removing Columns

Deleting Tables

Truncating Tables

4. More On Alter Table

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 1

Solution 1

5. Data Manipulation Language

Section Introduction

Inserting Data Into Tables

Updating Data in Tables

Deleting Data from Tables

Completing the Coffee Store Database

6. Selecting from a Table

Section Introduction

Select Statement

Where Clause

Using Inequality Symbols

Null Values

Exercise 1

Solution 1

In, Not In

Between

Like

Order By

Exercise 2

Solution 2

Distinct

Limit

Column Name Alias

Exercise 3

Solution 3

7. Selecting From Multiple Tables

Section Introduction

What Are Joins

Inner Join

Left Join

Right Join

Joining more than Two Tables

Exercise 1

Solution 1

8. Database Design

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

9. Creating a Cinema Booking System Database

1. Section Introduction