Data & Analytics: Introduction to SQLGain proficiency in databases and SQL and sharpen your data analysis skills.
Skills covered
Data & Analytics
- Course rating
4.4/5
- Course format
Self-paced course
- Course level
Basic
- Course language
English
Knowledge you will gain
Database basics
Understand the foundations of databases, including their components, modeling, and the concept of normalization.
SQL foundation
Grasp essential SQL concepts, explore different SQL statements, and learn to manipulate data for various operations.
SQL for analysis
Understand the difference between OLAP and OLTP and get introduced to Data Warehouses.
Window functions
Learn and practice SQL window functions and frames for proficient data analysis.
Study plan
- 9 modules
- 27 lessons
- 40 hours
1DataBase Basics
- 5 lessons
Introduction
Data. DB. DBMS
DB Components
DB Modeling
Normalization
2SQL Foundation. DML: SELECT Statement
- 6 lessons
- 1 practice task
3SQL Foundation. TCL, DML Statements
- 3 lessons
4SQL Foundation. DDL Statements
- 2 lessons
5SQL Foundation. DDL: CREATE FUNCTION
- 2 lessons
6SQL Foundation. DCL Statements
- 2 lessons
7SQL for Analysis. OLAP vs OLTP
- 3 lessons
8SQL for Analysis. Window Functions
- 2 lessons
9SQL for Analysis. Window Frames
- 2 lessons
Data & Analytics: Introduction to SQL
Lay the foundation for a successful career in data engineering.
Related courses