Training Home | SharePoint 2007 Training | Visual Studio .NET Development | SQL Server 2008 BI | SilverLight | Cloud Computing
Microsoft SQL Server & Business Intelligence Training
Microsoft SQL Server 2008 for Developers
VIEW COURSE DETAILS, COURSE SCHEDULE, REGISTERIn this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and Visual Basic to build database objects.
Student Prerequisites
To get the most out
of the Microsoft SQL
Server 2008 course,
you should have a
solid understanding
of relational
databases and the
concepts of SQL
Server. No
particular
programming
experience is
required, but the
course is taught
from a developer's
perspective.
Course Details:
| Course Code: SQL2008 | Format: Instructor-Led/Hands On |
| Course Length: 5 days | Registration Fee: $2,495 |
SQL Server
2005 Reporting
Services
VIEW COURSE DETAILS, COURSE SCHEDULE, REGISTERIn this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
Student Prerequisites
* Familiarity with
databases and the
SQL language.
* Knowledge of SQL
Server helpful but
not required.
* Knowledge of
Visual Studio
.NET/2005 helpful
but not required.
* Knowledge of C# or
VB helpful but also
not required.
Course Details:
| Course Code: SQL2005RS | Format: Instructor-Led/Hands On |
| Course Length: 2 days | Registration Fee: $995 |
SQL Server 2005 Integration Services
VIEW COURSE DETAILS, COURSE SCHEDULE, REGISTERThis course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.
Student Prerequisites
* Familiarity with
databases and the
SQL language.
* Knowledge of SQL
Server required.
* Knowledge of
Visual Studio
.NET/2005 required.
* Knowledge of C# or
VB required.
Course Details:
| Course Code: SQL2005INT | Format: Instructor-Led/Hands On |
| Course Length: 2 days | Registration Fee: $995 |
SQL Server 2005 Analysis Services
VIEW COURSE DETAILS, COURSE SCHEDULE, REGISTERIn this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%
Student Prerequisites
* Familiarity with
databases and the
SQL language.
* Knowledge of SQL
Server required.
* Knowledge of
Visual Studio
.NET/2005 helpful
but not required.
* Knowledge of C# or
VB helpful but also
not required.
Course Details:
| Course Code: SQL2005AS | Format: Instructor-Led/Hands On |
| Course Length: 2 days | Registration Fee: $995 |