Oracle
- 1. Introduction to RDBMS
Approach to Data Management Database Management:
An evolution Phenomenon Introduction to DBMS Database Models
Hierarchical Model Network Model Relational Model
The 12 Rules for an RDBMS (CODD’s
Rule) Zero rule
Need for an Extended Service form an
RDBMS
Why Oracle?
New Features of Oracle
Oracle as an Object Relational Database Management System (ORDBMS) Networking Computing Architecture (NCA)
Oracle Products
- 2. Introduction to SQL * Plus
Introduction to SQL *Plus
Oracle Data types
1. | Information Representation | Starting SQL *Plus
Querying database Tables |
|
2. | Guaranteed Access | ||
3. | Systematic Treatment of Null | Conditional Retrieval of Rows | |
Values | Working with NULL Values | ||
4. | Database Description Rule | Matching a pattern with a | |
5. | Comprehensive Data Sub- Language | Column from a table | |
6. | View Updating | Summarizing data with Aggregate | |
7. | High-Level Update, Insert, Delete | Functions | |
8. | Physical Data Independence | Ordering the Result of a Query | |
9. | Logical Data Independence | Command Summary of SQL *Plus Editor | |
10. | The Distribution Rule | 3. | Querying Multiple Table |
11. | Non-Subversion | Collating Information |
- 12. Integrity Rule
E-R Modeling
Degree of Relationship
Normalization
Need for Normalization
Steps in Normalization
Present Scenario for Data Management Relational Database Management System
Features of Oracle
Equi Joins
Cartesian Joins
Outer Joins
Self Joins
SET Operators Union Intersect Minus
Nested Queries
Correlated Sub query
Using Special Operators in Sub | Defining Header, Footer and Column | |
queries | Headings | |
Column Functions | Formatting the Columns | |
Arithmetic Functions | Control Break Reports | |
Data Functions | 7. | PL/SQL |
General Functions | Introduction |
PL/SQL Block Structure
PL/SQL Architecture
Variables and Constants | |||
4. | Data Manipulation and Control -1 | Conditional and Iterative Control | |
Creating tables | Writing the PL/SQL Code | ||
Applying column constraints | Cursor Management in PL/SQL | ||
Introduction to VIEWS | Explicit Cursor Attributes | ||
Inserting Values into a Table | Implicit Cursor Attributes | ||
Inserting the result of a query | Composite Data types | ||
Inserting through Parameter | PL/SQL Records | ||
substitution | Exception Handling in PL/SQL | ||
Updating Column(s) of a Table | Scope Rules | ||
Deleting Row(s) From a Table | Exception Propagation | ||
Manipulating Table(s) the Base table(s) | 8. | Advanced PL/SQL | |
through VIEWS | Subprograms in PL/SQL | ||
5. | Data Manipulation and Control –II | Procedure | |
Database Security and Privileges | Functions | ||
GRANT and REVOKE | Argument modes | ||
Application Privileges Management | Database Triggers | ||
Enhancing Performance | Creating a database Trigger | ||
Clustering | Stored Packages | ||
Sequences | Using Stored Functions in SQL | ||
Manipulating Database Objects | Statements | ||
COMMIT and ROLLBACK | |||
Granting Privileges on columns | |||
Revoking Object Privileges and Roles | |||
6. | SQL *Plus Reporting | ||
Introduction | |||
SQL *Plus Environment Commands | |||
Manipulating Variables |