Post from May, 2008

Microsoft SQL Server 2008 Database Administration

Thursday, 1. May 2008 9:34

Class Scheduling

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

Overview

Drawing on decades of practical experience, Champion Valley Software 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.

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

Category:Training | Comment (0) | Author: