Database Developer school training courses in Dallas, TX (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>>

Take your skills to the next level as a Microsoft Certified IT Professional (MCITP) Database Developer. This 3 course-training program will effectively prepare you to implement and develop Microsoft SQL Server 2005 databases. Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data by using S...

Full archival course description>>

web database developer training courses and programs are available at york technical college in Rock Hill, or it can provide customized training on your request. Please visit the official website of york technical college or call (803) 327-8000 for details.