Pay Fees After Satisfaction With Interview Guidence

Oracle Sql && Sql Server Download

DDL (Data Defiend 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 Sequence
  • INDEX
  • 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..
  • Programming Course

  • C/C++ RS: 3500
  • CORE JAVA, J2EERS: 5500
  • HTML5,CSS3,JQUERY,PHPRS: 6000
  • WordpressRS: 5000
  • C SHARPRS: 4500
  • ASP.NETRS: 5000
  • AndroidRS: 7000
  • Angualr JsRS: 6000
  • ASP Dot Net MVCRS: 8000
  • Unix/LinuxRS: 5000
  • Oracle(SQl)RS: 4000
  • Oracle(PL/SQl)RS: 5000
  • InformaticaRS: 12000
  • Jquery & Java ScriptRS: 4000
  • Spoken EnglishRS: 4000
  • Aptitude RS: 2800