Post from July, 2010

SQL Server 2008 Business Intelligence Bootcamp

Friday, 23. July 2010 9:08

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) | Author: