A two-week program providing an efficient, but in-depth introduction to the fundamental syntax of Structured Query Language (SQL) for querying, storage, and manipulation of data from a variety of databases. The program is ideally suited for professionals who work in data-focused environments who need the skills for basic extraction and analysis of data using SQL. Students will learn how to query, store, and manipulate data as well as produce basic SQL reports. The program is also beneficial as a foundation for further study in database application development.
The program will cover: an overview of Structured Query Language; table creation and table manipulation (insertions, deletions, etc.); writing queries with the SELECT statement and different operators; commands for removing duplicates and sorting data; various types of JOIN statements; datatypes; string, number, and date functions; formatting and the CASE statement; aggregate functions (SUM, COUNT, etc.) and GROUPBY command; subquery examples; how to manage nulls; what are different types of database objects; creating a view; the ALTER command; simple examples of procedures, functions, and triggers; an example of a real-world database application; and creating simple SQL reports.
Classroom lectures and demonstrations will be complemented by readings, short labs, and assignments. 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.
Dates & Location
Winter Quarter 2019:
Application Deadline:Dec. 11, 2018
Tuition Deadline:Dec. 18, 2018
Classes Begin:Jan. 9, 2019
Classes End:Jan. 19, 2019
Classes meet on on four days over a two-week period, on Wednesday evenings (5:45pm-9:00pm) and Saturday mornings (9:00am-12:15pm), on Jan. 9, Jan, 12, Jan. 16 and Jan. 19, 2019.
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
Winter Quarter 2019
Regular DePaul University students are charged the above rates based on their degree program. The tuition fee for this program is not included in the university's tuition package for full-time undergraduate students.
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 Introduction to SQL Program by January 9, 2019 for on-campus students and by January 11, 2019 for online students (convenience fees will not be refunded).
Please note tuition fees incurred for the Introduction to SQL Program are not eligible for deferment using the Employer Tuition Deferment Plan or for a payment plan using the In-Term Payment Plan.
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.
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
Applicants should have basic experience using a personal computer running Windows. No prior knowledge of Structured Query Language (SQL) is assumed.
The Introduction to 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 343;
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.