Microsoft SQL Server 2008 Database Administration

• Class Scheduling and registration
• Overview
• Course Price
• Textbook
• Instructors
• Course Outline

Class Scheduling

Register for this course: TCU's Extended Education Program.

Overview

Drawing on decades of practical experience, MHS Enterprises courses are a leap forward in content creation and delivery. Each Mentor teaching a course brings years of past and ongoing practical experience on the subject into the classroom to provide a unique perspective on the content delivered. Based on that practical experience, each mentor is equipped to answer any question which should arise and ensure that each delegate attending the class will leave with skills that can be applied immediately in their environment. Only the best content available coupled with the best instructors possible and utilizing the most current knowledge make it into an MHS course.

SQL Server 2008 is the latest version of Microsoft's flagship data platform. SQL Server 2008 includes hundreds of enhancements and dozens of brand new features that can take your applications to a whole new level. In this course you will learn about all of the capabilities available within SQL Server 2008 with a focus on administration and architecture.

This course is taught in a lecture/demo format. No in class, hands on labs will be available.

Course Price

Regular course price: $4000.
Price for TCU's Extended Education Program: $350.

Textbook

None. Slide decks and supporting scripts will be printed and distributed by the instructor.

Instructors

The primary author and primary instructor of this course, Michael Hotek, brings over a decade and a half of SQL Server experience in some of the largest and most complicated environments in the world. Mike is an accomplished speaker and trainer having delivered over 300 sessions across dozens of training events spanning more than 10 years with more than 3000 people having attended training from him. Mike is certified on SQL Server 2005 and is currently authoring the certification training kit and Step by Step books on SQL Server 2008 for Microsoft Press.

Course Outline

• Module 1: SQL Server Product Overview
  • Relational Engine
  • Business Intelligence
  • Integration Services
  • Reporting Services
  • Analysis Services
• Module 2: Installation and Configuration
  • Installation Routine
  • Service Accounts
  • Collation Sequences
  • Authentication Mode
  • SQL Configuration Manager
  • Surface Area Configuration
• Module 3: SQL Server Tools
  • Management Studio
  • BI Dev Studio
  • Profiler
  • SQL CMD
  • Database Mail
  • Performance Studio
  • Data Collector
  • Database Engine Tuning Advisor, DTA
  • Resource Governor
• Module 4: Creating Databases
  • Files
  • Filegroups
  • Creating a Database
• Module 5: Designing Tables
  • Data types
  • Column properties
  • Compression
  • Sparse rows and columns
  • Constraints
  • Schemas
• Module 6: Designing Indexes
  • Index structure
  • Clustered indexes
  • Non-clustered indexes
  • Filtered indexes
  • XML indexes
  • Spatial indexes
  • Forwarding pointers
  • Fragmentation and index maintenance
• Module 7: Partitioning Tables and Indexes
  • Partition functions
  • Partition schemes
  • SPLIT/MERGE
  • Data storage internals
  • SWITCH
• Module 8: Transactions
  • Locks
  • Isolation levels
  • Transaction management
• Module 9: Data Manipulation
  • INSERT
  • BULK INSERT
  • BCP
  • UPDATE
  • DELETE
  • MERGE
  • Change Data Capture
  • Change Data Tracking
• Module 10: Data Retrieval
  • SELECT statements
  • JOINS
  • Subqueries
  • Linked Servers
  • Spatial Data
  • Aggregates
  • Grouping Sets
  • CTEs
  • INTERSECT/EXCEPT
  • CUBE/ROLLUP
  • XML
• Module 11: Programming Objects
  • Views
  • Stored Procedures
  • Functions
  • Triggers
• Module 12: Maintaining Historical Data
  • Database Snapshots
  • Audit Trails
  • Row history
• Module 13: Service Broker
  • Messages
  • Queues
  • Contracts
  • Conversations
  • Automatic activation
• Module 14: Full Text
  • Full text catalogs
  • Full text indexes
  • Noise words
  • Word breakers
  • Thesaurus
  • Querying
• Module 15: Security
  • Instance and Database Security
  • DDL triggers
  • Data Encryption
  • Extensible key management
  • Signatures
  • Auditing
• Module 16: Policy Based Management
  • Policy based Management
  • Facets
  • Policies
  • Targets
  • Categories
  • Configuration Servers
• Module 17: Data Recovery
  • Recovery Models
  • Backup
  • Backup Types
  • Mirrored Backups
  • Compression
  • Encryption
  • Restore
  • Maintenance Plans
• Module 18: SQL Server Agent
  • Jobs
  • Operators
  • Alerts
• Module 19: Dynamic Management Views
  • Dynamic Management Views and Functions
• Module 20: Performance Analysis and Tuning
  • Query Plans
  • Plan guides
  • Show plans
  • SET options
  • Data Collector
  • System Monitor
  • Profiler
  • SQL Server Extended Events
  • DTA
  • Performance Studio
  • Resource Governor
• Module 21: High Availability Overview
  • Clustering
  • Database Mirroring
  • Log Shipping
  • Replication