Home›Courses›Coding›SQL
CodingBeginner Friendly10 Milestones

SQL Short Course

Query and manage databases. Master sql through bite-sized, swipeable learning tiles — designed for busy people who want to learn on the go.

Start This Course →

About This SQL Course

This SQL short course on SkillTiles breaks down everything you need to know into 10 structured milestones, each packed with bite-sized learning tiles you can swipe through in under 15 seconds each.

Whether you're a complete beginner or looking to refresh your knowledge, this online sql course uses AI-powered content to adapt to your learning pace. Each tile delivers a focused concept, example, or quiz — making it perfect for commutes, coffee breaks, or quick study sessions.

Covering 71 key topics across 10 milestones, this course takes you from foundations to practical application. Earn badges as you complete each milestone and track your progress on your learning dashboard.

Course Curriculum

1

SELECT & Filter

Query data from tables

SELECT basicsWHERE clauseAND/OR operatorsORDER BYLIMITDISTINCTLIKE pattern matchingNULL handling
2

JOINs & Groups

Combine and aggregate data

INNER JOINLEFT/RIGHT JOINGROUP BYHAVINGCOUNT/SUM/AVGaliasessubqueries basics
3

Joins & Relations

Combine data from multiple tables

INNER JOINLEFT/RIGHT JOINFULL OUTER JOINself-joinscross joinsmultiple table joinsjoin performance
4

Aggregation & Groups

Summarize and analyze data

GROUP BYHAVING clauseCOUNT, SUM, AVGMIN, MAXsubquerieswindow functions introCASE statements
5

Advanced SQL

CTEs, views, and optimization

Common Table Expressionsviews and materialized viewsindexes and explain planstransactionsstored procedures basicsstring and date functionsquery optimization tips
6

Window Functions

Row numbering, ranking, and running totals

ROW_NUMBERRANK and DENSE_RANKLAG and LEADrunning totals with SUMmoving averagesNTILE for bucketsPARTITION BY deep dive
7

Database Design

Schema design and normalization

entity-relationship diagramsnormalization (1NF through 3NF)denormalization trade-offsprimary and foreign keysjunction tablesdata types selectionnaming conventions
8

Database Administration

Backups, users, and monitoring

user roles and permissionsbackup strategiesreplication basicsmonitoring query performancedeadlock detectionconnection poolingdatabase migration tools
9

SQL vs NoSQL

When to use relational vs document databases

relational vs document modelMongoDB basicsRedis for cachinggraph databases overviewtime-series databaseschoosing the right databasemulti-model databases
10

SQL in Practice

Real-world queries and reporting

e-commerce query patternsreporting dashboardsETL with SQLdata quality checkspivot and unpivotrecursive CTEsperformance tuning case studies

What You'll Learn in This SQL Course

SELECT basics
WHERE clause
AND/OR operators
ORDER BY
LIMIT
DISTINCT
LIKE pattern matching
NULL handling
INNER JOIN
LEFT/RIGHT JOIN
GROUP BY
HAVING
COUNT/SUM/AVG
aliases

Related Coding Courses

Python Short Course
The world's most popular programming language
JavaScript Short Course
The language of the web
HTML & CSS Short Course
Build and style web pages from scratch

Ready to master SQL?

Start this sql short course today. Swipe through AI-powered tiles, earn badges, and build a daily learning habit — no experience needed.

Start Learning SQL →