EngX LogoEngX Logo
I'm inIcon.svg
Data & Analytics: Introduction to SQL
ByEPAM Systems
Gain proficiency in databases and SQL and sharpen your data analysis skills.
Skills covered
Data & Analytics

data-analytics-introduction-SQL.webp
Free
The course includes:
  • rating.svg
    Course rating

    4.4/5

  • graduation-hat-01.svg
    Course format

    Self-paced course

  • bar-chart.svg
    Course level

    Basic

  • globe.svg
    Course language

    English

Knowledge you will gain
checkmarkDatabase basics

Understand the foundations of databases, including their components, modeling, and the concept of normalization.

checkmarkSQL foundation

Grasp essential SQL concepts, explore different SQL statements, and learn to manipulate data for various operations.

checkmarkSQL for analysis

Understand the difference between OLAP and OLTP and get introduced to Data Warehouses.

checkmarkWindow 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
file-text-20.svgIntroduction
file-text-20.svgData. DB. DBMS
file-text-20.svgDB Components
file-text-20.svgDB Modeling
file-text-20.svgNormalization
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
Related courses