Database Developer school training courses in Boston, MA (public, in-house or online)

You Will Learn How To

Design and implement high-performance databases for SQL Server
Create indexes that optimize different types of queries
Design transactions that maximize concurrency and minimize contention
Interpret the data access plans produced by the query optimizer
Minimize I/O by designing efficient physical data structures
Analyze and cure performance problems using SQL Server’s tools

Course Benefits

High-availability database systems off...

Full archival course description>>

You Will Learn How To

Develop complex and robust SQL queries for SQL Server 2008, 2005 and 2000
Query multiple tables with inner joins, outer joins and self joins
Transform data with built-in functions
Summarize data using aggregation and grouping
Execute analytic functions to calculate ranks
Build simple and correlated subqueries

Course Benefits

Microsoft’s Transact-SQL is the cornerstone of all SQL Server database operations. In this hands-on cour...

Full archival course description>>

You Will Learn How To

Develop database applications for SQL Server databases with Transact-SQL
Create modular code using stored procedures
Develop reusable code with scalar- and table-valued functions
Handle Transact-SQL runtime errors to create robust software
Audit data changes using AFTER triggers
Manage concurrency using transactions and locking options

Course Benefits

Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow d...

Full archival course description>>

The Microsoft Certified IT Professional (MCITP) is appropriate for IT professionals who develop a Microsoft SQL Server 2005 database. This certification tests knowledge related to installation or SQL Server 2005, administration of databases, creation of applications, integration of databases, providing reporting services, and integration of notification services with existing applications.

Classroom-based training combined with intensive hands-on labs build the knowledge and experience yo...

Full archival course description>>

This class consists of five days of training that focuses on the new features available in SQL Server 2005. You will learn how to install SQL Server 2005; use the SQL Server 2005 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Replication to synchronize data between databases; use SQL Server Reporting Services (SSRS) to create dynamic database re...

Full archival course description>>