CIS 225 : Introduction to SQL Programming - Oracle

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, perform 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. You will query multiple tables, perform nested queries, implement constraints, use data and time functions, and creates sequences and views. Students 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 fundamental concepts. This course is the first of two courses required to acquire certification as Oracle Certified Associate (OCA).