Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle Introduction: Controlling Database Access and Integrity |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Trainee database administrators and application developers |
| Prerequisites |
| Familiarity with programming techniques would be an advantage |
| Course Aim |
| To illustrate the use of constraints and show how to control user access |
| Learning Objectives |
| Define the constraint types. Use constraints. Explain system and object privileges. Write SQL scripts using SQL. Plus to create and maintain tables, constraints, and privileges. |
| Topics Covered |
| Constraint operations - Constraint types - Using constraints - Hands-on: Adding and checking constraints Controlling user access - System privileges - Object privileges - Hands-on: Granting privileges Hands-on: SQL workshop - Accessing tables - Maintaining tables - Updating, modifying, and reporting |