• 0800 677 1232
  • info@robustittraining.com
  • Facebook:
  • LinkedIn:
  • Youtube:
  • Black Friday Sale Has Started: Click here to see deals

MCSA SQL Server 2016 Admin

EXAM CODES 70-764

About

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Who should take this exam?

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.

Benefits of training with us

  • Intuitive and rewarding online training resources

  • 24/7 access to our unique course materials

  • Custom built practical tasks and challenges
  • Official mock examinations to fully prepare you for any final exams
  • Career advice and CV support once training has been completed
  • Full printable course materials, allowing you take your learning offline at your own convenience

Enquiry Form

Request More Information

Configure data access and auditing (20-25%)
Configure encryption
  • Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors
Configure data access and permissions
  • Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking
Configure 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

Manage backup and restore of databases (20-25%)
Develop a backup strategy
  • Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation
Restore databases
  • Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores
Manage database integrity
  • Implement database consistency checks, identify database corruption, recover from database corruption

Manage and monitor SQL Server instances (35-40%)
Monitor database activity
  • Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector
Monitor queries
  • Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using 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
  • Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables
Monitor SQL Server instances
  • Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation

Manage high availability and disaster recovery (20-25%)
Implement log shipping
  • Configure log shipping, monitor log shipping
Implement AlwaysOn Availability Groups
  • Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups
Implement failover cluster instances
  • Manage shared disks, configure cluster shared volumes

  • Official Microsoft 70-764 Exam
  • Online or classroom training
  • Interactive mock exams
  • Live Lab (access to LIVE software)
  • Free Phone Support
  • Online & Email Support
  • World wide Recognised Qualification
  • Unlimited access for 12 months
  • Database Administrator
  • IT Security Specialist
  • Network Administrator
  • Systems Analyst
  • Database Engineer
  • Computer Network Technician
  • Database Architect

Courses you might also be interested in

MTA Database Fundamentals


This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on...

Find out more

MCSA SQL Server 2012/2014


This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. This exam is intended for SQL Server database administrators, system engineers...

Find out more

MCSA SQL Server 2016 Development


This exam is intended for database professionals who build and implement databases across organisations and who ensure high levels of data availability. Their responsibilities include creating database files, data types ...

Find out more

MCSA SQL Server 2016 Admin


This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently...

Find out more

Our training is trusted and accredited
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1