Database Management

Database Concepts
- Introduction to the world of Database.
- DBMS & its types.
- DBMS v/s RDBMS
- Normalization
Introduction to Oracle

No items in this section
Installation of Oracle on Windows / Linux

No items in this section
Introduction to the SQL *PLUS Environment

No items in this section
Structured Query Language (SQL)

No items in this section
CREATE TABLE

No items in this section
Creating a table from another table

No items in this section
ALTER TABLE

No items in this section
DROP TABLE

No items in this section
RENAME Tables

No items in this section
INSERT Command

No items in this section
UPDATE Command

No items in this section
DELETE Command

No items in this section
MERGE Command

No items in this section
SELECT Command
- Projection
- Selection
- Aggregate Functions
- Sub Queries
- GROUP BY Clause
- HAVING Clause
Constraints
- NIT NULL Constraint
- UNIQUE Constraint
- PRIMARY KEY Constraint
- FOREIGN KEY Constraint
- CHECK Constraint
- Enabling, Disabling & Viewing Constraints
Oracle SQL Built-in Functions
- String Functions
- Scaler Functions
- Numeric Functions
- Conversion Functions
- DateTime Functions
Views
- Creating a View
- Modifying a View
- Retrieving data from a View
- Removing a View
- Read-only Views
Sequences

No items in this section
Indexes

No items in this section
Synonyms

No items in this section
SET Operators
- SET Operator
- UNION Operator
- UNION ALL Operator
- INTERSECT Operator
- MINUS Operator
User Management in SQL
- Creating Users
- Controlling User Access
- Granting System Privileges to users
- Role Management
- GRANT Command
- REVOKE Command
Introduction to PL/SQL
- Need of PL/SQL
- PL/SQL Block
- PL/SQL Execution Environment
Control Structures in PL/SQL
- Conditional Controls
- Iterative Controls
- Sequential Controls
CURSORS
- Need for Cursors
- Implicit Cursors & Attributes
- Explicit Cursors & Attributes
- Parameterized Cursors
- Cursor within Cursor
PL/SQL Security - LOCKS
- Need for LOCKS
- Types of LOCKS
- Levels of LOCKS
- Explicit LOCKING
- The SELECT..FOR UPDATE Statement
- LOCK Table Statement
- Releasing LOCKS
Error Handling in PL/SQL

No items in this section
PL/SQL Functions & Procedures
- Functions v/s Procedures
- Creating and using Functions
- Creating and using Procedures
- Deleting Functions and Procedures
- Overloading Functions and Procedures
Database Triggers
- Need for Triggers
- Types of Triggers
- Deleting Triggers
- Generating Primary Key using a Database Trigger

Oracle (SQL + PL/SQL)

This content is protected, please login and enroll course to view this content!

Prev Selection

Next Sub Queries

Leave a Reply Cancel reply