Introduction to Databases
CODD'S Rules
Datatypes and Creating Tables
Oracle SQL SELECT Statement
Formatting Output in SQL * Plus
UNION, INTERSECT, MINUS Operators and Sorting Query Result
Oracle SQL Functions
Oracle Join Queries, (Inner Join, Outer Join, Self Join)
GROUP BY Queries, SUB Queries
CUBE, ROLLUP Functions, WITH, CASE Operators
Oracle Data Manipulation Language (INSERT, UPDATE, DELETE, INSERT ALL, MERGE)
Oracle Data Definition Language (CREATE, ALTER, DROP, TRUNCATE, RENAME)
Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)
Data Control Language (GRANT, REVOKE)
Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)
Data Control Language (GRANT, REVOKE)
Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE)
Oracle Date Operators, Functions
Managing Oracle Views
Managing Oracle Sequences
Managing Oracle Synonyms
Managing Indexes and Clusters
Oracle Table Partitioning and Creating Partitioned Tables
Oracle Objects and Object Types
Prev
Character Functions
Next
Aggregate Functions
