Oct 17, 2019  
2017-2018 Catalog 
    
2017-2018 Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

CIS 218 - Database Concepts

5 Credits
Introduction to the relational model and database design principles. Design and create a database and application using a relational database system. Learn Structured Query Language, including inserting, updating, deleting, and selecting data, and table joins.

Fees CF

Designed to Serve Students enrolled in Web/Database Developer; students enrolled in the Database Certificate program; professionals wishing to add database concepts and design to their technical skillset.
Active Date 2015-09-25

Grading System Decimal Grade
Class Limit 30
Contact Hours: Lecture 55 Lab 0 Worksite 0 Clinical 0 Other 0
Total Contact Hours 55
Degree Distributions:
Course Outline
I.Database terminology
II.Database design
III.ER (entity-relationship) modeling
IV.Normalization
V.Relationships and cardinality
VI.Forms
VII.Reports
VIII.Queries
IX.SQL (Structured Query Language): SELECT, INSERT, UPDATE, DELETE, joins

Student Learning Outcomes
Design a database and create an ER diagram.

Create database tables and the relationships between them.

Learn to gather and analyze business requirements.

Write basic SQL SELECT queries to retrieve, sort, and filter data. Use relational and logical operators.

Add, edit and delete table data.

Define important database terms and concepts.

Create and implement an E-R model.

Understand and enforce referential integrity.



[Add to Portfolio]