SQL - JOINS

SQL - Transaction Control Statements - Commit, set, autocommit, on/off, rollback, savepoint

SQL - Correlated Subqueries

SQL - JOINS

SQL - Multiple Row SubQueries( ANY, ALL , EXIST, NOT EXISTS, IN, NOT IN )

SQL - Single Row Sub Queries (Where, having, select)

SQL - Views in single table

SQL - HAVING clause

SQL - Date Functions

SQL - Creating a new calculated field for a table

SQL - Creating a sub table from an existing table

SQl - IN and NOT IN keywords

SQL - String Functions in Oracle

SQL - Rename, Alter, Update Queries in SQL

Compiler Design - LR(0) Parsers - Bottom Up Parsers.

Compiler Design - SLR Parsers - Bottom Up Parsers

Compiler Design - Operator Precedence Parsers

SQL - Constraints(Check -like, in, Default, Not Null, Primary Key, Referential Integrity (FK))

DBMS - Extended ER features - Specialization, Generalization, Constraints( 4 types) , Aggregation

LL(1) Parsers

SQL - Create (without constraints) , Insert, Delete, Drop, Select - Simple queries

DBMS - Reduction of ER Diagrams to Tables - Relationship Sets, Cardinalities & Participation(Part 2)

DBMS - Constraints in a Relational Model

DBMS - Weak Entities, Reduction of Weak Entities to Tables

DBMS - Keys (Candidate, Primary, Super and Foreign Key)