|
Description:
Covers topics in Structure Query Language (SQL) including statements such as
select, update, insert, delete, create. Emphasis on the ability to extract, update
and maintain databases using SQL.
Course Objectives:
Upon successful completion of this course, students will be able to:
- Explain what SQL is. [REASON]
- Identify the major data types. [REASON]
- Describe why SQL is such a powerful tool. [COMMUNICATE]
- Create relational databases using SQL. [REASON]
- Perform basic database maintenance and administration such as: insert,
update and delete data, create, drop and modify tables. [REASON]
- Create various types of select statements including: table, multi-table
and joins, and be proficient with functions and expressions. [REASON]
- Explain the significance of and create indexes. [REASON]
Click this link to view the course syllabus:
CIS 251 Syllabus
My Reflection on this Classs:
Even though there is less to "demonstrate" than anyone may like (myself included),
I played with SQL so much in this class! Being a "gotta know it all" kind of gal, I
was amazed by how nice I found manipulating databases using SQL directly rather than
MS Access (which was my only experiences with databases until this class). I also
learned the value of Open Freeware! If you work with SQL, I recommend you use MySQL
Toad for MySQL. Just Saying.
|
