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
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
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.
- Module 1 -
- Updates and
- Module 2 -
- Module 3 -
DTS Packages to SSIS
- Module 4 -
Designing SSIS Packages
Sources and Connections
- Data Flow
Tasks and Transformations
- Module 5 -
SSIS Package Debugging and Error Handling
- Data Flow
Errors and Exceptions
- Module 6 -
Designing SSAS Cubes
- Creatingand Modifying Cubes
and Dimension Relationships
- Module 7 -
SSAS Cube Extension
Translations, and Perspectives
- Module 8 -
SSAS Storage, Partitions, and Aggregations
Group Partitions and Storage
- Module 9 -
SSAS Data Mining Models
- Data Mining
- Data Mining
Sequence, and Forecasting
- Data Mining
- Module 10 -
Developing SSRS Reports
Filters and Groups
- Module 11 -
Formatting and Extending SSRS Reports
- Module 12 -
Deploying and Configuring SSIS Packages
- Module 13 -
Deploying and Processing SSAS Objects
Data Mining Objects
- Module 14 -
Deploying and Scheduling SSRS Reports
- Data Driven
- Module 15 -
SSIS Package Security and Execution
- Roles and
- Module 16 -
SSAS Cube Security and Administration
- Module 17 -
Securing and Querying SSAS Data Mining Models
- Module 18 -
SSRS Report Security and Administration
Permissions and Site Security
Properties and Linked Reports
- Data Source
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.