CIS 182 - Introduction to ANSI SQL

3 Credits, 3 Contact Hours
3 lecture periods 0 lab periods

Introduction to the American National Standards Institute (ANSI) Structured Query Language (SQL). Includes relational databases; SQL basics and nomenclature; simple queries, search conditions, and sorting; single table query processing and unions; simple and multi-table joins; summary queries using columns, group queries, and subqueries; and query expressions. Also includes adding, deleting, and modifying data from the database; referential integrity and constraints; creating databases; creating, removing, and modifying tables; and defining constraints.

Prerequisite(s): CIS 162
Information: CIS 162 may be waived with consent of instructor.

Course Learning Outcomes

Perform simple database queries.
Perform multi-table queries (joins).
Perform summary queries.
Sort and process the results returned by database queries.
Update databases by adding, deleting or modifying data.
Create a database and define the tables.
Set data integrity constraints.

Outline:

Relational Databases and Introduction to Structured Query Language (SQL)
SQL Basics and Nomenclature
Simple Queries
Search Conditions and Sorting
Single Table Query Processing and Unions
Simple Joins (Equi-Joins)
Multi-Table Joins
Summary Queries Using Column Functions
Grouped Queries and Search Conditions
Subqueries and Query Expressions
Adding and Deleting Data to the Database
Modifying Data in the Database
Referential Integrity and Constraints
Creating Databases
Creating and Removing Tables and Modifying Table Definitions
Defining Constraints

Effective Term:
Fall 2015