Advanced SQL Program
Overview
A two-week program covering advanced Structured Query Language (SQL) features such as 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 2010
Application deadline: Dec. 11, 2009
Tuition deadline: Dec. 17, 2009
Classes begin: Jan. 4, 2010
Classes end: Jan. 13, 2010
This section meets for four class sessions (Mondays & Wednesdays) over a two-week period, on
Jan. 4, 6, 11, and 13, 2010. Weeknight classes meet from 5:45pm to 9pm and are held at DePaul University's Loop Campus at 243 S. Wabash Avenue, Chicago, IL.
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 2010: No required textbook.
Fees: Winter 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 January 5, 2010.
Application Procedure
You may apply online. Or, to apply via fax, mail, or in person, print out and complete the Application Form.
Application fee: $40.00 (non-refundable)
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, found in the IPD Quick Links.