SQL Data Analysis Portfolio
Data analysis using SQL with complex queries
- Difficulty
- Easy
- Estimated time
- 6-8 hours
Skills
- SQL
- Query Optimization
- Data Analysis
Foundational · course 1 of 4
Database & Data Analysis with SQL
Master SQL for querying, manipulating, and analyzing data. Essential skill for every data professional.
- videos
- 35
- sections
- 5
- free videos
- 4
The Scientify programme is led by Jihar Gifari.
5 sections · 35 videos
What's inside, section by section.
Videos marked Free play right now, no account needed.
Free video · 1/4
Intro to Data Science Part 3
Section 1 · Intro to Data Science
Free videos in this course
01Intro to Data Science7 videos · 1 free
Introduction to the world of Data Science: what is data science, the role of a data scientist, and how data is used for business decision-making.
- 1Intro to Data Science Part 1
- 2Intro to Data Science Part 2
- 3Intro to Data Science Part 3
- 4Intro to Data Science Part 4
- 5Intro to Data Science Part 5
- 6Intro to Data Science Part 6
- 7Intro to Data Science Part 7
02SQL Part 1 – Beginner7 videos · 1 free
SQL fundamentals: SELECT, WHERE, ORDER BY, and fundamental operations to start accessing and filtering data from databases.
- 1SQL Beginner Part 1
- 2SQL Beginner Part 2
- 3SQL Beginner Part 3
- 4SQL Beginner Part 4
- 5SQL Beginner Part 5
- 6SQL Beginner Part 6
- 7SQL Beginner Part 6
03SQL Part 2 – Intermediate8 videos · 1 free
Intermediate SQL: GROUP BY, aggregate functions, HAVING, subqueries, and JOIN techniques to combine data from multiple tables.
- 1SQL Intermediate Part 1
- 2SQL Intermediate Part 2
- 3SQL Intermediate Part 3
- 4SQL Intermediate Part 4
- 5SQL Intermediate Part 5
- 6SQL Intermediate Part 6
- 7SQL Intermediate Part 7
- 8SQL Intermediate Part 8
04SQL Part 3 – Advanced11 videos · 1 free
Advanced SQL: window functions, CTEs, complex joins, and query optimization techniques for deeper data analysis.
- 1SQL Advanced Part 1
- 2SQL Advanced Part 2
- 3SQL Advanced Part 3
- 4SQL Advanced Part 4
- 5SQL Advanced Part 5
- 6SQL Advanced Part 6
- 7SQL Advanced Part 7
- 8SQL Advanced Part 8
- 9SQL Advanced Part 9
- 10SQL Lanjutan Bagian 10
- 11SQL Advanced Part 11
05SQL Part 4 – Project Portfolio 12 videos
Build your first portfolio! Apply all SQL skills you have learned to solve a real-world data analysis case study.
- 1Project Portfolio Part 1
- 2Project Portfolio Part 2
What you'll learn
- 01Intro to Data Science
- 02SQL from Beginner to Advanced
- 03Build SQL portfolio
Who it's for
- Beginners wanting to learn database
- Fresh graduates
- Career switchers
Tools you'll use
- PostgreSQL
- DBeaver
- SQL
Portfolio project
The project you'll build.
How to buy
Two ways to open this course.
Take a level package if you want several courses at once, or buy just this course.
With a level package
This course is in each of these packages. A package opens its level and every level below it.
- Foundational package4 coursesRp 79.000 for 1 month · Rp 299.000 for 12 months
- Intermediate package7 coursesRp 99.000 for 1 month · Rp 399.000 for 12 months
- Advanced package12 coursesRp 129.000 for 1 month · Rp 549.000 for 12 months
Buy just this course
Want more than one Foundational course? The Foundational package for 1 month (Rp 79.000) opens 4 courses.
Not sure this is the right level?
Answer four questions about what you already know, then see which level to start at.
Foundational package, 1 monthRp 79.000