Microsoft 70-764 - SQL Server 2016 Administration - ITU Online

Microsoft 70-764 – SQL Server 2016 Administration

The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.

Included In This Course

21 Hrs 14 Min
Videos
106 On-demand Videos
Closed Captions

Closed Captions

Course Topics
13  Topics
Question & Answers
250 Prep Questions
Certificate of Completion

Certificate of Completion

Note: Although the associated examination for this course has been retired, it is a good resource for online training.

Course Description

Empowering Your SQL Server Skills: Microsoft 70-764 Certification Journey

Embark on a transformative journey with our Microsoft 70-764 – SQL Server 2016 Administration course. Tailored for IT professionals aiming to master SQL Server 2016, this comprehensive training program is your gateway to achieving the coveted Microsoft Certification in SQL Server 2016 Administration. Though the associated exam has been retired, the skills and knowledge you gain remain invaluable in the IT industry. From understanding the nuances of SQL Server installation to mastering intricate maintenance tasks, this course is your roadmap to becoming a proficient SQL Server administrator. Elevate your professional credentials and stay ahead in the dynamic world of database management.

Course Benefits

Unlocking Potential: Advantages of Microsoft 70-764 Training

  1. Comprehensive Knowledge Base: Dive deep into SQL Server 2016 with 21 hours of expert-led training and 106 on-demand videos. Gain insights into essential topics like data encryption, database backup and restoration, and SQL Server instance management.

  2. Practical Skill Development: Engage in hands-on learning with practical exercises and 250 preparatory questions. These interactive components are designed to solidify your understanding and prepare you for real-world SQL Server administration challenges.

  3. Certification of Completion: Upon finishing the course, receive a Certificate of Completion, symbolizing your enhanced expertise in SQL Server 2016 Administration. This certification not only boosts your resume but also demonstrates your commitment to continuous learning and professional growth.

Who Is The Course For

Tailored Learning: Who Benefits Most from the Microsoft 70-764 Course?

    1. Aspiring SQL Server Administrators: Ideal for IT professionals responsible for installing, configuring, and maintaining Microsoft SQL Server environments. This course is a stepping stone for those seeking to specialize in SQL Server 2016 administration.

    2. Experienced IT Professionals: Perfect for individuals with at least two years of experience in SQL Server, looking to update and expand their skill set in line with the latest SQL Server 2016 features and best practices.

    3. Teams Seeking Unified Skills: A valuable resource for teams aiming to collectively upgrade their knowledge in SQL Server 2016. Enhance your team’s capabilities and ensure they are equipped with up-to-date skills in database administration.

Frequently Asked Questions About Microsoft 70-764 – SQL Server 2016 Administration

What is the aim of the Microsoft 70-764 SQL Server 2016 Administration online course?

This IT training course is designed to equip you with all the skills and knowledge necessary to administer a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks. It helps you prepare for the Microsoft Certification Exam 70-764​.

Who is the ideal candidate for this online course?

The course is intended for IT professionals responsible for installing, configuring, and maintaining a Microsoft SQL Server environment. Typically, students preparing for this course will have at least 2 years of experience working with SQL Server.

What will I learn during this course?

This course includes 22 hours of training and 106 videos. You’ll learn essential skills on how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting. You’ll also learn how to create an Availability Group, manage failover, configure read-only routing, and create distributed availability groups​.

What happens after the 7-day free trial of the All Access Monthly Subscription?

After the 7-day free trial, you’ll be automatically enrolled in the monthly subscription where you can access this training and over 2,500 hours of on-demand content. If you wish to cancel your subscription, you can do so anytime without any obligation.

I noticed the associated exam for this course has been retired. Is the course still relevant?

Absolutely! Although the associated exam for this course has been retired, this course remains a valuable resource for online training. It provides comprehensive knowledge about administering a complete Microsoft SQL 2016 server solution, which is still widely used today.

Can I buy this course for my entire team?

Yes, you can! If you’re interested in buying this course for your entire team, you can contact us to discuss the details. It’s a great way to ensure your team is up-to-date with the latest SQL Server 2016 administration skills.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Microsoft 70-764 SQL 2016 - Administering a SQL Database Infrastructure Course Content

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
Add a review
Currently, we are not accepting new reviews
4.8
Based on 81 reviews
1-5 of 81 reviews
  1. SJ

    good

  2. AA
  3. K
  4. BO
  5. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructor

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Microsoft 70-764 - SQL Server 2016 Administration

Subscribe To All-Access
Lock In $16.99 / Month Forever

Gain access to this training and all our other courses with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.99 $16.99 Monthly

OR

$49.00