CCNA training in Kochi | CCNP training in kochi www.emigonetworks.com | Emigo Networks | CCIE Training in Kochi, Cochin, Kerala | CCIE, CCNP, CCNA, MCSE, MCITP
 

Oracle Database: SQL

Oracle Database SQL Training in Cochin at Emigo Networks is the best place to do your Oracle Database SQL Certification Training because of its practical real time examples with latest updated Oracle Database SQL Course Content. Oracle Database SQL Training course is designed from basic to advance level topics which suits both beginners and professionals.

.

  ORACLE SQL TRAINING COURSE CONTENT

  SECTION1: INTRODUCTION

  • Describe the features of Oracle Database 12c
  • Describe the salient features of Oracle Cloud 12c
  • Explain the theoretical and physical aspects of a relational database
  • Describe Oracle server€™s implementation of RDBMS and object relational database management system (ORDBMS

  SECTION2: BASIC DATABASE CONCEPT AND SQL

  • Basic history of database concept: DBMS, RDBMS, ORDBMS
  • Advantage of ORACLE database and version information
  • SQL Language overview : DQL, DML, DDL, DCL, TCL
  • What is the usage of ANSI standard
  • SELECT Command – Column Alias Rules, String data
  • Concatenations with various data
  • Null Value handling with number and characters
  • Arithmetic Operator
  • Concatenation Operator
  • Eliminating Duplicate Rows

  SECTION3: RESTRICTING AND SORTING DATA

  • WHERE Clause – Character Strings and Dates, number
  • General Comparison Conditions = >>= <<= <>
  • Other Comparison BETWEEN , IN , LIKE , NULL
  • Logical Conditions AND OR NOT
  • ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns

  SECTION4: SINGLE-ROW FUNCTIONS

  • Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE
  • Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
  • Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date
  • Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
  • General Functions: NVL , NVL2 , NULLIF, COALESCE
  • CASE Expression, DECODE
  • Nested function with real-time usage

  SECTION5: JOINS

  • EQUI JOIN / SIMPLE JOIN / NORMAL JOIN
  • ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER
  • NATURAL JOIN, NATURAL OUTER JOINS
  • INNER JOIN, JOIN … USING clause, JOIN … ON clause
  • CROSS JOIN, NON-EQUI JOIN, SELF JOIN
  • ORACLE STANDARD OUTER JOINS

  SECTION6: MULTI-ROW FUNCTIONS

  • Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
  • Creating Groups of Data: GROUP BY Clause
  • Filtering Group Results: The HAVING Clause

  SECTION7: SUB-QUERIES

  • Single-Row Subqueries- Rules, Operators : = >>= <<= <>
  • Null Values in a Subquery
  • Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL

SECTION8: DATA MANIPULATION LANGUAGE DML AND TRANSACTION CONTROL LANGUAGE TCL

  • DML : INSERT, UPDATE, DELETE, MERGE
  • TCL : COMMIT, ROLLBACK, SAVEPOINT

  SECTION9: DATA DEFINITION LANGUAGE – DDL

  • DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE
  • DEFAULT OPTION

  SECTION10: CONSTRAINTS

  • NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
  • Column Level Constraint, Table Level Constraint €“ Naming constraints and usage
  • Adding a Constraint, Dropping a Constraint
  • Disabling Constraints, Enabling Constraints
  • Validating Constraints

  SECTION11: VIEWS

  • Simple Views and Complex Views €“ Create, Drop, Source Code
  • Rules for Performing DML Operations on a View
  • WITH CHECK OPTION , WITH READ ONLY
  • Inline Views
  • Materialized View €“ Create, Refresh, Drop – Usage

  SECTION12: OTHER DATABASE OBJECTS

  • Sequence- NEXTVAL and CURRVAL
  • Index – When to Create an Index, When Not to Create an Index.
  • Synonyms

  SECTION13: DCL COMMANDS

  • Granting / Revoking Privileges

   SECTION14: SET OPERATORS

  • UNION
  • UNION ALL
  • INTERSECT
  • MINUS

   SECTION15: ADVANCED DATE-TIME FUNCTIONS

  • TIME ZONES
  • SYSDATE, SYSTIMESTAMP
  • CURRENT_DATE , CURRENT_TIMESTAMP
  • Storing time zone data in Table

   SECTION16: ADVANCED GROUP BY CLAUSE

  • Group by with ROLLUP AND CUBE
  • GROUPING SETS

   SECTION17: ADVANCED SUBQUERIES

  • Pairwise Comparison Subquery
  • Nonpairwise Comparison Subquery
  • Correlated Subqueries
  • EXISTS , NOT EXISTS Operator

   SECTION18: HIERARCHICAL RETRIEVAL

  • Walking the Tree: From the Bottom Up , From the Top Down
  • LEVEL Pseudo column
  • Connect by prior

   SECTION21: MULTI-TABLE INSERT

  • Unconditional INSERT ALL
  • Conditional INSERT ALL

  SECTION21: DATABASE NORMALIZATION

  • Advantages of Normalization
  • Normal Forms

  Key Features of our Oracle SQL Training in Cochin


RHCE training in kochi | CCIE training in kochi Emigo
All Rights Riserved @ 2017 Emigo Networks
Powerd byHost On Pdl.com