Decision Making with
Basic SQL

25 academic hours

Evening Classes Twice a Week

5 meetings

Basic SQL Training – Fundamentals of Data Analysis

SQL is the language that powers the world of data – behind every dashboard, report, or query, there is correctly written code.
In this course, we will learn how to write queries that return what we really need to know: who to sell to, where to improve, and how to make informed decisions based on information.

This is not just another basic course. This is the foundation you really need to understand and work with data.

Real mastery of SQL from the ground up

You will learn to write queries that return exactly what you need to know – without guessing, and without asking for help from others.

Ability to understand and analyze data in an organization

You will know not only "how to extract information", but also how to ask the right questions and find the answers yourself.

Practice on real datasets

Not just theory – but practical work on real data that simulates situations from the corporate world.

A new language that will upgrade your resume

SQL is one of the most sought-after skills today – add a tool to your arsenal that opens doors to jobs, projects, and professional security.

Business insights, not just technical ones

You will learn how to think like analysts – understand processes through data, identify anomalies, and turn data into decisions.

Flexible learning with personal guidance

The course is delivered via Zoom, including recordings, exercises, and support from the lecturer even between classes - so you will always have someone to turn to.

Learn from someone who lives and breathes data

Our course leaders don’t just come from the classroom – they also come from the field. They live the world of data daily, teach from real experience, and know how to explain the most complex things in the clearest way. In short – you’re in good hands.

Ram Kedem – has lived in the world of Data for over 15 years, led diverse projects, professionally managed leading colleges, mentored tens of thousands of people, and wrote literature in the field of Data that is sold worldwide.

Gadi Chrust is the head of the analysis team at Plarium. Plarium is one of the largest social gaming companies in the world with over 400 million users. Gadi has many years of technical and business experience, and as part of his work he has interviewed dozens of analysts.

Michael Winner – Principal Data Scientist at the startup Yess. In addition, he worked and led data science initiatives and teams at AppsFlyer and Digital Turbine. Over 7 years of experience as a data scientist and team manager in the field, and 10 years of experience in the data field.

Dotan Antin is an analyst and BI developer at Applied Materials, a company that develops and manufactures systems that form the infrastructure of the global chip industry.
Dotan brings with him extensive experience and knowledge, and as part of his work he deals with various BI technologies.

Aviv Gelfand is a data scientist at the tech company Darrow AI. He holds a BA in statistics and data science from the Hebrew University. He is writing a thesis in the field of language models and methods to save runtime and memory in them, as part of his master’s degree at the Hebrew University.

Omar Bieber is the Head of BI at Superplay, one of the fastest growing gaming startups in the world. Omar brings with him extensive experience in the BI world from companies like Playtika and HiBob.

Hundreds of data people Study with us every year

This is what it sounds like when learning really makes a difference.

Building data capabilities – together with leading organizations

Everything you need to know about the course

  • Overview of SELECT statement usage
  • Retrieving all or specific rows from a table
  • Implementing column aliases for clarity
  • Utilizing concatenation for data combination
  • Performing arithmetic operations within queries
  • Employing the DISTINCT keyword for unique results
  • Applying simple comparison operators (e.g., =, <, >, <>)
  • Implementing complex operators (e.g., IN, BETWEEN, LIKE)
  • Combining conditions using
  • AND and OR logic
    Ordering query results with the
  • ORDER BY clause
  • Manipulating strings, numbers, and dates with built-in functions
  • Converting data types for compatibility
  • Employing conditional functions for custom data manipulation
  • Leveraging aggregate functions (e.g., AVG, SUM, MIN, MAX, COUNT)
  • Grouping data using the GROUP BY clause
  • Filtering grouped results with the HAVING clause
  • Merging data from multiple sources using INNER JOIN and OUTER JOIN
  • Implementing SELF JOIN for data comparisons within a single table
  • Understanding single-row and multi-row subqueries
  • Nesting subqueries for advanced data analysis
  • Adding, updating, or deleting data with INSERT, UPDATE, and DELETE commands
  • Designing new tables with the CREATE command
  • Modifying existing tables using ALTER
  • Removing tables with the DROP command

During the training, each student will receive access to the learning management system, which is designed to enrich the learning experience and assist in achieving course objectives.

The system offers a wide range of tools and resources that enable effective and convenient learning:

  • Study materials: All the content required for the course, including presentations, lesson recordings, practice files, and more, are available through it.
  • Discussion forum: Possibility to communicate with lecturers and fellow course members, ask questions and receive answers and clarifications.
  • Submitting assignments: Online submission of assignments and tests in a simple and convenient way.
  • Achievement tracking: View grades and personal progress data throughout the course.

The course is intended for users with a basic background in working with data, but does not require prior programming experience. To get the most out of the course, it is important that you have:

  • General familiarity with working with relational databases
  • Basic experience using the Windows operating system
  • Understanding what a tabular structure is and the ability to read data tables

To be eligible for a course completion certificate, the following requirements must be met:

  • Attendance at least 80% of the meetings.
  • Successful completion of tasks
  • Submitting projects as required.

I haven’t worked with SQL before – is the course right for me?
If you are familiar with basic data structures and the ability to read tables, this course is definitely a good fit. We will start with the basics and build a systematic understanding of the language.

Do I need a programming background?
No. The course does not require any prior programming background – SQL is a language for data analysis and not a classic development language. All terms are explained in a simple and clear manner.

Does the course include practical training?
Yes! Each topic is accompanied by examples, guided practice, and application to real datasets – so you can feel confident writing queries during the course.

If I miss a class – what happens?
No problem. All sessions are recorded and will be available for re-watching for three months after the course ends.

Is there support during the course?
Of course. The lecturer and support team are available for questions between sessions – via email or in a dedicated WhatsApp group.

What is the difference between this course and an advanced SQL course?
This course is designed to teach the basics of SQL – the advanced course continues from here and delves into complex techniques such as windows, CTE, user behavior analysis, and more.

Contact Us