Overview
Students will understand the data types used in Oracle database tables, how to modify data and execute queries through the use of Oracle SQL’s Data Manipulation Language (DML).
There are several hands-on labs in this course that will provide the student with the opportunity to practice and perfect the knowledge of Oracle that they will gain during this course.
Audience
Developers or end-users who need to know how to write SQL queries for Oracle databases.
Prerequisites: Experience with Windows operating system. Knowledge of
Relational Database technology. No SQL experience required.
Length
16 hours
Outline
Understanding Database Tables
• Overview and Objectives
• Topics
• Introduction
• Characteristics of Database Tables
• Most Commonly Used Data Types in Oracle
• Use of NULL
• Adding Constraints
• Modifying Data in a Table
Basic Data Manipulation (DML)
• Overview and Objectives
• Topics
• Introduction
• Basic SELECT Statement
• WHERE Clause
• WHERE Clause Comparison Operators
• Specific Column Selection
• CASE Expression
• Derived Columns
• ORDER BY Clause
• Expanding on the WHERE Clause
• Negative Logic in the WHERE Clause
• NULLS in the WHERE Clause
• Types of Built-In Functions
• Aggregate Functions
• Summary – Impact of NULLS
• Summary – Impact of NULLS
• GROUP BY Clause
• HAVING Clause
• Other Functions
• Summary
Advanced Data Manipulation (DML)
• Overview and Objectives
• Table Joins
• Inner Joins
• Outer Joins
• Subqueries
• Correlated Subqueries
• Using Correlated Subqueries to Check Data Integrity
• Nested Table Expression
• UNION
• Using SELECT With INSERT
Appendix A
Contents of Sample Tables
Answers to Labs and Exercises
References
Appendix B
Extra SQL Problems and Solutions