A company’s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases – with little room for error. When databases aren’t built or maintained correctly, it’s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL is a two-day hands-on training course that explores how to identify and use advanced querying techniques to manipulate and index tables.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to:
Advanced Query Techniques
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
User-Defined Functions
Stored Procedures
Triggers

1
  • Advanced Query Techniques

  • Inner Joins 

    Outer Joins (Left, Right, Full) 

    Performing Self-Joins 

    Subqueries 

    Simple 

    Correlated 

    Using the EXISTS Operator 

    Tips for Developing Complex SQL Queries 

    Using Aggregate Functions 

    AVG, COUNT

    SUM

    MIN

    MAX

    Performing Set Operations 

    UNION

    INTERSECT

    EXCEPT/MINUS

    Aggregating Results Using GROUP BY

    Restricting Groups with the HAVING Clause 

    Creating Temporary Tables 


2
  • Manipulating Table Data Using SQL's Data Manipulation Language (DML)

  • Inserting Data into Tables 

    Updating Existing Data 

    Deleting Records 

    Truncating Tables 

    Implementing Data Integrity with Transactions 

    Beginning Explicit Transactions 

    Committing Transactions 

    Rolling Back Transactions 


3
  • User-Defined Functions

  • Definition and Benefits of Use 

    CREATE FUNCTION

    Syntax 

    RETURN Clause and the RETURNS Statement 

    Scalar vs. Table Functions 

    Comparison with Stored Procedures 

    Returning Scalar Values and Tables ALTER and DROP FUNCTION


4
  • Stored Procedures

  • Definition and Benefits of Use 

    CREATE PROCEDURE

    Syntax 

    Variables and Parameters 

    Control of Program Flow 

    ALTER and DROP PROCEDURE

    Implementation Differences 


5
  • Triggers

  • Definition and Benefits of Use 

    Alternatives (e.g., Constraints) 

    CREATE TRIGGER

    Syntax 

    Trigger Types 

    "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables 

    Event Handling and Trigger Execution 

    ALTER and DROP TRIGGER


Audience

This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience.

Language

English

Prerequisites

Attendees should have incoming skills aligned with the topics in the course(s) below or should attended them as a prerequisite: TTSQL002 Introduction to SQL Programming Basics– 3 days TTSQL003 Introduction to Writing SQL Queries – 3 days

$1,695

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
02
Nov
Thursday
10:00 AM ET -
6:00 PM ET
Filling Fast
Available
Schedule select
14
Dec
Thursday
10:00 AM ET -
6:00 PM ET
Filling Fast
Available
Loading...