Beginning T-SQL for SQL Server Developer, Data Analyst and DBA

Learn step-by-step practical training on programming transact SQL query from basics on Microsoft SQL server database engine.

Beginning T-SQL for SQL Server Developer, Data Analyst and DBA

Learn step-by-step practical training on programming transact SQL query from basics on Microsoft SQL server database engine.
61
views
Share the link to this page
Copied

About the Class

This course helps you to learn programming Transact SQL Query by using the Microsoft SQL server database engine. The course will teach you beginning T-SQL that can be beneficial for Microsoft SQL Server database developers, Microsoft database administrator, Web developers such as .NET Developers, Database Analysts, Report Developers such as SSRS or ETL Developers such as SSIS, etc.

Course Content:

  • Introduction
  • What is a Relational Database
  • What is Relational Database Management System
  • SSMS and SQL Server Database Engine
  • SQL Server and SSMS Installation
  • Basic T-SQL
  • Creating DB Tables & Inserting Data into the tables
  • Primary Key and Foreign Key
  • Basic Select Commands
  • Aggregate Functions with SELECT Command
  • Group By Clause using Single and Multiple Columns
  • Difference Between WHERE and HAVING Clause
  • Syntax of SELECT Command
  • T-SQL Joins to query SQL Server
  • Inner Join
  • T-SQL with Inner Join and Group By Together
  • Left Join
  • Right Join
  • Full Join
  • Cross Join
  • Self-Join
  • Union Operation
  • Union All Operation
  • Intersect Operation
  • Except for Operation
  • Working with Schema
  • What is Schema and its Importance
  • Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL
  • Subqueries
  • Getting Started with first Subquery Example
  • Common Interview Question on Subquery
  • Joins Group by Derived table Subquery combined TSQL
  • Subquery as a Column
  • Subquery using NOT Exists
  • ALL ANY SOME Keywords in Subquery
  • Correlated Subquery
  • Not Exists Keyword Scenario of Correlated Subquery to speed up query performance
  • Datatypes
  • Datatype Conversion
  • Implicit & Explicit Conversion (Type Casting)
  • DML Operations and Constraints
  • Many Different Options while performing insert update and delete operations
  • Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints
  • Joining more than two tables
  • Joining three tables
  • Joining four Tables
  • One more example in joining four tables
  • Working with CASE Statements and Inbuilt Functions
  • Performing Select and Update operation using the case statement
  • WHILE Loop
  • Inbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.

Author

Vikas Munjal

Microsoft SQL Server and Business Intelligence Corporate Trainer and Consultant
I provide corporate trainings , job support and consultations in Microsoft SQL Server and Business Intelligence

School

Vikas Munjal's School

Requirements

There are no additional requirements.

Class Contents

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.66
List Price:  €93.81
You save:  €28.14
£56.18
List Price:  £80.26
You save:  £24.08
CA$96.40
List Price:  CA$137.73
You save:  CA$41.32
A$107.87
List Price:  A$154.11
You save:  A$46.23
S$95.25
List Price:  S$136.08
You save:  S$40.83
HK$548.53
List Price:  HK$783.65
You save:  HK$235.12
CHF 63.98
List Price:  CHF 91.40
You save:  CHF 27.42
NOK kr762.91
List Price:  NOK kr1,089.92
You save:  NOK kr327
DKK kr490.64
List Price:  DKK kr700.94
You save:  DKK kr210.30
NZ$117.76
List Price:  NZ$168.24
You save:  NZ$50.47
د.إ257.02
List Price:  د.إ367.19
You save:  د.إ110.16
৳7,677.38
List Price:  ৳10,968.15
You save:  ৳3,290.77
₹5,851.95
List Price:  ₹8,360.30
You save:  ₹2,508.34
RM333.74
List Price:  RM476.80
You save:  RM143.05
₦87,233.43
List Price:  ₦124,624.53
You save:  ₦37,391.10
₨19,453.72
List Price:  ₨27,792.22
You save:  ₨8,338.50
฿2,544.62
List Price:  ฿3,635.33
You save:  ฿1,090.70
₺2,265.05
List Price:  ₺3,235.93
You save:  ₺970.87
B$358.24
List Price:  B$511.79
You save:  B$153.55
R1,317.23
List Price:  R1,881.84
You save:  R564.60
Лв128.62
List Price:  Лв183.76
You save:  Лв55.13
₩96,628.19
List Price:  ₩138,046.19
You save:  ₩41,418
₪263.87
List Price:  ₪376.98
You save:  ₪113.10
₱3,959.57
List Price:  ₱5,656.78
You save:  ₱1,697.20
¥10,727.71
List Price:  ¥15,325.96
You save:  ¥4,598.25
MX$1,164.84
List Price:  MX$1,664.13
You save:  MX$499.29
QR254.81
List Price:  QR364.03
You save:  QR109.22
P960.24
List Price:  P1,371.84
You save:  P411.59
KSh9,098.70
List Price:  KSh12,998.70
You save:  KSh3,900
E£3,326.58
List Price:  E£4,752.47
You save:  E£1,425.88
ብር3,979.31
List Price:  ብር5,684.97
You save:  ብር1,705.66
Kz58,546.63
List Price:  Kz83,641.63
You save:  Kz25,095
CLP$67,475.25
List Price:  CLP$96,397.35
You save:  CLP$28,922.10
CN¥506.51
List Price:  CN¥723.62
You save:  CN¥217.11
RD$4,159.85
List Price:  RD$5,942.90
You save:  RD$1,783.05
DA9,426.32
List Price:  DA13,466.75
You save:  DA4,040.43
FJ$158.71
List Price:  FJ$226.74
You save:  FJ$68.02
Q544.83
List Price:  Q778.36
You save:  Q233.53
GY$14,647.93
List Price:  GY$20,926.52
You save:  GY$6,278.58
ISK kr9,909.88
List Price:  ISK kr14,157.58
You save:  ISK kr4,247.70
DH701.47
List Price:  DH1,002.14
You save:  DH300.67
L1,235.26
List Price:  L1,764.74
You save:  L529.47
ден4,036.76
List Price:  ден5,767.05
You save:  ден1,730.28
MOP$564.70
List Price:  MOP$806.75
You save:  MOP$242.05
N$1,315.52
List Price:  N$1,879.40
You save:  N$563.87
C$2,572.13
List Price:  C$3,674.63
You save:  C$1,102.50
रु9,333.57
List Price:  रु13,334.25
You save:  रु4,000.67
S/258.30
List Price:  S/369.02
You save:  S/110.71
K268.41
List Price:  K383.46
You save:  K115.05
SAR262.55
List Price:  SAR375.09
You save:  SAR112.53
ZK1,747.13
List Price:  ZK2,496.01
You save:  ZK748.88
L327.08
List Price:  L467.28
You save:  L140.19
Kč1,665.85
List Price:  Kč2,379.90
You save:  Kč714.04
Ft25,828.40
List Price:  Ft36,899.30
You save:  Ft11,070.90
SEK kr761.19
List Price:  SEK kr1,087.47
You save:  SEK kr326.27
ARS$60,557.36
List Price:  ARS$86,514.22
You save:  ARS$25,956.86
Bs485.16
List Price:  Bs693.12
You save:  Bs207.95
COP$267,004.46
List Price:  COP$381,451.29
You save:  COP$114,446.83
₡35,552.47
List Price:  ₡50,791.41
You save:  ₡15,238.94
L1,726.86
List Price:  L2,467.06
You save:  L740.19
₲517,422.09
List Price:  ₲739,206.10
You save:  ₲221,784.01
$U2,707.47
List Price:  $U3,867.98
You save:  $U1,160.51
zł282.05
List Price:  zł402.95
You save:  zł120.89

What's Included

Language: English
Level: Beginner
Skills: Basic T-SQL - SELECT, CASE Statement, Explicit Conversion, Subqueries, Data Types, DBA, SQL, DML Operations, Implicit Conversion, Creating Database, Schema
Age groups: All ages
Duration: 7 hours 17 minutes
37 Videos
8 Documents
0
Saves
61
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.