CIS-111: SQL for Database Development

School
Business, Entrepreneurship, and Professional Development
Division
Computer Technology
Department
Computer Information Systems
Academic Level
Undergraduate
Course Subject
Computer Information Systems
Course Number
111
Course Title
SQL for Database Development
Credit Hours
3.00
Instructor Contact Hours Per Semester
62.00 (for 15-week classes)
Student Contact Hours Per Semester
62.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
CIS-122 or CIS-125 or CIS-130 or CIS-170 or Instructor Permission
Catalog Course Description

An intermediate-level course familiarizing the student with the SQL language used to retrieve and modify tables and data within a SQL Server database management system. Covers outer joins, summary queries, and subqueries. Also discusses using normalization techniques to design and create database structures, views, scripts, stored procedures, scalar functions, and triggers.

Goals, Topics, and Objectives

Core Course Topics
  1. An introduction to relational databases and SQL
  2. How to work with SQL server databases
  3. How to retrieve data from a single table
  4. How to retrieve data from two or more tables
  5. How to code summary queries
  6. How to code subqueries
  7. How to modify data within a table
  8. SQL server data types
  9. How to design a database
  10. How to create and implement a database
  11. How to code scripts, views, stored procedures, tiggers, and scalar functions
Core Course Learning Objectives (Separated)
  1. Compose SQL statements that retrieve data from one table structure using the SELECT-FROM-WHERE-ORDER BY syntax.
  2. Generate SQL statements that retrieve data from more than one table coding the correct join relationship within the FROM clause.
  3. Write SQL statements that incorporate a subquery within the SELECT list, FROM clause, or WHERE clause.
  4. Construct SQL statements using the UPDATE, INSERT and DELETE statement that modify data within a table structure.
  5. Organize, plan, and implement a database structure using normalizing techniques based on example documents used within a business entity.
  6. Code SQL views, stored procedures, triggers, and scalar functions.

Assessment and Requirements

Assessment of Academic Achievement

Assessment of academic achievement may include (but is not limited to) exams, quizzes, homework, and laboratory assignments.

Effective Term
Fall 2020