Home About Courses Schedule Services Webinars Contact Search

Advanced SQL for SQL Server

SEE SCHEDULE

Duration: 3 Days

Method: Instructor Led, Hands-on Workshops

Price: $1800.00

Course Code: SS1010



Audience

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in SQL Server.

Description

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! We begin with an in-depth discussion of joins and move quickly to more complex operations involving set processing, grouping, subqueries, table expressions, recursion and more. Each topic is reinforced with hands-on workshops. Students will learn to write and run SQL in SQL Server Management Studio.

Objectives

Upon successful completion of this course, the student will be able to:

  • Work with complex SQL Statements
  • Solve business problems with SQL using several different techniques

Prerequisites

SS1010 or equivalent experience.

Topics

  1. Complex Joins
    • Inner Joins
    • LEFT and RIGHT Outer Joins
    • Full Outer Joins
    • “Anti” Joins
    • Self Joins
  2. Multiple Query Blocks
    • Non-correlated Subqueries
    • Correlated Subqueries
    • Scalar Fullselects
  3. Table Expressions and Views
    • Views
    • Nested Table Expressions
    • Common Table Expressions
  4. Set Operations
    • UNION
    • INTERSECT
    • EXCEPT
  5. Advanced Grouping
    • GROUP BY Clause
    • HAVING Clause
    • ROLLUP
    • CUBE
  6. Solving Complex Problems with SQL
    • Relational Difference
    • Quota Queries
    • Relational Division
    • Recursion
    • Complex CASE Statements
    • Table Pivoting
  7. Data Modification and Managing Transactions
    • Data Modification Statements
    • COMMIT, ROLLBACK and SAVEPOINT
    • When to COMMIT?
    • Checkpoint and Restart Considerations
    • Constraint Violations
  8. Temporary Data
    • Global Temporary Tables
    • Indexed Views
  9. Overview of Transact-SQL
    • Scripts
    • Stored Procedures
    • User-defined Functions