SQL Fund 1Z0-051

SQL Fund 1Z0-051

1. 8 Manipulating Data

   • DML
     • SELECT

2. 1 Oracle Server Technologies and the Relational Paradigm

3. 2 Data Retrieval Using the SQL SELECT Statement

4. 3 Restricting and Sorting Data 103

5. 4 Single-Row Functions 169

6. 5 Using Conversion Functions and Conditional Expressions

7. 6 Reporting Aggregated Data Using the Group Functions

8. 7 Displaying Data from Multiple Tables 300

9. 8 Using Subqueries to Solve Problems

   • Joins
     • join.. using
     • Join
     • Join

10. 9 Using the Set Operators

11. 10 Manipulating Data

12. 11 Using DDL Statements to Create and Manage Tables

13. 12 Creating Other Schema Objects