ITIS 165: Database Principles Using SQL
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
- 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
- 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