Advanced SQL Programming (TTSQL005)

Overview

This Advanced SQL Programming course is designed to strengthen your expertise in managing and analyzing relational databases. You will begin with a focus on relational database concepts, including the Entity-Relationship Model and key modeling conventions. Understanding these fundamentals will prepare you for applying more complex techniques in real-world scenarios, using practical examples from the tables provided throughout the course.

From there, the course will explore essential SQL functions for grouping and aggregating data, such as the MIN and MAX functions. You’ll learn how to use the GROUP BY and HAVING clauses effectively, work with nested functions, and handle null values in your queries. The course also covers various join types, allowing you to retrieve data from multiple tables, manage ambiguous column names, and create efficient queries with inner, outer, and cross joins.

In the final sections, the focus shifts to more advanced SQL topics like subqueries and set operators, as well as data manipulation and table management techniques. You’ll gain hands-on experience executing subqueries, using set operators like UNION and MINUS, and managing data through DML and DDL statements. By the end, you will be fully prepared to implement advanced SQL solutions, manage database objects, and perform complex data manipulation tasks with confidence.

Objectives

• Understand the relational database model and apply entity-relationship modeling conventions
• Utilize group functions to aggregate data, handle null values, and nest functions
• Implement advanced queries with joins, including natural, outer, and cross joins
• Execute subqueries, including single-row, multiple-row, and multiple-column subqueries
• Use set operators like UNION, INTERSECT, and MINUS to combine queries
• Perform DML operations like inserting, updating, and deleting rows, with real-world applications
• Understand DDL statements for creating and managing database schema objects
• Implement and enforce constraints such as NOT NULL, PRIMARY KEY, and FOREIGN KEY

Audience

This intermediate-to-advanced course is ideal for SQL developers, database professionals, data analysts, and IT professionals who work with databases and seek to advance their skills in complex data manipulation, analysis, and management.

Pre-Reqs

To ensure a smooth learning experience and maximize the benefits of attending this course, you should have the following prerequisite skills:

• Basic SQL Programming experience is required. This course is not intended for beginners.

Take Before: Students should have incoming practical skills aligned with those in the course(s) below, or should have attended the following course(s) as a pre-requisite:

Introduction to SQL Programming Basics

Introduction to Writing SQL Queries