Abhinav N.

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