In this course, you will learn the basics of writing Oracle SQL statements and how to use the advanced features of SQL in order to query and manipulate data within the database. This course provides the SQL skills that allow you to write queries against single and multiple tables, manipulate data in tables, and take advantage of Oracle supplied row functions. You will also cover advanced querying and reporting techniques, including using SET operators, writing hierarchical queries, and using the Flashback Query feature. This course also covers Schema objects such as tables, indexes, and constraints in detail.

What You’ll Learn

  • Access database data with a basic SELECT statement
  • Access data from more than one table
  • Manipulate database data
  • Decide where best to use Oracle-supplied functions in place of user-written code
  • Combine SQL result sets into a single result set using SET operators
  • Access data from a previous point in time using the flashback query feature
  • Combine multiple SQL statements into one statement
  • Create various database objects

Who Needs to Attend

Anyone interested in becoming a database programmer or administrator

Prerequisites

  • Introduction to Programming for Non-Programmers

Follow-On Courses

  • Oracle 10g/11g Database Administration I
  • Oracle 10g/11g Database Administration II

Course Outline

1. Writing SQL SELECT Statements

2. Restricting Data

3. Sorting Data

4. Displaying Data from Multiple Tables

5. Character Row Functions

6. Numeric Row Functions

7. Date/Time Row Functions

8. Miscellaneous Row Functions

9. Aggregating Data Using Group Functions

10. Extensions to the GROUP BY Clause

11. Manipulating Data I

12. Manipulating Data II

13. Using the Set Operators

14. Flashback Query

15. Using Subqueries

16. Hierarchical Retrieval

17. Using the Data Dictionary Views

18. Creating Database Objects I (Views)

19. Creating Database Objects II (Sequences)

20. Creating Database Objects III (Synonyms)

21. Creating Database Objects IV (Tables)

22. Creating Database Objects V (Indexes)

23. Creating Database Objects VI (Constraints)

24. Regular Expression Support