Nov 02, 2024  
2021-2022 Undergraduate Catalog 
    
2021-2022 Undergraduate Catalog [ ARCHIVED CATALOG VERSION ]

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) Two Hours Lecture. Two hours laboratory. 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)