The Power of Oracle 9i by Rajiv Parida And Vinod Sharma

Contents

1. Introduction to Database Management System and Data Modeling 2. Getting Started with Oracle 9i, SQL *Plus, ISQL *Plus 3. Writing Basic SQL Select Statement 4. Types of SQL Statements and Data Types 5. Creating and managing Tables 6. Using Functions 7. Maintaining Data Integrity (Using Constraints) 8. Database Objects 9. Introduction to Table Partitioning 10. Joins, Sub-Queries and Set Operators 11. Aggregating Data and External Table 12. Privileges, Roles, and Security Policies 13. Introduction to PL/SQL 14. PL/SQL Control Structure 15. Exception Handling 16. SQL Cursors 17. Creating Procedures and Functions 18. Managing PL/SQL Packages 19. Creating Database Trigger 20. Implementing Object Technique in Oracle 9i 21. PL/SQL Collections and Records 22. Manipulating Large Objects 23. Data Concurrency and Consistency in a Multi-User Environment 24. Managing Dependencies 25. Developing Web Application 26. Using Dynamic 27. Using XML in Oracle 9i 28. Architecture of Oracle Server 29. Oracle Memory Architecture 30. Introduction to Tablespaces, Datafiles, and Control Files 31. File Input/Output 32. Using Embedded SQL and PL/SQL 33. SQLJ 34. Data Dictionary and Oracle Reserved Words, Keyboards, and Namespaces 35. Additional Exercise Index