פרק זה נלמד SQL לאנליסטים מהבסיס עד לרמה מתקדמת

•  Select
  • SELECT statement
  • Using limit N 
  • The FROM Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • Using GROUP BY and HAVING
  • Using Distinct
  • Union queries
  • like/ilike
  • null/COALESCE
  • String Functions
  • Date Functions
  • Conversion Functions
  • Case When
  • פעולות חישוביות
• Joins
  • Inner Joins
  • Left join
  • Right Join
  • Outer Joins
  • Cross Join

• Advanced SQL

• • Subqueries
  • CTE – common table expressions
  • Window Functions 

• DDL & DML – bonus 

• • Creating Tables
  • Creating Constraints
  • Insert queries
  • UPDATE queries
  • DELETE queries
  • Alter table