Advanced SQL Program

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: Autumn Quarter 2010 This class is closed.
Application deadline: Aug. 20, 2010
Tuition deadline: Aug. 27, 2010
Classes begin: Sept. 9, 2010
Classes end: Sept. 18, 2010

This session is scheduled to meet four times over a two-week period, on Thursdays, Sept. 9 and 16 and Saturdays, Sept. 11 and 18. Thursday class times are 5:45pm to 9:15pm; Saturday class times are 9:00am to 12:15pm. Classes are held at DePaul University'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.

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 Autumn Quarter 2010:  no required textbook
Fees: Autumn Quarter 2010 
Tuition fee: $600.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 September 10, 2010.

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.