Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This is option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Please double check your website URL.
All fields marked with * are required.
Your credit card expiration date is in the past.
Your credit card CSC needs to be 4 digits.
Please confirm your order:
$$$$
You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your credit card CSC needs to be 3 digits.
Your billing zip code needs to be 5 digits.
There was a problem saving your address.
There was a problem saving your credit card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
Credit card number is in invalid format.
Wrong card type or credit card number is invalid.
Credit card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, there are only tickets of that type still available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Sorry, the tickets you are trying to order are not currently available.
Sorry, the payment type chosen is invalid for this event.
Sorry, there is only 1 ticket left for this event.
Sorry, there are only tickets left for this event.
We're sorry, this invitation is invalid.
We're sorry, this invitation has already been used.
We're sorry, you already have an order being processed for this event. Please wait a few minutes and try again.
We're sorry, there is a problem with your invitation. Please try again.
Invalid quantity of tickets selected.
Invalid donation amount.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
The captcha you entered is invalid. Please try again.
Invalid credit card selected. You have been logged out.
Sorry, your team selection was not valid.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
State
Zip Code
Province
Postal Code
County
State/Territory
State/Province
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
- 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
Please, note that due to time constraints and class membersip preference, some modules may be only partially covered or not covered at all. Mike, typically, attempts to cover the topics preferred by class membership.
Questions: Please e-mail bibootcamp@okcsql.org.
When & Where
Robert M. Bird Library on the OU Health Sciences Center Campus
1000 Stanton L. Young Blvd
Oklahoma City,
OK 73117
Monday, August 2, 2010 at 6:00 PM - Wednesday, August 18, 2010 at 9:30 PM (CT)
Add to my calendar
Hosted By
OU Health Sciences Center