CIS 225 — Introduction to SQL Programming - Oracle
Prerequisite: CIS 263 or CIS 268 or CIS 269 This course is designed to give students a firm foundation in concepts of relational databases, to create database structures and to store, retrieve, and manage data. Students will learn to query using Basic SQL statements, restrict, sort, per form single row functions and group the queried data. Students will write advanced SELECT statements and use advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Students will query multiple tables, perform nested queries, implement constraints, use data and time functions, and create sequences and views. Students will learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands -on practice reinforces the funda mental concepts. This course is the first of two courses required to acquire certification as Oracle Certified Associate (OCA). Code C Lecture: 3 hours Lab: 0 hours Credit Hours: 3