Tt
Click this widget to change the font size.
CC
Click this widget to change contrast.
Skip to content

Home Page CH 1 | CH 2 | CH 3 | CH 4 | CH 5 | CH 6 | CH 7 | CH 8 | CH 9 | CH 10 | CH 11 | CH 12 | CH 13 | Links | Search | Bio | Faculty

Guide to Oracle SQL (University at Buffalo Version)


Introduction

I developed this guide as a way to present Oracle database concepts and SQL*Plus to an advanced database programming course. While teaching "Database Programming" (CIS411) at Buffalo State College for a few semesters I have researched and used quite a few different SQL textbooks. Most of these textbooks covered the SQL and database topics well enough but they tended to be written with a general audience in mind. I needed to supplement these textbooks with numerous lecture notes specific to the SQLPlus environment.

This course has some knowledge of database concepts as pre-requisites. In reality, about 25% of my students each semester were at the beginning level and the rest were at a more advanced level already.

I'd like to acknowlegde my Buffalo State College colleagues, Andrew and Maria Garrity, for sharing their curriculum and knowledge with our students and me.

This guide is loosely based on the OCA Oracle Database 12c SQL Fundamentals I Exam Guide and intended for you to learn about the Oracle database environment and the SQL database query language syntax. I will provide examples using both the sqlplus command line tool and the SQL Developer graphical interface application.

You may also want to visit one of my other guide web sites: Guide to HTML, CSS, and JavaScript, Guide to PHP & MySQL, Guide to Java Object-oriented Programming.

Show DivChapter 1: Introduction to Databases

Show DivChapter 2: Maintaining a Database using SQL Statements

Show DivChapter 3: Restricting and Sorting Data

Show DivChapter 4: Single-Row and User Defined Functions

Show DivChapter 5: Using Conversion Functions and Conditional Expressions

Show DivChapter 6: Reporting Aggregated Data Using the Group Functions

Show DivChapter 7: Displaying Data from Multiple Tables

Show DivChapter 8: Using Subqueries to Solve Problems

Show DivChapter 9: Using the Set Operators

Show DivChapter 10: Manipulating Data

Show DivChapter 11: Formatting Result Sets

Show DivChapter 12: Using DDL Statements to Create and Manage Tables

Show DivChapter 13: Creating Other Schema Objects

Show DivChapter 14: Useful Links & Resources

Let's Get Started Exercises