70-445 Microsoft® SQL Server™ 2005 Business Intelligence – Implementation and Maintenance

Thursday, 14. February 2008 3:17 | Author:

Microsoft SQL Server 2005 Certification Boot Camp 70-445

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

TCU: Sid Richardson – Lecture Hall 4

3/1/2008 – 3/15/200

 

 

 

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

Course Price

Regular course
price: $6000.

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

Exam

70-445 exam

Microsoft Certification

Microsoft
Certified IT Specialist – Business Intelligence

Textbook

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

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 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
    • 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
    • Creating and 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 Adminstration
    • Roles
    • Assigning Permissions and
      Site Security
    • Execution Properties and
      Linked Reports
    • Data Source Credentials

Category:Training | Comment (0)

70-442 Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005

Wednesday, 23. January 2008 4:23 | Author:

70-442 Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005

Tu, W & Th: 6:00 PM-10:00 PM

TCU: Tucker Technology – Room 246

2/12/2008 – 2/27/2008

 

 

Microsoft SQL Server 2005 Certification Boot Camp 70-442
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-442 exam.

Course Price

Regular course price: $4000.

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

Exam

70-442 exam

Microsoft Certification

Microsoft Certified IT Professional – Database Developer

Textbook

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)

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 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 – Database Access
    • Data Providers
    • Data Access Connections
    • ADO.NET Object Model
  • Module 2 – Designing Queries
    • Writing Queries
    • Performance
    • XML
  • Module 3 – Cursors and Caching
    • Caching
    • Cursors
    • Cursor Efficiency
  • Module 4 – Advanced Queries
    • SMO
    • MARS
    • Asynchronous Queries
  • Module 5 – Data Integrity and Error Handling
    • Declarative Data Integrity
    • Procedural Data Integrity
    • Error Handling
  • Module 6 – Designing Transactions
    • Isolation Levels
    • Locking and Blocking
    • Deadlock
    • Lock Optimization
  • Module 7 – Optimizing Performance
    • Optimize and Tune Queries
    • Indexing
    • Optimizing Storage
  • Module 8 – Optimizing Application Performance
    • Scaling Applications
    • Resolving Performance Issues

 

 

 

Category:Training | Comment (0)

70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft® SQL Server™

Tuesday, 15. January 2008 4:21 | Author:

70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft® SQL Server™

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

TCU: Sid Richardson – Lecture Hall 1

2/9/2008 – 2/23/2008

 

 

Microsoft SQL Server 2005 Certification Boot Camp 70-444
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-444 exam.

Course Price

Regular course price: $4000.

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

Exam

70-444 exam

Microsoft Certification

Microsoft Certified IT Professional – Database Administrator

Textbook

MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server(TM) 2005 (Pro-Certification)

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 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 – Troubleshooting Performance
    • Server Performance
    • Connectivity
    • Database Performance
  • Module 2 – Analyzing Queries
    • Identifying Query Bottlenecks
    • Query Plans
    • Indexing
    • Stored Procedure Logging
    • Concurrency
  • Module 3 – Failure Diagnosis
    • Database Failures
    • Server Failures
    • Service Failures
  • Module 4 – Disaster Recovery
    • Fault Tolerance
    • Recovering From a Failure
    • Database Recovery
    • Salvaging a Damaged Database
  • Module 5 – Performance Monitoring
    • Monitoring Standards
    • Statistical Analysis
  • Module 6 – Database Maintenance
    • Maintenance Strategies
    • Maintenance Plans
    • Reporting Services
    • Linked Servers
  • Module 7 – Integration Services
    • Building Packages
    • Package Security
    • Troubleshooting
    • Deployment
  • Module 8 – Data Integrity
    • Reconciling Conflicts
    • Implicit and Explicit Constraints
    • Data Types
  • Module 9 – Business Requirements
    • Gathering and Analyzing Requirements
    • Enforcing Data Quality
    • Change Control
  • Module 10 – Replication
    • Management
    • Monitoring
    • Validation
  • Module 11 – Security
    • Server Security
    • Authentication and Authorization
  • Module 12 – Detection and Responding to Attacks
    • Auditing
    • Responding to Threats and Attacks

 

 

Category:Training | Comment (0)

70-441 Designing Database Solutions by Using Microsoft® SQL Server™ 2005

Wednesday, 2. January 2008 9:20 | Author:

Microsoft SQL Server 2005 Certification Boot Camp 70-441

Tu, W & Th: 6:00
PM-10:00 PM

TCU: Dan Rogers Hall – Room 134

1/22/2008 – 2/6/2008

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

Course Price

Regular course
price: $4000.

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

Exam

70-441 exam

Microsoft Certification

Microsoft
Certified IT Professional – Database Developer

Textbook

MCITP
Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using
Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)

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 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 – SQL Server
    Services
  • Module 2 – Logical Database
    Design
    • Normal Forms
    • De-normalization
    • Data Flow Architecture
    • Hierarchies
  • Module 3 – Physical Database
    Design
    • Datatypes
    • Constraints
    • Triggers
  • Module 4 – Designing for
    Performance
    • Indexing
    • Indexed Views
    • Partitioning
  • Module 5 – Database
    Technologies
    • XML
    • CLR
    • Scalability
    • Interoperability with
      External Systems
  • Module 6 – Data Retrieval
    • Views
    • Stored Procedures
    • User Defined Functions
  • Module 7 – Extending Database
    Functionality
    • Stored Procedures
    • User Defined Functions
    • DML and DDL Triggers
    • CLR Aggregates
  • Module 8 – Secure
    Applications
    • Authentication and
      Authorization
    • Endpoints
    • CLR security
    • Service Security
    • Auditing
    • Encryption
  • Module 9 – Secure Databases
    • Principals
    • Securables
    • Permissions
    • Schemas
    • Execution Context
  • Module 10 – Unit Test Plans
    • Desiging Test Plans
    • Query Performance
    • Data Consistency
    • Security
    • System Resources
    • Code Coverage
  • Module 11 – Benchmarking
    • Modeling and Capacity
      Planning
    • Baselines
    • Measuring and Reacting to
      Change
    • Tracking Over Time
  • Module 12 – Database
    Deployment Planning
    • Deployment Methodologies
    • Deployment Considerations
  • Module 13 – Source Code
    Control
    • Managing Code Change
    • SourceSafe Permissions and
      Rights
    • Version Information
    • Comparing Versions
    • Managing Source Trees
  • Module 14 – Data Distribution
    • Database Mail
    • SQL Server Agent
    • Web Services
    • Reporting Services
    • Notification Services
  • Module 15 – Reporting
    Services
    • Designing Reports
    • Managing Report Snapshots
    • Programmatic Interfaces
    • Report Optimization
  • Module 16 – Notification
    Services
    • Configuration
    • Events and Providers
    • Generators and Distributors
    • Testing
    • Subscriptions
    • Optimization
  • Module 17 – Integration
    Services
    • Packages and Package
      Elements
    • Debugging and Testing

Category:Training | Comment (0)

70-443 Designing a Database Server Infrastructure by Using Microsoft® SQL Server™ 2005

Wednesday, 12. December 2007 4:15 | Author:

Microsoft SQL Server 2005 Certification Boot Camp 70-443

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

TCU: Sid Richardson – Lecture Hall 1

1/19/2008 -2/2/2008

 

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

Course Price

Regular course price: $6000.

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

Exam

70-443 exam

Microsoft Certification

Microsoft Certified IT Professional – Database Administrator

Textbook

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server(TM) 2005 (Pro Certification)

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 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 – Server Infrastructure
    • Sizing a Server
    • Processor Architecture
    • Disk Subsystem
    • Memory
    • Windows Editions
  • Module 2 – Consolidation
    • Multiple Instances
    • Consolidating Instances
  • Module 3 – SQL Server Security in the Enterprise
    • Assessing Business Requirements
    • Authentication
  • Module 4 – Database Security Policies
    • Security Policies
    • Encrypting Network Traffic
    • Reducing Attack Surface
  • Module 5 – Endpoints
    • Overview
    • TCP Endpoints
    • HTTP Endpoints
  • Module 6 – Database Security
    • Authentication and Authorization
    • Principals
    • Securables
    • Permissions
    • Execution Context
  • Module 7 – Planning High Availability
    • Assessing Requirements
    • Database Storage
    • Migrating to an Availability Solution
  • Module 8 – Failover Clustering
    • Windows Clustering
    • Failover Instances
  • Module 9 – Database Mirroring
    • Overview
    • Components and Roles
    • Initializing
    • Failover and Failback Scenarios
  • Module 10 – Log Shipping
    • Overview
    • Initializing
    • Failover and Failback Scenarios
  • Module 11 – Replication
    • Overview
    • Transaction Replication
    • Merge Replication
    • Failover and Failback Scenarios
  • Module 12 – Physical Database Design
    • Table Design
    • Filegroups
    • Indexes
    • Views
    • Stored Procedures
    • Naming Conventions and Coding Standards
  • Module 13 – Recovery Strategies
    • Assessing Data Recovery Needs
    • Backup Types
    • Database Recovery
    • Backup Media
  • Module 14 – Archiving Data
    • Data Archive Policies
    • Partitioning

Category:Training | Comment (0)

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

Monday, 12. November 2007 4:13 | Author:

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.

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

Course Price

Regular course price: $4000.

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

Exam

70-431 exam

Microsoft Certification

Microsoft Certified Technology Specialist – SQL Server 2005

Textbook

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

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 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
    • OPENXML
    • XML Indexes
  • Module 9 – Functions, Stored Procedures, Triggers
    • Functions
    • Stored Procedures
    • Triggers
  • Module 10 – Flat Files
    • BULK INSERT
    • BCP
    • OPENXML
    • 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)

Comprehensive SQL Server 2005 Training Series Scheduled

Monday, 5. November 2007 7:58 | Author:

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)