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
FeesCF

Quarters Typically Offered
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 Basis Decimal Grade
Variable Credit Yes Range 1-5
Class Limit 30
Contact Hours: Lecture 55 Lab 0 Field Studies 0 Clinical 0 Independent Studies 0
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
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