70-433 Microsoft SQL Server 2008 Certification Boot Camp

Copied From the OKC SQL Users group:

 

Microsoft SQL Server 2008 Certification Boot Camp 70-433

Monday, February 08, 2010 at 6:00 PM – Tuesday, March 02, 2010 at 9:30 PM (CT)

Oklahoma City, OK

 

Ticket Information

 

Event  Details

Important Note: Due to high demand  and space issues, this event has sold out, and the wait list is, also, full. If  this event is successful, we hope to put on another, larger event later in the  year.

Course: Microsoft SQL Server 2008  Certification Boot Camp 70-433 (31.5 hours)

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

Session Dates: Monday, February, 8th, Tuesday, February 9th,
Wednesday, February 10th, Monday, February 15th, Tuesday, February 16th,
Wednesday, February 17th, Monday, February 22nd, Tuesday, February 23rd, and
Wednesday, February 24th

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

Location: 1100 N Lindsay, Service Center Bldg, Room  SCB-111, Oklahoma City, OK 73104. You can see the campus map and look for  Service Center Bldg by going to this link (http://www.ouhsc.edu/about/findus.asp). Surrounding buildings are the Dean  McGee Eye institute and the Oklahoma City Clinic.

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 -
  Database Design
• Data
  Modeling
• Schemas
• Data Types
• Column
  Properties
• Constraints
  and referential integrity
• Collation
  sequences
• Storage
  options

• Module 2 -
  Indexes
• Clustered
  and nonclustered indexes
• Full-text
  indexes
• Spatial
  indexes
• Managing
  fragmentation
• Building
  efficient indexes

• Module 3 -
  Data retrieval
• SELECT
  statement
• Aggregates
• Combining
  result sets
• Subqueries
• CTEs
• Ranking
  functions
• Full-text
  indexes
• Querying
  XML data
• Spatial
  queries

• Module 4 -
  Data Modification
• INSERT
• UPDATE
• DELETE
• MERGE
• BULK INSERT
• BCP
• Import -
  Export Wizard
• Change
  tracking
• Change data
  capture

• Module 5 -
  Programmable Objects
• Views
• Functions
• Stored
  procedures
• Triggers

• Module 6 -
  Partitioning
• Partition
  functions
• Partition
  schemes
• Managing
  partitioned objects

• Module 7 -
  Full-text Indexes
• Creating a
  Catalog
• Full Text
  Index
• Populating
  an Index
• Querying a
  Full Text Catalog

• Module 8 -
  Service Broker
• Overview
• Message
  types
• Contracts
• Services
• Queues
• Activation
  procedures

• Module 9 -
  Performance Analysis and Tuning
• System
  Monitor
• Profiler
• Correlating
  Performance Data
• Database
  Engine Tuning Advisor
• Resource
  Governor
• DMVs and
  DMFs
• Performance
  Data Warehouse
• Execution
  plans