IdentityI have five years of teaching exp and I have been working on Oracle PL/SQL for last 6.5 years.
Oracle SQL and PL/SQL
Course Syllabus (Oracle 11g / 12c)
Note: Each item is the topic of materials to be taught in a session of about 90 minutes. Thus, a total of 50 hours is required for this course.
1. Introduction to Relational Databases and Oracle SQL and PL/SQL
2. Basic SQL Statements
3. Restricting and Sorting Data
4. Single-Row Functions
5. Displaying Data from Multiple Tables
6. Aggregating Data using Group Functions
7. Sub Queries
8. Multiple-Column Sub Queries
9. Producing Readable Output with SQL*Plus
10. Manipulating Data
11. Creating and Managing Tables
12. Including Constraints
13. Creating Views
14. Other Database Objects
15. Controlling User Access
16. SQL Workshop
17. Declaring Variables
18. Writing Executable Statements
19. Interacting with the Oracle Server
20. Writing Control Structures
21. Working with Composite Data Types
22. Writing Explicit Cursors
23. Advanced Explicit Cursor Concepts
24. Handling Exceptions
25.Transaction processing and control
26.PL/SQL dynamic sql
27.PL/SQL Subprograms
28.Bulk Concept (BULK COLLECT and FORALL)
29.Triggers
30.PACKAGES
31.Managing Dependencies
32. Real-time Scenarios
33.Interview Questions
