Class Description
This class will focus on the basic SQL skills necessary for entry level database students. No previous SQL, Oracle, or database experience will be assumed. The majority of class time and lab work will be placed on the Data Manipulation Language (DML) skills necessary for entry level staff to construct queries to deliver the datasets necessary to perform their jobs and run reports. A high priority will also be given to exposing students to some of the basic options, techniques, and resources available so they will be able to determine their best approach for a given task, this of course will take practice and experience through use.
 

Textbook and tools for use in the class
Text: Murach’s Oracle SQL and PL/SQL, ISBN 978-1-890774-50-9, Published by Mike Murach & Associates, Inc.
Tools: Oracle 10g Express Edition (XE), Oracle SQL Developer 1.5.5 or later, both will be available on DVD from me or downloadable from Oracles website at no charge.

Content to be covered

• Relational Database Concepts
• Installing & Using Oracle 10g XE, and SQL Developer
• Simple SELECT’s and using WHERE and ORDER BY filters
• Joins & Unions
• Summary Queries, AGGREGATE and GROUP functions
• Subqueries, and Complex queries
• INSERT, UPDATE, and DELETE data
• Data Types – Working with Date & Time, Numeric, Character, and Data Type Conversions
• Designing Data Structures – Basics
• Data Normalization and Data Renormalization use – Basics
• Index’s & Sequences – Basics
• Working with timestamps and intervals
• Advanced topics like Triggers, and Stored Procedures as time and interest allow

Oracle 10g SQL Reference

• Oracle10g_SQL_Reference.pdf

Text book

• Chapter 1
• Chapter 2
• Chapter 3
• Chapter 4
• Chapter 5
• Chapter 6

Questions

Table Structure

• Initialization scripts and scripts used in the chapter