Next Level SQL Programming | Intermediate +

Trivera Technologies LLC
Training overview
Professional Course
2 days

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
Want to find out more?

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
    • 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

Costs

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

About Trivera Technologies LLC

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

Contact this 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.

Country *

Contact info

Trivera Technologies LLC

7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

 Show phone number
www.triveratech.com

Learn more!

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.

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available