JOIN

• 1 - JOIN Basics
• 2 - JOIN Exercise
• 3 - Left Right and Full JOIN
• 4 - JOIN Exercise - With all kinds of JOINs

• 1 - JOIN
• 2 - Exercise - JOIN
• 3 - Exercise - JOIN - Solution

Functions

• 1 - Scalar Functions
• 2 - Using Internet Sources to find the right Function
• 3 - Scalar Functions Basics Exercise (Part 1)
• 4 - Scalar Functions Basics Exercise (Part 2)
• 5 - Nested Functions
• 6 - Conversion Functions (Part 1)
• 7 - Conversion Functions (Part 2)
• 8 - Aggregate Functions Basics
• 9- The GROUP BY Clause
• 10 - Order of Execution
• 11 - COUNT(DISTINCT)
• 12 - Aggregate Functions Exercise
• 13 - HAVING
• 14 - HAVING Exercise

• 1 - Scalar Functions
• 2 - Exercise - Scalar Functions
• 3 - Exercise - Scalar Functions - Solution
• 4 - Conversion Functions
• 5 - Exercise - conversion functions
• 6 - Exercise - conversion functions - Solution
• 7 - Aggregate Functions
• 8 - Exercise - Aggregate Functions
• 9 - Exercise - Aggregate Functions - Solution
• 10 - Analytic Functions
• 11 - Exercise - Advanced Functions

Where and order by

• WHERE AND ORDER BY
• WHERE AND ORDER BY - solution

• 1 - Where _ Order by clauses
• 2 - Exercise - Where _ Order by clauses
• 3 - Exercise - Where _ Order by clauses - Solution

SQL exercises

• 1 - SQL summary exercise
• 2 - SQL summary exercise - solution

SQL Intro

• Installation on MAC
• Installation on WINDOWS

• 1 - מדריך התקנה

Intro to SQL query (SELECT, FROM)

• INTRO TO SQL QUERY
• INTRO TO SQL QUERY EXERCISE
• INTRO TO SQL QUERY solution

• 1 - Intro to SQL Query
• 2 - Exercise - Intro to SQL Query
• 3 - Exercise - Intro to SQL Query - Solution

UNION

• UNION - שיעור

• UNION EXERCISE
• UNION SOLUTION