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:

Design databases using normalization techniques. (PG2)
Install one or more database management systems. (PG2)
Use SQL to select, insert, update and delete data from a database. (PG2)
Use Data Manipulation Language (DML) scripts to create and modify database (PG2)
Use SQL aggregate functions to summarize data. (PG2)
Troubleshoot and optimize queries (PG2, PG4)
Use SQL to filter, sort and format data. (PG2)