Upcoming dates

Dates

Location

Time

Price

Dates August 2 - August 26
Location Online
TimeSun+Wed, 09:00-12:00
Price2,400 NIS

Curriculum summary

01

Introduction to DB & SQL

02

Statistics and SQL Functions

03

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

01

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.

02

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

03

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

How practical is this workshop?

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.

Will I have to learn anything before the course?

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

What is the course commitment?

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.