Advanced SQL

Advanced SQL

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

Advanced SQL course. Covering advanced SQL functionalities.

₪690.00 רכישה

קורס זה כולל:

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

סילבוס & קורס

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 - Analytic functions

  • 1 - Analytic functions - advanced
  • 1 - Analytic functions - advanced
  • 2 - Exercise - Analytic functions - advanced
  • 3 - Exercise - Analytic functions solution

3 - Subquery

  • 1 - Subquery - advanced
  • 2 - Subquery advanced - exercise
  • 1 - Subquery - advanced
  • 2 - Subquery basic exercise
  • 3 - Subquery basic exercise - solution
  • 4 - Subquery intermediate exercise
  • 5 - Subquery intermediate exercise - solution
  • 6 - Subquery complex exercise
  • 7 - Subquery complex exercise - solution

4 - CASE

  • 1 - CASE
  • 2 - CASE exercise
  • 1 - CASE presentation
  • 2 - CASE exercise
  • 3 - CASE exercise - solution
  • 4 - CASE extra exercise
  • 5 - CASE extra exercise - solution

5 - SQL errors

  • 1 - SQL errors
  • 1 - SQL errors presentation
  • 2 - SQL errors - exercise

6 - WITH AS

  • 1 - WITH AS
  • 2 - WITH AS exercise
  • 1 - WITH AS presentation
  • 2 - WITH AS exercise
  • 3 - WITH AS exercise - solution

7 - Execution Plan

  • 1 - Execution Plan
  • 1 - Execution Plan presentation
  • 2 - Execution plan exercise
  • 3 - Execution plan exercise - solution