Home
>
Events
>
Up and Running on SQL Server 2008 + Business Intelligence
Up and Running on SQL Server 2008 + Business Intelligence
-
UTS City campus
09/08 to 06/09
Overview
A practical course for the ICT Industry utilizing the latest SQL
Server 2008 developed by Microsoft. SQL Server 2008 provides
.NET integration and XML support as well as a wealth of
programming enhancements. The improved security is a feature of
this release. This course provides attendees with the knowledge
necessary to take advantage of new features provided by SQL
Server 2008. It provides a comprehensive overview of
technologies, security, and design best practices with
particular emphasis on hands-on skills.
On completion of this course, students should have the skills
to:
- Decide whether to migrate to SQL Server 2008
- Develop and write code for SQL Server 2008
-
Implement Advanced Availability & Scalability features of
SQL Server 2008
-
Implement Advanced indexing and Full-text search features
- Design Service Oriented Architecture (SOA)
-
Design distributed applications using the Distributed
Application Designer
- Use SQL Server 2008 Reporting Services
-
Use the Business Intelligence Development Studio to develop BI
database objects
-
Use SQL Server Management Studio to operate and maintain BI
database objects
-
Use Business Intelligence Development Studio for designing and
debugging BI applications
-
Understand that SQL Server 2008 provides many options to
deviate from generic database design, by eliminating or
virtualizing different components
This course has a particular emphasis on real world applications
and skills.
Topics covered include:
- SQL Server 2008 Architecture and Components
- SQL Server Management Studio
- Programming SQL Server 2008 with .NET
- Enhancements to Transact-SQL
- The XML Data Type and XQuery
-
SQL Server 2008 High Availability & Scalability features
- Security Features & Improvements
- ADO.NET 2.0
- SQL Server Service Broker
- Developing client applications
- SQL Server Business Intelligence Development Studio
-
Other BI tools such as DTS, Analysis Services OLAP, Analysis
Services Data Mining and Reporting Services
Schedule
|
Part B: SQL Server 2008 for Business Intelligence (BI)
|
|
Session
|
Date
|
Time
|
Topic
|
Presenters
|
|
1
|
Tuesday
06-04-2010
|
6PM - 9PM |
SQL Server Integration Services (SSIS) and creating a Data
Warehouse
|
Peter Gfader
|
| 2 |
Tuesday
13-04-2010
|
6PM - 9PM |
Analysis Services (OLAP)Creating a Cube + Cube Issues
|
Peter Gfader
|
| 3 |
Tuesday
20-04-2010
|
6PM - 9PM |
Reporting Services |
Peter Gfader
|
| 4 |
Tuesday
27-04-2010
|
6PM - 9PM |
The Best 3rd Party Cube Browsers |
Peter Gfader
|
| 5 |
Tuesday
04-05-2010
|
6PM - 9PM |
Data Mining |
Peter Gfader
|
* Systems will be provided during the demonstrations that have
all necessary software installed.
Note:
-
Bring a USB Key so you can back up your solution to take
home from the labs
-
We supply a VMWare image on DVD which is running
Windows XP Pro, Visual Studio .NET 2008 and SQL Server 2008
- You need a DVD ROM
- You need a Pentium 4 with 1GB RAM or more
-
You need VMWare player (Free from
VMWare Player Home
). You are welcome to install VS.NET 2008 and SQL Server
2008 but we don't provide any support (support is provided
for the VMWare image)
-
From the "Session Menu" on the login screen, choose the
"Windows XP.NET"session
-
Type in your username and password. Your vmware image
(session) will start automatically. (You can also start it
manually by running the command vmware from a terminal
window.)
2008
/
2008
/
2007
Adam Cogan
Jatin Valabjee
Eric Phan
Justin King
Peter Gfader