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.
Dates & Location
Winter Quarter 2016
The winter session's dates will be published soon.
Application Deadline:Dec. 18, 2015
Tuition Deadline:Jan. 4, 2016
Classes Begin:Jan. 13, 2016
Classes End:Jan. 23, 2016
Classes meet on four days over a two-week period, on Wednesday evenings (5:45pm) and Saturday mornings (9:00am-12:15pm), on: Jan. 13, Jan. 16, Jan. 20, and Jan. 23, 2016.
On-campus section: Classes are held at DePaul University's Loop Campus at 243 S. Wabash Avenue, Chicago.
Online section: An online section will be conducted in conjunction with the on-campus section.
See more information on the online section
DePaul University reserves the right to cancel any program prior to that program's first class meeting.
Winter Quarter 2016
Regular DePaul University students are charged the above rates based on their degree program.
Full payment of tuition must be received by the Institute for Professional Development office before the start of the program. The tuition fee for this program is not included in the university's tuition package for full-time undergraduate students. 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 13, 2016 (for on-campus students) and by January 15, 2016 (for online students).
Each program requires a $40.00 (non-refundable) application fee that can be paid online (via credit card) during the online application process. If you need to pay this fee by check or money order, please make the check or money order payable to DePaul University and send it to:
DePaul University Institute for Professional Development
243 S. Wabash Avenue
Chicago, IL 60604
Textbooks are a separate purchase to be made by students.
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.
There are no required textbooks for this session.
Applicants should have basic knowledge of Structured Query Language (SQL) and familiarity with a database application environment.
The Advanced SQL Program is an accredited course of DePaul University, which follows the quarter system (as opposed to the semester system). Credit hours are awarded to those who successfully complete the program's academic requirements. Academic requirements may include reading and homework assignments, written assignments, labs, projects, and other assignments. No midterm or final exams are conducted.
Course #: IPD 370; 1.5 undergraduate credit hours
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.
Application & Registration Procedure
All interested parties should 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. Upon admission, the Institute office will contact the prospective student with information and instructions about the registration process.
Registration is restricted to admitted students. IPD staff will register students upon receipt of payment and registration form. Regular DePaul students cannot register themselves via the university's registration system.