Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

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

LIVE LAB:

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

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

The 70-764 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the lab tasks, you will improve your practical skills in configuring access to data and auditing, managing backups and restoring a database, managing and monitoring SQL Server instances, managing high availability and disaster recovery. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-764 Administering a SQL Database Infrastructure exam.

Vendor:   Microsoft
Vendor Id:   70-764
Version:   1
Level:   Entry
Learning Time:   820  Minutes

Exercises

  1. Data Encryption
  2. Exercises:
    • Introduction
    • Exercise 1 - Encrypting Data Using Keys
    • Exercise 2 - Managing Column-Level Encryption
    • Exercise 3 - Managing Encryption and Decryption of Files Using Transparent Data Encryption
    • Summary
  3. Backup and Connection Encryption
  4. Exercises:
    • Introduction
    • Exercise 1 - Configuring Secure Sockets Layer (SSL) to Encrypt Data
    • Exercise 2 - Working with Encrypted Backup Files
    • Summary
  5. Manage Database Object Permissions
  6. Exercises:
    • Introduction
    • Exercise 1 - Managing SQL Server Logins, Database Users, and Roles
    • Exercise 2 - Working with Database Permissions
    • Summary
  7. Configuring Security Options
  8. Exercises:
    • Introduction
    • Exercise 1 - Working with Row-Level Security
    • Exercise 2 - Securing Sensitive Data
    • Summary
  9. Configuring Audits for SQL Server
  10. Exercises:
    • Introduction
    • Exercise 1 - Managing Server-Level Audit
    • Exercise 2 - Managing Database-Level Audit
    • Exercise 3 - Working with SQL Server Audit Log
    • Summary
  11. Backing Up Databases
  12. Exercises:
    • Introduction
    • Exercise 1 - Working with Jobs
    • Exercise 2 - Managing Schedules
    • Exercise 3 - Working with Transaction Logs
    • Summary
  13. Piecemeal Restore of Database and File Groups
  14. Exercises:
    • Introduction
    • Exercise 1 - Working with Piecemeal Restore of Database
    • Exercise 2 - Working with Piecemeal Restore of File Groups
    • Summary
  15. Working with Restore Options
  16. Exercises:
    • Introduction
    • Exercise 1 - Managing Point-in-Time Recovery
    • Exercise 2 - Working with Page Restore
    • Exercise 3 - Automating SQL Server Restores
    • Summary
  17. Maintaining Database Integrity
  18. Exercises:
    • Introduction
    • Exercise 1 - Working with DBCC Commands
    • Exercise 2 - Working with Suspect Pages Table
    • Exercise 3 - Restoring a Database
    • Summary
  19. Monitoring the Database Activity
  20. Exercises:
    • Introduction
    • Exercise 1 - Managing Activity Monitor
    • Exercise 2 - Working with Performance Monitor
    • Summary
  21. Configuring Data Collection and UCP
  22. Exercises:
    • Introduction
    • Exercise 1 - Configuring the Management Data Warehouse
    • Exercise 2 - Managing System Data Collection Sets
    • Exercise 3 - Working with Utility Control Point
    • Summary
  23. Managing a Query Store
  24. Exercises:
    • Introduction
    • Exercise 1 - Working with Query Store
    • Summary
  25. Using Trace and Extended Events
  26. Exercises:
    • Introduction
    • Exercise 1 - Working with SQL Server Profiler
    • Exercise 2 - Monitoring System Activity Using Extended Events
    • Summary
  27. Managing Indexes
  28. Exercises:
    • Introduction
    • Exercise 1 - Handling Indexes
    • Exercise 2 - Working with Types of Indexes
    • Summary
  29. Managing Statistics
  30. Exercises:
    • Introduction
    • Exercise 1 - Working with Statistics
    • Summary
  31. Managing Operators
  32. Exercises:
    • Introduction
    • Exercise 1 - Working with Alerts and Operators
    • Summary
  33. Monitoring SQL Server
  34. Exercises:
    • Introduction
    • Exercise 1 - Working with Policies
    • Exercise 2 - Configuring Database Mail
    • Exercise 3 - Using Database Mail
    • Summary
  35. Configuring Log Shipping
  36. Exercises:
    • Introduction
    • Exercise 1 - Setting up Log Shipping using SQL Server Management Studio
    • Exercise 2 - Setting up Log Shipping using Transact-SQL
    • Summary
  37. Backup to Azure
  38. Exercises:
    • Introduction
    • Exercise 1 - Creating Windows Azure Storage Objects and SQL Server Credential
    • Exercise 2 - Performing a Full Database Backup to the Windows Azure Blob Storage Service
    • Exercise 3 - Performing a Restore from the Full Database Backup
    • Summary
  39. Implementing Availability Groups
  40. Exercises:
    • Introduction
    • Exercise 1 - Configuring Always On Availability Groups
    • Exercise 2 - Creating a New Availability Group
    • Summary
  41. Implementing Failover Cluster Instances
  42. Exercises:
    • Introduction
    • Exercise 1 - Creating a Failover Cluster with a Single Node
    • Exercise 2 - Managing the Failover Cluster
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 295 USD 120 59% OFF
  • No of hours: 
    820
    + Minutes of practical exercises
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top