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
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
Write a review
$795.00
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.
