Venky DevMastery

  PLSQL-Course Contents 1. About PLSQL and features 2. Anonymous &Named Blocks 3. About Editors and IDE's 4. Data types in PLSQL 5. Declaring, Assigning variables. 6. DB programming with PLSQL 7. Conditional Statements(if then else, multi-if,nested if) 8. Reference types 9. Loops in PLSQL(while, for) 10.Cursor,ref cursor and dynamic cursor 12. Collections 13. Bulk Collect 14. collection methods 15. Rowtype array 16. User Defined records 17. Bulk Bind 18. VArray 19. Nested Table 20. pl/sql table vs varray vs nested table 21. Error/Exception handling 22. SQLcode, SQLerrm. 23. user defined errors using Raise statements 24. Pragma Exception_init ...

SQL Course Content Topic_Details  1. DB,DBMS,RDBMS,ORDMBS & DB development lifecycle Click Here 2. About Oracle Click Here 3. Client/Server Click Here 4. About SQL Click Here 5. Data, data definitions, schema, and SQL Developer tool and DB install process. Click Here 6. Creating a User/Schema/Account in Oracle DB. Click Here 7. Data types in Oracle. Click Here 8. Creating,inserting a Table in Oracle DB. Click Here 9. Operators in Oracle DB. Click Here 10. Displaying data from Oracle DB. Click Here 12. Where Clause Click Here 13. In,between,Like,Is Operators Click Here 14. Alias, All_users,User tables. Click Here 15.Order by, Distinct,fetch clauses ...