SQL Server 2008 Business Intelligence: ServicesHands On Technology Transfer, Inc. »
12 seats left
Specific Address TBD
New York, New York (Map)
|Share:||Facebook Twitter Pinterest Email|
Benefits of Booking through CourseHorse
- Booking is safe. When you book with us your details are protected by a secure connection.
- Lowest price guaranteed. Classes on CourseHorse are never marked up.
- This class will earn you 25950 points. Points give you money off your next class!
- Class Level: Intermediate
- Age Requirements: 21 and older
- Average Class Size: 8
What you'll learn in this sql server training:This hands-on course walks students through the complete data warehousing and data mining process using SQL Server. Students will design and create data warehouses, then use the Business Intelligence Development Studio (BIDS) to create SQL Server Integration Services (SSIS) routines to move records from a relational database into the data warehouse.
The complete course title is SQL Server 2008 Business Intelligence: Integration Services and Analysis Services
Students Will Learn:
- Importing Excel and XML Data
- Exporting SQL Server Data
- Automating ETL Routines
- Migrating SQL 2000 DTS packages
- Designing Data Warehouses
- Creating Cubes
- Mining Data
- Managing Cube Security
This includes exercises that import and export data between Excel spreadsheets, Access databases, XML files, flat files and SQL Server. Techniques to clean data will also be demonstrated, such as finding duplicate records or performing look-ups in tables. Other exercises will merge data from multiple sources, as well as splitting data to multiple destinations. Troubleshooting and security configurations for these Business Intelligence services are incorporated throughout the course.
Course Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at 3-day SQL Programming course, or equivalent knowledge, is recommended but not required.
"This was one of the most productive and informative classes I have experienced in my 27 years in IT. The instructor is truly an expert in his field."– T.D., Rainmaker
Note: Classes do not have fixed location. Prior to each class they examine the geographical location of the enrolled students and then select a venue that will provide most convenient overall access for the students. Classes are held in hotel conference rooms and exact location is determined 2 weeks prior to the course date.
Interested in an On-Site Class or Custom Program from Hands On Technology Transfer, Inc. ? Request info about private training
Start Dates (3)
|Start Date||# of Sessions||Price|
Mon, Aug 18 9:00am - 5:00pm
Tue, Aug 19 9:00am - 5:00pm
Wed, Aug 20 9:00am - 5:00pm
Thu, Aug 21 9:00am - 5:00pm
Fri, Aug 22 9:00am - 5:00pm
Specific Address TBD
New York, New York
Refund & Cancellation PolicyTuition includes all course materials. Students may withdraw before the second day of class to receive a 100% refund, provided course materials are returned to the instructor. Prorated refunds may be granted for withdrawals after the first day.
School: Hands On Technology Transfer, Inc.
Critical Characteristics of Effective Training
There are literally hundreds of IT training companies for you to choose from. Why should you choose Hands On Technology Transfer, Inc. (HOTT) above the rest? Here are nine critical characteristics that HOTT provides to assure success and remove your risk....
CourseHorse Approved School
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
Ready to take this class?
Or call 212-729-4088
Taking this class for work? Get exclusive perks & discounts for free.