 |
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 Developers
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
|
 |
 |
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writers
|
Course Number: 655
Duration: 2 days
view class outline
Transact-SQL Training Overview
Accelebrate's Introduction to T-SQL for SQL Server for Report Writers training class teaches attendees the T-SQL and SQL Server skills they need to develop queries, views, and stored procedures for SQL Server.
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.
Transact-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.
Transact-SQL Training Goals
- Understand how SQL Server works
- Learn to use SQL to output reports with SQL Server
- Learn to modify SQL Server data with SQL
- Learn how to write stored procedures for SQL Server
Transact-SQL Training Materials
- SQL in 10 Minutes
- Comprehensive courseware covering all topics taught in the class
Software Needed on Each Student PC
- Windows 2000, XP, or Windows 2003 Server
- SQL Server 2000 SP3a or later, or SQL Server 2005 (either on each student's machine or centrally), with the Northwind and Pubs sample databases
- SQL Server client tools, most notably the Query Analyzer (for SQL Server 2000) or SQL Server 2005 Management Studio
- Note: If you have purchased this course, please contact us for a detailed setup sheet.
|
Transact-SQL Training Outline
- Relational Database Basics
- Brief History of SQL
- Relational Databases [may be compressed due to attendee experience]
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
- SQL Server Objects
- SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
- Simple SELECTs with SQL Server
- Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
- SELECTing All Columns in All Rows
- Exploring the Tables
- SELECTing Specific Columns
- Sorting Records
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
- The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
- The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
- Writing SELECTs with Multiple Conditions
- Advanced SELECTs with SQL Server
- Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
- Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
- Subqueries, Joins, and Unions with SQL Server
- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Outer Joins
- Unions
- Inserting, Updating and Deleting Records with SQL Server
- Creating and Modifying Tables with SQL Server
- Creating Tables
- Datatypes
- Altering Tables
- Adding a Column
- Dropping a Column
- Renaming Tables
- Dropping Tables
- Views and Stored Procedures in SQL Server
- Creating Views
- Dropping Views
- Creating Stored Procedures
- Designing a stored procedure
- Specifying input parameters
- Returning a recordset
- Returning output parameters
- Testing stored procedures
- Importing/Exporting SQL Server data
- Importing delimited files and XML
- Importing data from other RDBMS systems
- Exporting data to delimited files or XML
- Backing up data to a backup file
- Exporting data to other RDBMS system
- 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!

|
 |
|
| |
I would recommend this class not only to new SQL users, but intermediate users as well. Class was well paced and informative providing details necessary to move learning forward.  |
| |
—Kevun Kohl
GE Money
Canton, Ohio |
|
 |