Mar 29, 2024  
2023-2024 Undergraduate Catalog 
    
2023-2024 Undergraduate 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 term) 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)