Database - Oracle

Part-01

Data, Information, DBMS, RDBMS, Uses of databases

Part-02

Sorting of data, filtering data

Part-03

Identify data, group data, associate data type and length

Part-04

Uniqueness, Relationships, Create Table, Drop Table

Part-05

Insert data and its variations, simple select statement

Part-06

Primary key, varchar, length, trim, order by clause

Part-07

Default clause, where condition, update statement

Part-08

Description: Alter table, .sql file, sum, max, min, avg, count

Part-09

Group by, Having, Delete, Truncate, Rowid

Part-10

to_date, to_char, AND, OR, Between, In