Udemy

Platform

English

Language

IT Certification

Category

Microsoft SQL Server 2016 Certification (70-764) Advance

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and (70-764) certification

3.35 (116 reviews)

Students

9.5 hours

Content

Jan 2019

Last Update
Regular Price

SKILLSHARE
SkillShare
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

Administrating of Microsoft SQL Server database and learn day to day DBA activities


Description

SQL Server supports mission critical applications and big data solutions without having to buy expensive add-ons or high-end appliances. Learn Microsoft's latest release SQL Server 2016. Use tools like SQL Management Studio and the Configuration Monitor to deploy and manage databases both on premises and in the cloud. Learn how to create new databases, build tables, define relationships, write queries, and use stored procedures and built-in functions. Show you how to manipulate XML and JSON data, and perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring. Plus, find out how to extend SQL Server by integrating it with cloud services like Microsoft Azure.

The following Topics will be covered

Basics:  

·         Installing SQL Management Studio  

·         Using SQL Server Configuration Monitor  

·         Creating a database  

·         Creating tables with SMS and T-SQL  

·         Creating relationships between tables  

·         Creating views  

·         Writing queries to return XML  

·         Working with XML and JSON  

·         Backing up and restoring SQL Server  

·         Monitoring and management  

·         Security    ·         Performance 


Advance SQL 2016 [ SQL Database Infrastructure (70-764) certification exam]


  • How to Configuring encryption

Encryption overview

Implement cell-level encryption

Configure transparent data encryption

implement always Encryption

implement backup encryption

Configure encryption for connections

  • Manage database integrity

Identify Database Corruption

Implement Database Consistency

Recover from database corruption

  • Monitor Database Activity

Monitor current sessions

identify causes of blocking activity

Find sessions that use tempdb

Configure the data collector

  • Monitor Queries

Manage the query Store

Configure trace events

Identify problematic execution

Server health and extended events

  • Manage Indexes

Identify And Repair Index Fragmentation

Identify And Create Missing Indexes

Identify And Drop Underutilized Indexes

Manage existing columnstore indexes

  • Manage Statistics

Statistics objects

identify and Correct outdated statistics

Implement Auto Update Statistics

Implement statistics for large Tables


·  Integrating SQL Server with cloud services like Azure

How to setup DR and high availability(ALWAYS-ON) step by step demo

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>SQL-Server Interview Questions >>>>>>>>>>>>>>>>


   


Screenshots

Microsoft SQL Server 2016 Certification (70-764) Advance
Microsoft SQL Server 2016 Certification (70-764) Advance
Microsoft SQL Server 2016 Certification (70-764) Advance
Microsoft SQL Server 2016 Certification (70-764) Advance

Content

Introduction

Introduction

Overview of SQL Server

Understanding Core features of SQL Server 2016

SQL Server Editions

How to Install SQL Server 2016

SQL Server Basic Installation

Advance installation Options

How to Install SQL Studio in SQL 2016

SQL Server tools

SQL server Configuration Manager

Basics of SQL management Studio

More about SQL Management Studio tool

SQL Activity Monitor tool

SQL Profiler

Creating and Configuring SQL databases

How to Create SQL Database

Advance Database Configuration Options

How to install Sample Database

Creating table in the databases

Creating Table using Management Studio

Understanding Data Column Options

Create a table using T-SQL

Create relationships between Tables

In-memory tables in SQL Server

Temporary tables in SQL Server

Creating Views in Databases

How to create view

Understanding advance option of views

Understanding Programmability in SQL Server

What is store procedure in SQL Server

Parameterized stored procedures in SQL Server

Built in Functions in SQL Server

Scalar Functions

Working with XML

Introduction to XML

writing queries to return XML

What is shred XML

Working with XML schemas

Storing XML

Working with JSON

what is JSON

Converting JSON to tabular Data

Storing JSON

SQL Server Backup and Restore

Overview of Backup and Restore in SQL Server

Basics Backups

Basic restore SQL backup

Creating maintenance plans to automate

Add a cleanup task to a maintenance plan

Monitoring and management in SQL server

Reviews the SQL Server Logs

Audit Login to SQL Server

Understanding dynamic Management views in SQL

Use of database console Commands (DBCC)

Overview of High Availability in SQL Server

Security in SQL Server

Overview of authentication methods in SQL Server

Instance Level Logins in SQL Server

Database Level Users

How to Encrypt Data

Dynamic Masking Feature in SQL 2016

Performance of SQL Databases

Basics of Indexes

How to create index

Column Store Index

What is execution plan in SQL Server

Overview of Query Store in SQL 2016

Microsoft Cloud

Backup to Azure cloud

SQL Server Interview Questions

Configuring encryption MSSQL 2016

What is Encryption?

Implement cell-level encryption

How to Configure transparent data encryption

implement always Encryption

implement backup encryption

Configure encryption for connections

Manage Database Integrity

Identify Database Corruption

Implement Database Consistency

Recover From Database Corruption

Monitor Database Activity

Monitor Current Sessions

Identify Causes of Blocking Activity

Find sessions that use tempdb

Configure the Data Collector

Monitor Queries

Manage the query Store

Configure Trace Events

Identify Problematic Execution

Server Health and Extended Events

Manage Indexes

Identify And Repair Index Fragmentation

Identify And Create Missing Indexes

Identify And Drop Underutilized Indexes

Manage existing columnstore indexes

Manage Statistics

Statistics objects

identify and Correct outdated statistics

Implement Auto Update Statistics

Implement statistics for large Tables

TEST LAB SQL Server Always-ON Feature Step by Step

introduction

Building the Domain Controller

Creating a Domain Account and Joining a SQL Server to the Domain

Creating a Windows Fail over Cluster and a SQL Server Availability Group


Reviews

R
Rainier24 July 2020

Loved this course. Looking for a quick refresher for a job interview so the pace and content was perfect. Easy voice to listen to and broken up into digestible pieces

A
Anderson6 February 2020

Didn't like very much how the instructor conducted the lessons, there were times when he would be quite for some periods of time. His pacing wasn't very thrilling which gave the lessons a tiny bit of boredom. He does know a lot about SQL Server, but I didn't feel like he was able to teach on the same proportion.

J
Jeter27 January 2020

He certainly is knowledgeable, but most importantly he really and I can't stretch this enough, he really can teach very well

D
Dallas2 September 2019

The information was good, but was difficult to follow with the combination of slow speech and accent.

D
Dinesh30 August 2019

Not at all ! you have not given basic tutorial about creating table inserting data into it & relations between table. Just u have imported data & gone further

R
Roderick30 June 2019

As of now I must answer no. I am thoroughly convinced that the instructor is reading from a script, the actions do not always correspond to the message being conveyed, and he know nothing to very little about SQL Server.

J
Jeffrey7 June 2019

a little different then what i was looking for, and i had a hard time getting the testdb used in the course to work properly. besides that the course was nice and provided a lot of different aspects of microsoft sql that may help me in the future.

S
Sachin12 May 2019

Hi, Trainer English is very poor and it's not synced with the video and he is not provided wide picture of editions and concept is very poor. I want refund for this videos. please initiate refund.

K
Kervon19 April 2019

The accent takes a short time to get accustomed to and the content is detailed enough. The only issue is sometimes the actions taken in the video lags behind the actions being described in the audio.

R
Roman9 March 2019

Hayat has an in depth knowledge of the content and has formulated the course in a very precise manner, i have learned a lot from him thanks

A
Angela7 March 2019

The instructor isn't showing a step by step process at all and didn't even show you where to get a free versions of SQL Server 2016. He's using a licensed version. He also didn't go through the installation process very carefully. This is suppose to be for the SQL certification and it's not.

E
Erick28 February 2019

This is an excellent course in order to get a quick and general foundation to SQL and understanding databases with practically demo and examples

S
Shannon15 January 2019

Compare to other SQL related training materials and provider, I think this one provides more detailed and hands on demo with example

J
James5 December 2018

This course is very detailed step by step process and explanations, which makes very understanding of the subject topic for new/non IT person. Now I am confident that, I will continue learning SQL Platform. Thanks for creating the excellent course

C
Carlimtiamarie24 November 2018

Amazing course for beginner even for middle level career who want to start their career as SQL DBA it start from basic to advance enclosed different types of installation basic/advance, backup, JSON Data, function, store procedure and other valuable information with hands-on it is practical course as ever seen on udemy thank instructor for sharing your knowledge.


Coupons

DateDiscountStatus
10/25/201982% OFFExpired
5/26/202082% OFFExpired
6/10/202182% OFFExpired
7/20/202182% OFFValid

1551000

Udemy ID

2/12/2018

Course created date

10/25/2019

Course Indexed date
Bot
Course Submitted by