 |

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
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Kamloops / Vancouver, British Columbia
- 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
- 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
- Honolulu, Hawaii
- 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
- Annapolis / 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
- Fredericton / Moncton / Saint John, New Brunswick
- 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
- Bismarck & Fargo, North Dakota
- Halifax, Nova Scotia
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Québec City / Montreal, Québec
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- 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
- 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
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
 |
 |
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writers
|
Course Number: SQL-140
GSA/Previous 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. 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/?action=categorygroup&page=database.
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 Objectives
- 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
- T-SQL in 10 Minutes
- Comprehensive courseware covering all topics taught in the class
Software Needed on Each Student PC
- Windows 2000 Pro, XP Pro, Vista Business/Ultimate or 7, Server 2008, or Server 2008 with the latest service packs installed
- SQL Server 2000, 2005, or 2008 installed with the latest service packs
- SQL Server client tools, most notably the Query Analyzer (for SQL Server 2000) or SQL Server Management Studio (for SQL Server 2005 or 2008)
- Related sample databases we would provide
- 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
- 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.

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