Active Outline

General Information

Course ID (CB01A and CB01B)
CIS D064B
Course Title (CB02)
Introduction to SQL
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2024
Course Description
Introduction to Oracle SQL (Structured Query Language), DML (Data Manipulation Language) processing techniques, DDL (Data Definition Language) techniques, selecting and sorting data, joins, SQL functions, Oracle objects, Oracle data processing concepts to maintain large database systems.
Faculty Requirements
Course Family
Not Applicable

Course Justification

This course is transferable to all California State University campuses and is required as part of the Database Design for Developers (Oracle) Certificate of Achievement. SQL stands today as the standard computer database language. It introduces learners with language to access relational databases for creating and managing a database. It is beneficial for those with careers in IT, including Database Architects, Database Administrators, and Database Designers, to hold certification for a specific database software program.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to CSU only

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

Corequisite(s)

Advisory(ies)

ESL D272. and ESL D273., or ESL D472. and ESL D473., or eligibility for EWRT D001A or EWRT D01AH or ESL D005.

CIS D044A

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Lecture and visual aids

Discussion of assigned reading

Discussion and problem solving performed in class

Quiz and examination review performed in class

Homework and extended projects

Collaborative learning and small group exercises

Collaborative projects

Other: Laboratory discussion sessions

Other: Laboratory experiences which involve students in designing, coding, and testing SQL programs.

Assignments

  1. Reading from text
  2. Documenting, coding, testing and debugging six to ten programs guided with clearly documented design, covering the Lab Topics specified in X. below, half completed in the computer lab, half completed as homework

Methods of Evaluation

  1. Successful completion of programming assignments with output verifying program correctness; use of SQL, documentation, programming style, efficiency, and testing methods.
  2. One or more examinations requiring programming demonstrating ability to develop a design and/or write code using specific SQL constructs.
  3. A final examination requiring some programming demonstrating ability to develop an algorithm and write code. The code will involve select, insert, update, delete, create and alter statements.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None
Essential College Facilities:
  • Access to a computer system with Oracle SQL Plus

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
Walter Shields, ClydeSQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQLBank Media LLCIllustrated edition (November 18, 2019)978-1945051753
Steve O'HearnOCA Oracle Database SQL Exam Guide (Exam 1Z0-071)McGraw-Hill Education1st edition (August 23, 2017)978-1259585494

Examples of Supporting Texts and References

AuthorTitlePublisher
Pratt, Philip J. "A Guide to SQL, 9th Edition." Course Technology, 2014.

Learning Outcomes and Objectives

Course Objectives

  • Review the basic features of databases.
  • Demonstrate usage of basic SQL statements to restrict and sort data.
  • Demonstrate usage of single-row functions for retrieving from database.
  • Illustrate usage of joins to get data from multiple tables.
  • Explain and apply data aggregation and sub-queries to fetch data from database.
  • Demonstrate how formatting output works to produce readable reports.
  • Create Database Objects using a database schema.
  • Define database security policy and create different levels of user access and variables in database schema.
  • Use Control Structures to implement decision making constructs in RDBMS.
  • Describe how cursors are implemented in databases.
  • Demonstrate usage of database utilities used for importing and exporting data from databases.

CSLOs

  • Design solutions for introductory level problems using appropriate design methodology incorporating interpreted database constructs.

  • Create algorithms, code, document, debug, and test introductory level SQL programs.

Outline

  1. Review the basic features of databases.
    1. Introduction to DBMS
    2. Types of databases
    3. Introduction to RDBMS
    4. Relational database theory
    5. Normalization theory
    6. Designing relational databases
    7. Introduction to object relational databases
  2. Demonstrate usage of basic SQL statements to restrict and sort data.
    1. SQL Plus
    2. Select statements
    3. Data types in SQL
    4. Operators
      1. Arithmetic operators
      2. Comparison operators
      3. Character operators
      4. Concatenation operators
      5. Logical operators
      6. IN and BETWEEN operators
    5. Clauses in SQL
      1. WHERE
      2. STARTING WITH
      3. ORDER BY
      4. GROUP BY
  3. Demonstrate usage of single-row functions for retrieving from database.
    1. Character
    2. Number
    3. Date
    4. Conversion
    5. General
  4. Illustrate usage of joins to get data from multiple tables.
    1. Equijoins
    2. Non-Equijoins
    3. Outer joins
    4. Self joins
  5. Explain and apply data aggregation and sub-queries to fetch data from database.
    1. Group functions
      1. COUNT
      2. AVG
      3. SUM
      4. MAX/MIN
      5. Nesting of Group functions
    2. Sub queries
      1. Single-row sub query
      2. Multiple-column sub query
  6. Demonstrate how formatting output works to produce readable reports.
    1. Using Aliases
    2. INSERT statements
    3. UDATE statement
    4. DELETE statement
  7. Create Database Objects using a database schema.
    1. CREATE TABLE
    2. ALTER TABLE
    3. DROP statement
    4. RENAME statement
    5. TRUNCATE statement
  8. Define database security policy and create different levels of user access and variables in database schema.
    1. Create User and Privileges
    2. Grant Option and Revoke
  9. Use Control Structures to implement decision making constructs in RDBMS.
    1. Usage of DECODE
    2. Introduction to temporary tables and records
  10. Describe how cursors are implemented in databases.
    1. Implicit Cursor concepts
    2. Integration of cursors with DML and DDL operations
  11. Demonstrate usage of database utilities used for importing and exporting data from databases.
    1. SQL Loader
    2. DB import/export utility.

Lab Topics

  1. Write code using SQL implementing simple queries to work with one table.
  2. Write code using SQL implementing simple queries to work with more than one table.
  3. Write code using SQL implementing data grouping and analysis
  4. Write code using SQL implementing transaction concepts with usage in Insert, Update and Delete statements.
  5. Write code using SQL implementing a database schema using Create and Alter statements
  6. Design database security model for multi-user access
Back to Top