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

SQL Server 2008 Business Intelligence Bootcamp

Monday, August 02, 2010 at 6:00 PM – Wednesday, August 18, 2010 at 9:30 PM (CT)

Oklahoma City, OK

Ticket Information

Event Details

This course is now
sold out and we are accepting up to 20 names for the waitlist. If you are on  the waitlist, please, leave your  schedule open for the event. We often have  last minute cancellations. If a spot opens up, we will automatically register  you and notify you, if you are the next person on the waitlist.

Course: SQL Server 2008 Business Intelligence Bootcamp (24.5 hours)

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

Session Dates: Monday, August 2nd, Tuesday, August 3rd, Tuesday,  August 10th, Wednesday, August 11th, Monday, August 16th, Tuesday, August 17th,  Wednesday, August 18th

Given the expertise and time  commitment being provided by Michael Hotek for free, we ask that all  registrants be able to attend at least 4 of the 7 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: www.ouhsc.edu/about/findus.asp and 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: 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.

Books: TBD. None will be required.

OUHSC Severe Weather Info  Link: 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 -
  Installation
• Component
  Installation
• Updates and
  Advanced Installation

• Module 2 -
  Configuration
• SSRS
  Configuration
• SSAS
  Configuration

• Module 3 -
  Migration
• SSAS
  upgrades
• Migrating
  DTS Packages to SSIS

• Module 4 -
  Designing SSIS Packages
• Package
  Creation
• Data
  Sources and Connections
• Control
  Flow Objects
• Data Flow
  Tasks and Transformations

• Module 5 -
  SSIS Package Debugging and Error Handling
• Transactions
  and Checkpoints
• Package
  Error Handling
• Data Flow
  Errors and Exceptions

• Module 6 -
  Designing SSAS Cubes
• Data
  Sources
• Creatingand Modifying Cubes
• Dimensions
• Hierarchies
  and Dimension Relationships

• Module 7 -
  SSAS Cube Extension
• Measures
  and Groups
• KPIs
• Actions,
  Translations, and Perspectives
• MDX

• Module 8 -
  SSAS Storage, Partitions, and Aggregations
• Measure
  Group Partitions and Storage
• Partition
  Aggregations

• Module 9 -
  SSAS Data Mining Models
• Data
  Preparation
• Data Mining
  Structures
• Data Mining
  Models
• Association,
  Sequence, and Forecasting
• Cube
  Sources
• Data Mining
  Algorithms

• Module 10 -
  Developing SSRS Reports
• Projects
• Report
  Objects
• Advanced
  Properties
• Datasets
• Dataset
  Filters and Groups

• Module 11 -
  Formatting and Extending SSRS Reports
• Parameters
• Expressions
• Report
  Builder Models

• Module 12 -
  Deploying and Configuring SSIS Packages
• Package
  Configurations
• Package
  Deployment

• Module 13 -
  Deploying and Processing SSAS Objects
• Deployment
• Processing
  SSAS Objects
• Processing
  Data Mining Objects

• Module 14 -
  Deploying and Scheduling SSRS Reports
• Deployment
• Schedules
  and Subscriptions
• Data Driven
  Subscriptions
• Rendering
  Formats

• Module 15 -
  SSIS Package Security and Execution
• Roles and
  Protection Levels
• Command
  Line Execution
• Scheduling

• Module 16 -
  SSAS Cube Security and Administration
• User
  Security Models
• SSAS
  Backups
• Performance
  Monitoring

• Module 17 -
  Securing and Querying SSAS Data Mining Models
• Testing
  Model Accuracy
• DMX
• Securing
  Mining Models

• Module 18 -
  SSRS Report Security and Administration
• Roles
• Assigning
  Permissions and Site Security
• Execution
  Properties and Linked Reports
• Data Source
  Credentials

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.

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

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 (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

Class Date :

June 20th from 9 am to 4 pm
June 21st from 1 pm to 5 pm
June 27th from 9 am to 4 pm
June 28th  from 1 pm to 5 pm

Microsoft SQL Server 2008 Certification Boot Camp 70-432

Class Scheduling

Register for this course: TCU’s Extended Education Program.

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 prepartion 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-432 exam.

Course Price

Regular course
price: $4000.

Price for TCU’s Extended Education Program: FREE. (Please note, the cost of the course is free. Classroom rental for this class is a total of $600, which will be evenly divided between all attendees.)

Exam

70-432 exam

Microsoft Certification

MCTS: SQL Server 2008, Implementation and Maintenance

Textbook

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 -Implementation and Maintenance (PRO-Certification)

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 – 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

Just wanted to make you aware of some upcoming SQL Server 2008 training at TCU.  The course is running on Saturdays and Sundays from June 20 – 28.  The cost of the course is $0.  Yes, 22 hours of SQL Server 2008 training for free.
We did have to rent the classroom from TCU and will be splitting the cost between all of the attendees.  Since there are 50 people registered at this point and the classroom rental was $600 for the entire course, that is $12 per person at this point.  So,  while the registration fee is $0, the total course cost at this point is $12 for about 22  hours of SQL Server 2008 training.

Course registration
can be found here:

https://lifelong.is.tcu.edu/wconnect/CourseStatus.awp?~~SUCT09SQL

Class Scheduling

Register for this course: TCU’s Extended Education Program.

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.

SQL Server 2008 is the latest version of Microsoft’s flagship data platform. SQL Server 2008 includes hundreds of enhancements and dozens of brand new features that can take your applications to a whole new level. In this course you will learn about all of the capabilities available within SQL Server 2008 with a focus on  administration and architecture.

This course is taught in a lecture/demo format. No in class, hands on labs will be available.

Course Price

Regular course
price: $4000.

Price for TCU’s
Extended Education Program: $350.

Textbook

None. Slide decks and supporting scripts will be printed and distributed by the instructor.

Instructors

The primary author
and primary instructor of this course, Michael Hotek, brings over a decade and a half 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 over 300 sessions across dozens of training events spanning more than 10 years with more than 3000 people having attended training from him. Mike is certified on SQL Server 2005 and is currently authoring the certification training kit and Step by Step books on SQL Server 2008 for Microsoft Press.

Course Outline

• Module 1: SQL Server Product
  Overview
• Relational Engine
• Business Intelligence
• Integration Services
• Reporting Services
• Analysis Services

• Module 2: Installation and
  Configuration