Apr 21, 2024  
2022-2023 Undergraduate Catalog 
2022-2023 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Personal Bookmarks (opens a new window)

CIS 148 - Intro. to SQL & Database Design

Number of Credits: 3
Introduction to SQL and Database Design gives the student experience in designing and creating databases using several database management systems(DBMS). Students will use relational database theory to design databases and will learn structured query language (SQL)to select, insert, update and delete data. (Fall & Spring Only) Two hours lecture each week. Two hours laboratory each week. Three Credits. Three billable hours.

Pre-/Co-requisite(s): Any general education MATH course.

Course Objectives: Upon successful completion of this course, students will be able to:
  1. Design databases using normalization techniques. (PG2)
  2. Install one or more database management systems. (PG2)
  3. Use SQL to select, insert, update and delete data from a database. (PG2)
  4. Use Data Manipulation Language (DML) scripts to create and modify database (PG2)
  5. Use SQL aggregate functions to summarize data. (PG2)
  6. Troubleshoot and optimize queries (PG2, PG4)
  7. Use SQL to filter, sort and format data. (PG2)

Add to Personal Bookmarks (opens a new window)