Revised 08/2021

ITD 132 - Structured Query Language (3 CR.)

Course Description

Incorporates a working introduction to commands, functions and operators used in SQL for extracting data from standard databases. Lecture 3 hours per week.

General Course Purpose

This course provides a comprehensive foundation sufficient for a student to write ANSI/ISO Structured Query Language (SQL) statements to access a relational database.

Course Prerequisites/Corequisites

Introductory knowledge of database application software

Course Objectives

Upon completing the course, the student will be able to:

• Write generic ANSI/ISO standard SQL statements
• Describe what a query is and how it is used to access data in a database
• Understand the processing of data with row and aggregate functions
• Understand the definition and use of primary and foreign keys
• Execute the commands to create table and add constraints
• Understand the concept and the advantages of database indexes
• Understand the role of users and roles/groups in database security
• Execute an SQL script

Major Topics to Be Included

• Creating tables in a database
• Inserting, deleting and updating data in tables
• Queries, sub-queries, and joins
• Row functions, Group functions
• Indexes and views
• Database security
• Writing SQL scripts

Student Learning Outcomes

Creating tables in a database

• Explain database model with necessary primary and foreign keys
• Implement SQL CREATE statements
• Describe constraint types and when they should be used
• Implement constraints when necessary

Inserting, deleting and updating data in tables

• Implement SQL INSERT statements
• Implement SQL UPDATE and DELETE statements 

Queries, sub-queries, and joins

• Implement SQL SELECT statement with simple and compound selection criteria
• Implement SQL SELECT statements that access multiple tables using joins
• Implement SQL SELECT sub query statements
• Implement SQL SELECT statements using GROUP BY and HAVING clauses
• Explain Boolean choices in query construction

Functions

• Implement SQL SELECT statements using string, date, and time functions
• Implement SQL SELECT using summary aggregate functions

Indexes and views

• Create database indexes
• Explain what a database view is and when it should be used
• Create a database view

Database security

• Create new users and roles/groups
• Grant and revoke privileges for users and groups on database objects
• Drop user and roles/groups

Writing SQL scripts

• Write and save an SQL script using any of the SQL commands
• Execute an SQL script
• (optional) Introduction to Cube queries

Required Time Allocation

Topics do not need to be followed sequentially. Many topics are taught best as an integrated whole, often revisiting the topic several times, each time at a higher level. The final exam time is not included in the time table. The last category,  Other Optional Content , leaves time for an instructor to tailor the course to special needs or resources.