The Complete SQL Bootcamp: Go from Zero to Hero
Beginner 9 hours English Certificate of Completion
What you'll learn
Use PostgreSQL and PgAdmin to write queries
Read and write any standard SQL statement
Use SELECT, WHERE, GROUP BY, HAVING and ORDER BY
Master JOINs across multiple tables
Create, alter and drop tables and databases
Work with aggregate functions and window functions
Tackle SQL interview-style assessment exercises
This course includes
9h
On-demand video
8
Articles
40+
Coding exercises
Yes
Certificate
Comparison · LBS
Compare alternatives for Python
Same topic, different providers. We surface the trade-offs others hide so you can pick the course that actually fits your time, budget, and goals.
UUdemy4.7(210K)
The Complete SQL Bootcamp: Go from Zero to Hero
- Price
- $12.99Often on sale · $12.99
- Duration
- 9 hrs
- Level
- Beginner
- Certificate
- Completion
CCoursera4.6(102K)
IBM Data Science Professional Certificate
- Price
- FREEAudit free · Cert $49/mo
- Duration
- 110 hrs
- Level
- Beginner
- Certificate
- Professional
DcDataCamp4.7(14,800)
Data Scientist with Python Career Track
- Price
- $29/mo$29/mo
- Duration
- 88 hrs
- Level
- Beginner
- Certificate
- Completion
Prices and ratings refreshed daily. We're not affiliated with any single provider.
Syllabus· 6 courses · 20+ lessons
- Why PostgreSQL
- Installing PostgreSQL & PgAdmin (Win/Mac)
- Sample database walkthrough
- SELECT statement
- SELECT DISTINCT, COUNT, WHERE
- ORDER BY, LIMIT
- BETWEEN, IN, LIKE/ILIKE
- Aggregation functions
- GROUP BY introduction and challenge
- HAVING clause
- AS clause
- INNER, FULL, LEFT, RIGHT joins
- UNION
- JOIN challenge tasks
- Timestamps and EXTRACT
- Mathematical & string functions
- Subqueries and self-joins
- CREATE, INSERT, UPDATE, DELETE
- CASE, COALESCE, NULLIF
- Final assessment test
Instructor
JP
Jose Portilla
Head of Data Science · Pierian Training
4.5M learners38 courses 4.6 instructor rating
Jose Portilla is one of Udemy's top-rated data science instructors, with over 4.5 million students across Python, SQL, and ML courses. He holds a degree from Santa Clara University and previously trained data teams at Fortune 500 companies through Pierian Training.
Requirements
- A computer (Windows, Mac or Linux)
- Ability to install free software (PostgreSQL & PgAdmin)
- No prior SQL experience required
- Roughly 9–12 hours total
Who this course is for
- Anyone preparing for a data-analyst interview
- Engineers needing SQL on the job
- Marketers, PMs and ops people working with databases
- Students before taking a more advanced data course
About this provider
U
Udemy
University-backed online learning platform · 142M learners · 7,000+ courses
4.6 trust score·Refund within 14 days
Frequently asked questions
Jose's bootcamp is more structured with PostgreSQL setup and exercises. Mode's free tutorial is browser-based and faster but shallower. Use Mode if you only need a 2-hour primer; use this bootcamp for a real foundation.
90% of standard SQL transfers across both. Jose uses PostgreSQL because it has stricter standards. The skills here apply to MySQL, SQL Server and BigQuery with only minor syntax tweaks.
For analyst and junior data roles, yes. For senior data engineering interviews you also need window functions, query plans and indexing — covered briefly here but worth supplementing.
Most learners complete it in a weekend (10–12 hours). The challenges add another 5–6 hours if you do them all.
Mode Analytics SQL tutorial, SQLBolt, or Khan Academy's SQL course — all free and browser-based, though shorter than this bootcamp.