Enroll Now

Oracle

>

Oracle Syllabus

  • Writing Basic SQL SELECT Statements1
  • Restricting and Sorting Data2
  • Single-Row Functions3
  • Displaying Data from Multiple Tables4
  • Aggregating Data Using Group Functions5
  • Subqueries6
  • Manipulating Data7
  • Creating and Managing Tables8
  • Including Constraints9
  • Creating Views10
  • Other Database Objects11
  • Controlling User Access12
  • Using SET Operators13
  • Enhancements to the GROUP BY Clause14
  • Advanced Subqueries15
  • Hierarchical Retrieval16
  • Extensions to DML and DDL Statements17

Oracle (PL/SQL Syllabus)

  • Part I: Programming in PL/SQL1
  • Creating and Running PL/SQL Code2
  • Part II: PL/SQL Program Structure3
  • Loop Basics4
  • Exception Handlers5
  • Part III: PL/SQL Program Data6
  • Strings7
  • Numbers8
  • Records9
  • Collections10
  • Miscellaneous Datatypes11
  • Part IV: SQL in PL/SQL12
  • Data Retrieval13
  • Procedures, Functions, and Parameters14
  • Packages15
  • Triggers16
  • Managing PL/SQL Code17
  • I/O and PL/SQL18
>