Loading...

Course Description

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.                                                

Course Outline

  • Creating Advanced Subqueries
  • Creating Advanced Joins
  • Creating Union Queries
  • Transaction Processing, Stored Procedures, Triggers
For more information click here.                                                                                                 

Notes

Instructor: Dr. Cecelia Allison

Prerequisites

Students should have a competency in the Introductory and Intermediate levels of SQL.

ONCE1187: Introduction to SQL
ONCE1188: Intermediate SQL                                                                                                                     

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL
Type
Online, self paced
Dates
Oct 07, 2024 to Nov 01, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

Course Details:

  • Course Name: Advanced SQL, part of the SQL Certificate | Temple University
  • Course Duration: One month
  • Format: Online, self-guided
  • Scheduled Dates: October 7 to November 1, 2024
  • Instructor: Cecelia Allison

Contact Information:

  • For more information, please contact the Office of Non-Credit and Continuing Education:
    • Email: ncce@temple.edu
    • Phone: 215-204-4866
Section Title
Advanced SQL
Type
Online, self paced
Dates
Nov 04, 2024 to Nov 29, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

Course Details:

  • Course Name: Advanced SQL, part of the SQL Certificate | Temple University
  • Course Duration: One month
  • Format: Online, self-guided
  • Scheduled Dates: November 4-29, 2024
  • Instructor: Cecelia Allison

Contact Information:

  • For more information, please contact the Office of Non-Credit and Continuing Education:
    • Email: ncce@temple.edu
    • Phone: 215-204-4866
Section Title
Advanced SQL
Type
Online, self paced
Dates
Dec 02, 2024 to Dec 27, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

Course Details:

  • Course Name: Advanced SQL, part of the SQL Certificate | Temple University
  • Course Duration: One month
  • Format: Online, self-guided
  • Scheduled Dates: December 2-27, 2024
  • Instructor: Cecelia Allison

Contact Information:

  • For more information, please contact the Office of Non-Credit and Continuing Education:
    • Email: ncce@temple.edu
    • Phone: 215-204-4866
Section Title
Advanced SQL
Type
Online, self paced
Dates
Jan 06, 2025 to Jan 31, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

Course Details:

  • Course Name: Advanced SQL 
  • Course Duration: One month
  • Format: Virtual, self-guided
  • Scheduled Dates: January 6-31, 2025
  • Instructor: Cecelia Allison

Contact Information:

  • For more information, please contact the Office of Non-Credit and Continuing Education:
    • Email: ncce@temple.edu
    • Phone: 215-204-4866
Section Title
Advanced SQL
Type
Online, self paced
Dates
Feb 03, 2025 to Feb 28, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

Course Details:

  • Course Name: Advanced SQL 
  • Course Duration: One month
  • Format: Virtual, self-guided
  • Scheduled Dates: February 3-28, 2025
  • Instructor: Cecelia Allison

Contact Information:

  • For more information, please contact the Office of Non-Credit and Continuing Education:
    • Email: ncce@temple.edu
    • Phone: 215-204-4866