COURSE OUTLINE FOR CREDIT COURSE

Basic Course Information

Courses numbered 1 - 49 are remedial or college preparatory courses which do not apply toward an A. A. Degree and are not intended for transfer. Courses numbered 50-99 apply toward an AA Degree, but are not intended for transfer. Courses numbered 100 and higher apply toward an AA Degree and/or are intended for transfer to a four-year college or university.

Discipline: CSIT
Course Number: 150
Title: Introduction to SQL

Units and Hours

Units: 3.00
Grade Option: Grade/Pass/No Pass
Course Length in Weeks: Min Weeks - 16 Max Weeks - 18
Min Semester Hours
Hour Type
Hours
Min Semester Hours
Max Semester Hours
Lecture Category
2.50
40.00
45.00
Lab Category
1.50
24.00
27.00
Subtotal
4.00
64.00
72.00
Out of Class Hour
5.00
80.00
90.00
Totals
9.00
144.00
162.00
Max Semester Hours
Hour Type
Hours
Min Semester Hours
Max Semester Hours
Max Lecture Category
2.50
40.00
45.00
Max Lab Category
1.50
24.00
27.00
Max Subtotal
4.00
64.00
72.00
Max Out of Class Hour
5.00
80.00
90.00
Max Totals
9.00
144.00
162.00

Grading Basis: Grade/Pass/No Pass
Basic Skills Requirements: Appropriate Language and/or Computational Skills.

Requisites

To satisfy a prerequisite, the student must have earned a letter grade of A, B, C or P(Pass) in the prerequisite course, unless otherwise stated.

Prerequisite: None
Corequisite (Course required to be taken concurrently): None
Prerequisite: (Completion of, or concurrent enrollment in): None
Recommended Preparation: None
Limitation on Enrollment (e.g. Performance tryout or audition): None

Catalog Description

Intended for individuals who want to learn how to search for and manipulate data in a database, create tables and indexes, handle security, control transaction processing, and learn the basics of how to design a database.

Student Learning Outcomes

Upon successful completion of the course, the student will be able to:
  1. Demonstrate Industry-accepted coding standards.
  2. Students will be able to use and test SQL statements that manipulate information, create database objects, and construct correct data integrity and security controls for a relational database according specified criteria.

Specific Course Objectives

Upon successful completion of the course, the student will be able to:
  1. Identify the features of SQL.
  2. Query a database using SQL.
  3. Utilize sub-queries in the database.
  4. Modify data in a database using SQL.
  5. Ensure database integrity

Methods of Instruction

Methods of Instruction may include, but are not limited to, the following
  1. Lab
  2. Lecture

Content in Terms of Specific Body of Knowledge

  1. Introduction
    1. SQL basics
    2. Relational Databases
    3. Database Design Fundamentals
    4. Creating Tables and Indexes
  2. Selecting Data
    1. The Select List
    2. Specifying Tables
    3. Selection Criteria
    4. Sorting Data and Functions
    5. The Order By Clause
    6. Distinct Selects
    7. Aggregate Functions
  3. Grouping Data
    1. The Group By Clause
    2. Having Criteria
    3. Joining Data
    4. Inner Joins
    5. Outer Joins
    6. Set Functions
  4. Using Subqueries
    1. Joins vs. Subqueries
    2. Subquery Rules
    3. Multiple Nesting
  5. Adding and Changing Data
    1. Insert Statement
    2. Update Statement
    3. Delete Statement
    4. Views and Misc. topics
    5. Creating Views
    6. Managing Database Security
    7. Transaction Management
    8. Triggers and Stored Procedures
    9. Performance Issues
    10. Database Integrity

Textbooks/Resources

Textbooks
  1. Murach, Joel. Murach's MySQL, 2nd Edition. 2nd Murach, 2015.

Assignments

Required Reading:
Students will be required to read chapters in the class text.

Required Writing:
Students will discuss (in writing) useful methods of troubleshooting SQL statements

Critical Thinking:
It is the intention of the Database program to teach its students to think critically. Every database course requires students to clarify their thoughts sufficiently so that those thoughts can be expressed in a form that a computer can carry them out. The various CSDB courses focus on different areas of critical thinking, but each has as its primary objective to teach students to think critically in that area. Designing a database for a computer to perform complex operations is probably more demanding of critical thinking skills than almost any other activity. First, before one can write a database system to do something, one must understand what the program is supposed to accomplish. Since the intended objectives of a software system are described in English (at best), significant critical thinking skills are required simply to understand what is to be done. Second, students must determine, in precise detail, how the objectives may be accomplished. Finally, students must express the required steps as a database system. A computer program is a text in an unforgiving language, a programming language. Programming languages are interpreted more formally and literally than virtually any other language in existence. Syntax and semantics are rigidly defined. Everything must be correct for the program to operate properly. Accomplishing these steps successfully requires well honed and sophisticated critical thinking skills, skills that students are forced to develop through their studies in database systems.

Outside Assignments:
There are written homework exercises within each section of each chapter which are assigned, requiring an average of one hour to complete. In addition, numerous computer lab exercises are assigned, each ranging from one to ten hours to complete by an average student.

Students are expected to spend a minimum of three hours per unit per week in class and on outside assignments, prorated for short-term classes.

Methods of Assessment

Methods of Assessment may include, but are not limited to, the following:
  1. Homework
  2. Exams/Tests

Open Entry/Open Exit

Not Open Entry/Open Exit

Repeatability

Course is Repeatable for Reasons other than a Deficient Grade? No

Contact Person

Stephen R. Perry