Inhoud ICT-cursus 70-465 Designing Database Solutions for Microsoft SQL Server

Inhoud van de ICT-cursus 70-465 Designing Database Solutions for Microsoft SQL Server | De Kantooropleider

Tijdens de ICT-cursus 70-465 Designing Database Solutions for Microsoft SQL Server worden de volgende onderdelen behandeld:

Planning Infrastructure

  • start the course
  • describe the process for planning a SQL Server 2014 database server infrastructure
  • recognize the SQL Server 2014 options for database server infrastructure topology, including on-premises physical, private cloud, and public cloud options
  • describe the basic considerations for choosing SQL Server 2014 hardware
  • describe the specific considerations for choosing SQL Server 2014 CPU and memory hardware
  • describe the specific considerations for choosing SQL Server 2014 storage and network hardware
  • recognize the features, usage scenarios, and advantages of database normalization
  • recognize the features, usage scenarios, and advantages of database denormalization
  • recognize the function of schemas, and best practice for implementation
  • describe the considerations for planning tables and data types
  • describe the best practice for constraints on SQL databases
  • describe the function and features of MAP toolkit for SQL Server planning
  • describe the database discovery and inventory features of MAP toolkit
  • describe the MAP toolkit functionality for detailing computers running heterogeneous database instances
  • describe the reporting functionality in MAP toolkit
  • describe the key concepts associated with policy-based management
  • plan policy-based management in SQL Server 2014
  • implement policy-based management in SQL Server 2014
  • test a policy-based management implementation for compliance
  • describe how System Center Advisor can be used for cloud-based management of SQL Server infrastructure
  • describe how System Operations Manager can be used for management of SQL Server infrastructure
  • describe the use and limitations of the SQL Server management pack for System Center Operations Manager
  • identify how to plan the database infrastructure

Private Clouds

  • start the course
  • recognize the reasons for consolidating SQL Server databases
  • recognize the options for consolidating a SQL Server environment
  • plan a strategy for SQL Server consolidation
  • manage consolidated SQL server resources for single instances
  • manage consolidated SQL server resources for multiple instances
  • manage SQL Server consolidated virtualized resources
  • describe the features and characteristics of cloud computing
  • describe the main cloud computing delivery models
  • recognize methods and paradigms for cloud management
  • recognize the features of SQL Server in the Azure Public Cloud
  • recognize Private Clouds and how they differ from traditional data centers
  • recognize the process for enabling resource pooling in a SQL Server private cloud environment
  • recognize the process for enabling elasticity and self-service in a SQL Server private cloud environment
  • recognize the process for enabling metering and enforcing policies in a SQL Server private cloud environment
  • create a SQL Server 2014 prepared instance
  • complete a SQL Server 2014 prepared instance
  • add features to a SQL Server 2014 prepared instance
  • remove features from a SQL Server 2014 prepared instance
  • Recognize options for SQL Server 2014 consolidation

Windows Azure SQL Database

  • start the course
  • identify the architecture components of Windows Azure public cloud
  • recognize the services offered as part the Windows Azure public cloud product
  • create a storage account in the Windows Azure public cloud service
  • recognize the features of the Windows Azure Storage service, part of the Windows Azure public cloud product
  • recognize the features and functionality offered by the Windows Azure Storage Table Service
  • use the Windows Azure Storage Table Service to create cloud hosted table data stores
  • recognize the features and functionality offered by the Windows Azure Storage Blob Service
  • use the Windows Azure Storage Blob Service to create cloud hosted table data stores
  • recognize the features of Windows Azure SQL Database
  • identify the function and interrelationship of the components of Windows Azure SQL Database
  • provision a Windows Azure SQL Database
  • provision a Windows Azure SQL Database server
  • manage a Windows Azure SQL Database using the Windows Azure Management Portal
  • recognize the options and requirements for Windows Azure SQL Database security
  • configure Windows Azure SQL Database security
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by generating a T-SQL script
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by running a T-SQL script that you have generated
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by using the Microsoft Sync Framework 2.1
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by using the export and import options
  • Implementing SQL solutions with Windows Azure

High Availability

  • start the course
  • recognize the function and features of Windows Azure virtual machines
  • recognize how virtual disks are configured and stored on Windows Azure
  • create a VM on Windows Azure
  • connect to a VM that you have created on Windows Azure
  • configure security for a VM on Windows Azure
  • create a TCP endpoint on Windows Azure
  • configure a VM with SQL Server on Windows Azure
  • connect to a configured VM with SQL Server on Windows Azure
  • recognize the options for SQL Server 2014 high availability and when each is appropriate
  • recognize the characteristics of AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2014
  • recognize the characteristics of AlwaysOn Availability Groups in SQL Server 2014
  • recognize log shipping features and functionality in SQL Server 2014
  • configure log shipping using SQL Server Management Studio on SQL Server 2014
  • configure log shipping using T-SQL on SQL Server 2014
  • test a log shipping configuration that you have created in SQL Server 2014
  • test a log shipping failover on a log shipping configuration that you have created in SQL Server 2014
  • Configure high availability

Clustering and AlwaysOn

  • start the course
  • identify the components of Windows Server Failover Clusters
  • identify the processes of Windows Server Failover Clusters
  • recognize the characteristics of Windows Server Failover Cluster quorum
  • identify the characteristics of Windows Server Failover Cluster storage
  • create a Windows Server Failover Cluster
  • identify the interrelationship between AlwaysOn Availability Groups and clustering
  • list the prerequisites for AlwaysOn Availability Groups
  • identify the characteristics of active secondary replicas in AlwaysOn Availability Groups
  • identify the availability modes of AlwaysOn Availability Groups
  • identify the failover modes of AlwaysOn Availability Groups
  • create an AlwaysOn Availability Group using the SSMS wizard
  • create an AlwaysOn Availability Group using the SSMS dialog box
  • create an AlwaysOn Availability Group using Transact-SQL
  • join a secondary replica to an AlwaysOn Availability Group
  • manage jobs and logins for an AlwaysOn Availability Group
  • perform a manual failover for an AlwaysOn Availability Group
  • suspend and resume an AlwaysOn Availability Database
  • remove a primary from an AlwaysOn Availability Group, and remove a secondary from an AlwaysOn Availability Group
  • take an AlwaysOn Availability Group offline
  • remove an AlwaysOn Availability Group
  • configure SQL Server infrastructure

Backup and Recovery

  • start the course
  • recognize the various backup types available in SQL Server 2014
  • describe the different SQL Server 2014 recovery models
  • describe the different backup strategies available in SQL Server 2014
  • perform a backup of a SQL Server 2014 database
  • perform a backup of a SQL Server 2014 database to Azure Blob Storage
  • describe the SQL Server 2014 restore process
  • recognize the process sequences for restoring SQL Server 2014 databases
  • restore a SQL Server 2014 database
  • restore a SQL Server 2014 database to a point in time
  • restore a SQL Server 2014 database from Windows Azure Blob Storage
  • backup and restore a Windows Azure SQL database
  • describe the considerations for creating a disaster recovery plan
  • describe the considerations for verifying a disaster recovery plan
  • describe the considerations for maintaining a disaster recovery plan
  • describe SQL Server 2014 replication
  • describe SQL Server 2014 snapshot and transactional replication
  • describe SQL Server 2014 peer-to-peer transactional and merge replication
  • describe the function of agents in SQL Server 2014 replication
  • describe the considerations for security in SQL Server 2014 replication
  • configure SQL Server 2014 replication
  • validate a SQL Server 2014 replication configuration
  • Plan SQL Server Backup and Recovery
Print pagina