Sep 18, 2019  
2017-2018 Catalog 
    
2017-2018 Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

CIS 220 - Structured Query Language and Database Administration

5 Credits
Learn to use SQL, the industry-standard language for creating and maintaining relational databases. Students will create and process a database. Topics include table and index creation, manipulating data, table joins, nested queries, transactions, triggers and an introduction to stored procedures. In addition, students will learn database administration topics including security and permissions.

Pre-requisite(s) CIS 217 min 2.0 or CIS 218 min 2.0
Fees CF

Designed to Serve Students enrolled in Web/Database Developer; students enrolled in the Database Certificate program; students enrolled in the Networking Specialist program; professionals wishing to add database concepts to their technical skillset.
Active Date 2012-02-15

Grading System Decimal Grade
Variable Credit Yes Range 1-5
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. Structured Query Language (SQL) III. DDL: CREATE, ALTER, DROP IV. DML: SELECT, INSERT, UPDATE V. Indexes VI. Table joins VII. Nested queries and subqueries VIII. Transactions IX. Triggers X. Introduction to Stored procedures XI. Database security and encryption XII. Permissions and authentication XIII. Backing up and restoring a database XIV. Query optimization

Student Learning Outcomes
Create, alter and drop tables

Insert, update, and delete rows

Write SELECT queries

Write transactions

Create indexes

Write join queries and nested queries

Understand the difference between triggers and stored procedures

Implement triggers

Understand database security considerations and encrypt secure data

Create database users and administer permissions



[Add to Portfolio]