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
- 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
- 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
- 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
- Stored Procedures
- Definition and Benefits of Use
- CREATE PROCEDURE
- Syntax
- Variables and Parameters
- Control of Program Flow
- ALTER and DROP PROCEDURE
- Implementation Differences
- 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.
Contact this provider
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...