Aangeboden leervormen
70-465: Designing Database Solutions for SQL Server 2012
Met de online training 70-465: Designing Database Solutions for SQL Server 2012 van Sinteno krijg je de meest complete digitale leeromgeving en de beste voorbereiding op de praktijk. Het is een dynamische en unieke voorbereiding op de certificering EN geeft je tools die volledig zijn geïntegreerd in een omgeving.
De online training 70-465: Designing Database Solutions for SQL Server 2012 geeft toegang tot zowel de e-Learning, de examensimulatie, een online mentor, examenquizzen, tips, trucs en links.
Deze online training geeft echter géén toegang tot een Live Lab.
Hier vind je meer informatie over CertKits en Live Lab's
In de online training 70-465: Designing Database Solutions for SQL Server 2012 leer je enterprise database infrastructuur oplossingen te plannen en te implementeren door gebruik te maken van SQL Server 2014 en andere gerelateerde Microsoft technologieën.
Onderwerpen die aan bod komen zijn onder andere het plannen van de infrastructuur, private clouds, Windows Azure SQL database, High Availability, clustering en alwaysOn, backup en recovery en nog veel meer.
Voor wie
Databasebeheerder.
Programma
Tijdens de online training 70-465: Designing Database Solutions for SQL Server 2012 worden de volgende onderwerpen behandeld:
Planning Infrastructure
- Start the course
- Describe the process for planning a SQL Server 2012 database server infrastructure
- Recognize the SQL Server 2012 options for database server infrastructure topology, including on-premises physical, private cloud, and public cloud options
- Describe the:
- Basic considerations for choosing SQL Server 2012 hardware
- Specific considerations for choosing SQL Server 2012 CPU and memory hardware
- Specific considerations for choosing SQL Server 2012 storage and network hardware
- Recognize the:
- Features, usage scenarios, and advantages of database normalization
- Features, usage scenarios, and advantages of database denormalization
- Function of schemas, and best practice for implementation
- Describe the:
- Considerations for planning tables and data types
- Best practice for constraints on SQL databases
- Function and features of MAP toolkit for SQL Server planning
- Database discovery and inventory features of MAP toolkit
- MAP toolkit functionality for detailing computers running heterogeneous database instances
- Reporting functionality in MAP toolkit
- Key concepts associated with policy-based management
- Plan policy-based management in SQL Server 2012
- Implement policy-based management in SQL Server 2012
- Test a policy-based management implementation for compliance
- Describe:
- How System Center Advisor can be used for cloud-based management of SQL Server infrastructure
- How System Operations Manager can be used for management of SQL Server infrastructure
- 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
- Consolidated SQL server resources for multiple instances
- 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
- The features of SQL Server in the Azure Public Cloud
- Private Clouds and how they differ from traditional data centers
- Recognize the process for enabling:
- Resource pooling in a SQL Server private cloud environment
- Elasticity and self-service in a SQL Server private cloud environment
- Metering and enforcing policies in a SQL Server private cloud environment
- Create a SQL Server 2012 prepared instance
- Complete a SQL Server 2012 prepared instance
- Add features to a SQL Server 2012 prepared instance
- Remove features from a SQL Server 2012 prepared instance
- Recognize options for SQL Server 2012 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
- Running a T-SQL script that you have generated
- Using the Microsoft Sync Framework 2.1
- 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 2012 high availability and when each is appropriate
- Characteristics of AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2012
- Characteristics of AlwaysOn Availability Groups in SQL Server 2012
- Log shipping features and functionality in SQL Server 2012
- Configure log shipping using SQL Server Management Studio on SQL Server 2012
- Configure log shipping using T-SQL on SQL Server 2012
- Test a log shipping configuration that you have created in SQL Server 2012
- Test a log shipping failover on a log shipping configuration that you have created in SQL Server 2012
- 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
- Availability modes of AlwaysOn Availability Groups
- Failover modes of AlwaysOn Availability Groups
- Create an AlwaysOn Availability Group using:
- The SSMS wizard
- The SSMS dialog box
- 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 2012
- Describe the different SQL Server 2012 recovery models
- Describe the different backup strategies available in SQL Server 2012
- Perform a backup of a SQL Server 2012 database
- Perform a backup of a SQL Server 2012 database to Azure Blob Storage
- Describe the SQL Server 2012 restore process
- Recognize the process sequences for restoring SQL Server 2012 databases
- Restore a SQL Server 2012 database
- Restore a SQL Server 2012 database: To a point in time
- From Windows Azure Blob Storage
- Backup and restore a Windows Azure SQL database
- Describe the considerations for:
- Creating a disaster recovery plan
- Verifying a disaster recovery plan
- Maintaining a disaster recovery plan
- Describe SQL Server 2012: Replication
- Snapshot and transactional replication
- Peer-to-peer transactional and merge replication
- Configure SQL Server 2012 replication
- Describe the function of agents in SQL Server 2012 replication
- Describe the considerations for security in SQL Server 2012 replication
- Validate a SQL Server 2012 replication configuration
- Plan SQL Server Backup and Recovery
Resultaat
Je kunt zelfstandig database infrastructuur oplossingen plannen en implementeren op basis van SQL Server 2012.
Voorkennis
Je hebt de volgende certificering behaald:
– MCSA: SQL Server 2012
Examen
Let op: Deze training blijft wel bestaan maar de mogelijkheid om het bijbehorende examen af te leggen is per 31 januari 2021 komen te vervallen.
Een groot aantal Microsoft trajecten zijn namelijk aan het veranderen. Veel MCSA en MCSE trajecten maken plaats voor Role-Based trajecten.
De vervanger van deze online training is nog niet bekend.
Bij de training inbegrepen
| Certificaat van deelname | ja |
| Voortgangsbewaking | ja |
| Geschikt voor mobiel | ja |
| Studieadvies | Onze consultants zijn beschikbaar om je te voorzien van studieadvies. |
| Studiemateriaal | Gecertificeerde docenten met uitgebreide kennis over de onderwerpen. |
| Service | Service via telefoon of e-mail. |
