Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Querying with Transact-SQL Essentials Course

Querying with Transact-SQL Essentials Training Course


Course Description:

Training Dates
(Click on the course name below to view course details and full list of class dates)

Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 12/17/2018 - 12/19/2018
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 1/2/2019 - 1/4/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 1/14/2019 - 1/16/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 1/28/2019 - 1/30/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 2/11/2019 - 2/13/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 2/25/2019 - 2/27/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 3/11/2019 - 3/13/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 3/25/2019 - 3/27/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 4/8/2019 - 4/10/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 4/22/2019 - 4/24/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 5/6/2019 - 5/8/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 5/20/2019 - 5/22/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 6/3/2019 - 6/5/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 6/17/2019 - 6/19/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 7/1/2019 - 7/3/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 7/15/2019 - 7/17/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 7/29/2019 - 7/31/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 8/12/2019 - 8/14/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 8/26/2019 - 8/28/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 9/9/2019 - 9/11/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 9/23/2019 - 9/25/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 10/7/2019 - 10/9/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 10/21/2019 - 10/23/2019
Course Fee : $1795


Querying with Transact-SQL Essentials
Locations: Available Nationwide and Online
Class Date(s): 11/4/2019 - 11/6/2019
Course Fee : $1795


Course Syllabus

Section 1: Introduction to Microsoft SQL Server 2016
This Section introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.
Lessons
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Lab : Working with SQL Server 2016 Tools

Section 2: Introduction to T-SQL Querying
This Section introduces the elements of T-SQL and their role in writing queries, describes the use of sets in SQL Server, describes the use of predicate logic in SQL Server, and describes the logical order of operations in SELECT statements.
Lessons
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Lab : Introduction to Transact-SQL Querying

Section 3: Writing SELECT Queries
This Section introduces the fundamentals of the SELECT statement, focusing on queries against a single table.
Lessons
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Lab : Writing Basic SELECT Statements

Section 4: Querying Multiple Tables
This Section explains how to write queries which combine data from multiple sources in SQL Server. The Section introduces the use of JOINs in T-SQL queries as a mechanism for retrieving data from multiple tables.
Lessons
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Lab : Querying Multiple Tables

Section 5: Sorting and Filtering Data
This Section explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The Section also discusses how to resolve missing and unknown results.
Lessons
Sorting Data
Filtering Data with Predicates
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown Values
Lab : Sorting and Filtering Data

Section 6: Working with SQL Server 2016 Data Types
This Section explains the data types SQL Server uses to store data. It introduces the many types of numeric and special-use data types. It also explains conversions between data types, and the importance of type precedence.
Lessons
Introducing SQL Server 2016 Data Types
Working with Character Data
Working with Date and Time Data
Lab : Working with SQL Server 2016 Data Types

Section 7: Using DML to Modify Data
This Section describes the use of Transact-SQL Data Manipulation Language to perform inserts, updates, and deletes to your data.
Lessons
Inserting Data
Modifying and Deleting Data
Lab : Using DML to Modify Data

Section 8: Using Built-In Functions
This Section introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.
Lessons
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Lab : Using Built-In Functions

Section 9: Grouping and Aggregating Data
This Section introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The Section is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause.
Lessons
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Lab : Grouping and Aggregating Data

Section 10: Using Subqueries
This Section will introduce the use of subqueries in various parts of a SELECT statement. It will include the use of scalar and multi-result subqueries, and the use of the IN and EXISTS operators.
Lessons
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Lab : Using Subqueries

Section 11: Using Set Operators
This Section introduces the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.
Lessons
Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY
Lab : Using SET Operators

Available Locations

Alabama
Birmingham
Birmingham South
Huntsville
Mobile
Montgomery

Arizona
Mesa
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Mission Valley
Orange
Palo Alto
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Rocky Hill
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Fort Walton Beach
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miami Doral
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Plantation
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise
Meridian

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Ellicott City
Frederick
Germantown
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Traverse City
Troy

Minnesota
Bloomington
Maple Grove
Minneapolis
Minneapolis downtown
Rochester MN
St Cloud
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua
Portsmouth

New Jersey
Bridgewater
East Brunswick
East Rutherford
Hamilton
Jersey City
Mahwah
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Brooklyn
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Queens
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Chapel Hill
Charlotte
Charlotte North
Charlotte Uptown
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Glen Allen
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile