Jun 07, 2020
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.
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
III.ER (entity-relationship) modeling
V.Relationships and cardinality
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 (opens a new window)