Post from May, 2010

70-432 Microsoft SQL Server 2008 Certification Boot Camp

Saturday, 1. May 2010 6:04

From OKC SQL Developers Group

Course: Microsoft SQL Server 2008 Certification Boot Camp 70-432 (35 hours)

Time: 6:00 p.m. – 9:30 p.m.

Session Dates: Monday, May 17th, Tuesday, May 18th, Wednesday, May 19th, Monday, May 24th, Tuesday, May 25th, Wednesday, May 26th, Tuesday, June 1st, Wednesday, June 2nd, Monday, June 7th, Tuesday, June 8th.


Given the expertise and time committment being provided by Michael Hotek for free, we ask that all registrants be able to attend at least 6 of the 10 sessions of this course.

Location:  Robert M. Bird Library on the OU Health Sciences Center Campus. The address is 1000 Stanton L. Young Blvd, Oklahoma City, OK 73117 . We’ll be meeting in the auditorium, which is room
299. You can see the campus map and look for the Robert M. Bird Library at the
following two links: and


Parking:  Free parking South of the Bird Library in the J parking lot at the NW corner of 1000 Stanton L Young Blvd and NE 10th Street. The entrance arm should be raised after 5:00pm. Please, consider coming early the first evening to the correct parking lot.


Event Cost:  Free. Special thanks to OUHSC for providing the location for free and to Mike Hotek for teaching for free.


Food and Drink?:  Due to the event being free, we regret that we cannot provide food and drinks. Please, feel free to bring your own dinner for the evening.


Class Size:  Due to the popularity of the last class selling out it’s 40 spots in 20 hours, we have a larger location for
this class. Thus, we have 100 spots available.


Laptops:  You are welcome to bring your laptops. There is a laptop power plug every two three chairs under the table at the audience area.


Prerequisites:  There are no prerequisites for this course. Given Mike Hotek’s teaching style, we expect that beginning, intermediate, and advanced SQL Server professionals should benefit from this course.


Book:  MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008-Implementation
and Maintenance: Microsoft SQL Server 2008–Implementation and Maintenance
(PRO-Certification) (Hardcover)
. Purchasing the book is optional, however, Mike says he’ll be following it more closely than he did the book for the previous class.


OUHSC Severe Weather Info Link:


Primary Instructor

The primary author and primary instructor of this course, Michael Hotek, brings about 2 decades 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 hundreds training sessions across dozens of training
events spanning a decade or more with thousands of people having attended training from him.

Course Modules

  • Module 1 – Installing and
    Configuring SQL Server 2008
    • SQL Server Editions
    • Hardware and Software
    • Installing a New Instance
    • Upgrading an Instance
    • Collation sequences
    • Authentication modes
    • Service accounts
    • SQL Server Configuration
    • Database Mail
  • Module 2 – Configuration and
    • Data and Log Files
    • Recovery Models
    • Filestream data
    • Database integrity
    • Database options
  • Module 3 – Tables
    • Schemas
    • Data Types
    • Column Properties
    • Constraints
    • User-Defined Data Types
  • Module 4 – Indexes
    • Index structure
    • Clustered indexes
    • Non-clustered indexes
    • XML indexes
    • Spatial indexes
    • Index maintenance
  • Module 5 – Full-text Indexes
    • Creating a Catalog
    • Full Text Index
    • Populating an Index
    • Querying a Full Text Catalog
  • Module 6 – Partitioning
    • Partition Functions
    • Partition Schemes
    • Partitioning Tables and
    • Querying Partitions
    • Managing Partitions
  • Module 7 – Importing and
    Exporting Data
    • BCP
    • Import – Export Wizard
  • Module 8 – Policy Based
    • Facets
    • Conditions
    • Targets
    • Policies
    • Enforcing compliance
  • Module 9 – Backup, Restore,
    and Move a Database
    • Recovery Models
    • Backup Methods
    • Restoring Databases
    • Database Snapshots
  • Module 10 – Automating SQL
    • Jobs
    • Schedules
    • Operators
    • Alerts
  • Module 11 – Security
    • Endpoints
    • Surface area configuration
    • Principals
    • Securables
    • Permissions
    • Ownership chains
    • Impersonation
    • Keys, certificates, and
    • Signatures
    • Audit specifications
    • Transparent data encryption
  • Module 12 – Monitoring
    Microsoft SQL Server
    • System Monitor
    • Profiler
    • Correlating Performance Data
    • Diagnosing database failures
    • Diagnosing service failures
    • Diagnosing hardward failures
    • Resolving blocking and
  • Module 13 – Optimizing
    • Database Engine Tuning
    • Resource Governor
    • DMVs and DMFs
    • Performance Data Warehouse
  • Module 14 – Failover
    • Windows Clustering
    • Failover Instances
  • Module 15 – Database
    • Roles
    • Operating Modes
    • Initialization
    • Failover and Failback
  • Module 16 – Log Shipping
    • Roles
    • Initialization
    • Failover and Failback
  • Module 17 – Replication
    • Replication Components
    • Replication Methods
    • Configuration
    • Security
    • Conflict Resolution
    • Monitoring

Please, note that
due to time constraints and class membership preference, some modules may be
only partially covered or not covered at all. Mike, typically, attempts to
cover the topics preferred by class membership.

Category:Training | Comment (0) | Author: