DACC | Course Descriptions & Syllabi

Course Descriptions & Syllabi

Table of Contents | Areas of Study | Information Systems | INFO285 syllabus

COURSE NUMBER:		INFO285
COURSE TITLE:		Database Concepts: SQL
DIVISION:		Technology
IAI CODE(S):
SEMESTER CREDIT HOURS:		3.0
DELIVERY MODE:

COURSE DESCRIPTION:
Database models, using a database system, commercial databases, database processing and procedures, and integration of database systems will be discussed. File processing techniques, administration of database structures, backup and recovery, queries, and database analysis and design will also be covered. Labs, working with SQL, will be assigned to emphasize these topics.

PREREQUISITES:
INFO224 or INFO244

NOTES:

COURSE OBJECTIVES / GOALS:

Be able to list the advantages and disadvantages of Database processing.
Be able to define and explain a Database environment.
Understand common commercial Databases such as: MS SQL Server and Oracle
Understand considerations which affect computer performance.
Be able to list commonly used design tools for end users.
Know how to succeed with Data modeling.
Know the productivity and flexibility aspects of Database.
Understand the improvements in productivity gained when using a Fourth Generation Language compared to traditional programming languages.

TOPICAL OUTLINE:

Introduction to Relational Databases and SQL
SQL Server Management Studio
Designing a Database
Retrieving Data with Queries
Summary Queries
Sub-queries
Insert, Update, Delete Data
Create and Maintain Databases and Tables with SQL
Data Types and Functions
Views
Scripts
Stored Procedures, Functions, and Triggers

TEXTBOOK / SPECIAL MATERIALS:
See bookstore website for current book at http://www.dacc.bkstr.com
EVALUATION:
Evaluation of the student will be based on the following: Final grades are determined through a weighted average of the final examination, quizzes, lab assignments, homework assignments, and class attendance.
BIBLIOGRAPHY:

REVISION:
Fall 2012

RECORD UPDATED:
2012-12-18 10:46:00