Course: Designing Database Solutions for Microsoft SQL Server (exam 70-465)
Course: Designing Database Solutions for Microsoft SQL Server (exam 70-465)
$369.00
$446.49incl. vat
duration:
19 hours|
Language:
English (US) |
access duration:
180 days |
Details
In this SQL Server 2014 training course you will learn about
planning enterprise database infrastructure solutions and how the
implementation works using SQL Server 2014 and other Microsoft
technologies.
Among subjects that covered are planning infrastructure, private
clours, Windows Azure SQL database, High Availability, clustering
and alwaysOn, backup and recovery and far more.
Result
After completing this course you can plan database
infrastructure solutions by your own and you know how the
implementation works based on SQL Server 2014. You are also
prepared for the MCSE Exam 70-465.
Prerequisites
You have completed the course MCSA: SQL Server 2012.
Target audience
Database Administrators
Content
Designing Database Solutions for Microsoft SQL Server (exam 70-465)
19 hours
Microsoft SQL Server 2014 - Designing Solutions: 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
Microsoft SQL Server 2014 - Designing Solutions: 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
Microsoft SQL Server 2014 - Designing Solutions: 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
Microsoft SQL Server 2014 - Designing Solutions: 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
Microsoft SQL Server 2014 - Designing Solutions: 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
Microsoft SQL Server 2014 - Designing Solutions: 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
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. Thelab enviromentconsist of completenetworks containing for example,clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
Unlimited access to our IT professionals community
Study advice
Our consultants are here for you to advice about your study career and options
Study materials
Certified teachers with in depth knowledge about the subject.
Service
World's best service
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.