Disable Preloader
ORACLE 12C

Oracle 12C DBA supports cloud computing and enable unparalleled software and hardware efficiencies, which gives it the strength to provide high performance. In this Oracle training, students learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Oracle Database 12C offers businesses a comprehensive and power way to merge databases and manage them effectively over the cloud. This new database architecture is enabled with in-memory data processing capabilities that take data analytics to the next level. Businesses can improve their performance, security, efficiency and data availability significantly with Oracle Database 12C


Module List

  • Pre Installation Configuration
  • Database Creation
  • Oracle network services
  • Connecting Tools To Database
  • Use Management And Security
  • Oracle Instance
  • Redo log File Management
  • Control File Management
  • Table space Management
  • Backups

ORACLE 12C Course Details

    • Basic history of database concept: DBMS, RDBMS, ORDBMS
    • Advantage of ORACLE database and version information
    • Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad
    • 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

    • 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

    • 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

    • 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.
    • Multi table Joins, Complex Joins – How to simplified complex joins.

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

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

    • pagesize, linesize, column heading , column format , colsep
    • tTitle, bTitle, break on column, spool , CSV file generation, Text file generation

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

    • DDL: CREATE, ALTER, RENAME, DROP, TRUNCATE
    • DEFAULT OPTION.
    • Constrain table copy

    • 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

    • 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

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

    • Creating Users
    • Granting / Revoking Privileges
    • Creating and Granting Privileges to a Role

    • Tables, Views, Synonyms, Index, Sequence, Constrains, Source and other Dictionary

    • UNION,
    • UNION ALL,
    • INTERSECT,
    • MINUS

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

    • Group by with ROLLUP,
    • Group by with CUBE,
    • GROUPING SETS

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

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

    • Unconditional INSERT ALL
    • Conditional INSERT ALL
    • Conditional FIRST INSERT

    • SQLLDR – Loading CSV file / Flat file into ORACLE table.

    • WM_CONCAT, LAG, LEAD, RANK, DENSE_RANK
    • Query_by partition_clause with sum, min, max, avg, count,
    • order_by_clause with sum, min, max, avg, count,
    • Psudo column: Rownum, Rowid, - Elimination duplicate data
    • Connect by rownum, Connect by Level – Generating random numbers, random dates,
    • Quote Operator syntax and usage

    • Export / Import SCHEMA

    • What is migration?
    • Migration Estimating, Planning, Preparation – Simple Scenario / Complex Scenario.

Training Advantages
35 contact hours
Industry Case Studies
Industry case studies
Real time training

ORACLE 12C FAQ'S

    Oracle is one of the powerful application that is used all around in the world in a number of business verticals like banking, retail, automobiles, power, etc. It gives business the much needed competitive edge for decision making through swift information gathering and data processing.

    Being a course of complex nature, the student is expected to have prior knowledge in any of the Oracle applications. Hands on experience or knowledge in Oracle 10g, 11g, 12C, etc. will help the student in quick learning.

    On completion of this course, a student will have adept knowledge in Oracle database administration. They will become experts in data warehouse management, server configuration, application clusters, Enterprise Manager Grid control software, etc.