CIS220 — Structured Query Language and Database Administration
CIS 220 - Structured Query Language and Database Administration 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. 0 or CIS 218 min 2.0 Fees CF Quarters Typically 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 Lecture 55 Lab 0 Field Studies 0 Clinical 0 Independent Studies 0 Total 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
Prerequisites: CIS217, CIS218