70-433 Microsoft SQL Server 2008 Developer Course

Microsoft SQL Server 2008 Certification Boot Camp 70-433

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. Only the best content available coupled with the best instructors possible and utilizing the most current knowledge make it into a Champion Valley Software course.

Certification Boot Camps cover the subject matter for an exam, however, they are not taught directly to the exam. All of the other test preparation courses focus on students memorizing large amounts of material for the sole purpose of taking a particular exam. Once the exam is completed, most of the knowledge memorized is
either forgotten or not useful in the IT world. These courses are designed to teach the subject matter while not teaching specifically to an exam. At the conclusion of the training, attendees come away with a large volume of
knowledge which can be immediately applied to their jobs. If a student decides to subsequently take an exam, they are prepared for the material, but first and foremost, they are prepared for the demands of a job working with SQL Server.

This course covers the entire subject matter encompassed by the 70-433 exam.

Course Price

Regular course
price: $4000.

Price for Fort Worth
SQL Server User’s Group: $25. (Yes, a total of $25 for the entire 32 hour, instructor led class.)

Exam

70-433 exam

Microsoft Certification

MCTS: SQL Server 2008, Database Development

Textbook

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008-Database Development

Instructors

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 Outline

  • 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 – Peformance
    Analysis and Tuning
    • System Monitor
    • Profiler
    • Correlating Performance Data
    • Database Engine Tuning
      Advisor
    • Resource Governor
    • DMVs and DMFs
    • Performance Data Warehouse
    • Execution plans
Tags »

Author:
Date: Friday, 1. October 2010 4:24
Trackback: Trackback-URL Category: Training

Feed for the post RSS 2.0 Comment this post

Submit comment

Login required