CIS 251 Structured Query Language (SQL), Fall 2013

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.
Back to Courses page Return to EdCC Top 10 Fav Courses

Comments about this course...

This course introduced me to MySQL and while I can't honestly say that I'm a big fan, it does have a lot to offer and with the new and improved Workbench, I felt almost as home as I do when working on Microsoft SQL Server Management Studio. I have several years of experience on that platform so it's no trivial thing to admit that MySQL is a worthwhile product to consider for small-to-medium sized projects (as usual, your mileage may vary, etc.). Grade: 4.0

Course Level Objectives

  1. Explain what SQL is. [REASON]
  2. Identify the major data types. [REASON]
  3. Describe why SQL is such a powerful tool. [COMMUNICATE]
  4. Create relational databases using SQL. [REASON]
  5. Perform basic database maintenance and administration such as: insert, update and delete data, create, drop and modify tables. [REASON]
  6. Create various types of select statements including: table, multi-table and joins, and be proficient with functions and expressions. [REASON]
  7. Explain the significance of and create indexes. [REASON]

Course Examples

Assignment 5 - GROUP BY, HAVING and ORDER BY Queries (opens a new tab/window) This is a PDF of the queries created for the assignment.

Assignment 6 – COMBINING TABLE EXPRESSIONS, UPDATING TABLES, AND CREATING TABLES. (opens a new tab/window) This is a PDF of the queries created for the assignment.

Valid XHTML 1.0 Transitional