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

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

Conclusion

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training Adobe Training PHP Training XML Training Perl Training Sitemap
“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- 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.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK