Font size:

Students learn the technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.


TARGET AUDIENCE:
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

COURSE OBJECTIVES:
After completing this course, students will be able to:•Write SELECT queries•Query multiple tables•Sort and filter data•Describe the use of data types in SQL Server•Modify data using Transact-SQL•Use built-in functions•Group and aggregate data•Use subqueries•Use table expressions•Use set operators•Use window ranking, offset and aggregate functions•• Implement pivoting and grouping sets•Execute stored procedures•Program with T-SQL•Implement error handling•Implement transactions

Lesson 1: Introduction to Microsoft SQL Server 2014

    The Basic Architecture of SQL Server
    SQL Server Editions and Versions
    Getting Started with SQL Server Management Studio
    Lab : Working with SQL Server 2014 Tools

Lesson 2: Introduction to T-SQL Querying

    Introducing T-SQL
    Understanding Sets
    Understanding Predicate Logic
    Understanding the Logical Order of Operations in SELECT statements
    Lab : Introduction to Transact-SQL Querying

Lesson 3: Writing SELECT Queries

    Writing Simple SELECT Statements
    Eliminating Duplicates with DISTINCT
    Using Column and Table Aliases
    Writing Simple CASE Expressions
    Lab : Writing Basic SELECT Statements

Lesson 4: Querying Multiple Tables

    Understanding Joins
    Querying with Inner Joins
    Querying with Outer Joins
    Querying with Cross Joins and Self Joins
    Lab : Querying Multiple Tables

Lesson 5: Sorting and Filtering Data

    Sorting Data
    Filtering Data with a WHERE Clause
    Filtering with the TOP and OFFSET-FETCH Options
    Working with Unknown and Missing Values
    Lab : Sorting and Filtering Data

Lesson 6: Working with SQL Server 2014 Data Types

    Introducing SQL Server 2014 Data Types
    Working with Character Data
    Working with Date and Time Data
    Lab : Working with SQL Server 2014 Data Types

Lesson 7: Using DML to Modify Data

    Inserting Data
    Modifying and Deleting Data
    Lab : Using DML to Modify Data

Lesson 8: Using Built-In Functions

    Writing Queries with Built-In Functions
    Using Conversion Functions
    Using Logical Functions
    Using Functions to Work with NULL
    Lab : Using Built-In Functions

Lesson 9: Grouping and Aggregating Data

    Using Aggregate Functions
    Using the GROUP BY Clause
    Filtering Groups with HAVING
    Lab : Grouping and Aggregating Data

Lesson 10: Using Subqueries

    Writing Self-Contained Subqueries
    Writing Correlated Subqueries
    Using the EXISTS Predicate with Subqueries
    Lab : Using Subqueries

Lesson 11: Using Table Expressions

    Using Derived Tables
    Using Common Table Expressions
    Using Views
    Using Inline Table-Valued Functions
    Lab : Using Table Expressions

Lesson 12: Using Set Operators

    Writing Queries with the UNION Operator
    Using EXCEPT and INTERSECT
    Using APPLY
    Lab : Using Set Operators

Lesson 13: Using Window Ranking, Offset, and Aggregate Functions

    Creating Windows with OVER
    Exploring Window Functions
    Lab : Using Window Ranking, Offset and Aggregate Functions

Lesson 14: Pivoting and Grouping Sets

    Writing Queries with PIVOT and UNPIVOT
    Working with Grouping Sets
    Lab : Pivoting and Grouping Sets

Lesson 15: Executing Stored Procedures

    Querying Data with Stored Procedures
    Passing Parameters to Stored Procedures
    Creating Simple Stored Procedures
    Working with Dynamic SQL
    Lab : Executing Stored Procedures

Lesson 16: Programming with T-SQL

    T-SQL Programming Elements
    Controlling Program Flow
    Lab : Programming with T-SQL

Lesson 17: Implementing Error Handling

    Using TRY / CATCH Blocks
    Working with Error Information
    Lab : Implementing Error Handling

Lesson 18: Implementing Transactions

    Transactions and the Database Engine
    Controlling Transactions
    Isolation Levels
    Lab : Implementing Transactions




Virtual 20461 Querying Microsoft SQL Server® Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet. The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.

There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.

This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students. You will hear and see your instructor as they teach the course and answer your questions via voice or text. Choose the online live virtual training option and you can access the recorded version even after the class has finished.

The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.

Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.

Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live2/19/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521254
PA Wayne2/19/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544283
Virtual Live3/5/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521256
KS Overland Park3/5/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544348
Virtual Live3/19/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521259
IN Carmel3/19/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544503
Virtual Live4/9/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521262
TX San Antonio4/9/2018 9:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544729
Virtual Live4/23/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521244
CA San Diego4/23/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544857
Virtual Live5/7/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521247
TX Irving5/7/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544937
Virtual Live5/21/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521250
CT Bloomfield5/21/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544092
Virtual Live6/4/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521253
CA Anaheim6/4/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544293
Virtual Live6/18/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521255
MI Detroit6/18/2018 10:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544478
Virtual Live7/9/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521258
IL Chicago7/9/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544549
Virtual Live7/23/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>5 days2975.002521261
VA McLean7/23/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>5 days2975.002544747
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 22 of 22 items