SQL Server Transact-SQL // // SQL101

SQL101: Introduction to Transact SQL

home > training > SQL101: Introduction to Transact SQL

SQL101: Introduction to Transact SQL

$2,295.00

46 Student Comments

  • 4 Days
  • Interface exclusive course
  • Master the SELECT statement
  • No programming experience needed
  • Attend online with RemoteLive™
  • Replay™ Class Recordings Included
Interface Gold™This is an Interface Gold™ class date delivered live at our Phoenix location. Online attendees will have access to our RemoteLive™ platform. Replay™ class recordings are included.
RemoteLive™
Online Virtual
Attend in Person Phoenix Location
Feb 12 - Feb 15
8AM - 4PM (PHX)
GTRThis class date is Guaranteed to Run and will not change.
REPLAYThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
Attend Live Online/Virtual
Attend in Person Phoenix Location
Apr 9 - Apr 12
8AM - 4PM (PHX)
GTRThis class date is Guaranteed to Run and will not change.
REPLAYThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
Attend Live Online/Virtual
Attend in Person Phoenix Location
Jun 11 - Jun 14
8AM - 4PM (PHX)
GTRThis class date is Guaranteed to Run and will not change.
REPLAYThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
Attend Live Online/Virtual
Attend in Person Phoenix Location

Do you need a class sooner? We can also offer additional dates through our partners! It's not Interface Gold™ but it's a great choice if your schedule is not flexible.

Request A Date
Introduction to Transact SQL course image
x
Course:

Course Description

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.

You’ll gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results.

We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements. This approach uses the natural way of breaking down a problem into logical steps. Each step can be validated before moving to the next step. This differs from most courses, which present SQL as a set of features.

Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs.

Course Outline

1. Discovering the Database

  • Using SQL Server Management Studio (SSMS)
  • Identifying table relationships
  • SSMS Diagram Support
  • Preparing to Write a SQL SELECT


2. Accessing Tables

  • The Basic SELECT
  • Combining Two Tables with a Join
  • Inner Join
  • Outer Join
  • Combining Multiple Tables with a Join


3. Filtering the Data

  • Basic Filtering with WHERE clause
  • Equality expressions
  • Wildcard filtering
  • Complex Filtering
  • Range and List-based Filtering
  • Using Built-in Functions


4. Displaying Data

  • Defining the Result Set
  • Manipulating Numbers and Data Types
  • Using Conditional Column Output
  • NULL Functions
  • CASE Expressions
  • Controlling Output Rows
  • TOP operator


5. Aggregating Data

  • Grouping and Summarizing Data
  • Filtering Aggregate

Audience

This course is intended for Business Analysts, System Administrators, Database Administrators and other professionals with no programming or SQL experience. This course is valuable for anyone who needs to learn how to write a SELECT statement to access SQL Server databases.

Prerequisites

  • Ability to work with the Windows operating system
  • Windows login, startup of applications and programs, menu and toolbar manipulation skills
  • Basic knowledge of the purpose of a database

What You Will Learn

  • Use the SQL Server Management Studio tool to browse the definition of the database, find necessary object names, create database diagrams, and execute a SQL query to return data rows.
  • Write a simple SELECT statement, returning all the columns and rows and formulate meaningful join strategy to bring together all necessary data.
  • Write a WHERE clause to filter the rows based on equality, a list of values, a range of values and a wildcard character condition.
  • Understand the impact on filtering based on implicit data conversions using data type precedence and how to create a proper search argument.
  • Control the display of data in a SQL SELECT including renaming columns, using simple expressions with function to change output values, conditionally change the output values using CASE expressions, sort the result set, eliminate duplicate rows and control the number of rows returned.
  • Write Transact-SQL queries that aggregate values across rows based a group and filter the result set based on aggregated values.
SHOW MORE COURSE OUTLINE
SHOW LESS COURSE OUTLINE
Partners

STUDENT COMMENTS
FOR THIS COURSE.

December 21, 2017 | SQL101 Student
Comments about the Instructor
"Obviously a wide range of knowledge on the topic that made learning much easier since all questions were appropriately answered."
December 21, 2017 | SQL101 Student
Comments about the Instructor
"Peter is a great instructor and helps each student with any and all questions they may have."
December 21, 2017 | SQL101 Student
Comments about the Instructor
"Clarified all questions, made the topic very easy to understand."
December 21, 2017 | SQL101 Student
Comments about the Physical Environment
"Remote session was as good as being there in person."
October 19, 2017 | SQL101 Student
Comments about the Instructor
"Instructor is very well rounded and knows how to relate to us as adult students."
SHOW MORE COMMENTS