Microsoft SQL Server 2008 Administration

Duration: 5 Days | Price: $2495 | Class Dates:

Students Will Learn:

Configuring and Installing SQL Server 2008
SQL Server Database Engine Architecture
Replication, Backup and Restore
Database Mirroring

Security Administration
Performance Optimization
Maintaining Data Integrity
Creating and Populating Databases
Automating Procedures
Full-Text Search Architecture

Course Description: This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. Attendees will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2008. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.

Emphasis is placed on how SQL Server 2008 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. The hands-on labs provide comprehensive practice performing common administrative tasks.

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's SQL Programming/Relational Database Design course is highly recommended although not required.

Microsoft SQL Server 2008 Administration Course Overview:

An Overview of SQL Server 2008 SQL Server 2008 Architecture Available Features and Tools New Capabilities SQL Services Product Licensing Product Editions Installing SQL Server 2008 Preparing for Installation Creating Users for Service Accounts Choosing Appropriate File Locations Choosing Instance Names Installing SQL Server 2008 Choosing Appropriate Features Specifying Service User Accounts Choosing Licensing Mode Choosing Appropriate Collation Installing Multiple Instances Upgrading to SQL Server 2008		Configuring SQL Server 2008 Registering Servers Using Metadata Views to Obtain Object Properties Using Object Explorer Configuring a SQL Server Instance Configuring Object Properties Using the Query Window Creating Transact SQL Projects Managing Services Configuring Server Network Connections Configuring Client Connections and Aliases Configuring the Surface Area of SQL Server Configuring Policy-Based Management Creating a Central Management Server Using the Dedicated Administrator Connection Configuring Data Replication Creation and Maintenance of Full-Text Catalogs Describing Full-Text Search
Monitoring Data Structures Creating DDL Triggers Creating Event Notifications Configuring SQL Server Audit		Using SQL Server 2008 Management Tools SQL Server Management Studio SQL Server Configuration Manager SQL Server Books Online SQLCMD
Monitoring SQL Server Performance Using the Windows Performance Tool to Detect the Cause of a Bottleneck Using SQL Server Profiler Using Dynamic Management Functions Interpreting Management Studio Reports Using Activity Monitor		Creating and Configuring a Database Creating Databases Creating Tables Specifying Data Types Creating Indexes Describing Data File Structure Describing Log File Structure and Function Creating Filegroups Configuring Filestream Storage Creating and Using Database Snapshots Moving a Database to Another SQL Server
Optimizing SQL Server Performance Describing Index Structures Clustered Indexes Nonclustered (NC) Indexes Choosing Appropriate Clustered Index Choosing Appropriate NC Indexes Detecting Index Fragmentation Rebuilding and Reorganizing Indexes Using the Database Engine Tuning Advisor Generating and Interpreting Query Plans Configuring the Resource Governor		Securing SQL Server SQL Server Security Architecture Defining Principals and Securables Using the Security Hierarchy Creating Logins and Users Applying Password Policies to SQL Logins Creating Roles Granting Permissions Using SQLCMD to Test Permissions Creating and Using Certificates Setting Execution Context Encrypting Data Encrypting Databases
Automating Tasks Creating Maintenance Plans Job Creation and Execution Creating Schedules for Jobs Creating and Using Proxies Configuring Alerts Creating and Using Operators Configuring and Using Database Mail		Importing and Exporting Data Using bcp and BULK INSERT Using the Import/Export Wizard Using Integration Services to Import Data
Backing Up and Restoring Databases Choosing Appropriate Database Recovery Model Option Describing Automatic Recovery Choosing an Appropriate Backup Strategy Determining Backup File Contents Designing a Database Recovery Plan Using Backup Compression Use of Filegroups in a Backup Strategy Restoring the Master Database Rebuilding System Databases		Maintaining Data Reliability Maintaining Data Integrity Creating Constraints Describing and Using DML Triggers Configure Data Compression Setting Transaction Isolation Levels Capturing Changed Data Maintaining High Availability of Data Purpose of Windows Clustering Implementing Database Mirroring Use of Log Shipping

Student Testimonials

"Great course. Fast paced learning covered exactly what I needed."
– T.W., United States Navy

"I really enjoyed the hands on labs that went with every chapter. It really helped you understand things better."
– T.B., Centurytel

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299