70-433 Microsoft SQL Server 2008 Developer Course

Friday, 1. October 2010 4:24 | Author:

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

Category:Training | Comment (0)

SQL Server 2008 Business Intelligence Bootcamp

Friday, 23. July 2010 9:08 | Author:

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

Type End Quantity
BIBootcamp Ended Free Sold Out

 

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

Category:Training | Comment (0)

70-432 Microsoft SQL Server 2008 Certification Boot Camp

Saturday, 1. May 2010 6:04 | Author:

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

Category:Training | Comment (0)

70-433 Microsoft SQL Server 2008 Certification Boot Camp

Friday, 8. January 2010 8:58 | Author:

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

Type Remaining End Quantity
Microsoft SQL Server 2008 Certification Boot Camp
70-433
Sold Out Ended Free Sold Out

 

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 (http://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

Category:Training | Comment (0)

70-432 Microsoft SQL Server 2008 Certification Boot Camp

Tuesday, 2. June 2009 6:46 | Author:

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)

For the SQL Community

Friday, 1. May 2009 3:40 | Author:

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

 

 

Category:Training | Comment (0)

Microsoft SQL Server 2008 Database Administration

Thursday, 1. May 2008 9:34 | Author:

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
    • Installation Routine
    • Service Accounts
    • Collation Sequences
    • Authentication Mode
    • SQL Configuration Manager
    • Surface Area Configuration
  • Module 3: SQL Server Tools
    • Management Studio
    • BI Dev Studio
    • Profiler
    • SQL CMD
    • Database Mail
    • Performance Studio
    • Data Collector
    • Database Engine Tuning
      Advisor, DTA
    • Resource Governor
  • Module 4: Creating Databases
    • Files
    • Filegroups
    • Creating a Database
  • Module 5: Designing Tables
    • Data types
    • Column properties
    • Compression
    • Sparse rows and columns
    • Constraints
    • Schemas
  • Module 6: Designing Indexes
    • Index structure
    • Clustered indexes
    • Non-clustered indexes
    • Filtered indexes
    • XML indexes
    • Spatial indexes
    • Forwarding pointers
    • Fragmentation and index
      maintenance
  • Module 7: Partitioning Tables
    and Indexes
    • Partition functions
    • Partition schemes
    • SPLIT/MERGE
    • Data storage internals
    • SWITCH
  • Module 8: Transactions
    • Locks
    • Isolation levels
    • Transaction management
  • Module 9: Data Manipulation
    • INSERT
    • BULK INSERT
    • BCP
    • UPDATE
    • DELETE
    • MERGE
    • Change Data Capture
    • Change Data Tracking
  • Module 10: Data Retrieval
    • SELECT statements
    • JOINS
    • Subqueries
    • Linked Servers
    • Spatial Data
    • Aggregates
    • Grouping Sets
    • CTEs
    • INTERSECT/EXCEPT
    • CUBE/ROLLUP
    • XML
  • Module 11: Programming
    Objects
    • Views
    • Stored Procedures
    • Functions
    • Triggers
  • Module 12: Maintaining
    Historical Data
    • Database Snapshots
    • Audit Trails
    • Row history
  • Module 13: Service Broker
    • Messages
    • Queues
    • Contracts
    • Conversations
    • Automatic activation
  • Module 14: Full Text
    • Full text catalogs
    • Full text indexes
    • Noise words
    • Word breakers
    • Thesaurus
    • Querying
  • Module 15: Security
    • Instance and Database
      Security
    • DDL triggers
    • Data Encryption
    • Extensible key management
    • Signatures
    • Auditing
  • Module 16: Policy Based
    Management
    • Policy based Management
    • Facets
    • Policies
    • Targets
    • Categories
    • Configuration Servers
  • Module 17: Data Recovery
    • Recovery Models
    • Backup
    • Backup Types
    • Mirrored Backups
    • Compression
    • Encryption
    • Restore
    • Maintenance Plans
  • Module 18: SQL Server Agent
    • Jobs
    • Operators
    • Alerts
  • Module 19: Dynamic Management
    Views
    • Dynamic Management Views and
      Functions
  • Module 20: Performance
    Analysis and Tuning
    • Query Plans
    • Plan guides
    • Show plans
    • SET options
    • Data Collector
    • System Monitor
    • Profiler
    • SQL Server Extended Events
    • DTA
    • Performance Studio
    • Resource Governor
  • Module 21: High Availability
    Overview
    • Clustering
    • Database Mirroring
    • Log Shipping
    • Replication

Category:Training | Comment (0)

TCU Course Proposals Approved

Friday, 25. April 2008 3:29 | Author:

A few months ago, we submitted a course proposal to TCU for the summer session and just heard back that it had been approved.  So, we are pleased to announce the extension of our ultra-low cost training solutions through TCU’s Extended Education Program.

 

SQL Server 2008 Database Administration will take you on a tour of SQL Server 2008.  This
course combines both the core training to get anyone not familiar with SQL Server up to speed as well as also covers the new features now available in SQL Server 2008.

 

Course registration  is at:

https://lifelong.is.tcu.edu/wconnect/CourseStatus.awp?~~SU081303A
for the 6/9 – 6/12 class offering

https://lifelong.is.tcu.edu/wconnect/CourseStatus.awp?~~SU081303B
for the 6/16 – 6/19 class offering

 

We are working on adding a 3rd section which will run from 6/14 – 6/28 on the weekend (Sat 9AM-6PM and Sun 1PM -5PM) for those who can’t get away during the week.  If the section gets added, you will find it on the TCU registration site.

 

Classes are scheduled for Monday – Thursday from 9AM – 6PM with a 1 hour break for lunch.  Cost of the course is $350 (three hundred fifty dollars) and there are no textbooks to buy.  Print outs of the slide decks will be provided.

 

Course material is based on almost 2 years of research and development on SQL Server 2008. Having just finished “The Rational Guide to SQL Server 2005 Security” which should be hitting shelves soon, Mike is the author of two forthcoming SQL Server 2008 books – “SQL Server 2008 Step by Step” from Microsoft Press and “The Rational Guide to SQL Server 2008 Security” by Rational Press as well as co-authoring the 70-432 SQL Server 2008 Training Kit for Microsoft Press.

Category:Training | Comment (0)

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

Thursday, 21. February 2008 0:27 | Author:

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

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

TCU

4/15/2008- 4/30/2008

Microsoft SQL Server 2005 Certification Boot Camp 70-431
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)

70-446 Designing a Business Intelligence Infrastructure by Using Microsoft® SQL Server™ 2005

Saturday, 16. February 2008 3:25 | Author:

 

70-446 Designing a Business Intelligence Infrastructure by Using Microsoft® SQL Server™ 2005

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

TCU: Sid Richardson – Lecture Hall 4

4/12/2008 – 4/26/2008

 

 

Microsoft SQL Server 2005 Certification Boot Camp 70-446

 

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 Course 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-446 exam.

Course Price

Regular course price: $6000.

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

Exam

70-446 exam

Microsoft Certification

Microsoft Certified IT Professional – Business Intelligence Developer

Textbook

Microsoft SQL Server(TM) 2005 Analysis Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Microsoft SQL Server(TM) 2005 Integration Services Step by Step

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

  • Analysis Services
    • Module 1 – Business Intelligence and Data Warehousing
      • Business Intelligence
      • Facts and Dimensions
    • Module 2 – OLAP Principles
      • OLAP Principles
      • SSAS Principles
    • Module 3 – Building a Cube
      • Analyzing Requirements
      • Building a Cube
      • Schemas
      • Processing and Browsing
    • Module 4 – Dimensions
      • Standard Dimensions
      • Time Dimensions
      • Parent-Child Dimensions
    • Module 5 – Measure Groups and Measures
      • Adding Measure Groups
      • Aggegating
      • Distinct Counts
      • Calculations
    • Module 6 – Finance Measure Group
      • Unary operators
      • Nonadditive Dimensions
    • Module 7 – Aggregations and Hierarchies
      • Desiging Aggregations
      • Building Hierachies
      • Optimization
    • Module 8 – MDX
      • Tuples
      • Querying
      • Custom Members
      • MDX scripts
      • KPIs
    • Module 9 – Special Features
      • Dimension Relationship
      • Currency Conversion
      • Localization
      • Folders and Perspectives
    • Module 10 – Cube Interaction
      • Actions
      • Writeback
    • Module 11 – Security
      • Roles
      • Dimension Security
      • Cell Security
      • Administration Security
    • Module 12 – Partitions and Processing
      • VLDBs
      • Storage
      • OLAP Processing
      • Monitoring Activity
    • Module 13 – Deployment
      • Deployment Options
      • XMLA
      • Automating Processing
      • Scheduling
      • Disaster Recovery
  • Reporting Services
    • Module 1 – Overview
      • Scenarios
      • Lifecycle
      • Components
    • Module 2 – Installation
      • Preparation
      • Deployment Considerations
      • Component Installation
    • Module 3 – Building a Report
      • Report Authoring
      • Report Managment
      • Report Access
    • Module 4 – Basic Reports
      • Report Definition File
      • Report Designer
      • Structure
      • Formatting
    • Module 5 – Expressions
      • Basic Calculations
      • Aggregations
      • Conditional Formatting
    • Module 6 – Data Organization
      • Data Regions
      • Matrix
      • Charts
      • Lists
    • Module 7 – Advanced Reports
      • Parameters
      • Interactive Features
      • Hierarchies
    • Module 8 – Building Report Models
      • Creating a Report Model
      • Modifying a Report Model
      • Managing Report Models
    • Module 9 – Content Management
      • Publishing
      • Organizing Content
      • Report Properties
      • Report Execution
    • Module 10 – Security
      • Report Server Security
      • Data Security
    • Module 11 – Managing Server Components
      • Configuring Reporting Services
      • Managing the Report Server
      • Reporting Services Databases
    • Module 12 – Accessing Reports
      • Finding and Viewing Reports
      • Saving Reports
      • Report Snapshots
    • Module 13 – Rendering Reports
      • MHTML
      • Document Management
      • Data Exchange
    • Module 14 – Subscriptions
      • Standard Subscriptions
      • Data-Driven Subscriptions
      • Managing Subscriptions
    • Module 15 – Report Builder
      • Building Basic Reports
      • Enhancing Reports
    • Module 16 – Custom Reporting
      • Custom Code
      • Data Processing Extensions
      • Report Definition Language – RDL
    • Module 17 – Programming Management
      • Web Services
      • Custom Applications
      • WMI
    • Module 18 – Custom Reporting Tools
      • URLs
      • Web Services
  • Integration Services
    • Module 1 – Introduction
      • Components
      • Process Control
      • DTS Migration
    • Module 2 – Building a Package
      • Business Intelligence Development Studio
      • Import Export Wizard
      • Package Elements
      • Testing
    • Module 3 – Extracting and Loading Data
      • Connection Managers
      • Data Sources
      • Data Source Views
    • Module 4 – Data Flow Transformations
      • Data Flow
      • Transformations
      • Expressions
      • Error Output
    • Module 5 – Control Flow
      • Components
      • Containers
      • Constraints
    • Module 6 – Scripting
      • Creating Scripts
      • Script Component
      • ActiveX Scripts
    • Module 7 – Debugging
      • Control Flow
      • Data Flow
      • Script Tasks
    • Module 8 – Package Execution
      • Package Configurations
      • XML Configuration File
      • Multiple Configuration Files
      • Configuration Order
      • Execution Options
      • Package Logging
    • Module 9 – Error Handling
      • Error Detection
      • Event Handlers
      • Transactions
      • Checkpoints
    • Module 10 – Security and Deployment
      • Deployment Utility
      • Package Security
      • Roles
      • Deployment Options
      • Configurations
    • Module 11 – Optimizing Packages
      • Memory Buffers
      • Execution Trees
      • Synchronous and Asynchronous Processing
      • Data Blocking
      • Non-blocking Transformations
      • Buffer Settings
      • Parallelism
      • Data Sources
      • Performance Management
      • Iterative Design
    • Module 12 – Data Warehouse Concepts
      • Objectives
      • Characteristics
      • Fundamentals
      • Data Warehouse Design
      • Data Warehouse Schema
    • Module 13 – Populating Data Warehouses
      • Staging
      • Managing Dimensions
      • Managing Fact Tables
    • Module 14 – General Principles
      • Package Design

 

 

Category:Training | Comment (0)