SQL Mastery & Database Design
A 3-week intensive roadmap to master SQL fundamentals, advanced querying, and essential database design principles for relational databases.
W1
SQL Fundamentals & Data Retrieval
SQL Fundamentals & Data Retrieval
By the end of this module you will be able to write basic to intermediate SQL queries to retrieve, filter, and sort data from single and multiple tables.
6 videos•82m
3 readings
6 topics
1 homework
Topics
1.1
Relational vs. Non-Relational Databases
Introduction to Databases
8 minutes
1.2
SQL tutorial for beginners | Basics of ORDER BY, LIMIT, OFFSET | Lesson 3
SQL Basics
21 minutes
1.3
2 MySQL Data Types and Operators
Data Types and Operators
25 minutes
1.4
Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
Aggregate Functions and Grouping
11 minutes
1.5
6 SQL Joins you MUST know! (Animated + Practice)
Joining Tables
9 minutes
1.6
How to do Subqueries in SQL with Examples
Subqueries
8 minutes
References
Week 1: SQL Fundamentals & Data Retrieval
Week 2: Advanced SQL & Data Manipulation
Week 3: Database Design & Normalization
Rate this course
Community Insights
0Join the discussion
Sign in to share your thoughts and technical insights.
Loading insights...