SQL Server Training / Transact SQL Training
Introduction to Transact SQL for SQL Server for Report Writers
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 Objectives
Transact SQL Training Outline
Relational Database Basics
Brief History of SQL
Relational Databases [may be compressed due to attendee experience]
SQL Server Objects
Simple SELECTs with SQL Server
Introduction to the Northwind Database
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
The WHERE Clause and Operator Symbols
The WHERE Clause and Operator Words
Checking Multiple Conditions
Writing SELECTs with Multiple Conditions
Advanced SELECTs with SQL Server
Aggregate Functions and Grouping
Built-in Data Manipulation Functions
Subqueries, Joins, and Unions with SQL Server
Inserting, Updating and Deleting Records with SQL Server
Creating and Modifying Tables with SQL Server
Views and Stored Procedures in SQL Server
Creating Stored Procedures
Testing stored procedures
This course can be adapted to any level of prior SQL Server and relational database experience.
All attendees receive comprehensive courseware and a copy of Sams Publishing’s Teach Yourself T-SQL in 10 Minutes.
Software needed for each student PC: