Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL with MySQL for Database Design
Introduction to Our SQL with MySQL Course
Welcome to the SQL Database Design with MySQL Course (4:03)
How to Download the Lecture Resources (3:22)
Day 1: Getting Started With SQL Using MySQL
Introduction to DAY 1 (3:20)
Basics: Understanding Data and Databases (5:21)
What is DBMS (Database Management System)? (4:28)
Introduction to Relational Databases Concepts (6:00)
Overview of SQL (3:38)
Installing MySQL on Windows (14:52)
Installing MySQL on Mac (12:12)
Installing MySQL on Linux (15:57)
MySQL Interface (8:08)
Creating Database to work on this Course (4:04)
USE Database in SQL (3:15)
Basic SQL Query with MySQL (5:03)
Doing More with SELECT (6:41)
Challenge: Getting Overview Of Products (2:57)
Challenge: Specific Product Information (2:36)
Comments in SQL (8:35)
DAY 1: Review (4:43)
Day 2: SELECT - A Closer Look | Learn SQL with MySQL
Introduction to DAY 2 (3:30)
Introduction to SELECT Statement (3:05)
Data Types in SQL (10:55)
Eliminating Duplicate Rows using SQL (4:53)
Challenge: Product Diversity (2:53)
Column Aliases in SQL (6:34)
Challenge: Customer Report (3:34)
Using Expressions with SELECT (8:42)
What are NULL Values in SQL (5:52)
Handling NULL Values in SQL (8:23)
Sorting Results with ORDER BY (10:06)
Challenge: Pricing Review (1:57)
Limiting Results with LIMIT (7:56)
Challenge: Premium Products (2:14)
DAY 2: Review (5:12)
Day 3: WHERE - A Closer Look | Learn SQL with MySQL
Introduction to DAY 3 (3:17)
Introduction to WHERE Clause (2:20)
Operators in SQL (3:03)
Arithmetic Operators in SQL (11:13)
Challenge: Tax Calculations (2:42)
Comparison Operators in SQL (10:33)
AND Operator: Working with Multiple Conditions (9:33)
Challenge: Accessories under $30 (2:51)
OR Operator: Working with Multiple Conditions in SQL (9:01)
Challenge: Inventory Check (6:57)
NOT Operator in SQL (2:01)
Alternative to Multiple OR’s (5:38)
Challenge: Customer Location (4:29)
Challenge: Product Popularity (3:34)
Between in SQL (8:41)
Challenge: Price Adjustment (3:42)
Searching for a Pattern in Data with LIKE Operator (16:01)
Challenge: Searching for Stars (2:08)
Using WHERE with NULL Values (8:21)
Nested WHERE Clauses using MySQL (6:11)
DAY 3: Review (5:38)
Day 4: Grouping and Aggregation | Learn SQL with MySQL
Introduction to Day 4 (3:03)
Introduction to Grouping and Aggregation in SQL (4:39)
Understanding Aggregate Functions in SQL (11:07)
The GROUP BY Clause in SQL (8:13)
Challenge: Sales Volume (3:36)
Combining Aggregate Functions and GROUP BY (5:49)
Challenge: Customer Demographic (3:05)
Challenge: Retrieving Best Sellers (4:44)
Grouping By Multiple Columns (5:03)
The HAVING Clause in SQL (7:13)
Challenge: Premium Customers (3:33)
Challenge: Frequent Shoppers (3:08)
Challenge: Customer Spending Habits (2:03)
Nested Aggregation and Grouping (5:37)
Common Pitfalls and How to Avoid Them (2:55)
Practical Applications of Grouping and Aggregation (5:39)
DAY 4 Review (5:07)
Day 5: JOINS in SQL | Learn SQL with MySQL
Introduction to Day 5 (4:34)
Introduction to Joins in SQL (2:56)
INNER JOIN in SQL (12:42)
Inner Joins with Multiple Tables (10:15)
Challenge: Product Names in Sales Volume (4:47)
LEFT JOIN in SQL (5:49)
Challenge: Product Sales Analysis (7:45)
RIGHT JOIN in SQL (4:10)
Understanding ON vs USING in Joins (4:30)
Self Join in SQL (6:49)
Challenge: City-Wise Customer Analysis (4:11)
CROSS JOIN in SQL (2:31)
NATURAL JOIN in SQL (4:12)
Challenge: Customer Analysis (5:14)
Challenge: Customer Purchase Analysis (6:17)
Common Pitfalls and Best Practices (11:14)
DAY 5 Review (7:34)
Day 6: Database Design | Learn SQL with MySQL
Introduction to Day 6 (2:38)
Introduction to Database Design (5:29)
QuantumTutors - Our New Startup (5:04)
Introduction to Entity-Relationship Model (2:26)
ER Diagrams in Database Design (8:55)
One to One Relationship (6:35)
One to Many Relationship (6:38)
Many to Many Relationship (6:55)
Normalization Techniques (3:17)
First Normal Form (1NF) (2:10)
Second Normal Form (2NF) (1:52)
Third Normal Form (3NF) (2:08)
Identifying Relationships for Database Design (5:36)
DAY 6 Review (1:12)
Day 7: DDL in SQL | Learn SQL with MySQL
Introduction to DAY 7 (5:52)
Introduction to DDL in SQL (2:59)
Creating and using Database (9:42)
Challenge: Database for QuantumTutors (2:40)
CREATE Statement in SQL (15:09)
Describing Tables in SQL (3:56)
Primary Keys in Database (7:30)
Foreign Keys in Database (11:41)
Challenge: Defining REST Of the Tables (6:24)
Sample Data For MySQL (2:23)
Copy Tables in SQL (8:32)
ALTER Statement in SQL (1:37)
ALTER to add column (8:00)
Challenge: Course Duration (2:46)
ALTER to Drop column (4:31)
Challenge: Changes in Business Model (2:11)
ALTER to modify column (9:20)
Challenge: Managing Integrity (3:12)
Challenge: Course Categorization (3:32)
DROP Statement in SQL (8:58)
DROP and Foreign Keys in Database (3:10)
TRUNCATE Statement in SQL (5:06)
Challenge: Data Pruning (1:53)
DROP with references (11:43)
RENAME Statement in SQL (4:06)
Day 7 Review (5:27)
Day 8: DML in SQL | Learn SQL with MySQL
Introduction to DAY 8 (3:41)
Introduction to DML Statements in SQL (0:37)
Working with Insert Statements (7:34)
Challenge: New Admin Onboarding (2:05)
Inserting multiple records at once (2:55)
Challenge: New Instructors Onboarding (2:42)
Inserting data from another table (5:59)
Update statement in SQL (3:34)
Challenge: Course Title Improvements (5:24)
Updating multiple columns (4:29)
Challenge: Profile Update (2:13)
Updating multiple rows in SQL (3:38)
Challenge: Discounted Courses (1:37)
Deleting specific records from the table (4:46)
Challenge: Course Retirement (7:02)
Deleting all records from the table (1:30)
Challenge: Complete Reset (2:33)
Difference between DROP, DELETE, and TRUNCATE (2:29)
DAY 8 Review (5:35)
Day 9: SubQueries and Functions | Learn SQL with MySQL
Introduction to DAY 9 (2:34)
Subqueries Introduction (7:17)
Challenge: Course Popularity (8:05)
Correlated and Non-Correlated Subqueries using SQL (8:56)
Challenge: Course with Highest Price (3:58)
Exists and Not Exists with Subqueries (3:57)
Challenge: Instructors Not Teaching (3:23)
Using ANY and ALL with Subqueries in SQL (3:28)
Challenge: Top Performing Instructors (3:30)
Single Row Subqueries in SQL (1:20)
Multi Row Subqueries in SQL (1:31)
Inserting and Deleting using Subquery (2:37)
Challenge: Remove Reviews for Courses Not Offered (2:08)
DAY 9 Review (5:27)
Day 10: MySQL with Python
Setting Up Python MySQL Environment (11:50)
Querying Data (5:55)
Grouping Data (8:15)
Inserting Data into Tables (6:38)
Creating a Database (2:23)
Creating Tables (2:03)
Updating Data (3:21)
Deleting Data (1:35)
Day 10: MySQL with Java
Setting Up Java MySQL Environment (8:38)
Querying Data (4:04)
Grouping and Joining (2:09)
Java MySQL Prepared Statements (3:54)
Inserting Data into Tables (4:19)
Creating a Database (1:29)
Creating Tables (1:20)
Updating Data (1:54)
Deleting Data (2:28)
Challenge: Sales Volume
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock