ITIS 165: Database Principles Using SQL

Citrus College Course Outline of Record

Citrus College Course Outline of Record
Heading Value
Effective Term: Fall 2024
Credits: 3
Total Contact Hours: 54
Lecture Hours : 54
Lab Hours: 0
Hours Arranged: 0
Outside of Class Hours: 108
Total Student Learning Hours: 162
Transferable to CSU: Yes
Transferable to UC: Yes - Approved
Grading Method: Standard Letter

Catalog Course Description

This is an introductory course in SQL (Standard Query Language). Concepts covered include a general overview of SQL and MySQL, creating a MySQL database, tables, queries, subqueries, filtering, and conditional logic. 54 lecture hours.

Course Objectives

  • Design tables, fields, properties, and relationships in a client-server relationship using SQL
  • Enter, edit, retrieve, sort, and filter data appropriately
  • Create calculated fields and use data manipulation functions
  • Understand and create table joins including advanced joins
  • Understand and use stored procedures
  • Understand and manage transaction processing
  • Understand basic database security issues
  • Express and communicate information via MS Excel and Access applications

Major Course Content

  1. Understand basic database concepts including:
    • creation of tables including definition of fields and specification of properties
    • creation of relationships and enforcement of referential integrity
    • creation of queries including extraction of data from multiple related tables using various criteria and various logical relationships (AND/OR)
    • creation of forms based on multiple tables
    • creation of reports based on multiple tables
  2. Understand the details of SQL in database development and maintenance in a client-server relationship

Suggested Reading Other Than Required Textbook

None required.

Examples of Required Writing Assignments

Students will outline data structures noting various fields with requisite properties prior to actual database creation.

Examples of Outside Assignments

Students will be required to create, modify, query, and report from various sample databases through selected case problems.

Instruction Type(s)

Lecture, Online Education Lecture