Post from June, 2009

70-432 Microsoft SQL Server 2008 Certification Boot Camp

Tuesday, 2. June 2009 6:46

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

Category:Training | Comment (0) | Author: