MCSA SQL 2016 Database Administrator Training
Details
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: 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
Speaker/s
OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more.
OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.
Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.
OEM - Learn to WorkChoose from 1000+ training courses from 200+ brands for your personal and business development.
An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.
We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.
There are no reviews written yet about this product.
Add your review
Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.
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? ...