TOAD for Oracle Fundamentals I


1. Oracle Server Technologies and the Relational Paradigm

    1.1. Position the Server Technologies
    1.2. Understand Relational Structures
    1.3. Summarize the SQL Language
    1.4. Use the Client Tools
    1.5. Create the Demonstration Schemas

2. Data Retrieval Using the SQL SELECT Statement List the Capabilities of SQL SELECT Statements

    2.1. List the Capabilities of SQL SELECT Statements
    2.2. Execute a Basic SELECT Statement

3. Restricting and Sorting Data

    3.1. Limit the Rows Retrieved by a Query
    3.2. Sort the Rows Retrieved by a Query
    3.3. Ampersand Substitution

4. Single-Row Functions

    4.1. Describe Various Types of Functions Available in SQL
    4.2. Use Character, Number, and Date Functions in SELECT Statements

5. Using Conversion Functions and Conditional Expressions

    5.1. Describe Various Types of Conversion Functions Available in SQL
    5.2. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Function
    5.3. Apply Conditional Expression in a SELECT Statement

6. Reporting Aggregated Data Using the Group Functions

    6.1. Describe the Group Functions
    6.2. Identify the Available Group Functions
    6.3. Group Data Using the GROUP BY Clause
    6.4. Include or Exclude Grouped Rows Using the HAVING Clause

7. Displaying Data from Multiple Tables

    7.1. Write SELECT Statements to Access Data from More Than One Table Using Equijoins and No equijoins
    7.2. Join a Table to Itself Using a Self-Join
    7.3. View Data that Does Not Meet a Join Condition by Using Outer Joins
    7.4. Generate a Cartesian Product of Two or More Tables

8. Using Subqueries to Solve Problems

    8.1. Devine Subqueries
    8.2. Describe the Types of Problems That the Subqueries Can Solve
    8.3. List the Types of Subqueries
    8.4. Write Single-Row and Multiple-Row Subqueries

9. Using the Set Operators

    9.1. Describe the Set Operators
    9.2. Use a Set Operator to Combine Multiple Queries into a Single Query
    9.3. Control the Order of Rows Returned

10. Manipulating Data

    10.1. Describe Each Data Manipulation Language (DML) Statement
    10.2. Insert Rows into Table
    10.3. Update Rows in a Table
    10.4. Delete Rows from Table
    10.5. Control Transactions


  1. Windows


Sigit Utoyo. Menamatkan pendidikan tinggi jurusan Manajemen Informatika di STMIK Budi Luhur Jakarta. Memiliki berbagai sertifikasi internasional seperti : Oracle9i Certified Associate (OCA), Oracle10g Certified Professional(OCP), Oracle11g Certified Professional(OCP), dll. Berpengalaman lebih dari 10 tahun dibidang System Programmer Administrator dan Database Administrator khusus di produk Oracle. Saat ini bekerja di PT Universal System menjabat sebagai Oracle Database Administrator.