50400 Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008
- Course Categorization:
- Microsoft,
- Databases,
- Course Provider:
- New Horizons Computer Learning Centers
- Learning Method:
- Classroom Learning
Lesson 1: Designing an Administrative Solution for SQL Server 2008
- Overview of SQL Server 2008
- Designing an Administrative Solution
- Developing and Deploying an Administrative Solution for SQL Server 2008
- Implementing an Administrative Solution in SQL Server Management Studio (SSMS)
- Lab : Designing an Administrative Solution for SQL Server 2008
Lesson 2: Deploying SQL Server 2008
- System Requirements for SQL Server 2008
- Upgrading and Migrating to SQL Server 2008
- Configuring Instances in SQL Server 2008
- Lab : Deploying SQL Server 2008
Lesson 3: Designing the Physical Structure of SQL Server 2008
- Introduction to the Physical Structure of a Database
- Planning for Partitioning
- Planning for Full-Text Indexing
- Lab : Designing the Physical Structure of SQL Server 2008
Lesson 4: Designing a Strategy for Maintaining a Database in SQL Server 2008
- Designing a Strategy for Maintaining Statistics for a Database
- Designing a Strategy for Maintaining Indexes
- Designing a Strategy for Database Compression
- Lab : Designing a Strategy for Maintaining a Database in SQL Server 2008
Lesson 5: Designing Solutions for Managing SQL Server 2008
- Designing a Policy-Based Management Strategy
- Controlling Resource Usage by using Resource Governor
- Auditing Database Changes
- Lab : Designing Solutions for Managing SQL Server 2008
Lesson 6: Automating the Database Management Strategy for SQL Server 2008
- Managing SQL Server Agent
- Automating Administrative Tasks in SQL Server
- Monitoring Events in SQL Server
- Lab : Automating the Database Management Strategy for SQL Server 2008
Lesson 7: Designing a Strategy for Securing SQL Server 2008
- Securing SQL Server 2008 Instances
- Planning Database Security
- Managing Certificate and Keys in SQL Server 2008
- Implementing Database Encryption
- Lab : Designing a Strategy for Securing SQL Server 2008
Lesson 8: Designing a Strategy for Monitoring SQL Server 2008
- Overview of Monitoring SQL Server 2008
- Monitoring SQL Server Instances
- Monitoring SQL Server Databases
- Monitoring Multiple SQL Servers by Using Data Collection
- Lab : Designing a Strategy for Monitoring SQL Server 2008
Lesson 9: Designing a Strategy for Content Distribution in SQL Server 2008
- Distributing Data in SQL Server 2008
- Working with Distributed Queries
- Managing Distributed Content by Using Distributed Transactions
- Managing SQL Server Integration Services (SSIS) Packages
- Setting Up Scalable Shared Databases
- Lab : Designing a Strategy for Content Distribution in SQL Server 2008
Lesson 10: Designing a Strategy for Replication in SQL Server 2008
- Designing a Database Replication Strategy
- Implementing Content Distribution by using Replication
- Configuring a High-Availability Solution by Using Replication
- Lab : Designing a Strategy for Replication in SQL Server 2008
Lesson 11: Designing a High-Availability Solution for SQL Server 2008
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Failover Clustering
- Designing a High-Availability Strategy
- Lab : Designing a High-Availability Solution for SQL Server 2008
Lesson 12: Designing a Backup and Recovery Strategy for SQL Server 2008
- Planning a Backup Strategy
- Planning a Recovery strategy
- Designing a Backup and Recovery Strategy
- Implementing a Repair Strategy
- Lab : Designing a Backup and Recovery Strategy for SQL Server 2008
- Charleston, SC - June 4, 2012
- Columbia, SC - June 4, 2012
- Greenville, SC - June 4, 2012
- Greensboro, NC - June 4, 2012
- Charleston, WV - June 4, 2012
- Urbandale, IA - June 4, 2012
- Charleston, SC - July 16, 2012
- Columbia, SC - July 16, 2012
- Greenville, SC - July 16, 2012
- Greensboro, NC - July 16, 2012
- Charleston, WV - July 16, 2012
- Urbandale, IA - July 16, 2012
- Orlando, FL - August 20, 2012
- Charleston, SC - August 27, 2012
- Columbia, SC - August 27, 2012
- Greenville, SC - August 27, 2012
- Greensboro, NC - August 27, 2012
- Charleston, WV - August 27, 2012
- Urbandale, IA - August 27, 2012
- Charleston, SC - October 8, 2012
- Anaheim, CA - October 8, 2012
- Columbia, SC - October 8, 2012
- Greenville, SC - October 8, 2012
- Greensboro, NC - October 8, 2012
- Charleston, WV - October 8, 2012
- Urbandale, IA - October 8, 2012
- Charleston, SC - November 19, 2012
- Columbia, SC - November 19, 2012
- Greenville, SC - November 19, 2012
- Charleston, WV - November 19, 2012
People Also Registered For
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Certified Ethical Hacker (CEH)
This class will immerse the student into an interactive environment where they will be shown how to scan, test, hack and secure their own systems. Students then learn how intruders escalate...
Windows 7 - Level 1
Students will log on to Windows 7, explore its interface, identify the different components in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools and...
Data Communication Over TCP/IP V6 Networks
In this course, students will examine the enhancements made to TCP/IPv4 and some related protocols. Students will also examine the various transition strategies adopted to upgrade from TCP/IPv4 to...
Computer Hacking Forensics Investigator (CHFI)
This course will provide participants the necessary skills to identify an intruders footprints and to properly gather the necessary evidence to prosecute in the court of law.
Related Courses
10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...
6231 Maintaining a Microsoft SQL Server 2008 R2 Database
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...
6232 Implementing a Microsoft SQL Server 2008 R2 Database
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...
