MOC 6231 - Maintaining a Microsoft SQL Server 2008 Database: About this Course. About this Course_x000D_. This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.. Gerichtet an: About this Course. About this Course_x000D_. This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.. Audience Profile. This course is intended for IT Professionals who administer and maintain SQL Server databases...
Standorte und Zeitplan
Lage
Beginn
Berlin
Beginn
auf AnfrageAnmeldung möglich
Essen
(Nordrhein-Westfalen, NRW)
Beginn
auf AnfrageAnmeldung möglich
Frankfurt A. M.
(Hessen)
Beginn
auf AnfrageAnmeldung möglich
Hamburg
Beginn
auf AnfrageAnmeldung möglich
Hannover
(Niedersachsen)
Beginn
auf AnfrageAnmeldung möglich
Köln
(Nordrhein-Westfalen, NRW)
Beginn
auf AnfrageAnmeldung möglich
Leipzig
(Sachsen)
Beginn
auf AnfrageAnmeldung möglich
München
(Bayern)
Beginn
auf AnfrageAnmeldung möglich
Nürnberg
(Bayern)
Beginn
auf AnfrageAnmeldung möglich
Stuttgart
(Baden-Württemberg)
Beginn
auf AnfrageAnmeldung möglich
Stuttgart
(Baden-Württemberg)
Beginn
auf AnfrageAnmeldung möglich
Alle ansehen (11)
Hinweise zu diesem Kurs
Before attending this course, students must have:_x000D_ Basic knowledge of the Microsoft Windows operating system and its core functionality. _x000D_ Working knowledge of Transact-SQL. _x000D_ Working knowledge of Relational databases. _x000D_ Core Windows Server skills. _x000D_ Database design skills. _x000D_ In addition, it is recommended, but not...
Fragen & Antworten
Ihre Frage hinzufügen
Unsere Berater und andere Nutzer werden Ihnen antworten können
Wir überprüfen Ihre Frage, um sicherzustellen, dass sie an die Veröffentlichungsstandards anpasst. Nach Ihren Antworten haben wir auch entdeckt, dass Sie für diesen Kurs möglicherweise nicht anmelden können. Entweder das wegen Ihrer Ausbildung sein können oder Ihrer Lage und so weiter. Auf jedem Fall wird es besser wenn Sie es mit Ihrer Ausbildungsstätte erkären.
Vielen Dank!
Wir überprüfen Ihre Frage und werden diese in Kürze veröffentlichen.
Oder bevorzugen Sie, dass das Zentrum Sie kontaktiert?
Meinungen
Haben Sie diesen Kurs belegt? Teilen Sie Ihre Meinung
Erfolge dieses Bildungszentrums
2020
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
Monitoring
Server
SQL
Microsoft
MS SQL Server
Support
DB
SQL Server
DTS
MS SQL
MSDE
MSQL
SQL Server 2000
Microsoft SQL Server 2000
C# mssql
MSSQL 2000
MSSQL 2005
MSSQL Server
Net mssql
Access MSSQL
Asp mssql
IIS MSSQL
Java MSSQL
MSSQL Database
MSSQL Datenbank
IT
Inhalte
KURSZIEL MOC 6231 - Maintaining a Microsoft SQL Server 2008 Database: About this Course_x000D_
About this Course_x000D_
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. _x000D_
_x000D_
Audience Profile_x000D_
This course is intended for IT Professionals who administer and maintain SQL Server databases. _x000D_
_x000D_
At Course Completion_x000D_
After completing this course, students will be able to:_x000D_
Install and configure SQL Server 2008.
_x000D_
Manage database files.
_x000D_
Backup and restore databases.
_x000D_
Manage security.
_x000D_
Transfer data into and out of SQL Server.
_x000D_
Automate administrative tasks.
_x000D_
Replicate data between SQL Server instances.
_x000D_
Maintain high availability.
_x000D_
Monitor SQL Server.
ZIELGRUPPE About this Course_x000D_
About this Course_x000D_
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. _x000D_
_x000D_
Audience Profile_x000D_
This course is intended for IT Professionals who administer and maintain SQL Server databases. _x000D_
_x000D_
At Course Completion_x000D_
After completing this course, students will be able to:_x000D_
Install and configure SQL Server 2008.
_x000D_
Manage database files.
_x000D_
Backup and restore databases.
_x000D_
Manage security.
_x000D_
Transfer data into and out of SQL Server.
_x000D_
Automate administrative tasks.
_x000D_
Replicate data between SQL Server instances.
_x000D_
Maintain high availability.
_x000D_
Monitor SQL Server.
KURSINHALT Course Outline_x000D_
_x000D_
Module 1: Installing and Configuring SQL Server_x000D_
The students will be introduced to planning for a SQL Server installation. The students will then be introduced to installing, configuring, and managing SQL Server._x000D_
_x000D_
Lessons _x000D_
Preparing to Install SQL Server
_x000D_
Installing SQL Server
_x000D_
Configuring a SQL Server Installation
_x000D_
Lab : Installing and Configuring SQL Server
_x000D_
Installing SQL Server
_x000D_
Configuring SQL Server
_x000D_
After completing this module, students will be able to:_x000D_
Explain how to prepare the hardware and other resources necessary to install SQL Server.
_x000D_
Install SQL Server.
_x000D_
Manage and configure SQL Server.
_x000D_
_x000D_
Module 2: Managing Databases and Files_x000D_
The students will be introduced to database planning and creation, and using database options to control database behavior._x000D_
_x000D_
Lessons _x000D_
Planning Databases
_x000D_
Creating Databases
_x000D_
Using Policy-Based Management
_x000D_
Lab : Managing Databases and Files
_x000D_
Creating a Database
_x000D_
Monitoring and Managing Filegroup Usage
_x000D_
Creating a Policy
_x000D_
After completing this module, students will be able to:_x000D_
Plan a database implementation that meets an organization's requirements.
_x000D_
Create a SQL Server database.
_x000D_
Manage a SQL Server database.
_x000D_
_x000D_
Module 3: Disaster Recovery_x000D_
The students will be introduced to disaster recovery techniques for SQL Server. They will learn how to perform different types of backup and restore operations, including online restores and backup and restores of system databases._x000D_
_x000D_
Lessons _x000D_
Planning a Database Backup Strategy
_x000D_
Backing Up a User Database
_x000D_
Restoring User Databases
_x000D_
Performing Online Restore Operations
_x000D_
Recovering Data from Database Snapshots
_x000D_
System Databases and Disaster Recovery
_x000D_
Lab : Disaster Recovery
_x000D_
Implementing a Backup Strategy
_x000D_
Restoring and Recovering a Database
_x000D_
Performing Piecemeal Backup and Restore Operations
_x000D_
Restoring the Master Database
_x000D_
After completing this module, students will be able to:_x000D_
Plan a backup strategy for a database.
_x000D_
Back up user databases.
_x000D_
Restore user databases from backups.
_x000D_
Restore data in a user database while it is online.
_x000D_
Recover data for a user database from a database snapshot.
_x000D_
Restore and recover system databases.
_x000D_
_x000D_
Module 4: Managing Security_x000D_
The students will be introduced to protecting SQL Server. Students will learn about the SQL Server security model and how to use SQL Server security features to control access to databases and their contents._x000D_
_x000D_
Lessons _x000D_
Overview of SQL Server Security
_x000D_
Protecting the Server Scope
_x000D_
Protecting the Database Scope
_x000D_
Managing Keys and Certificates
_x000D_
Auditing Security
_x000D_
Lab : Managing Security
_x000D_
Creating Logins and Assigning Server-Scope Permissions
_x000D_
Creating Database Users and Assigning Database-Scope and Schema-Scope Permissions
_x000D_
Encrypting Data Using Certificates and Keys
_x000D_
Implementing SQL Server Audit
_x000D_
After completing this module, students will be able to:_x000D_
Describe how SQL Server manages security.
_x000D_
Protect SQL Server at the server level.
_x000D_
Protect SQL Server databases.
_x000D_
Use keys and certificates to protect SQL Server objects.
_x000D_
Audit SQL Server security.
_x000D_
_x000D_
Module 5: Transferring Data_x000D_
The students will be introduced to transfer data to and from SQL Server using UI and command-line tools, and learn about transferring and transforming data with SQL Server Integration Services._x000D_
_x000D_
Lessons _x000D_
Overview of Data Transfer
_x000D_
Introduction to SQL Server Integration Services
_x000D_
Lab : Transferring Data
_x000D_
Using the Import/Export Wizard
_x000D_
Performing a Bulk Load
_x000D_
Creating an SSIS Solution
_x000D_
After completing this module, students will be able to:_x000D_
Use UI and command-line tools to import and export data.
_x000D_
Describe the features of SQL Server Integration Services.
_x000D_
_x000D_
Module 6: Automating Administrative Tasks_x000D_
The students will learn how to automate routine administrative tasks using jobs, operators, and alerts._x000D_
_x000D_
Lessons _x000D_
Automating Administrative Tasks in SQL Server
_x000D_
Using SQL Server Agent
_x000D_
Creating Maintenance Plans
_x000D_
Implementing Alerts
_x000D_
Managing Multiple Servers
_x000D_
Managing SQL Server Agent Security
_x000D_
Lab : Automating Administrative Tasks
_x000D_
Configuring SQL Server Agent
_x000D_
Creating Operators and Jobs
_x000D_
Creating Alerts
_x000D_
After completing this module, students will be able to:_x000D_
Define SQL Server administrative tasks and schedule those tasks to run automatically.
_x000D_
Configure SQL Server Agent to support automatic task scheduling.
_x000D_
Script tasks by using SQL Server jobs, and define operators for managing those jobs.
_x000D_
Define alerts to warn operators about events raised by SQL Server.
_x000D_
Define and manage administrative tasks that span multiple servers.
_x000D_
Configure SQL Server Agent security.
_x000D_
_x000D_
Module 7: Implementing Replication_x000D_
The students will be introduced to techniques for configuring SQL Server replication._x000D_
After completing this module, students will be able to:_x000D_
Describe replication and its components.
_x000D_
Configure and implement replication.
_x000D_
Use replication to meet the requirements of some common scenarios.
_x000D_
_x000D_
Module 8: Maintaining High Availability_x000D_
The students will be introduced to concepts and methods for maintaining high availability with SQL Server._x000D_
_x000D_
Lessons _x000D_
Introduction to High Availability
_x000D_
Implementing Log Shipping
_x000D_
Implementing Database Mirroring
_x000D_
Implementing Server Clustering
_x000D_
Using Distributed High Availability Solutions
_x000D_
Lab : Maintaining High Availability
_x000D_
Configuring Log Shipping
_x000D_
Configuring Database Mirroring
_x000D_
After completing this module, students will be able to:_x000D_
Describe the factors affecting database availability.
_x000D_
Describe how to implement log shipping to support fast recovery of a standby SQL Server database.
_x000D_
Describe how to use SQL Server mirroring to implement a software solution for fast failover.
_x000D_
Explain how to implement clustering to support fast failover of computers running SQL Server instances.
_x000D_
Describe how to implement distributed high availability solutions.
_x000D_
_x000D_
Module 9: Monitoring SQL Server_x000D_
The students will be introduced to monitoring SQL Server performance and activity. _x000D_
_x000D_
Lessons _x000D_
Viewing Current Activity
_x000D_
Using SQL Server Profiler
_x000D_
Monitoring with DDL Triggers
_x000D_
Using Event Notifications
_x000D_
Lab : Monitoring SQL Server
_x000D_
Monitoring SQL Server Activity
_x000D_
Tracing SQL Server Activity
_x000D_
Using DDL Triggers
_x000D_
Using Event Notifications
_x000D_
After completing this module, students will be able to:_x000D_
Examine the current activity in a SQL Server instance.
_x000D_
Use SQL Server Profiler to trace server and database activity.
_x000D_
Use DDL triggers to monitor changes to the structure of database objects.
_x000D_
Use event notifications to capture and monitor significant events for a SQL Server instance.
_x000D_
_x000D_
Module 10: Troubleshooting and Performance Tuning_x000D_
The students will learn how to troubleshoot a variety of common SQL Server problems. Students will also learn how to tune SQL Server for improved performance using a variety of tools._x000D_
_x000D_
Lessons _x000D_
Troubleshooting SQL Server
_x000D_
Performance Tuning in SQL Server
_x000D_
Using Resource Governor
_x000D_
Using Data Collector
_x000D_
Lab : Troubleshooting and Performance Tuning
_x000D_
Troubleshooting Connectivity Problems
_x000D_
Troubleshooting Concurrency Problems
_x000D_
Using the Database Engine Tuning Advisor
_x000D_
Implementing Resource Governor
_x000D_
Implementing Data Collector
_x000D_
After completing this module, students will be able to:_x000D_
Troubleshoot common SQL Server problems, such as connectivity, concurrency, and job and disk space problems.
_x000D_
Perform basic performance tuning tasks in SQL Server using the Database Engine Tuning Advisor, index tuning, and query tuning.
_x000D_
Use Resource Governor to manage SQL Server workloads and resources.
_x000D_
Use Data Collector to obtain performance data about your computer and the instances of SQL Server running on your computer.
VORRAUSSETZUNG Before attending this course, students must have:_x000D_
Basic knowledge of the Microsoft Windows operating system and its core functionality.
_x000D_
Working knowledge of Transact-SQL.
_x000D_
Working knowledge of Relational databases.
_x000D_
Core Windows Server skills.
_x000D_
Database design skills.
_x000D_
In addition, it is recommended, but not required, that students have completed: Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
_x000D_
_x000D_
Special Offer:_x000D_
Free SQL Server 2008 Software Offer_x000D_
Enroll now and attend any one of eight featured SQL Server 2008 training classes before June 30, 2009, and you will receive (while supplies last) a fully licensed copy of SQL Server 2008 Standard Edition with one client access license (CAL)_x000D_