SQL

2 - Intro to SQL query (SELECT, FROM)

• 1 - The SELECT Clause
• 2 - SELECT Exercise

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

2 - SQL Intro

• 1 - Microsoft SQL Server Management Studio Basics
• 2 - Installation on WINDOWS
• 3- Installation on MAC

• 1 - מדריך התקנה
• 3 - Microsoft SQL Server Management Studio
• 4 - Intro to DB
• 5 - Intro to Tables

3 - Where and order by

• 1 - The WHERE Clause
• 2 - WHERE Exercise - Basic
• 3 - Logic and Advanced Operators
• 4 - The ORDER BY Clause
• 5 - WHERE & ORDER BY Exercise

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

4 - 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 - Aggregate Functions Exercise
• 10 - The GROUP BY Clause
• 11 - Order of Execution
• 12 - COUNT(DISTINCT)
• 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 Analytic Functions
• 8 - Exercise - Aggregate Analytic Functions
• 9 - Exercise - Aggregate Analytic Functions - Solution
• 10 - Analytic Functions
• 11 - Exercise - Advanced Functions

5 - 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

6 - SQL exercises

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

7- UNION

• UNION - שיעור
• תרגול UNION

• UNION EXERCISE
• UNION SOLUTION