RDBMS

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

Share WhatsApp

Course Overview

• Codd’s Rules

• Oracle Data Types

• Oracle DDL Commands (Create Table, Alter Table, Drop Table), DML Commands (Insert, Update, Delete, Select) and TCL Commands (Commit, Rollback, SavePoint) Statements with integrity constraints

• Special Operators (IN, NOT IN, EXISTS, LIKE)

• Oracle Functions

• Range Searching and Pattern Matching

• Joins

• Sub Queries

• Indexes (Create index, Drop Index, Types of Index)

• Views (Read-only view, Updatable view)

• Sequences

• PL/SQL Block Structure

• Cursor (Explicit, Implicit)

• Error handling in PL/SQL

• Stored and Local Procedures & Functions

• Database Triggers

• Database Packages