|
Sep 12, 2024
|
|
|
|
CIS 220 - Structured Query Language and Database Administration5 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
Add to Portfolio (opens a new window)
|
|