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: 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.