SQL Server training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
SQL Server 2005 Training * SSAS Training * SSIS Training * SSRS Training
T-SQL Training * SQL Server 2000 Training* Live Online Training


 * SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
 * SQL Server Training: Introduction to Microsoft SQL Server 2005 Administration
 * SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services
 * SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services
 * SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services
 * T-SQL Training: T-SQL for SQL Server 2005 for Report Writers
 * Live Online Training



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary SQL Server Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour SQL Server seminar delivered for their developers. Contact us today for more information.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • Whiteman Air Force Base / Kansas City, Missouri
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

T-SQL Training: T-SQL for SQL Server 2005 for Developers

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 657
Duration: 3 days
view class outline

T-SQL Training Overview

Accelebrate's T-SQL for SQL Server 2005 Developers teaches developers all the Transact-SQL skills they need to develop queries, views, functions, stored procedures, and triggers in SQL Server, as well as embed .NET code.

Note: If you are a developer, we encourage you to consider our Introduction to T-SQL for Developers class as an alternative to this class. All audiences may also wish to consider our SSRS Training: Introduction to SQL Server 2005 Reporting Services class.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.

T-SQL Training Prerequisites

This course can be adapted to any level of prior SQL Server and relational database experience.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

T-SQL Training Objectives

  • Write and tune sophisticated T-SQL queries
  • Work with SQL Server Management Studio
  • Use T-SQL’s programming features such as functions and control flow
  • Implement transactions and error-handling
  • Build stored procedures and triggers
  • Embed .NET code in their databases using SQLCLR
  • Use advanced query techniques such as recursive queries, pivot queries, and full text search

T-SQL Training Materials

  • Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
  • Comprehensive courseware covering all topics taught in the class

Software Needed on Each Student PC

  • Windows 2000, XP, Windows 2003 Server, or Vista
  • Visual Studio 2005
  • SQL Server 2005 with the latest service packs
  • SQL Server Management Studio
  • Important Note: If you have purchased this class, please contact us for detailed setup instructions

T-SQL Training Outline

  • A Tour of SQL Server 2005
    • SQL Server 2005 Editions, Components, and Tools
    • Using SQL Server Management Studio (SSMS)
    • Working with Tables and Queries
    • New Transact-SQL Features
    • Business Intelligence Services
  • Designing and Creating a Database
    • Relational Database Design Principles
    • Implementing the Design
  • Data Selection Queries
    • Understanding Transact-SQL
    • The SELECT Statement
    • The WHERE Clause
    • Using ORDER BY to Sort Data
    • The GROUP BY Clause
    • Joining Tables
  • Modifying Data
    • Modifying Data
    • Inserting Data
    • Updating Data
    • Deleting Data
    • Understanding Transaction Isolation
  • Working with SQL Server Management Studio
    • Getting Started with SSMS
    • Exploring the Object Explorer
    • Working with the Query Editor
    • Using SQL Server Books Online
  • Transact-SQL Programming
    • Overview of Transact-SQL
    • Using Built-In Functions
    • Controlling Flow
    • Ranking Results
  • Transactions and Error Handling
    • Transaction Concepts
    • Applications and Transactions
    • Creating Explicit Transactions
    • Using TRY/CATCH Error Handling
  • Creating Views
    • What Is a View?
    • Creating Views
    • Updating Data Using a View
    • Using Computed Columns
    • Indexed Views
    • Partitioned Views
  • Creating Stored Procedures and Triggers
    • Creating Stored Procedures
    • Creating Triggers
  • Creating User-Defined Functions
    • User-Defined Function Overview
    • Scalar Functions
    • Inline Table-Valued Functions
    • Multi-Statement Table-Valued Functions
    • Using Functions, Views, and Stored Procedures
  • Using .NET Code in SQL Server 2005
    • Writing SQLCLR Code
    • SQLCLR Code Modules
    • Managing Code Modules
    • SQLCLR Security
    • T-SQL vs. .NET Code
  • Advanced Query Techniques
    • Full-Text Search
    • Generating XML with FOR XML
    • Using APPLY
    • Creating Recursive Queries
    • Creating Pivot Queries
    • Executing Dynamic SQL
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



 
The material presented and the pace of the class are excellent.
 
—Mike Morford
Premier Farnell
Chicago, Illinois

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003-2006 by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | San Diego, CA | San Francisco, CA | Denver, CO | Washington, DC | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Oklahoma City, OK | Toronto, ON | Philadelphia, PA | Pittsburgh, PA | Portland, OR | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Open Source & Apache Training