Designing Database Solutions for SQL Server

Designing Database Solutions for SQL Server
2012 (MOC 20465B)
SQL Server 2012
&
`
r
Max. Teilnehmerzahl
Die Teilnehmerzahl beträgt
maximal 8 Personen.
Dauer
5 Tage
e
Die nächsten Termine
08.05.2017 - 12.05.2017
-----
Preis
2.390,00 Euro (exkl. MwSt)
2.844,10 Euro (inkl. MwSt)
12.06.2017 - 16.06.2017
-----
r
Ansprechpartner
Andreas Dittfurth
Tel: 030 6954504-10
Fax: 030 6954504-08
[email protected]
03.07.2017 - 07.07.2017
-----
j
Kursbeschreibung
This course describes the process of designing a SQL Server 2012 database. Students will learn how to
plan a server infrastructure, plan a database schema, plan storage, and database and server configurations
to help them to create high performance, secure, scalable, and highly available databases by using SQL
Server 2012.
j
Aktuelle
Kursinformationen
Bitte beachten Sie, dass die Kursunterlagen ausschließlich in englischer Sprache verfügbar sind.
j
Lernziele
After completing this course you will be able to:
- Design an appropriate database server infrastructure for a given business application scenario
- Design a logical schema for a database based on application requirements
- Design the physical implementation of a database for a given set of requirements
- Design a solution for including data files in a database
- Plan and manage indexes to optimize performance
- Design security for SQL Server instances and databases
- Plan policy-based management
- Plan SQL Server health monitoring
- Plan and implement the appropriate backup strategy for a given scenario
- Plan and manage multi-server maintenance and automation
- Use PowerShell to manage SQL Server 2012
- Design an optimal replication strategy
- Plan and implement a high availability solution
j
Zielgruppe
This course is intended for database administrators and developers who need to design and implement
enterprise database solutions and IT Professionals and software developers who need to build and support
applications that use a SQL Server 2012 database.
Erstellt am 07.04.2017
Seite 1 von 2
j
Teilnahmevoraussetzung
This course requires that you meet the following prerequisites:
- Experience with Transact-SQL
- Familiarity with SQL Server 2012 components and tools
- Familiarity with objects in a SQL Server database
- Familiarity with enterprise Windows network and security architecture
j
Inhalte
- Designing a Database Server Infrastructure
- Designing a Logical Database Schema
- Designing a Physical Database Implementation
- Incorporating Data Files into a Database
- Tuning Database Performance
- Designing Database Security
- Policy-Based Management
- Monitoring Server Health
- Designing a Database Backup Solution
- Automating Multi-Server Maintenance
- Managing SQL Server with Windows PowerShell
- Replicating Data
- Planning High Availability
j
Webseite
Link zum Kurs
j
Weiterführende
Themen
IT - Informationstechnologie
Erstellt am 07.04.2017
Microsoft-Zertifizierungen
Seite 2 von 2