Professional Course

Next Level SQL Programming | Intermediate +

2 days
2 days
This provider usually responds within 48 hours 👍

Course description

Next Level SQL Programming | Intermediate +

Next Level SQL 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

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Who should attend?

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.

Training content

  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
    • 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
    • Syntax
    • RETURN Clause and the RETURNS Statement
    • Scalar vs. Table Functions
    • Comparison with Stored Procedures
    • Returning Scalar Values and Tables
  4. Stored Procedures
    • Definition and Benefits of Use
    • Syntax
    • Variables and Parameters
    • Control of Program Flow
    • Implementation Differences
  5. Triggers
    • Definition and Benefits of Use
    • Alternatives (e.g., Constraints)
    • Syntax
    • Trigger Types
    • "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables
    • Event Handling and Trigger Execution


  • Price: 1,495.00
  • Discounted Price: 971.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

Contact this provider

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Trivera Technologies LLC
7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...

Read more and show all training delivered by this supplier