Microsoft SQL Server 2017 for Everyone

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017.

Microsoft SQL Server 2017 for Everyone

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017.
46
views
Share the link to this page
Copied

About the Class

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

We will explore best practices in database development using SQL Server Express 2017 and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What will you learn in this course?

  • Install SQL server
  • Install SQL Management Studio
  • Connect to an instance
  • Create a database
  • Create tables
  • Run Queries against tables
  • General use of the Management Studio
  • Create relationships
  • Use aggregate functions to do quick mathematical operations
  • Export data to Excel using the Management Studio
  • Practical use of SQL
  • Creating and managing database views
  • Creating and managing custom functions; table triggers and stored procedures
  • How to backup and restore databases

Who should take this course?

  • This course is for beginners with absolutely no experience in the database.
  • This course is for you if you are already comfortable with basic database operations.
  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.
  • This course is for you if you want to understand design principles in database development.
  • This course is for you if you are proficient in Microsoft Access and want to learn a new database management system

Author

Admin

School

Admin's School

Requirements

  • You should have a computer
  • You should have a desire to learn database development
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.73
List Price:  €93.91
You save:  €28.17
£56.12
List Price:  £80.18
You save:  £24.05
CA$96.22
List Price:  CA$137.47
You save:  CA$41.24
A$107.81
List Price:  A$154.03
You save:  A$46.21
S$95.15
List Price:  S$135.93
You save:  S$40.78
HK$548.48
List Price:  HK$783.57
You save:  HK$235.09
CHF 63.94
List Price:  CHF 91.35
You save:  CHF 27.40
NOK kr762.14
List Price:  NOK kr1,088.82
You save:  NOK kr326.68
DKK kr490.42
List Price:  DKK kr700.63
You save:  DKK kr210.21
NZ$117.47
List Price:  NZ$167.82
You save:  NZ$50.35
د.إ257.02
List Price:  د.إ367.18
You save:  د.إ110.16
৳7,684
List Price:  ৳10,977.62
You save:  ৳3,293.61
₹5,842.44
List Price:  ₹8,346.70
You save:  ₹2,504.26
RM333.67
List Price:  RM476.69
You save:  RM143.02
₦87,233.43
List Price:  ₦124,624.53
You save:  ₦37,391.10
₨19,461.79
List Price:  ₨27,803.75
You save:  ₨8,341.96
฿2,555.43
List Price:  ฿3,650.78
You save:  ฿1,095.34
₺2,262.32
List Price:  ₺3,232.03
You save:  ₺969.70
B$356.19
List Price:  B$508.86
You save:  B$152.67
R1,315.74
List Price:  R1,879.71
You save:  R563.97
Лв128.32
List Price:  Лв183.32
You save:  Лв55
₩96,716.60
List Price:  ₩138,172.49
You save:  ₩41,455.89
₪264.30
List Price:  ₪377.59
You save:  ₪113.28
₱3,960.09
List Price:  ₱5,657.51
You save:  ₱1,697.42
¥10,727.32
List Price:  ¥15,325.40
You save:  ¥4,598.08
MX$1,158.65
List Price:  MX$1,655.28
You save:  MX$496.63
QR255.28
List Price:  QR364.70
You save:  QR109.42
P960.43
List Price:  P1,372.11
You save:  P411.67
KSh9,102.19
List Price:  KSh13,003.69
You save:  KSh3,901.50
E£3,328.15
List Price:  E£4,754.70
You save:  E£1,426.55
ብር3,971.92
List Price:  ብር5,674.41
You save:  ብር1,702.49
Kz58,276.96
List Price:  Kz83,256.37
You save:  Kz24,979.41
CLP$66,657.14
List Price:  CLP$95,228.57
You save:  CLP$28,571.42
CN¥506.55
List Price:  CN¥723.67
You save:  CN¥217.12
RD$4,145.99
List Price:  RD$5,923.11
You save:  RD$1,777.11
DA9,436.93
List Price:  DA13,481.92
You save:  DA4,044.98
FJ$158.20
List Price:  FJ$226.02
You save:  FJ$67.81
Q545.23
List Price:  Q778.93
You save:  Q233.70
GY$14,659.90
List Price:  GY$20,943.61
You save:  GY$6,283.71
ISK kr9,867.19
List Price:  ISK kr14,096.59
You save:  ISK kr4,229.40
DH703.75
List Price:  DH1,005.40
You save:  DH301.65
L1,235.26
List Price:  L1,764.74
You save:  L529.47
ден4,041.60
List Price:  ден5,773.97
You save:  ден1,732.36
MOP$565.01
List Price:  MOP$807.19
You save:  MOP$242.18
N$1,310.76
List Price:  N$1,872.60
You save:  N$561.83
C$2,576.75
List Price:  C$3,681.23
You save:  C$1,104.48
रु9,339.41
List Price:  रु13,342.59
You save:  रु4,003.17
S/260.34
List Price:  S/371.93
You save:  S/111.59
K268.57
List Price:  K383.69
You save:  K115.11
SAR262.54
List Price:  SAR375.07
You save:  SAR112.53
ZK1,748.59
List Price:  ZK2,498.09
You save:  ZK749.50
L326.82
List Price:  L466.91
You save:  L140.08
Kč1,666.80
List Price:  Kč2,381.25
You save:  Kč714.44
Ft25,759.11
List Price:  Ft36,800.31
You save:  Ft11,041.19
SEK kr760.01
List Price:  SEK kr1,085.77
You save:  SEK kr325.76
ARS$60,593.84
List Price:  ARS$86,566.34
You save:  ARS$25,972.50
Bs485.53
List Price:  Bs693.65
You save:  Bs208.11
COP$268,319.37
List Price:  COP$383,329.81
You save:  COP$115,010.44
₡35,593.98
List Price:  ₡50,850.73
You save:  ₡15,256.74
L1,728.29
List Price:  L2,469.10
You save:  L740.80
₲516,847.12
List Price:  ₲738,384.68
You save:  ₲221,537.56
$U2,707.47
List Price:  $U3,867.98
You save:  $U1,160.51
zł279.99
List Price:  zł400
You save:  zł120.01

What's Included

Language: English
Level: All levels
Skills: Database Design, Microsoft, Microsoft SQL, SQL Server
Age groups: All ages
Duration: 3 hours 42 minutes
23 Videos
0
Saves
46
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.