 |
 SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
SQL Server Training: Introduction to Microsoft SQL Server 2008 for Developers and Query Writers
SQL Server Training: Introduction to Microsoft SQL Server 2005 for Developers and Query Writers
SQL Server Administration Training: Introduction to Microsoft SQL Server 2005 for Administrators
SQL Server 2005: Advanced Topics
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
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
T-SQL Training: T-SQL for SQL Server 2008 for Developers
T-SQL Training: T-SQL for SQL Server 2005 for Developers
Live Online Training
 Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
Contract #
3-09-70-2645A
Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Oakland / San Jose / San Francisco, California
- Sacramento, 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
- Boise, Idaho
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Flint, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Whiteman Air Force Base / Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Trenton, New Jersey
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Stockholm, Sweden
- Chattanooga / Knoxville, Tennessee
- 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 2008 for Developers
|
Course Number: 658
Duration: 3 days
view class outline
Looking for T-SQL for SQL Server 2005 for Developers?
T-SQL Training Overview
Accelebrate's T-SQL for SQL Server 2008 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: All audiences may also wish to consider our SSRS Training: Introduction to SQL Server 2008 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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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 XP Pro, Vista Business/Ultimate, Server 2003, or Server 2008 with the latest service packs installed
- SQL Server 2008 with the latest service packs
- Visual Studio 2005 or 2008 with the latest service packs
- SQL Server Management Studio
- Related sample databases Accelebrate would provide
- Note: If you have purchased this course, please contact us for a detailed setup sheet.
Important Note: If you have purchased this class, please contact us for detailed setup instructions.
|
T-SQL Training Outline
- A Tour of SQL Server 2008
- SQL Server 2008 Editions, Components, and Tools
- Using SQL Server Management Studio (SSMS)
- Working with Tables, Queries, and Views
- Business Intelligence Services
- Designing and Creating a Database
- Relational Database Design Principles
- Implementing the Design
- Working with SQL Server Management Studio
- Getting Started with Management Studio
- 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
- Data Selection Queries
- Understanding Transact-SQL
- The SELECT Statement
- The WHERE Clause
- Using ORDER BY to Sort Data
- The GROUP BY Clause
- Joining Tables
- Advanced Data Types
- Introduction
- The HierarchyID Data Type
- Sparse Columns and Column Sets
- FILESTREAM Storage
- Spatial Data
- Complex Querying
- Working with NULL Values
- Ranking Grouped Data
- Writing Correlated Subqueries
- Using Common Table Expressions
- Modifying Data
- Modifying Data with Transact-SQL
- Inserting Data
- Updating Data
- Deleting Data
- Understanding Transaction Isolation
- Working with XML
- The XML Data Type
- XML Schema Collections
- Querying XML
- Best Practices
- Creating Views
- What Is a View?
- Creating Views
- Updating Data Using a View
- Using Computed Columns
- Indexed Views
- Partitioned Views
- Implementing SQL Server Partitions
- Overview of Table-Based Partitions
- Creating Partitioned Tables
- Querying Partitions
- Managing Partitions
- 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
- Creating Stored Procedures and Triggers
- Creating Stored Procedures
- Creating Triggers
- Advanced Query Techniques
- Full-Text Search
- Advanced T-SQL Techniques
- Executing Dynamic SQL
- Advanced Techniques
- Complex Data and Structures
- Writing More Efficient Queries
- Working with Complex Queries
- Maintaining Query Files
- Conclusion
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
