Course Agenda

•Day 1:

–Introduction

–Retrieving Data Using the SQL SELECT Statement

–Restricting and Sorting Data

–Using Single-Row Functions to Customize Output

–Using Conversion Functions and Conditional Expressions

•Day 2:

–Reporting Aggregated Data Using the Group Functions

–Displaying Data from Multiple Tables

–Using Subqueries to Solve Queries

–Using the Set Operators

Oracle Database 11g: SQL Fundamentals I I - 5

Course Agenda

•Day 3:

–Manipulating Data

–Using DDL Statements to Create and Manage Tables

–Creating Other Schema Objects

Oracle Database 11g: SQL Fundamentals I I - 6

Appendixes Used in the Course

•Appendix A: Practice Solutions

•Appendix B: Table Descriptions

•Appendix C: Oracle Join Syntax

•Appendix D: Using SQL*Plus

•Appendix E: Using SQL Developer

•Additional Practices

•Additional Practices Solutions

Oracle Database 11g: SQL Fundamentals I I - 7

Lesson Agenda

•Course objectives, course agenda, and appendixes used in this course

•Overview of Oracle Database 11g and related products

•Overview of relational database management concepts and terminologies

•Introduction to SQL and its development environments

•The HR schema and the tables used in this course

•Oracle Database 11g documentation and additional resources

Oracle Database 11g: SQL Fundamentals I I - 8