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.
Applicants should have basic knowledge of Structured Query Language (SQL) and familiarity with a database application environment.
Dates & Location: Autumn Quarter 2014
Application deadline: Aug. 29, 2014
Tuition deadline: Sept. 4, 2014
Classes begin: Sept. 17, 2014
Classes end: Sept. 27, 2014
This session is scheduled to meet for four (4) class meetings over a two-week period, on Wednesday evenings (5:45pm-9pm) and Saturday mornings (9am-12:15pm), on Sept. 17, Sept. 20, Sept. 24, and Sept. 27, 2014.
Classes are held at DePaul University's Loop Campus at 243 S. Wabash Avenue, Chicago.
Online: An online section will be conducted in conjunction with the on-campus section. For more information on the online section, click here.
DePaul University reserves the right to cancel any program prior to that program's first class meeting.
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: There are no required textbooks for this session
Fees: Autumn Quarter 2014
Tuition fee: $775.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 the first day September 17, 2014 (for on-campus students) and by September 19, 2014 (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.