Oct 18, 2024  
2020-2021 College Catalog 
    
Catalog Navigation
  Catalog Home
  Message from the Chancellor
  Academic Calendar
  The College
  Admissions, Registration and Records
  Costs and Payments
  Financial Assistance
  Student Services and Student Life
  Educational Options
  Earning a Degree or Certificate
  Degrees and Certificates
  Programs by Department
  Course Descriptions
  Selected Policies, Governance and Faculty
  Center for Training and Development Clock Hour Modules
HELP
2020-2021 College Catalog [ARCHIVED CATALOG]

CIS 182 - Introduction to ANSI SQL

3 Credits, 3 Contact Hours (3 lec.)

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.