DBMS and RDBMS using Oracle

Contents

1. RDBMS

1.1 Concepts of RDBMS

1.2 Difference between DBMS and RDBMS  

1.3 Features of RDBMS

1.4 Introduction of Oracle

1.5 Historical Development of Oracle

1.6 Role and Responsibilities of Database Administrator

1.7 Transaction processing

1.8 DSS (Decision Support System)

1.9 Data warehousing

1.10 DATA MARTS

1.11 RDBMS Terminologies

1.12 Integrity Constraints

1.13 Functional Dependencies

1.14 Normalization

1.15 BCNF (BOYCE CODD NORMAL FROM)

2. Introduction to SQL

2.1 Introduction

2.2 Features of SQL

2.3 Logging on to SQL*PLUS

2.4 SQL Data types

2.5 Classification of SQL Commands

2.6 The CREATE TABLE command

2.7 Integrity Constraint

2.8 Creating table from a table

2.9 Inserting of data in to table

2.10 Updating the data of a table

2.11 Deletion of records

2.12 Select Command

2.13 SQL OPERATORS

2.14 SQL FUNCTIONS 

3. Sub Queries and Join

3.1 Introduction

3.2 Logical Operators

3.3 Comparison Operators

3.4 Aliases

3.5 JOIN (WORKING WITH MULTIPLE TABLES)

3.6 CREATE VIEW

3.7 CREATE SEQUENCE

3.8 ALTER SEQUENCE

3.9 DROP SEQUENCE

3.10 CREATE INDEX

3.11 ALTER INDEX

3.12 DROP INDEX

3.13 Create Cluster

3.14 DROP CLUSTER

4. Introduction to procedural language (PL/SQL)

4.1 Introduction to PL / SQL

4.2 Advantages of PL/SQL

4.3 Disadvantages of Oracle PL/SQL

4.4 PL/SQL Environment

4.5 PL/SQL Block Structure

4.6 PL/SQL CHARACTER SET

4.7 Declaring variables

4.8 Variable Initialization and Keywords

4.9 Comments

4.10 PL/SQL Data Types

4.11 PL/SQL OPERATORS

4.12 How to write Simple program in PL/SQL?

4.13 PL/SQL using tables

4.14 Manipulating Data Using PL/SQL

4.15 Control Structure

4.16 ERROR HANDLING IN PL/SQL

4.17 Difference between SQL & Pl/SQL

5. Concept of Cursor

5.1 Introduction.

5.2 Types of Cursors

5.3 Using Cursor For….Loop

5.4 Deletion or Updation Using Cursor

5.5 Parameterized cursor (passing parameter to cursor)

5.6 Cursor Attributes

5.7 Triggers

6. Locks in Oracle

6.1 Introduction

6.2 Concepts of locking

6.3 Types of locking

6.4 Using Lock Table Statement

6.5 Levels of lock

6.6 Select… For update clause

6.7 Deadlock 6.8 Primary introduction to DBA

7. User Create Granting

7.1 Introduction

7.2 System Privileges

7.3 OBJECT PRIVILEGES

7.4 REVOKE command

8. TRANSACTIONS in Oracle

8.1 Introduction

8.2 Explicit Transaction control Statements

8.3 State of data before COMMIT or ROLLBACK

8.4 State of data After COMMIT

8.5 State of data After ROLLBACK