SQL Server 2016 Administration
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
108 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server 2016 Administration to your Wishlist.

Add to Wishlist

SQL Server 2016 Administration

Newest and beneficial features of SQL Server 2016
New
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
108 students enrolled
Created by Raphael Asghar
Last updated 8/2017
English
Current price: $12 Original price: $20 Discount: 40% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • At the end of this course, the student will be able to learn, configure, and manage the newest features of SQL Server 2016 administration such as data masking, temporal tables, polybase, row level security and much more
View Curriculum
Requirements
  • To follow and benefit from this course, you must have taken the prerequisite courses: Learn T-SQL from Scratch, SQL Administration part 1, 2 and 3
Description

Welcome to SQL Server 2016 Administration. In this course, the student will be exposed to the latest and newest features that SQL Server 2016 has to offer.  The student will learn about data masking, temporal tables, row level security, Azure cloud technology, stretch database configuration, live query statistics and much more.  With this experience, the student will be able to configure, manage, deploy the latest features that are only available in SQL Server 2016 and as a result gain an advantage over the other IT professionals

Who is the target audience?
  • Any student that wants to learn and administrate SQL Server 2016 and gain the benifits from the newest features
Compare to Other SQL Server Courses
Curriculum For This Course
37 Lectures
06:33:13
+
Introduction to SQL Server 2016 New Features and Administration
37 Lectures 06:33:13


2 Creating a VM with Windows OS
15:35

3 Installing sql 2016
10:00

3 Installing sql 2016 part 2
11:08

4 Installing SSMS
02:56

4a Installing SSMS
03:53

5 Installing sample dbs
06:59

6 Dynamic Data Masking
10:00

6 Dynamic Data Masking part 2
13:28

7 Row Level Security
19:20

8 Stretch database
08:47

9 Reasons to create stretch database
16:22

10 Cost of Azure
05:27

10b Create an Azure account
16:55

11 Stretch Demo
18:54

11a restoring stretch db
08:46

12 Live Query Statistics
09:38

13 Temporal Tables
10:00

13a Temporal Table part 2
19:47

14 Query Store
10:00

14a Query Store part 2
16:49

15 Forced Plan
10:00

15a Forced Plan
11:00

16 What is In Memory OLTP
18:19

17 In Memory OLTP demo
10:00

17a In Memory OLTP demo part 2
10:02

18 Determining memory tables
09:05

19 Restart services
03:39

20 Demo of performance and IO
13:18

21 Polybase
13:34

22 Azure Blob storage setup
13:00

22a Azure Blob storage setup
13:31

23 set up polybase
11:17

24 delete azure account
04:30

25 R technology
01:05

BONUS VIDEO AND DOCS
03:23
About the Instructor
Raphael Asghar
4.5 Average rating
2,385 Reviews
25,061 Students
13 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.