SQL for Data Analysis
Curriculum summary
Introduction to DB & SQL
Statistics and SQL Functions
SQL Functions Advanced #2
Module 1 Introduction to DB & SQL
Introduction To Databases & SQL while learning how to use basic Select Queries And Calculations. Learn how to use Filter, Sort and Scalar Functions.
Module 2 Statistics and SQL Functions
Get acquaintance with Statistical Functions And Aggregating Data. Learn how to use Joins, Subqueries, Views and Set Operators
Module 3 SQL Functions Advanced #2
Take a deep dive into Analytical Functions, Advanced Scalar Functions, Pivot Queries Solving Advanced Problems In SQL Using CTEs and SQL Window functions
Introduction to DB & SQL
Module 1 Introduction to DB & SQL
Introduction To Databases & SQL while learning how to use basic Select Queries And Calculations. Learn how to use Filter, Sort and Scalar Functions.
Statistics and SQL Functions
Module 2 Statistics and SQL Functions
Get acquaintance with Statistical Functions And Aggregating Data. Learn how to use Joins, Subqueries, Views and Set Operators
SQL Functions Advanced #2
Module 3 SQL Functions Advanced #2
Take a deep dive into Analytical Functions, Advanced Scalar Functions, Pivot Queries Solving Advanced Problems In SQL Using CTEs and SQL Window functions
Got any questions?
Who is this for?This workshop is tailored for data analysts, product managers, digital marketers and everyone who is interested in getting into the data analysis world, but has no prior experience with SQL or other programming languages
This workshop is tailored for data analysts, product managers, digital marketers and everyone who is interested in getting into the data analysis world, but has no prior experience with SQL or other programming languages
How practical is this workshop?This is a very technical, hands-on workshop. We intend to make you write code until you drop 🙂
This is a very technical, hands-on workshop. We intend to make you write code until you drop 🙂
Why is this course relevant today?It has often been said that data is the new oil. This is true, and SQL is an excellent entry point into the world of data. Working with data is a crucial skill today, regardless of what industry you’re in.
It has often been said that data is the new oil. This is true, and SQL is an excellent entry point into the world of data. Working with data is a crucial skill today, regardless of what industry you’re in.
Will I have to learn something before the course?No, the course is for absolute beginners – no experience required whatsoever
No, the course is for absolute beginners – no experience required whatsoever
Am I expected to work outside of course hours?Every student comes with their own background and prior knowledge. The course is designed to give you enough time to practice in class, but in certain cases, you might need to spend a few hours outside of class to complete assignments/projects
Every student comes with their own background and prior knowledge. The course is designed to give you enough time to practice in class, but in certain cases, you might need to spend a few hours outside of class to complete assignments/projects
What is the course commitment?Depending on the course, it is either once or twice a week, 3 hours each time.
Depending on the course, it is either once or twice a week, 3 hours each time.
