We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

MCSA SQL 2016 Database Administrator Training

Online Training by  Office Elearning Menu
Inquire Now
Online / Training

Details

MCSA SQL 2016 Database Administrator Training - OEM Certkit

Order the MCSA SQL 2016 DataBasics Administrator OEM CertKit. A dynamic, unique 1-click certification preparation product. OEM CertKit offers the student learning and certification preparation tools that are fully integrated into a customized learning management system (LMS).
With the OEM CertKit the user has access to all following products from one LMS. Fully integrated products include: In-depth E-Learning with 1 year online access, exam quizzes, tips and information, MeasureUp exam simulation is available for 60 days and starts the first time you enter the practice test area. Some OEM Cert Kit titles include 1 year of online Mentoring and Virtual LABs (extra charge). * Check the General Properties section below to see if online Mentoring and Virtual LABs are included for this title.

Outline

Course content
Administering a SQL Database Infrastructure (exam 70-764) 16:24 hoursMicrosoft SQL Server 2016: Encryptio

Course: 1 Hour, 38 Minutes

  • Course Introduction
  • Encryption Features
  • Transparent Data Encryption
  • Using Transparent Data Encryption
Microsoft SQL Server 2016: Data Access and Permissions

Course: 2 Hours, 14 Minutes

  • Course Introduction
  • Database Users
  • Creating a Database User with SSMS
  • Creating a Database User with T-SQL
  • Permissions
  • User Access
  • Granting Database Object Access
  • Revoking Database Object Access
Microsoft SQL Server 2016: Auditing

Course: 2 Hours, 2 Minutes

  • Course Introduction
  • Auditing
  • Auditing with Triggers
  • Auditing with Temporal Tables Part
  • Auditing with Temporal Tables Part
Microsoft SQL Server 2016: Backing Up Databases

Course: 1 Hour, 47 Minutes

  • Course Introduction
  • Database Backups
  • Backup Strategies
  • Backup Media
  • Backup Retention Policies
  • Creating Backups Using SSMS
  • Creating Backups Using T-SQL
  • Transaction Logs and Backups
  • Automating Backup
Microsoft SQL Server 2016: Restoring Databases

Course: 2 Hours, 7 Minutes

  • Course Introduction
  • Database Restore
  • Complete Database Restores with the Simple Model
  • Restoring a Database with the Simple Model
  • Complete Database Restores with the Full Model
  • Restoring a Database with the Full Model Part
  • Restoring a Database with the Full Model Part
  • Automating and Testing Restores
Microsoft SQL Server 2016: Managing Database Integrity

Course: 57 Minutes

  • Course Introduction
  • Database Consistency Checker
  • Using Database Consistency Checker in SSMS
  • Viewing Progress Reports for DBCC Commands
  • Performing Checks on Databases
  • Performing Checks on Tables and Indexes
  • Consistency Check Errors
Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Course: 2 Hours, 10 Minutes

  • Course Introduction
  • Activity Monitor
  • Using Activity Monitor in SSMS
  • Identifying Blocks
Microsoft SQL Server 2016: Monitoring SQL Server Instances

Course: 2 Hours, 7 Minutes

  • Course Introduction
  • Database Mail
  • Logs and Retention in Database Mail
  • Configuring Database Mail
Microsoft SQL Server 2016: Managing Indexes and Statistics

Course: 1 Hour, 31 Minutes

  • Course Introduction
  • Indexes
  • Detecting Index Fragmentation
  • Repairing Index Fragmentation Using SSMS
  • Repairing Index Fragmentation Using T-SQL
  • Identifying and Creating Missing Indexes
  • Finding and Removing Underutilized Indexes
Microsoft SQL Server 2016: High Availability and Disaster Recovery

Course: 1 Hour, 45 Minutes

  • Course Introduction
  • Log Shipping
  • Configuring Log Shipping with SSMS
  • Configuring Log Shipping with T-SQL
  • Log Shipping Management
  • Monitoring Log Shipping
Provisioning SQL Databases (exam 70-765) 16:16 hoursComponents of a SQL Server 2016 Installation

Course: 1 Hour, 59 Minutes

  • Course Introduction
  • SQL Server Components
  • SQL Server Instances
  • SQL Server Editions
  • SQL Server Versions
  • 32-bit Systems
  • 64-bit Systems
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 49 Minutes

  • Course Introduction
  • Tempdb Files
  • Tempdb Attributes
  • Tempdb Sizing
  • SQL Installation Options
  • Installing SQL Server 2016
  • Post-installation Best Practices
  • SQL Server Servicing Installation
  • Unattended Installation Options
  • Performing an Unattended Installation
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 54 Minutes

  • Course Introduction
  • SQL Server on Azure VM Overview
  • Usage Scenarios
  • Licensing Considerations
  • IaaS vs On-premises Deployment Options
  • Connecting to the SQL Server Azure VM
  • Migrate a Database to a SQL Server Azure VM
  • Backing up a Database to an Azure URL
  • Restoring a Database from an Azure URL
  • Configuring Automatic SQL Server Updates in Azure VM
  • Customer Experience Improvement Program (CEIP)
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 38 Minutes

  • Course Introduction
  • SQL Server Instances Overview
  • Hosting a SQL Server Instance Using Azure VMs
  • Azure Automation
  • Azure Resource Manager
  • Deploying SQL Server by Using Templates
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 35 Minutes

  • Course Introduction
  • SQL Server Firewall
  • Configuring SQL Server Firewall Rules
  • Managing Existing Firewall Rules in Azure
  • Connection Security
  • TCP Ports
  • Authentication
  • Contained Database Users
  • Managing Logins and Users
  • SQL Database Auditing
  • SQL Server Authorization
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 35 Minutes

  • Course Introduction
  • Transparent Data Encryption Overview
  • Implementing Transparent Data Encryption
  • TDE Commands and Functions
  • TDE Catalog Views
  • TDE Dynamic Management Views
  • TDE Considerations
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 17 Minutes

  • Course Introduction
  • Evaluate Database Performance
  • Changing Service Tiers
  • Elastic Database Pools
  • Configuring the Database Scope
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 36 Minutes

  • Course Introduction
  • Single Tenant vs Multi Tenant
  • Architectural Considerations
  • Multiple Tenant Considerations
  • Managing Multi-tenant Data
  • Isolating Tenant Data
  • Deploying Applications to Azure SQL Database
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 30 Minutes

  • Course Overview
  • Migration Methods
  • Azure VM Deployment Wizard
  • Backing up to a File and URL
  • AzCopy Command-line Utility
  • Microsoft Azure Import/Export Service
Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 23 Minutes

  • Course Overview
  • Connection Strings
  • Storing Connection Strings
  • Connection Strings for Azure Storage Accounts
  • Shared Access Signatures
  • Explicit Storage Endpoint
  • Parsing Connection Strings
  • Retry Logic

Special Offer

Check our website for special offers
Reviews
Be the first to write a review about this course.
Write a Review
What is OEM Office Elearning Menu?
OEM Office Elearning Menu provides ICT training to businesses and individuals, for end users or ICT professionals of all skill levels. From Microsoft Office to Certified Ethical Hacker, with over 200 brands of training we are sure we can get you started. By responding to new technology, we can always keep our training offerings relevant. Plus, we employ our own instructors, all of whom are certified and have years of hands-on experience.

What does OEM Office Elearning Menu do?
We offer comprehensive, customized ICT training from a variety of major A-brands to certification. For Microsoft Office, we can provide training in five languages: Dutch, English, French, German and Spanish. For Microsoft Office, we also take the exams. In addition to Microsoft Office, we offer customized training for all kinds of other software. This makes us the one-stop shop for all ICT training. Our goal is to teach people how to work with software in a goal-oriented and efficient way. We find good communication very important. We offer short lines of contact. Our customers always have a fixed point of contact with us.

How does a training course at OEM Office Elearning Menu work? ...
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.