Course Overview
TOPA 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| 12/12/24 - TTV - Virtual-Instructor Led - Virtual-Instructor Led | (click to enroll)
 |
What You'll Learn
TOPThis “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- 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
