Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writers

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

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

Valid Object References

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

UNION ALL
UNION Rules

Inserting, Updating and Deleting Records with SQL Server

INSERT
UPDATE
DELETE

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

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.

Complimentary SQL Server Training Seminar