logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Advanced SQL Programming

SS Course: 9000545

Course Overview

TOP

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. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.

Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will explore:
•    Advanced Query Techniques
•    Manipulating Table Data Using SQL's Data Manipulation Language (DML)
•    User-Defined Functions
•    Stored Procedures
•    Triggers

                                                                  

Scheduled Classes

TOP
03/16/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
04/27/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
06/08/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
07/27/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
09/14/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
11/02/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
12/14/23 - TTV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)

What You'll Learn

TOP

This “skills-centric” course is about 50% hands-on lab and 50% lecture, designed to train attendees in next level SQL and database skills, coupling the most current, effective techniques with the soundest industry practices. Throughout the course students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review.

Our engaging instructors and mentors are highly experienced practitioners who bring years of current "on-the-job" experience into every classroom.  Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will explore:

  • Advanced Query Techniques
  • Manipulating Table Data Using SQL's Data Manipulation Language (DML)
  • User-Defined Functions
  • Stored Procedures
  • Triggers

Outline

TOP
Viewing outline for:
  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
  1. 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

  1. 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
  1. Stored Procedures
  • Definition and Benefits of Use
  • CREATE PROCEDURE

Syntax
Variables and Parameters

  • Control of Program Flow
  • ALTER and DROP PROCEDURE
  • Implementation Differences
  1. 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

Prerequisites

TOP
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.

    Who Should Attend

    TOP

    Next Step Courses

    TOP