Microsoft SQL Server 2008 Training
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.
Our instructor led courses are filled with examples and designed with hands-on lab exercises so you can practice as you learn.
Our state of the art training rooms provide individual workstations to maximize your learning experience.
We limit class size to 12 students, making the learning experience interactive yet personalized.
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
In this course, you will learn about the features that are available in SQL Server, like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing with complex data structures and processes, and how to make your databases more scalable through partitioning.
Creating Reports Using SQL Server Reporting Services
This two-day instructor-led course teaches students how to build reports using Reporting Services. The course discusses how to use the Reporting Services development tools to create reports, for those focused on creating reports. This course will not cover the administrative nor the programming aspects of Reporting Services; these topics are covered in our SQL Server 2005/2008 Reporting Services course.
SQL Server 2005/2008 Reporting Services
In this course, you will learn how to use SQL Server 2008 Reporting Services, explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You'll then explore tabular and list reports that employ datasets and data regions.
As you progress you'll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL.
Next you'll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You'll gain knowledge of SSRS Security in managing of user roles and accounts and much more. For the SQL 2005 users, we will cover the features/differences in class.
SQL Server 2005/2008 Integration Services
This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations.
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
SQL Server 2005/2008 Analysis Services
In this course, you will learn how to use Microsoft SQL Server 2008 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 2008 developer the tools to build data cubes and forecasting solutions.
This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005/2008 Integrated Services and Reporting Services
2778 - Writing Queries Using Microsoft SQL Server Transact-SQL
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2005 or 2008.
6158 - Updating Your SQL Server 2005 to SQL Server 2008
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
6231 - Maintaining a Microsoft SQL Server 2008 Database
This four-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
6232 Implementing a Microsoft SQL Server 2008 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
If you require a custom or dedicated training program for your company, contact a VTEC Education Specialist at 207.775.0244, or email sales@vtec.org.
Offers
