70-764 SQL Server 2016 Database Administration (DBA)

70-764 SQL Server 2016 Database Administration (DBA), available at $39.99, has an average rating of 3.9, with 78 lectures, based on 20 reviews, and has 140 subscribers.

You will learn about Authenticate and authorize users Assign server and database roles Authorize users to access resources Protect data with encryption and auditing Describe recovery models and backup strategies Backup SQL Server databases Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course is ideal for individuals who are ALL LEVELS It is particularly useful for ALL LEVELS.

Enroll now: 70-764 SQL Server 2016 Database Administration (DBA)

Summary

Title: 70-764 SQL Server 2016 Database Administration (DBA)

Price: $39.99

Average Rating: 3.9

Number of Lectures: 78

Number of Published Lectures: 78

Number of Curriculum Items: 78

Number of Published Curriculum Objects: 78

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Authenticate and authorize users

Assign server and database roles

Authorize users to access resources

Protect data with encryption and auditing

Describe recovery models and backup strategies

Backup SQL Server databases

Restore SQL Server databases

Automate database management

Configure security for the SQL Server agent

Manage alerts and notifications

Managing SQL Server using PowerShell

Trace access to SQL Server

Monitor a SQL Server infrastructure

Troubleshoot a SQL Server infrastructure

Import and export data

Who Should Attend

ALL LEVELS

Target Audiences

ALL LEVELS

this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist you in preparing for the 70-764: Administering a SQL Database Infrastructure exam.

Course Curriculum

Chapter 1: The Course Guide Explanation

Lecture 1: Welcome

Lecture 2: Course structure

Chapter 2: Module 0 : Preparing The Enviroment

Lecture 1: Setup The domain

Lecture 2: Installing The SQL Server 2016

Lecture 3: Recourse Needed

Chapter 3: Module 1 : SQL Server Security

Lecture 1: Lesson 1 : Authenticating Connections to SQL Server

Lecture 2: Lesson 1 [LAB] : Authenticating Logins

Lecture 3: Lesson 2 : Authorizing Logins to Connect to Databases

Lecture 4: Lesson 2 [LAB] : Authorizing Logins and User Tokens

Lecture 5: Lesson 3 : Partially Contained Databases

Lecture 6: Lesson 3 [LAB] : Creating a Partially Contained Database

Chapter 4: Module 2 : Assigning Server and Database Roles

Lecture 1: Lesson 1 : Working with Server Roles

Lecture 2: Lesson 1 [LAB] : Assigning Fixed and User-Defined Server Roles

Lecture 3: Lesson 2: Working with Fixed Database Roles

Lecture 4: Lesson 2 [LAB] : Managing Database Roles and Users

Lecture 5: Lesson 3 : User-Defined Database Roles

Lecture 6: Lesson 3 [LAB] : User-Defined Database Roles

Chapter 5: Module 3 : Authorizing Users to Access Resources

Lecture 1: Lesson 1 Authorizing User Access to Objects

Lecture 2: Lesson 1 [LAB] : Authorizing User Access to Objects

Lecture 3: Lesson 2 Authorizing Users to Execute Code

Lecture 4: Lesson 2 [LAB] Authorizing Users to Execute Code

Lecture 5: Lesson 3 Configuring Permissions at the Schema Level

Lecture 6: Lesson 3 [LAB] Configuring Permissions at the Schema Level

Chapter 6: Module 4 Protecting Data with Encryption and Auditing

Lecture 1: Lesson 1 Options for Auditing Data Access in SQL Server

Lecture 2: Lesson 1 [LAB] : Auditing with Temporal Tables

Lecture 3: Lesson 2 Implementing SQL Server Audit

Lecture 4: Lesson 2 [LAB] Using SQL Server Audit

Lecture 5: Lesson 3 Managing SQL Server Audit

Lecture 6: Lesson 3[LAB] Managing SQL Server Audit

Lecture 7: Lesson 3.1 [LAB] Viewing the Output of SQL Server Audit

Lecture 8: Lesson 4 Protecting Data with Encryption

Lecture 9: Always Encrypted ,TDE,restoring Encrypted Bcakup [LAB]

Lecture 10: Dynamic Data Masking [Lab]

Lecture 11: Cell Encryption [LAB]

Chapter 7: Module 5 Recovery Models and Backup Strategies

Lecture 1: Lesson 1 Understanding Backup Strategies

Lecture 2: Lesson 2 SQL Server Transaction Logs

Lecture 3: Lesson 3 Planning Backup Strategies

Lecture 4: Module 5 [LAB]

Chapter 8: Module 6 Backing Up SQL Server Databases

Lecture 1: Lesson 1 Backing Up Databases and Transaction Logs

Lecture 2: Lesson 2 Managing Database Backups

Lecture 3: Lesson 2 [LAB] Verifying Backups

Lecture 4: Lesson 3 Advanced Database Options

Chapter 9: Module 7 Restoring SQL Server Databases

Lecture 1: Lesson 1 Understanding the Restore Process

Lecture 2: Lesson 2 Restoring Databases

Lecture 3: Lesson 3 Advanced Restore Scenarios

Lecture 4: Lesson 4 Point-in-time Recovery

Lecture 5: Module 7 [LAB]

Chapter 10: Module 8 Automating SQL Server Management

Lecture 1: Lesson 1 Automating SQL Server Management

Lecture 2: Lesson 2 Working with SQL Server Agent

Lecture 3: Lesson 3 Managing SQL Server Agent Jobs

Lecture 4: Module 8 [LAB]

Chapter 11: Module 9 Configuring Security for SQL Server Agent

Lecture 1: Configuring Security for SQL Server Agent

Lecture 2: Module 9 [LAB]

Chapter 12: Module 10 Monitoring SQL Server with Alerts and Notifications

Lecture 1: Lesson 1 Monitoring SQL Server Errors

Lecture 2: Lesson 2 Configuring Database Mail

Lecture 3: Module 10 [LAB] part 1 Configure Database Mail

Lecture 4: Module 10 [LAB] part 2 Alert and Notification

Chapter 13: Module 11 Introduction to Managing SQL Server Using PowerShell

Lecture 1: Lesson 1 Getting Started with Windows PowerShell

Lecture 2: Lesson 2 Configure SQL Server Using PowerShell

Lecture 3: Lesson 3 Administer and Maintain SQL Server with PowerShell

Lecture 4: Module 11 [LAB]

Chapter 14: Module 12 Tracing Access to SQL Server with Extended Events

Lecture 1: Lesson 1 Extended Events Core Concepts

Lecture 2: Lesson 1 [LAB] : Creating an Extended Events Session

Lecture 3: Lesson 2 Working with Extended Events

Lecture 4: Lesson 2 [LAB] Tracking Session-Level Waits

Chapter 15: Module 13 Monitoring SQL Server

Lecture 1: Lesson 1 Monitoring Activity Part 1

Lecture 2: Lesson 1 Part 2

Lecture 3: Lesson 1 Part 3

Lecture 4: Lesson 1 [LAB]

Lecture 5: Lesson 2 Capturing and Managing Performance Data

Lecture 6: Lesson 3 Analyzing Collected Performance Data

Lecture 7: Lesson 2,3 [LAB]

Chapter 16: Module 14 Troubleshooting SQL Server

Lecture 1: Lesson 1 A Troubleshooting Methodology for SQL Server

Lecture 2: Lesson 2 Resolving Service-Related Issues

Lecture 3: Lesson 3 Resolving Connectivity and Login Issues

Lecture 4: Module 14 [LAB]

Chapter 17: Module 15 Importing and Exporting Data

Lecture 1: Lesson 1 Export and Import

Lecture 2: Lesson 1 [LAB] Export and Import

Instructors

itcomtek .com
itComtek.com

Rating Distribution

1 stars: 3 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 6 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!