Microsoft 70-764 – SQL Server 2016 Administration

Course Level: Beginner
Duration: 21 Hrs 14 Min
Total Videos: 106 On-demand Videos

Dive into the world of database management with our Microsoft SQL Server Administration course, designed to equip IT professionals, database administrators, and developers with in-depth knowledge of SQL Server infrastructure. Learn how to configure encryption, manage data access, and implement high availability solutions, preparing you for Microsoft's 70-764 certification exam and a rewarding career in SQL Server database administration.

Get Access To Every Vision Training Course

Learning Objectives

01

Understand and apply encryption configurations, including cell-level, transparent data, and backup encryption.

02

Learn to configure data access and permissions, create and maintain users, and manage database object permissions.

03

Understand and perform auditing tasks on SQL Server and Azure SQL Server.

04

Develop and implement a comprehensive backup strategy, including managing large databases and setting up alert systems.

05

Master the process of database restoration, including piecemeal restores, page recovery, and point-in-time recovery.

06

Learn to manage database integrity through consistency checks and corruption recovery strategies.

07

Gain skills in monitoring database activity, identifying problematic sessions, and configuring data collectors.

08

Effectively manage and monitor SQL Server instances, implement log shipping, and set up Always On Availability Groups.

Course Description

Take your SQL Server skills to the next level with our comprehensive course on Microsoft 70-764 – SQL Server 2016 Administration. This course is designed to equip you with the expertise needed to proficiently administer a SQL Server database infrastructure. Based on Microsoft’s 70-764 certification exam, this course offers a deep dive into crucial topics, including configuring encryption, managing data access and permissions, setting up auditing, and implementing backup strategies. You’ll also learn how to restore databases, maintain database integrity, monitor database activities, and roll out high availability and disaster recovery solutions. This course is ideal for aspiring and current SQL Server Database Administrators aiming to validate their skills with a recognized certification.

Our course offers a balanced mix of theoretical knowledge and hands-on learning, providing you with a practical understanding of SQL Server administration tasks. Through a series of lectures, demonstrations, and lab exercises, you’ll get the chance to apply what you’ve learned in a real-world context. By the end of this course, you’ll have mastered how to configure user options for Azure SQL Database, manage database object permissions, and much more. This course caters to IT professionals, database administrators, and developers eager to enhance their SQL Server administration skills.

Whether you are a seasoned DBA looking to upskill, a beginner aiming to kickstart a career in database administration, or an IT professional tasked with managing SQL Server databases, this course is tailored to your needs. Our Microsoft SQL Server Administration course provides you with the knowledge and skills necessary to excel in your career. Enroll today and start your journey towards becoming a proficient SQL Server Database Administrator.

Who Benefits From This Course

  • Database administrators seeking to deepen their understanding of SQL Server 2016
  • IT professionals who work with data integrity and want to improve their skills
  • Cloud database managers looking to improve their knowledge of Azure SQL database user options
  • Database developers interested in learning more about encryption, data access, and permissions
  • IT specialists who want to develop a comprehensive backup strategy for large databases
  • System administrators interested in improving their skills in monitoring SQL Server Instances
  • IT managers looking to implement effective failover cluster strategies
  • Professionals responsible for implementing and managing Always On Availability Groups
  • Individuals preparing for the Microsoft 70-764 certification exam

Frequently Asked Questions

What is the role of a SQL Server Database Administrator?
A SQL Server Database Administrator (DBA) manages the SQL Server database infrastructure. They are responsible for configuring encryption, managing data access and permissions, configuring auditing, developing and implementing backup strategies, restoring databases, managing database integrity, monitoring database activity, and implementing high availability and disaster recovery solutions. SQL Server DBAs also optimize database performance, enforce security protocols, and ensure data consistency and availability. Their role is crucial in any organization that relies on databases to store and manipulate data.
What is the Microsoft 70-764 certification exam?
The Microsoft 70-764 certification exam, also known as "Administering a SQL Database Infrastructure," is designed to test a candidate's knowledge and skills in SQL Server administration. It covers a wide range of topics, including data access and permissions, database backups and restoration, database integrity management, and implementing high availability and disaster recovery solutions. Passing this exam is a stepping stone towards becoming a certified SQL Server Database Administrator.
What skills are required to become a SQL Server Database Administrator?
To become a SQL Server Database Administrator, you need a strong understanding of SQL Server administration tasks. This includes configuring encryption, managing data access and permissions, configuring auditing, developing and implementing backup strategies, restoring databases, managing database integrity, and implementing high availability and disaster recovery solutions. Additionally, you should have a good understanding of Azure SQL Database and how to configure user options for it. General IT knowledge, problem-solving skills, and attention to detail are also essential.
What is the job outlook for SQL Server Database Administrators?
The demand for SQL Server Database Administrators is growing as more organizations rely on databases to store and manipulate data. DBAs play a crucial role in managing and securing these databases. According to the U.S. Bureau of Labor Statistics, employment of database administrators (including SQL Server DBAs) is projected to grow 10% from 2019 to 2029, much faster than the average for all occupations. This growth is driven by the increased data needs of companies across the economy.
How relevant is the Microsoft 70-764 certification in today's job market?
The Microsoft 70-764 certification is highly relevant in today's job market. It validates your skills in SQL Server administration and can increase your chances of landing a job as a SQL Server DBA. Many employers prefer or require certification as it demonstrates a standardized level of knowledge and expertise. By earning this certification, you can distinguish yourself from other job applicants and increase your potential earning power.

Included In This Course

Module 1: Configure Encryption

  •    Introduction
  •    Exam Objectives and Lab Setup
  •    Restoring AdventureWorks 2016 Database Lab Part 1
  •    Restoring AdventureWorks 2016 Database Lab Part 2
  •    Restoring AdventureWorks 2016 Database Lab Part 3
  •    Configure Encryption
  •    Cell-Level Encryption Part 1
  •    Cell-Level Encryption Part 2
  •    Cell-Level Encryption Lab Part 1
  •    Cell-Level Encryption Lab Part 2
  •    Transparent Data Encryption
  •    Transparent Data Encryption Lab
  •    Always Encrypted
  •    Always Encrypted Lab
  •    Backup Encryption
  •    Backup Encryption Lab
  •    Connection Encryption
  •    Encryption Troubleshooting

Module 2: Configure Data Access and Permissions

  •    Create and Maintain Users
  •    Create and Maintain Users Lab Part 1
  •    Create and Maintain Users Lab Part 2
  •    Configure and Maintain Custom Roles
  •    Configure and Maintain Custom Roles Lab
  •    Manage Database Object Permissions Part 1
  •    Manage Database Object Permissions Part 2
  •    Manage Database Object Permissions Lab Part 1
  •    Manage Database Object Permissions Lab Part 2
  •    Configure User Options for Azure SQL Database
  •    Configure Row-Level Security
  •    Configure Dynamic Data Masking
  •    Configure Dynamic Data Masking Lab

Module 3: Configure Auditing

  •    Manage a SQL Server Audit
  •    Manage a SQL Server Audit Lab
  •    Query the SQL Server Audit Log
  •    Manage an Azure SQL Server Audit

Module 4: Develop a Backup Strategy

  •    Backup Types Part 1
  •    Backup Types Part 2
  •    Manage, Backup, and Restore Databases Lab Part 1
  •    Manage, Backup, and Restore Databases Lab Part 2
  •    Backup Very Large Databases Part 1
  •    Backup Very Large Databases Part 2
  •    Backup Very Large Databases Part 3
  •    Backup Very Large Databases Part 4
  •    4.9 Managing Very Large Databases Lab Part 1
  •    4.10 Managing Very Large Databases Lab Part 2
  •    4.11 Managing Very Large Databases Lab Part 3
  •    Configure Alerting for Failed Backups
  •    Configure Alerting for Failed Backups Lab Part 1
  •    Configure Alerting for Failed Backups Lab Part 2
  •    Back up Databases to Azure
  •    Manage Transaction Log Backups
  •    Configure Database Recovery Models
  •    Set Database Recovery Model Lab
  •    Configure Backup Automation
  •    Configure Backup Automation Lab

Module 5: Restore Databases

  •    Perform Piecemeal Restores
  •    Restore Databases Lab Part 1
  •    Restore Databases Lab Part 2
  •    Restore Databases Lab Part 3
  •    Perform Page Recovery
  •    Perform Point-in-Time Recovery
  •    Perform Point-in-Time Recovery Lab
  •    Restore File Groups
  •    Develop a Plan to Automate and Test Restores

Module 6: Manage Database Integrity

  •    Implement Database Consistency Checks
  •    Implement Database Consistency Checks Lab
  •    Identify Database Corruption
  •    Recover From Database Corruption

Module 7: Monitor Database Activity

  •    Monitor Current Sessions
  •    Monitor Current Sessions Lab
  •    Identify Sessions that Cause Blocking Activity
  •    Identify Sessions that Consume tempdb Resources
  •    Configure the Data Collector

Module 8: Monitor Queries

  •    Manage the Query Store
  •    Manage the Query Store Lab
  •    Configure Extended Events and Trace Events
  •    Identify Problematic Execution Plans

Module 9: Manage Indexes

  •    Identify and Repair Index Fragmentation
  •    Identify and Create Missing Indexes
  •    Identify and Drop Underutilized Indexes
  •    Manage Existing Columnstore Indexes Part 1
  •    Manage Existing Columnstore Indexes Part 2
  •    Partitioned Tables

Module 10: Monitor SQL Server Instances

  •    Create and Manage Operators
  •    Create and Manage SQL Agent Alerts
  •    Configure Policy-Based Management
  •    Configure Policy-Based Management Lab
  •    Identify Available Space on Data Volumes
  •    Identify the Cause of- Manage Performance Degradation
  •    Identify the Cause of- Manage Performance Degradation Lab Part 1
  •    Identify the Cause of- Manage Performance Degradation Lab Part 2

Module 11: Implement Log Shipping

  •    Configure and Monitor Log Shipping
  •    Configure and Monitor Log Shipping Lab Part 1
  •    Configure and Monitor Log Shipping Lab Part 2

Module 12: Implement Failover Cluster Instances

  •    Windows Server Failover Cluster
  •    Manage Shared Disks
  •    Configure Cluster Shared Volumes
  •    Configuring WSFC Lab

Module 13: Implement Always On Availability Groups

  •    Database Mirroring
  •    Create an Availability Group
  •    Manage Failover
  •    Configure Read-Only Routing
  •    Create Distributed Availability Groups
  •    Configuring Always On Availability Group Lab Part 1
  •    Configuring Always On Availability Group Lab Part 2
  •    Conclusion

Vision What's Possible

Vision Your Best Career
365
Price: $139 / YEAR

Gain unlimited access to our comprehensive IT training library featuring top certifications like CompTIA, Cisco, Microsoft, AWS, and more. Explore expert-led courses in cybersecurity, networking, cloud computing, project management, and soft skills development—all designed to help you build real-world, job-ready skills. With the 365 Training Pass, you can start learning today and accelerate your path to a successful IT career.

Sign Up for my 365 access pass today
  • 855-488-5327
  • customerservice@visiontrainingsystems.com

Navigate With Us