Expert
Welcome to our comprehensive SQL Fundamentals course! In this program, you will dive deep into the world of structured query language (SQL), the essential tool for managing and manipulating data in relational databases. Whether you're a beginner or looking to refresh your SQL skills, this course is designed to equip you with the knowledge and hands-on experience needed to excel in database management and data analysis.
Curriculum
- 13 Sections
- 40 Lessons
- 0 Quizzes
- 1h 10m Duration
Intro to Database and SQL
12 Lessons0 Quizzes
- Structured vs Unstructured Data
- Intro to Database
- Intro to Data Warehouse
- Intro to Datalake
- Flow of a product
- Types of Databases
- Schema
- Keys
- Data Warehouse Schema
- Basic SQL Commands
- DDL, DML
- Structure of a Query
Creating Databases
2 Lessons0 Quizzes
- DDL Commands
- SQL Views
Data Manipulation in SQL
7 Lessons0 Quizzes
- Finding unique values
- Operators in SQL
- Filtering Data
- SQL Commands
- Wildcards
- IN, NOT, AND, OR operators
- Removing Null Values
Aggregate Functions in SQL
4 Lessons0 Quizzes
- Basic Aggregate Functions
- Group by Clause
- Filtering Data with Aggregate Functions
- TOP, LAST, LIMIT
Joins & Union
1 Lesson0 Quizzes
- Joins & Union
Subqueries
5 Lessons0 Quizzes
- Basic Subqueries
- Subquery with Aggregate Functions
- Subquery with Conditional Logic
- Subquery with Joins
- Types of Subqueries
Types of Subqueries
3 Lessons0 Quizzes
- Case Statements
- CTE with join
- Multiple CTEs
Window Functions
3 Lessons0 Quizzes
- Basic Syntax
- Rank, Dense Rank, Row Number
- Lag, Lead, Frame Clause
Date Time Functions
2 Lessons0 Quizzes
- Basic Datetime Functions
- Aggregate Datetime Functions
String Functions
1 Lesson0 Quizzes
- String Functions
Practice Sessions
0 Lessons0 Quizzes
Case Studies
0 Lessons0 Quizzes
Capstone Projects
0 Lessons0 Quizzes
Related Courses
Intermediate
Probability and Statistics for Data science
- Foundational Concepts
- Time Sersies Analysis
- Practical Applications
1h
0
0
14
