Advanced SQL Programming (TTSQL005)

Course Overview

SQL, or Structured Query Language, is the essential language that allows you to communicate with and manipulate databases. Advanced SQL Programming not only adds flair to basic database management but opens up new avenues for data retrieval, analysis, and optimization.  

Geared for experienced SQL users, Advanced SQL Programming is a two-day course designed to transform your SQL skills, leading to enhanced data retrieval, analysis, and optimization. You’ll explore techniques that enable them to solve complex challenges and contribute to organizational efficiency and innovation.

This course includes interactive discussions, group activities, and a balanced approach of lectures and hands-on labs. Expect to build, design, and troubleshoot complex SQL queries, create robust data manipulation techniques, and explore the intricate world of triggers, all under the guidance of a seasoned industry expert. You’ll apply these skills in a practical context, simulating real-world projects and utilizing innovative tools and techniques. You’ll exit this course able to design and execute intricate SQL queries, manage data with unprecedented accuracy, and implement unique functions and procedures, ready to apply these skills on the job.

NOTE: This course uses Oracle SQL Developer in the labs, however the tooling is just the means used to teach SQL. This is not a SQL Developer focused course, and prior SQL Developer knowledge is not required.  The course focuses on skills and concepts that can be applied to other databases and platforms. If you need a specific alternate database, please inquire for details and options.

Learning Objectives

Working in a hands-on learning environment led by our expert practitioner, attendees will explore:

• Advanced Query Techniques: Dive into Inner and Outer Joins, Subqueries, and Aggregate Functions. Mastering these will allow for precise data extraction and comprehensive analysis, forming a solid foundation for developing complex SQL queries.
• Manipulating Table Data Using SQL's DML: Learn techniques like Inserting, Updating, Deleting Records, and Transactions. These skills enable control over data integrity and efficient data manipulation, essential for maintaining high-quality database operations.
• User-Defined Functions: Create and manage Scalar vs. Table Functions. By understanding these, you can craft customized solutions, leading to flexible and dynamic data handling.
• Stored Procedures: Explore Variables, Parameters, and Program Flow. With these, you can streamline repetitive tasks, promoting efficient database management.
• Triggers: Grasp the creation and management of Triggers. Triggers automate tasks within the database, enhancing responsiveness and making systems more robust.