Post from January, 2010

70-433 Microsoft SQL Server 2008 Certification Boot Camp

Friday, 8. January 2010 8:58

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

Type Remaining End Quantity
Microsoft SQL Server 2008 Certification Boot Camp
70-433
Sold Out Ended Free Sold Out

 

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

Category:Training | Comment (0) | Author: