MCSA SQL 2016 Database Administrator Ausbildung





MCSA SQL 2016 Database Administrator Ausbildung
MCSA SQL 2016 Database Administrator E-Learning Zertifizierte Lehrer Prüfungsquizze Online Mentor MeasureUp Test Exam Live Labs Tipps Tricks Zertifikat.
Lesen Sie mehr- Marke:
- Microsoft SQL Server
- Verfügbarkeit:
- Auf Lager
- Award Winning E-learning
- Tiefpreisgarantie
- Persönlicher Service durch unser Expertenteam
- Sicher online oder per Rechnung bezahlen
- Bestellung und Start innerhalb von 24 Stunden
MCSA SQL 2016 Database Administrator Ausbildung - OEM Certkit
Bestel de MCSA SQL 2016 Database Administrator OEM CertKit. Een dynamisch, uniek certificeringsvoorbereidingsproduct met 1 klik. OEM CertKit biedt de student leer- en certificeringsvoorbereidingstools die volledig zijn geïntegreerd in een op maat gemaakt leerbeheersysteem (LMS).
Met de OEM CertKit heeft de gebruiker toegang tot alle volgende producten vanuit één LMS. Volledig geïntegreerde producten omvatten: uitgebreide E-Learning met 1 jaar online toegang, examen quizzen, tips en informatie, MeasureUp examensimulatie is 60 dagen beschikbaar en begint met de eerste keer dat u het oefentest gebied betreedt. Sommige OEM Cert Kit-titels bevatten 1 jaar online Mentoring en Virtuele LAB´s (meerprijs). *Controleer het gedeelte Algemene eigenschappen hieronder om te zien of online Mentoring en Virtuele LAB´s zijn inbegrepen voor deze titel.
Kursinhalt
Administering a SQL Database Infrastructure (exam 70-764) 16:24 hours
Microsoft 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 hours
Components 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
Unterrichtsdauer | 32:40 Stunde |
---|---|
Sprache | Englisch |
Online-Zugang | 365 Tage |
Teilnahmeurkunde | Ja |
Preisgekröntes Online-Training | Ja |
Es wurden noch keine Bewertungen für dieses Produkt abgegeben.
Bewertungen
Es wurden noch keine Bewertungen für dieses Produkt abgegeben.
Microsoft Office SCORM e-Learning
Möchten Sie Microsoft Office E-Learning SCORM in das LMS Ihrer Organisation integrieren? Nehmen Sie Kontakt mit uns auf.