Watch A Short Video Overview of Instructor-Led Online Classes
SQL Server Training
Training Courses
In this Microsoft SQL Server 2005 for Administrators Training course students learn how to understand basic database design principles
and how to implement them in SQL Server, to configure and tune SQL Server
and monitor database activity, implement disaster recovery options, and
implement asynchronous messaging with the new Service Broker...[more]
In this Microsoft SQL Server 2005 for Developers Training course students learn how to install and configure Microsoft SQL Server
2005, to understand the differences between views, stored procedures, triggers,
and user-defined functions, to examine new RANKing functions, Common
Table Expressions, learn techniques for dealing with complex queries, and
to explore advanced techniques for working with complex data structures...[more]
In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions...[more]
In this SQL Querying Introduction Training course, students will learn the basics of retrieving data from a database using Structured Query Language (SQL.) Students will also learn how to sort, filter and group data in a query result....[more]
In this SQL Server 2005 Analysis Services Training course students learn the core concepts in building solutions using
Microsoft Business Intelligence with SSAS, OLAP (cube) modeling and data
mining, and to develop solutions using Business Intelligence Development
Studio (BIDS)...[more]
In this SQL Server 2005 Integration Services Training course students learn how to use the SQL Server Management Studio
tool to build database maintenance plans, to work with Business Intelligence
Development Studio, work with Control Flow and Data Flow, and to debug and
handle errors in code...[more]
In this SQL Server 2005 Reporting Services Training course students learn how to create complex reports using expressions,
global collections, and conditional formatting, to create reports with nested
groups and multiple parameters, to secure reports using integrated security and
SSL, and to empower users to create ad-hoc reports using Report Builder and
the models created using Report Model projects...[more]
In this SQL Server 2008 Analysis Services Training course students learn how Business Intelligence applies to a database,
how the cube structure works for viewing data information, see how to create
cube models using SQL Server Business Intelligence Development Studio
(BIDS), and how to create key performance indicators (KPIs)...[more]
In this SQL Server 2008 for Developers Training course students learn how to apply relational database design principles,
use SQL Server Management Studio (SSMS), implement security with
authentification, authorization and encryption, and to understand Business
Intelligence to add reporting and analysis capabilities to databases and
applications...[more]
In this SQL Server 2008 Integration Services Training course students learn how to use BIDS to create well-designed packages,
to work with Control Flows and understand how to build them using many of
the built-in tasks, including the various containers, and to understand variables
and configurations to make their packages dynamic and resilient to changes in
environments...[more]
In this SQL Server 2008 Reporting Services Training course students learn how to create tabular and list reports, use global,
field and parameter collections, create groups using the grouping pane for
Details Group and Row Groups, create Matrix reports and see the new features
of Matrix reports for SSRS 08, and to create a Web Service, a Web Service
Subscription and Custom Assemblies...[more]
In this T-SQL with SQL Server 2008 Training course students learn how to create a SQL Server database based on
sound design principles, create constraints, triggers, and indexes, write and
use stored procedures to provide a safe, controlled, efficient way to execute
Transact-SQL code to access and update data and database objects, and to
understand the complex data types in SQL Server...[more]
