R-DBMS & Oracle (Video Session)

Introduction To Data

Understanding Requirments From Data

Understanding the limitation of using Flat Files

Functional Dependencies

Normalization 1NF, 2NF, 3NF

Understanding Oracle Commands

Understanding DataTypes in Oracle

Understanding Operators & Expressions in Oracle

Understanding Types of Databases

Install Oracle from Scratch

Diving into Corelated Queries

Corelated SubQuery - Exists & Not Exists

Introduction to Joins

Joins from Join

Self Join

Left Outer Join

Right Outer Join

Full Outer Join

Foreign Key

ER Diagram

Cardinality of Relationships

Crow Foot Notation

Relationships & Foreign Keys

Data Language-TCL

Data Language-DCL

Single Column Constraint

Create & Identity

Delete vs Truncate

DML-Insert

DML-Update & Delete

DML-Select

DML-Select Distinct

DML-WHERE Distinct

DML-LIKE Operator

DML-GROUP BY Operator

DML-Date Functions

DML-Numeric Functions

DML-Conversion Functions

DML-Miscellaneous Functions

DML-Case Statements