sql syllbus

                                               SQL Syllabus 

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

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