Guide to Oracle SQL (Buffalo State College Version)


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 colleague, Andrew Garrity, for sharing his curriculum and knowledge with our students and me.

This guide is intended for you to learn about the Oraccle database environment and the SQL database query language syntax.

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: Data Retrieval Using the SQL SELECT Statement

Show DivChapter 3: Restricting and Sorting Data

Show DivChapter 4: Single-Row 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: Using DDL Statements to Create and Manage Tables

Show DivChapter 12: Creating Other Schema Objects

Show DivChapter 13: Hierarchical Queries

Show DivChapter 14: Embedded SQL

Show DivChapter 15: Oracle SQLLDR Command Examples

Show DivChapter 16: Useful Links & Resources

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Copyright © 2018 Jim Gerland