Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »
Artikelnummer: 118508048

MCSA SQL 2016 Database Administrator Ausbildung

Artikelnummer: 118508048

MCSA SQL 2016 Database Administrator Ausbildung

623,78 742,30 Inkl. MwSt.

MCSA SQL 2016 Database Administrator E-Learning Zertifizierte Lehrer Prüfungsquizze Online Mentor MeasureUp Test Exam Live Labs Tipps Tricks Zertifikat.

Lesen Sie mehr
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.

Bewertung der Schüler

Springest: 8.9, Edubookers: 8.5

Qualitätsgarantie

Preisgekröntes E-Learning & zertifizierte Tutoren

Microsoft Partner

und Certiport Partner

Nicht Gut, Geld Zurück

und eine Starter-Garantie