Reporting Transact SQL

Transact SQL

44.95 34.95
$44.95 $34.95
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Language: English
  • Difficulty: Beginner
  • Audience: IT Professionals

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

Transact SQL or T-SQL is a standardized computer language for querying, altering and defining relational databases, using declarative statements. In this course we will learn how to write queries in T-SQL for Microsoft SQL Server. While this course is specifically focused on Microsoft product, most of what you learn will be applicable to any SQL based database including Oracle, DB2, MySQL etc. This course does not assume that you have any prior knowledge of T-SQL. If you understand relational database concepts it will be a benefit, however it is not a prerequisite.  

 

Course Objectives

At the end of this course, you will be able to:
  • Understand T-SQL querying concepts
  • Use Select, From, Where, and Order By Clauses
  • Conduct transactions
  • Work with Group By and Having clauses
  • Create multi-table queries with joins and sets
  • Use table expressions
  • Affect query performance
 

Topics Covered

T-SQL Querying Concepts
  • T-SQL vs. Other SQL Dialects
  • Formatting Standards
  • ASCII and Unicode
  • Data Types
  • Understanding NULL

Select, From, Where, and Order By Clauses
  • Getting Started
  • Case-Sensitive Collation
  • Aliasing Columns and Tables
  • Filtering Records with the Where Clause
  • Sorting Result Sets

Batches and Transactions
  • Batch
  • Transaction
  • Query Processing by SQL Server
  • Locking

Group By and Having Clauses
  • Group By
  • Having
  • Aggregates
  • Logical Processing Order

Multi-Table Queries with Joins and Sets
  • Union and Union All
  • Except and Intersect
  • Inner Joins
  • Outer Joins
  • Joining Multiple Tables

Table Expressions
  • Common Table Expressions
  • Temp Tables
  • With Results Sets

Affecting Query Performance
  • How SQL Server Accesses Data
  • Performance Tesing and Measuring
  • Indexes and Statistics
  • Execution Plans
 

Subject Matter Expert

360training instructor, Jeff Rathjen
 

Quiz Information

There are quizzes and a final exam associated with this course. To achieve successful completion, a passing score of 70% is required.

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.