Database - Oracle

Oracle basics, PLSQL elements, Data Definition, Data Manipulation

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 - 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