Dec 01, 2021  
2021-2022 College Catalog 
    
2021-2022 College Catalog
Add to Portfolio (opens a new window)

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
  1. Perform simple database queries.
  2. Perform multi-table queries (joins).
  3. Perform summary queries.
  4. Sort and process the results returned by database queries.
  5. Update databases by adding, deleting or modifying data.
  6. Create a database and define the tables.
  7. Set data integrity constraints.

Outline:
  1. Relational Databases and Introduction to Structured Query Language (SQL)
  2. SQL Basics and Nomenclature
  3. Simple Queries
  4. Search Conditions and Sorting
  5. Single Table Query Processing and Unions
  6. Simple Joins (Equi-Joins)
  7. Multi-Table Joins
  8. Summary Queries Using Column Functions
  9. Grouped Queries and Search Conditions
  10. Subqueries and Query Expressions
  11. Adding and Deleting Data to the Database
  12. Modifying Data in the Database
  13. Referential Integrity and Constraints
  14. Creating Databases
  15. Creating and Removing Tables and Modifying Table Definitions
  16. Defining Constraints


Effective Term:
Fall 2015



Add to Portfolio (opens a new window)