home > training > SQL101v2: Introduction to Transact SQL
Print Page

141 Student Comments

SQL101v2: Introduction to Transact-SQL

Master the SELECT statement

$2,795

  • 5 Days
  • Interface exclusive course
  • Master the SELECT statement
  • No programming experience needed
  • Attend online with RemoteLive™
  • Replay™ Class Recordings Included
  • Included in the "all-you-can-eat" Microsoft Live Training Subscription Learn More

Interface Gold™Gold Benefits: Retake this course for one year. Replay™ class recordings included. Money-back guarantee. Price Match available. MS SubscriptionIncluded in the "all-you-can-eat" Microsoft Live Training Subscription.

Dates Available
Class Time
Guaranteed
to Run
Attend
Live Online
Rewatch with
Replay™
 
Dec 11 - Dec 15
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Jan 8 - Jan 12
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Feb 12 - Feb 16
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Mar 11 - Mar 15
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
7AM - 3PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Apr 8 - Apr 12
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
7AM - 3PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
May 13 - May 17
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
7AM - 3PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Jun 24 - Jun 28
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
7AM - 3PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online
Rewatch with Replay™
Register
Register today - no risk!  No cancellation fees.  Full money back guarantee!

This course is recommended for the following:
DP-080T00: Querying Data with Microsoft Transact-SQL

x
Course:
  • This field is for validation purposes and should be left unchanged.

Buy 2 Promo
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.

Outline

Module 1: Discovering the Database

Lessons:

  • Basic Table Metadata
  • Foundations of Relationships of Data Modeling
  • Relationships in Data Modeling
  • Database Diagramming
  • Preparing to Write SQL

 

Module 2: Accessing Tables

Lessons:

  • The Basic SELECT
  • Introducing Joins: Single Join Queries
  • Multiple Join Queries

 

Module 3: Filtering the Data

Lessons:

  • Basic Filtering
  • Complex Filtering
  • Advanced Filtering

 

Module 4: Displaying Data

Lessons:

  • Defining the Result Set
  • Manipulating Numbers and Data Types
  • Controlling Output Rows

 

Module 5: Aggregating Data

Lessons:

  • Grouping Data

 

Module 6:  Modifying the Data

Lessons:

  • Inserting Data
  • Deleting Data
  • Updating Data

 

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.
Student Comments (141)
Comments about enhancing the Courseware
"Looking forward to the SQL250: Transact-SQL Course for Developers class"
October 20, 2023 | DP-080T00 Student
Comments about the Instructor
"He was great, I enjoyed learning from him"
October 20, 2023 | DP-080T00 Student
Comments about the Instructor
"His collaborative style fostered and engaged class discussions allowing us to learn not only from Peter but also from our peers. I thoroughly enjoyed this class!"
October 6, 2023 | DP-080T00 Student
Comments about the Instructor
"Peter was very informative and did provide a ton of examples when asked. He even helped solve one of my classmate's issues in a quick and timely manner"
October 6, 2023 | DP-080T00 Student
Comments about the Instructor
"Instructor Avila is very knowledgeable, professional, and courteous. The lecture is very well organized, clear, and interesting. I learned a lot from this course and will definitely apply to my job. I greatly appreciate Instructor Avila teaching this course."
October 6, 2023 | DP-080T00 Student
Load More Comments