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
Meet our Experts
Ayelet Goldzweig |
An experienced data analyst and researcher, Ayelet has an MA in Cognitive Neuropsychology from the Hebrew University, and vast experience working in data-driven startups. Ayelet enjoys seeing her students’ eyes shining in that special moment of insight – when they have learned something new.
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 anything 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.
Is the course accessible online?Absolutely! We want you to log into class from anywhere you want and is most convenient for you. The lesson are live in the form of a virtual classroom.
Absolutely! We want you to log into class from anywhere you want and is most convenient for you. The lesson are live in the form of a virtual classroom.
