SQL Server Tutorial

Learn SQL server step by step from scratch.
00:00
00:00

SQL Server Tutorial

Learn SQL server step by step from scratch.
249
views
Share the link to this page
Copied

About the Class

This course has 21 labs which cover the below syllabus:

Lab 1 - Basic fundamentals database, tables, rows, and columns

Lab 2 - Primary key, foreign key, referential integrity, and constraints

Lab 3 - Database normalization (1st, 2nd and 3rd normal forms)

Lab 4 - SQL basics (Select, Insert, Update and Delete)

Lab 5 - DDL (Data definition language) queries

Lab 6 - Transactions, locks and isolation level in SQL server

Lab 7 - ISNULL and coalesce functions

Lab 8 - Row_Number, partition, rank, and DenseRank

Lab 9 - Triggers, inserted and deleted tables

Lab 10 - Instead of and after triggers

Lab 11 - Denormalization, OLTP and OLAP

Lab 12 - Understanding Star schema and Snow flake design

Lab 13 - SQL Server 8 kb pages

Lab 14 - Index and performances

Lab 15 - Page split and indexes

Lab 16 - Clustered vs non-clustered

Lab 17 - Stored procedures and their importance

Lab 18 - Change data capture

Lab 19:- Explain columnstore indexes

Lab 20 - SQL server agent

Lab 21 - How can we implement pivot and unpivot in SQL server

Author

Quest Pond

Renowned Trainer and Author MR SHIVPRASAD KOIRALA and Questpond make a team of top MVP recognized professionals in the Microsoft domain. Since 2001, we have trained many professionals in technologies like OOP, ASP.NET, SQL Server, WCF, WPF, WWF, Silverlight, LINQ, Azure, Architecture and Project Management. Questpond is famous for online...

School

Quest Pond's School

Requirements

There are no additional requirements.

Class Contents

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.35
List Price:  €91.94
You save:  €27.58
£54.06
List Price:  £77.24
You save:  £23.17
CA$100.64
List Price:  CA$143.79
You save:  CA$43.14
A$111.07
List Price:  A$158.68
You save:  A$47.61
S$93.78
List Price:  S$133.98
You save:  S$40.20
HK$544.79
List Price:  HK$778.31
You save:  HK$233.51
CHF 61.64
List Price:  CHF 88.06
You save:  CHF 26.42
NOK kr734.31
List Price:  NOK kr1,049.06
You save:  NOK kr314.74
DKK kr482.28
List Price:  DKK kr689.01
You save:  DKK kr206.72
NZ$122.43
List Price:  NZ$174.91
You save:  NZ$52.47
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,505.80
List Price:  ৳12,151.66
You save:  ৳3,645.86
₹5,986.87
List Price:  ₹8,553.03
You save:  ₹2,566.16
RM310.30
List Price:  RM443.30
You save:  RM133
₦107,202.98
List Price:  ₦153,153.68
You save:  ₦45,950.70
₨19,613.09
List Price:  ₨28,019.91
You save:  ₨8,406.81
฿2,354.74
List Price:  ฿3,364.07
You save:  ฿1,009.32
₺2,659.49
List Price:  ₺3,799.44
You save:  ₺1,139.94
B$403.08
List Price:  B$575.86
You save:  B$172.77
R1,280.11
List Price:  R1,828.81
You save:  R548.70
Лв126.51
List Price:  Лв180.73
You save:  Лв54.22
₩102,913.29
List Price:  ₩147,025.29
You save:  ₩44,112
₪258.59
List Price:  ₪369.43
You save:  ₪110.84
₱4,015.29
List Price:  ₱5,736.37
You save:  ₱1,721.08
¥10,487.65
List Price:  ¥14,983
You save:  ¥4,495.35
MX$1,426.47
List Price:  MX$2,037.90
You save:  MX$611.43
QR255.18
List Price:  QR364.56
You save:  QR109.38
P956.11
List Price:  P1,365.94
You save:  P409.82
KSh9,046.20
List Price:  KSh12,923.70
You save:  KSh3,877.50
E£3,539.39
List Price:  E£5,056.49
You save:  E£1,517.10
ብር9,194.76
List Price:  ብር13,135.94
You save:  ብር3,941.17
Kz63,830.88
List Price:  Kz91,190.88
You save:  Kz27,360
CLP$65,878.78
List Price:  CLP$94,116.58
You save:  CLP$28,237.80
CN¥508.37
List Price:  CN¥726.28
You save:  CN¥217.90
RD$4,417.27
List Price:  RD$6,310.66
You save:  RD$1,893.38
DA9,358.50
List Price:  DA13,369.86
You save:  DA4,011.36
FJ$160.90
List Price:  FJ$229.86
You save:  FJ$68.96
Q539.89
List Price:  Q771.31
You save:  Q231.41
GY$14,641.92
List Price:  GY$20,917.93
You save:  GY$6,276
ISK kr9,209.28
List Price:  ISK kr13,156.68
You save:  ISK kr3,947.40
DH677.04
List Price:  DH967.24
You save:  DH290.20
L1,256.33
List Price:  L1,794.83
You save:  L538.50
ден3,985.44
List Price:  ден5,693.73
You save:  ден1,708.29
MOP$560.78
List Price:  MOP$801.14
You save:  MOP$240.36
N$1,271.80
List Price:  N$1,816.94
You save:  N$545.13
C$2,575.39
List Price:  C$3,679.28
You save:  C$1,103.89
रु9,569.36
List Price:  रु13,671.10
You save:  रु4,101.74
S/254.77
List Price:  S/363.97
You save:  S/109.20
K288.46
List Price:  K412.10
You save:  K123.64
SAR262.45
List Price:  SAR374.95
You save:  SAR112.49
ZK2,010.67
List Price:  ZK2,872.51
You save:  ZK861.84
L321.72
List Price:  L459.62
You save:  L137.90
Kč1,612
List Price:  Kč2,302.96
You save:  Kč690.95
Ft26,020.18
List Price:  Ft37,173.28
You save:  Ft11,153.10
SEK kr700.79
List Price:  SEK kr1,001.17
You save:  SEK kr300.38
ARS$74,180.53
List Price:  ARS$105,976.73
You save:  ARS$31,796.20
Bs483.58
List Price:  Bs690.86
You save:  Bs207.28
COP$292,941.74
List Price:  COP$418,506.14
You save:  COP$125,564.40
₡34,974.06
List Price:  ₡49,965.09
You save:  ₡14,991.02
L1,790.29
List Price:  L2,557.67
You save:  L767.38
₲560,625.83
List Price:  ₲800,928.37
You save:  ₲240,302.54
$U2,951.08
List Price:  $U4,216.01
You save:  $U1,264.93
zł270.14
List Price:  zł385.94
You save:  zł115.79

What's Included

Language: English
Level: Beginner
Skills: Software, Database, SQL, Programming, SQL Server
Age groups: All ages
Duration: 8 hours 6 minutes
21 Videos
2 Documents
0
Saves
249
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.