70-432 Microsoft SQL Server 2008 Certification Boot Camp

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: http://www.ouhsc.edu/about/findus.asp and
http://www.ouhsc.edu/about/2009OUHSC_map.pdf.

 

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: http://www.ouhsc.edu/police/PersonalSafety/SevereWeatherPrecautions.asp

 

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
      Requirements
    • Installing a New Instance
    • Upgrading an Instance
    • Collation sequences
    • Authentication modes
    • Service accounts
    • SQL Server Configuration
      Manager
    • Database Mail
  • Module 2 – Configuration and
    Maintenance
    • 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
      Indexes
    • Querying Partitions
    • Managing Partitions
  • Module 7 – Importing and
    Exporting Data
    • BULK INSERT
    • BCP
    • Import – Export Wizard
  • Module 8 – Policy Based
    Management
    • 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
    Server
    • Jobs
    • Schedules
    • Operators
    • Alerts
  • Module 11 – Security
    • Endpoints
    • Surface area configuration
    • Principals
    • Securables
    • Permissions
    • Ownership chains
    • Impersonation
    • Keys, certificates, and
      encryption
    • 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
      deadlocking
  • Module 13 – Optimizing
    Performance
    • Database Engine Tuning
      Advisor
    • Resource Governor
    • DMVs and DMFs
    • Performance Data Warehouse
  • Module 14 – Failover
    Clustering
    • Windows Clustering
    • Failover Instances
  • Module 15 – Database
    Mirroring
    • 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.

Tags »

Author:
Date: Saturday, 1. May 2010 6:04
Trackback: Trackback-URL Category: Training

Feed for the post RSS 2.0 Comment this post

Submit comment

Login required