Advanced SQL

Advanced SQL Program 

Advanced SQL Program Details

About

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.

Students will be instructed to download an open-source database. Students must have full administrator rights to their personal computers in order to successfully install and use the database.

For a complete program description, download the program's brochure.

Dates & Location

Spring Quarter 2020:

  • Application Deadline:May 1, 2020
  • Tuition Deadline:
  • May 8, 2020
  • Classes Begin:May 20, 2020
  • Classes End:May 30, 2020

On-campus section: Classes meet on four days over a two-week period, on Wednesday evenings (5:45pm-9:00pm) and Saturday mornings (9am-12:15pm): May 20, May 23, May 27 and May 30, 2020. Classes are held at DePaul's Loop Campus at 243 S. Wabash Avenue, Chicago. UPDATE: This class will transition to strictly online mode for spring quarter.

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.

Fees

Spring Quarter 2020

Tuition

  • $1,000.00

Full payment of tuition must be received before the start of the program. Students who elect to pay tuition using a credit or debit card will be assessed a non-refundable 2.75% convenience fee.

Refund/Cancellation Policy: DePaul reserves the right to cancel any program before that program’s first scheduled meeting, in which case tuition fees (but not convenience fees) will be refunded. The university's refund policy allows a return of 100% of tuition if the student drops the Winter Quarter 2020's Advanced SQL Program by Feb. 5, 2020 (for on-campus students) and by Feb. 7, 2020 (for online students)-convenience fees will not be refunded. The drop with refund deadline for Spring Quarter 2020 is May 20, 2020 (for on-campus students) and May 22, 2020 (for online students)--convenience fees will not be refunded.

Please note tuition fees incurred for the Advanced SQL Program are not eligible for deferment using the  Employer Tuition Deferment Plan or for a payment plan using the Single Term Payment Plan.

Notice for Current DePaul Students

  • Undergraduates: Please be aware that the tuition fee for this program is not included in the university’s full-time term package pricing.

Application Fee

  • $40.00non-refundable

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
Room 301
Chicago, IL 60604

Textbooks

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.

Other Fees

CTA U-Pass Fee: Beginning Autumn Quarter 2016, any IPD certificate program student who enrolls in a full-time course load (8 graduate or 12 undergraduate credit hours) and where at least one course is taught at an on-campus location will be automatically enrolled in the University’s CTA U-Pass program. The CTA U-Pass program provides unlimited rides on CTA transport and it requires that all eligible students participate in the program. The cost of the CTA U-Pass is $105.00 per quarter. Students who meet the eligibility criteria will have this fee added to their student accounts. Students are responsible for this fee regardless of benefit use or card pick-up. Students who are taking courses exclusively online do not qualify for this program. Further information about the U-Pass program is found at upass.depaul.edu.

Admissions

Admission Requirements

Applicants should have basic knowledge of Structured Query Language (SQL) and familiarity with a database application environment.

Course Credit

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.

You do not have to be an existing DePaul student to take this certificate program. Registration is restricted to individuals who apply for admission to the program and receive an acceptance letter. IPD staff will register applicants upon receipt of payment and registration form.

Regular DePaul students cannot register themselves via the university's registration system. If interested in enrollment, regular DePaul students should begin by submitting an application for admission. Students must meet the program's admission criteria.