Introduction to Transact-SQL

Master Transact-SQL in our 4-day course tailored for business analysts and database administrators to efficiently query and manage SQL Server databases.

Course Thumbnail

Essential Skills Gained

Checkmark

Use SQL Server Management Studio to explore and diagram database structures.

Checkmark

Write comprehensive SELECT statements with advanced filtering and data manipulation.

Checkmark

Control and format query output using expressions and CASE logic.

Checkmark

Aggregate and group data to generate meaningful insights.

Format

  • Instructor-led
  • 4 days with lectures and hands-on labs.

Audience

  • Business Analysts
  • System Administrators
  • Database Administrators
  • Students with no programming experience

Description

During this 4-day course, students will learn Transact-SQL as implemented in SQL Server 2000, 2005 and SQL Server 2008 R2. The course is designed and paced for students that do not have a programming background. The course provides students with knowledge to learn the technical skills needed to write Transact-SQL SELECT statements accessing one or more tables. The student will learn the various techniques for combining data, filtering the results as well as how to control and format the statement output. The course starts by establishing a foundation understanding of a SQL Server database and use of the tools available to discover the database definition. Students are prepared to use various Microsoft tools to submit queries and view the results. Following a step-by-step process for creating SQL queries from business requirements, students learn how to write a query based on the way SQL Server processes the SQL statement. This differs from most courses, which present SQL as a set of features. This approach uses the natural way of breaking down the problem into a logical set of steps. Each step can be validated before moving to the next step. Lectures that highlight and explain Transact-SQL concepts are reinforced with extensive follow-along demonstrations and hands-on labs.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Discovering the Database

  1. Using SQL Server Management Studio (SSMS)

  2. Identifying table relationships

  3. SSMS Diagram Support

  4. Preparing to Write a SQL SELECT

Accessing Tables

  1. The Basic SELECT

  2. Combining Two Tables with a Join

  3. Inner Join

  4. Outer Join

  5. Combining Multiple Tables with a Join

Filtering the Data

  1. Basic Filtering with WHERE clause

  2. Equality expressions

  3. Wildcard filtering

  4. Complex Filtering

  5. Range and List-based Filtering

  6. Using Built-in Functions

Displaying Data

  1. Defining the Result Set

  2. Manipulating Numbers and Data Types

  3. Using Conditional Column Output

  4. NULL Functions

  5. CASE Expressions

  6. Controlling Output Rows

  7. TOP operator

Aggregating Data

  1. Grouping and Summarizing Data

  2. Filtering Aggregate

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.