SQL

SQL

Beginner Level מתחיל Duration 4 שעות עברית

Basic SQL course. Covering basic commands and methodologies.

₪690.00 רכישה

קורס זה כולל:

  • 4 שעות של תוכן מוקלט
  • 27 מסמכים
  • תרגילים ללא הגבלה שנוצרים בקליק

סילבוס & קורס

1 - SQL Intro

  • 1 - Microsoft SQL Server Management Studio Basics
  • 2 - Installation on WINDOWS
  • 3- Installation on MAC
  • 1 - SQL SERVER Installation Guide
  • 2 - Guide to installing DB and tables
  • 3 - Microsoft SQL Server Management Studio
  • 4 - Intro to DB
  • 5 - Intro to Tables

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

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