back to Course Categories | back | print
SQL Server Programming          

Duration: 5 days

Description 
This class focuses on developing applications in a SQL Server environment. Applications will be developed using Transact-SQL, .NET and XML. Topics include wo you will learn how to Develop database applications for SQL Server 2005 using Transact-SQL and .NET Create and debug robust Transact-SQL stored procedures Leverage the new XML data type and the XQuery language Build data validation and audit trails with INSTEAD OF and AFTER triggers Manage concurrency using transactions and isolation levels Transmit and receive reliable message streams using Service Broker course benefits The development features offered in SQL Server 2005 make this database management system one that is viable for both small-scale or large-scale organizations. By using Transact-SQL, .NET and XML, developers have the potential to build truly flexible, scalable and robust applications that meet today's business demands. hands-on training In this in-depth course, you gain extensive practical experience developing and debugging stored procedures, triggers and functions, building XML queries, and handling reliable message-driven software. You develop applications that take full advantage of SQL Server 2005.

Topics

  • SQL Server overview
  • Transact-SQL
  • Understanding databases
  • Logical and physical design
  • Understanding relationships
  • Constraints
  • Primary keys
  • Foreign keys
  • Normalization
  • Network architectures
  • Structured Query Language (SQL)
  • Stored queries
  • Tables and indexes
  • Managing indexes
  • Designing Tables
  • Transactions
  • Log files
  • Organizing data
  • Data types
  • Tables
  • Tables columns
  • Database files
  • Organizing a database
  • Creating databases
  • Filegroups
  • Security
  • Users
  • Permissions
  • Application security
  • Auditing
  • Security checklists
  • Fixed server roles
  • User-Defined roles
  • Application roles
  • SQL and Transact SQL
  • SELECT Statement
  • Transact SQL Built-In functions
  • Summary queries
  • Sub-queries
  • Views
  • Working with views
  • SHOWPLAN
  • Statistics
  • Managing transactions
  • Modifing records
  • Deleting records
  • Locking
  • Transact SQL
  • Variables
  • Flow Control Statements
  • The EXEC( ) function
  • Error processing
  • Working with cursors
  • Stored procedures
  • Passing parameters
  • Returning values
  • Temporary procedures
  • Triggers
  • Nested Triggers
  • Action queries
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • Sorting data
  • Aggregate functions
  • Joins
  • SQL Server tools
  • Query Analyser
  • Importing data
  • Exporting data
  • DTS - Data Transformation Services
  • XML Support
  • The dtsrun Utility
  • Connecting to External Data

Prerequisites

  • A fundamental understanding of computers and relational databases. A basic understanding of programming is required.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design