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
Closed Captions
Certificate of Completion
Course Description for Microsoft SQL 70-764: Administering a SQL Database Infrastructure
The “Microsoft SQL 70-764: Administering a SQL Database Infrastructure” course is designed to equip you with the essential skills and knowledge required to administer SQL Server databases effectively. This course covers a wide range of topics, including configuring encryption, data access, permissions, and auditing, developing a backup strategy, restoring databases, managing database integrity, monitoring database activity, and implementing high availability and disaster recovery solutions.
You will learn how to manage SQL Server instances, monitor and optimize query performance, and implement log shipping and failover clustering. The course includes practical labs to reinforce your learning and provide hands-on experience with SQL Server administration tasks. By the end of the course, you will be well-prepared to handle real-world challenges in managing SQL Server database infrastructures.
What You Will Learn in Microsoft SQL 70-764 Course
This course will provide you with a comprehensive understanding of SQL Server administration, focusing on practical skills and real-world applications. Here are the key learning outcomes:
- Configure and manage encryption for data protection
- Set up and maintain user access and permissions
- Implement SQL Server auditing and manage audit logs
- Develop and execute a comprehensive backup strategy
- Restore databases and perform recovery operations
- Monitor and troubleshoot database integrity
- Analyze and optimize database performance
- Implement high availability solutions, including log shipping and failover clusters
Exam Objectives for Microsoft SQL 70-764 Certification
The Microsoft SQL 70-764 certification exam is designed to validate your skills in administering SQL Server databases. The exam objectives include:
- Configuring data encryption and security measures
- Managing database access and permissions
- Implementing SQL Server auditing
- Developing backup and restore strategies
- Managing database integrity and troubleshooting issues
- Monitoring and optimizing database performance
- Implementing high availability and disaster recovery solutions
The certification is governed by Microsoft, and achieving it will demonstrate your ability to manage SQL Server database infrastructures effectively.
Who This Microsoft SQL 70-764 Course is For
This course is ideal for IT professionals, database administrators, and developers who want to enhance their skills in SQL Server administration. It is also suitable for:
- Database administrators looking to improve their database management skills
- IT professionals responsible for managing SQL Server databases
- Developers who need to understand database infrastructure
- Students and beginners interested in a career in database administration
Possible Jobs You Can Get With Microsoft SQL 70-764 Knowledge
Completing this course will open up various career opportunities in the field of database management. Potential job roles include:
- SQL Server Database Administrator
- Database Manager
- Database Developer
- Data Analyst
- IT Consultant specializing in database solutions
With the skills gained from this course, you will be prepared to handle diverse database management tasks in various industries.
Average Industry Salaries for People with Microsoft SQL 70-764 Skills
Professionals with SQL Server administration skills can expect competitive salaries in the industry. Here are some average salary ranges:
- SQL Server Database Administrator: $80,000 – $120,000 per year
- Database Manager: $90,000 – $130,000 per year
- Database Developer: $75,000 – $110,000 per year
- Data Analyst: $70,000 – $100,000 per year
- IT Consultant: $85,000 – $140,000 per year
These figures provide an idea of the financial benefits of acquiring advanced SQL Server administration skills.
Get Started Today with Microsoft SQL 70-764
Don’t miss out on the opportunity to advance your career with the Microsoft SQL 70-764 course. Enroll today and gain the expertise needed to manage SQL Server databases effectively. With comprehensive course content and hands-on labs, you’ll be ready to tackle real-world challenges and excel in your role as a database administrator. Take the first step towards enhancing your career by signing up now!
Frequently Asked Questions About Microsoft 70-764 – SQL Server 2016 Administration
What is the Microsoft SQL 70-764 course about?
The Microsoft SQL 70-764 course focuses on administering SQL Server databases. It covers a wide range of topics such as configuring encryption, data access and permissions, auditing, backup and restore strategies, database integrity, query performance monitoring, and high availability solutions.
What are the key learning outcomes of the Microsoft SQL 70-764 course?
The key learning outcomes include managing encryption, user access, and permissions, implementing SQL Server auditing, developing backup strategies, restoring databases, ensuring database integrity, optimizing query performance, and implementing high availability solutions.
Who is the Microsoft SQL 70-764 course for?
This course is ideal for IT professionals, database administrators, developers, and anyone interested in a career in SQL Server administration. It is suitable for those looking to enhance their database management skills and understanding of database infrastructure.
What job opportunities can I pursue with Microsoft SQL 70-764 knowledge?
With SQL 70-764 knowledge, you can pursue roles such as SQL Server Database Administrator, Database Manager, Database Developer, Data Analyst, and IT Consultant specializing in database solutions. These roles span various industries and offer competitive salaries.
What is the average salary for professionals with Microsoft SQL 70-764 skills?
Professionals with SQL 70-764 skills can expect average salaries ranging from $80,000 to $140,000 per year, depending on the specific role and level of experience. Positions like SQL Server Database Administrator, Database Manager, and IT Consultant typically offer higher salaries within this range.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Your Training Instructor
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.”
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
$49.00
good
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.