Post from November, 2007

70-431 Microsoft® SQL Server™ 2005 Implementation and Maintenance

Monday, 12. November 2007 4:13

Microsoft SQL Server 2005 Certification Boot Camp 70-431

TCU: Sid Richardson – Lecture Hall 4

Sa: 9am – 6 pm / Sun 1 – 5pm

12/1/2007 – 12/16/2007


Class Scheduling

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


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-431 exam.

Course Price

Regular course price: $4000.

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


70-431 exam

Microsoft Certification

Microsoft Certified Technology Specialist – SQL Server 2005


MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)


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 200 sessions across dozens of training events spanning more than 8 years with more than 2000 people having attended training from him. Mike is certified in both SQL Server 2005 as well as being a Microsoft Certified Trainer.

Course Outline

  • Module 1 – Installation
    • SQL Server Editions
    • Hardware Requirements
    • Instances
    • Installing a New Instance
    • Upgrading an Instance
  • Module 2 – Configuration and Security
    • Data and Log Files
    • Database Mail
    • Recovery Models
    • Endpoints
    • Principals
    • Securables
    • Permissions
    • Execution Context
    • Signatures
    • Encryption
    • Linked Servers
  • Module 3 – Tables, Constraints, and User-Defined Data Types
    • Data Types
    • Column Properties
    • Constraints
    • User-Defined Data Types
  • Module 4 – Indexes
    • Index Structure
    • Clustered Index
    • Non-clustered Index
  • Module 5 – Building Queries
    • SELECT
    • Funtions
    • Temporary Tables
    • Transactions
    • INSERT
    • UPDATE
    • DELETE
  • Module 6 – Partitioning
    • Partition Functions
    • Partition Schemes
    • Partitioning Tables and Indexes
    • Querying Partitions
    • Managing Partitions
  • Module 7 – Views
    • Creating Views
    • Modifying Data
    • Indexed Views
  • Module 8 – XML Data
    • XML Structures
    • XML Schemas
    • XML Indexes
  • Module 9 – Functions, Stored Procedures, Triggers
    • Functions
    • Stored Procedures
    • Triggers
  • Module 10 – Flat Files
    • BCP
    • Import – Export Wizard
  • Module 11 – Backup, Restore, and Move a Database
    • Recovery Models
    • Backup Methods
    • Restoring Databases
    • Moving a Database
  • Module 12 – Database Management
    • Index Fragmentation
    • Statistics
    • Shrinking Files
    • DBCC
  • Module 13 – SQL Server Agent
    • Jobs
    • Schedules
    • Operators
    • Alerts
  • Module 14 – Performance
    • SQL Server Profiler
    • System Monitor
    • Database Engine Tuning Advisor
    • DMVs and DMFs
    • Correlating Performance Data
    • Blocking and Deadlocking
    • Resolving Database Errors
  • Module 15 – Database Snapshots
    • Creating a Database Snapshot
    • Reverting from a Database Snapshot
  • Module 16 – Database Mirroring
    • Roles
    • Operating Modes
    • Initialization
    • Failover and Failback
  • Module 17 – Log Shipping
    • Roles
    • Initialization
    • Failover and Failback
  • Module 18 – Replication
    • Replication Components
    • Replication Methods
    • Configuration
    • Security
    • Conflict Resolution
    • Monitoring
  • Module 19 – Service Broker
    • Architecture
    • Components
    • Sending and Receiving Messages
  • Module 20 – Full Text Catalogs
    • Creating a Catalog
    • Full Text Index
    • Populating an Index
    • Querying a Full Text Catalog

Category:Training | Comment (0) | Author:

Comprehensive SQL Server 2005 Training Series Scheduled

Monday, 5. November 2007 7:58

In cooperation with Texas Christian University, we successfully delivered a series of SQL Server 2005 certification bootcamps with a combined attendance of 282.  Each course covers the subject material for each individual exam.  However, these courses are not targeted at memorizing and regurgitating on an exam.  We teach you the material so that whether or not you decide to take any given exam, you have the knowledge necessary to either start a job in the SQL Server world or to dramatically expand your SQL Server knowledge.  S0870-431 is the introductory course for the relational engine within the series and covers all of the basics topics across the relational engine.  S0870-441 is targeted at database development for designing solutions.  S0870-442 is targeted at database development for optimizing data access and performance tuning.  S0870-443 is targeted at database administration for designing a secure and highly available SQL Server infrastructure.  S0870-444 is targeted at database administration for optimizing and maintaining a SQL Server infrastructure.  S0870-445 is the introductory course for the Business Intelltgence track covering an introduction to SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).  S0870-446 is targeted at the professional Business Intelligence developer for SSIS, SSRS, and SSAS.  Each course is 32 hours of comprehensive SQL Server education for the unheard of price of $300 per course.  You will NOT find more detailed instruction anywhere else and you certainly won’t find instructor led training at this price range

Category:Training | Comment (0) | Author: