Standard

Posted: 09/10/07

R State Standard

£ Institutionally Developed

College: n/a

CIS 2161 – Structured Query Language (SQL)

 

Course Description:

 

A course designed to allow the student to solve common database retrieval problems through the use of the SQL Language that supports common databases such as SQL/Server, Oracle, DB2, ACCESS and other database systems.  Topics include: Understanding database vocabulary, understanding object and relational database concepts, understanding and implementing SQL statements that retrieve, insert, update and delete data in a database, ability to implement aggregate and group SQL functions, create, edit and drop database tables, query data from multiple databases, design queries and sub queries, develop an understanding of union, and join operations, understand how to execute and implement database triggers.

 

Competency Areas:

Hours:

 

 

 

Database Vocabulary

Class

4

Object Oriented and Relational Database Design

D. Lab

6

Designing & Developing SQL Programs

P. Lab/O.B.I.

0

Data Retrieval using SQL

Credit

7

Database Maintenance using SQL – Insert, Update, Delete

 

 

Designing Queries and Sub queries

 

 

Using SQL Joins, unions, intersections

 

 

Performance tuning queries

 

 

Using SQL triggers

 

 

Debugging SQL programs

 

 

 

Prerequisite:  

SCT100, CIS105, and an operating systems course

Corequisite: 

 

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D. Lab

P. Lab/

O.B.I.

 DATABASE VOCABULARY

 4

6 

0

 

Understand and use vocabulary of databases, including tables, columns, rows, data types, keys, relationships, queries, record sets

 

 

 

OBJECT ORIENTED AND RELATIONAL DATABASE DESIGN

4

6

0

 

Understand and use database design fundamentals and solutions for fitting new data into existing data structures, and creating new database tables.

 

 

 

DESIGNING & DEVELOPING SQL PROGRAMS

4

6

0

 

Understand and use concepts from CIS105 to develop logical, effective SQL statements.

 

 

 

DATA RETRIEVAL USING SQL

4

6

0

 

Understand and be able to use SQL Select statements.

 

 

 

DATABASE MAINTENANCE USING SQL – INSERT, UPDATE, DELETE

4

6

0

 

Master and use SQL to add, change, and remove records and fields from a database.

 

 

 

 DESIGNING QUERIES AND SUB QUERIES

 4

6

0

 

 Understand and use SQL Group by and Having clauses, composite functions and WHERE expressions to report on database data.

 

 

 

USING SQL JOINS, UNIONS, INTERSECTIONS

4

6

0

 

Be able to perform multiple table queries using database union, intersection, projection and join expressions

 

 

 

PERFORMANCE TUNING QUERIES

4

6

0

 

 Understand how to fine tune SQL queries to maximize response time and how to develop maximum performance queries

 

 

 

USING SQL TRIGGERS

4

6

0

 

Understand how to create and use SQL trigger functions

 

 

 

DEBUGGING SQL PROGRAMS

4

6

0

 

Be able to troubleshoot SQL program problems

 

 

 

 

Suggested Resources

 

Books:

 

Oracle9i: SQL, with an Introduction to PL/SQL, ISBN: 0-619-6475-7, Morris-Murphy, Course Technology

A Guide To SQL, ISBN: 0-619-21674-3, Pratt, Course Technology

SQL for SQL Server, ISBN: 0131132997, Bordoloi, Bock, Bock, Prentice Hall

Bundle: Guide to SQL/Concepts of Database Management, ISBN: 1-4188-7877-4, Pratt, Course Technology

Custom Edition Concepts of Database Management, ISBN: 1-4188-9339-0, Pratt/Adams, Course Technology