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

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 >>>>>>>>>>>>>>>>

English
language

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

The post Microsoft SQL Server 2016 Certification (70-764) Advance appeared first on StudyBullet.

Check Today's 30+ Free Courses on Telegram!

X
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock