| |
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 ISBN 9789380298146
|
| |
Pages : 675
|