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
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
Course: 2 Hours, 2 Minutes
- Course Introduction
- Auditing
- Auditing with Triggers
- Auditing with Temporal Tables Part
- Auditing with Temporal Tables Part
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
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
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
Course: 2 Hours, 10 Minutes
- Course Introduction
- Activity Monitor
- Using Activity Monitor in SSMS
- Identifying Blocks
Course: 2 Hours, 7 Minutes
- Course Introduction
- Database Mail
- Logs and Retention in Database Mail
- Configuring Database Mail
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
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
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
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
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)
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
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
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
Course: 1 Hour, 17 Minutes
- Course Introduction
- Evaluate Database Performance
- Changing Service Tiers
- Elastic Database Pools
- Configuring the Database Scope
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
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
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? ...
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? ...
Related Courses
Your Own Institute of training and Professional Development
Phoenix Educational Institute
MACOB IT SOLUTIONS LLC
Office Elearning Menu
