United States flagCanada flag1 877 849 1850 International flag +1 678 648 311
Please contact us
for GSA pricing.
GSA
Contract #
GS-35F-0307T

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

Course Number: SQL-140
Duration: 2 days
view course 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.

Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house 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 for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

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 Materials

All attendees receive comprehensive courseware and a copy of Sams Publishing’s Teach Yourself T-SQL in 10 Minutes.

Software Needed on Each Student PC

    • Windows XP Pro, Vista Business/Ultimate or 7, Server 2008, or Server 2008 R2 with the latest service packs installed
    • SQL Server 2005, 2008, or 2012 installed with the latest service packs
    • SQL Server client tools, most notably SQL Server Management Studio
    • Related sample databases we would provide

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