Facebook

70-764: Administering a SQL Server 2016 Database Infrastructure eLearning

* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us:  sales@ccslearningacademy.com.

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us

psinghal
Last Update April 3, 2024
0 already enrolled

About This Course

Course Description:

In this instructor-led, online training course, students will learn the knowledge and skills to administer a SQL server database infrastructure. Students will be taught how to authenticate and authorize users, protect data with encryption and auditing, backup and restore SQL Server, configure security for the SQL Server agent, and more.

Exam Number: 70-764

Learning Objectives

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

Inclusions

  • Accessible 24x7x365 both from your PC and Mobile Device
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*
  • *For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com
  • NOTE: These are our Partner Delivered eLearning.

Pre-requisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Target Audience

  • This instructor led, online training course is for those who administer and maintain SQL Server databases.

Curriculum

52 Lessons

1. Configuring auditing

Configure an audit on SQL Server
Query the SQL Server audit log
Manage a SQL Server audit
Configure an Azure SQL database audit
Analyze audit logs and reports from Azure SQL database

2. Developing a backup strategy

3. Monitoring database activity

4. Monitoring Queries

5. Managing indexes

6. Managing statistics

7. Monitoring queries

8. Implement log shipping

9. Implement AlwaysOn availability groups

10. Implement failover cluster instances

11. Monitoring database activity

Your Instructors

psinghal

0/5
440 Courses
0 Reviews
0 Students
See more

Write a review

IMG1696444711.jpg

$795.00

Level
Intermediate
Lectures
52 lectures

Inclusions

  • Accessible 24x7x365 both from your PC and Mobile Device
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*
  • *For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com
  • NOTE: These are our Partner Delivered eLearning.
#edumall-wp-widget-courses-1 { display: none; } #single-course-ratings { display: none; } .tutor-single-course-lead-meta { display: none; } .lead-meta-item meta-course-total-enrolled { display: none; }