SQL Syllabus

                                             SQL Classes 

                                                     Oracle Sql & Sql Server
DDL (Data Definition Language)
•  Create
•  Alter
•  add
•  modify
•  rename
•  drop
•  Drop
•  truncate
DML (Data Manipulation Language)
•  INSERT
•  UPDATE
•  DELETE
•  MERGE
•  Function
•  Max()
•  Min()
•  length()
•  avg()
•  count()
•  substr()
•  sysdate()
•  instr()
•  trim()
Nvl Function
•  CONSTRAINTS
•  Column Level Constraint
•  Table Level Constraints
•  CASCADING CONSTRAINTS
•  NOT NULL Constraint
•  UNIQUE Constraint
•  PRIMARY KEY Constraint
•  CHECK Constraint
•  FOREIGN KEY Constraint
•  ALTER TABLE with CONSTRAINT
•  Enabling Constraint
•  Disabling Constraint
•  Group Function
•  Using NVL with group function
•  HAVING with Group Function
Subqueries
•  Single Row Subquery
•  Multiple Row Subquery
•  Group function using subquery
•  ALL with subquery
•  NOT IN with subquery
•  Join (Display Data from Multiple Tables)
•  String Handling
•  INNERJOIN
•  LEFTOUTERJOIN
•  RIGHTOUTERJOIN
•  EQUIJOIN
•  NON-EQUIJOIN
•  OUTER Join
•  SELF Join
•  Merge
•  Substitution Variables
•  Using VERIFY command
•  Using SET commands
•  Using Format commands
•  BREAK Command
•  Creating VIEW
•  SIMPLE VIEW
•  WHERE using View
•  DML operation using View
•  FORCE using View
•  Column Alias using View
•  GROUP FUNCTION using VIEW
•  WITH CHECK OPTION using VIEW
•  Inline View
•  Creating Sequence, Index, Synonym
•  How to use SequenceINDEX
•  UNIQUE INDEX
•  Function Based Indexes
•  Using SET Operator
•  UNION
•  UNION ALL
•  INTERSECT
•  MINUS
•  DISTINCT
•  Advanced Subqueries
•  Multiple Column Subqueries
•  Pairwise Comparison Subquery
•  Using a Subquery in FROM clause
•  Using EXISTS operator INSERT
•  Using EXISTS operator UPDATE
•  Correlated UPDATE and DELETE
•  Using WITH clause
•  Enhancement to the GROUP BY clause
•  GROUPING using GROUP BY
•  GROUPING SETS using GROUP BY
•  Controlling User Access
•  CREATE TABLESPACE
•  Privileges in Oracle
•  CREATE USER
•  GRANTS
•  ROLE
•  Change Password
•  Object Privileges
•  WITH GRANT OPTION Keyword
•  PUBLIC Keyword
•  REVOKE Object Privileges
•  Many more..