Advanced SQL Program
Overview
A two-week program covering advanced features of Structured Query Language (SQL), a standard query language for accessing information from relational databases. Most of the SQL syntax covered in the program will be standard SQL and students will be directed to download a freely available database for practice. Program topics include correlated and non-correlated sub-queries, complex sub-queries, set operations, enhancements to the GROUP BY clauses, hierarchical retrievals, useful built-in functions, query re-write, and performance considerations. The program is geared towards application developers, systems analysts, database administrators, and technical support professionals who have basic SQL knowledge. Hands-on practices to reinforce the classroom material will be included.
Admission requirements
Applicants should have basic knowledge of Structured Query Language (SQL) and familiarity with a database application environment.
Dates & Location: Winter Quarter 2012
The winter session is now closed. Dates for the spring session will be published in early February.
Classes are held at DePaul's Loop Campus at 243 S. Wabash Avenue, Chicago, IL.
Online: Students may elect to register for an online section of the course. For more information about the online section, click here.
DePaul University reserves the right to cancel any program prior to that program's first class meeting.
Course Credit
The Advanced SQL Program is an accredited course of DePaul University, which follows the quarter system (as opposed to the semester system).
Course #: IPD 370
Credit hours: 1.5 undergraduate
The credit hour is awarded to those who successfully complete the program's academic requirements. Course requirements include programming and design assignments. No quizzes or exams are given.
Course credit and final grade information will be available through the Institute for Professional office upon the program's completion; it will be reflected on the university's system at the end of the university's regular academic quarter.
Textbooks
Reading materials for certificate programs consist of textbooks and supplementary handouts. Textbook readings are considered preparatory in nature and are typically assigned prior to lectures; supplementary handouts are frequently distributed in class to provide additional information.
Textbooks for Winter Quarter 2012: To be determined
Textbooks for Autumn Quarter 2011: There are no required textbooks for this session
Fees: Winter Quarter 2012
Tuition fee: $725.00
Application fee: $40.00 (non-refundable)
Full payment of tuition must be received by the Institute for Professional Development office before the start of the program. The university's refund policy allows a return of 100% of tuition (minus a separate $25 registration fee) if the student drops the Advanced SQL Program by January 21, 2012 (for on-campus students) and by January 24, 2012 (for online students).
Fees are payable by check made out to DePaul University, or by credit card. For credit card payment, print out and complete the 
Payment by Credit Card Form.
Application & Registration Procedure
The first step is to apply for admission using the Institute for Professional Development's online application; or, to apply via fax, mail, or in person, print out and complete the Application Form.