 |
 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.
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
|
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
|
| |
|
|
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 |
|
|
