SQL Server Training / Transact SQL Training
Introduction To SQL For Report Writers and Analysts (3-day)
This 3-day SQL Server course, Introduction to T-SQL for Report Writers and Analysts, teaches attendees the basics of Transact SQL, including writing simple and complex queries, working with data types, building functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations and subqueries.
We also offer a 4-day class that adds coverage of ranking functions, common table expressions (CTE’s), data manipulation language (DML), and more.
Note: This class is appropriate for SQL Server 2012 through 2017.
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.
SQL Training Objectives
All students will:
SQL Training Outline
Class Databases Overview
Database Design Concepts
What is SQL
Database Terminology Overview
Introduction to Database Diagrams
SQL Server Objects
Overview of SSMS and Query Writing
Tips and tricks with SSMS
Using the SQL Editor
Creating SSMS script projects
Adding comments to queries
Understanding batches and scripts
Basic SELECT Statement
The SELECT Statement
Execution Order of SELECT Statements
Working with Data Types
Numeric Data Types
String Data Types
Date and Time Data Types
Other Data Types
Enhancing SELECT Statements
Built-in Functions Overview
How to find help on functions
Working with Functions
Understanding Data Type Conversion
Handling NULL Data
NULL vs blank
= vs IS NULL
Aggregating and Grouping Data
Aggregate and Nulls
HAVING vs WHERE
Overview ROLLUP and CUBE
Joining Multiple Tables
Joining Three or More Tables
Alternate Syntax, Implicit Joins
Viewing graphical execution plans
Nested vs correlated
Subqueries in SELECT, WHERE, FROM
Alternatives including temp tables, table variables, joins
Putting it all Together
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
All SQL Server training students receive comprehensive courseware.
Software needed for each student PC:
Attendees will need SQL Server Developer Edition or Express Edition (versions 2012 through 2017), including the database engine and Management Studio, as well as sample databases that Accelebrate will provide.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.