Oracle SQL Training

Course Detail
Oracle SQL Training
(500 Review)

ABOUT THE COURSE

  • After completion of training program on Oracle 11G-12C SQL , students and professionals will get the most and the best from their accounting skills.
  • Oracle 11G-12C SQL training from JAGJIT INSTITUTE Delhi is cost-competitive.
  • Course Completion Certificate to every student and carries global recognition.
  • Oracle 11G-12C SQL Training can be customized after analyzing the company-specific requirements
  • Industry Specific specially tailored Oracle 11G-12C SQL training modules.
  • Highly qualified and certified trainers on Oracle 11G-12C SQL with expertise in our instruction methods.
  • At no extra cost, the needy students can repeat the classes with prior permission.
  • For the students to get maximum benefit from the training, One-on-One attention is given to each student.
  • Well maintained Smart Labs with latest equipment where individual can flourish their practical knowledge with hands on practice.
  • To make students become well aware of the complex working scenarios in the work field, we establish strong practices in enhancing their technical skills and concepts on the subject.
  • PG Facilities available in the nearby vicinity for students coming from other states for Oracle 11G-12C SQL Training in Delhi.
  • Our Oracle 11G-12C SQL Course content is structured to cover all the modules within Oracle 11G-12C SQL. From basic to advance, we give Oracle 11G-12C SQL training in Delhi in a manner that is easy to understand.

Below is the detailed course content for Oracle 11G-12C SQL

SQL SELECT Statement
  • Lecture 1:
    Operator Precedence
    30 Minute
  • Lecture 2:
    Example - Operator Precedence
    30 Minute
  • Lecture 3:
    Literal Character Strings
    30 Minute
  • Lecture 4:
    Quote (q) Operator
    30 Minute
  • Lecture 5:
    Pattern Matching Using the LIKE Operator
    30 Minute
  • Lecture 6:
    ESCAPE Identifier
    30 Minute
  • Lecture 7:
    Rules of Precedence
    30 Minute
WHERE Clause, Operators and Sorting (Order by) 
  • Lecture 1:
    ORDER BY For NULLs
    30 Minute
  • Lecture 2:
    Positional Sorting
    30 Minute
  • Lecture 3:
    Substitution Variables
    30 Minute
  • Lecture 4:
    Demo of Substitution Variable in SQL developer
    30 Minute
  • Lecture 5:
    Specifying Column Names, Expressions, and Text
    30 Minute
  • Lecture 6:
    DEFINE Command
    30 Minute
  • Lecture 7:
    Using the VERIFY Command
    30 Minute
Using SQL Functions
  • Lecture 1:
    Character-Manipulation Functions – Advanced
    30 Minute
  • Lecture 2:
    Number Functions – Advanced
    30 Minute
  • Lecture 3:
    RR Date Format – Century Calculation Rules
    30 Minute
  • Lecture 4:
    Date-Manipulation Functions – Advanced
    30 Minute
  • Lecture 5:
    Using the TO_CHAR Function with Dates – Advanced
    30 Minute
  • Lecture 6:
    Nesting Functions
    30 Minute
Conversion Functions and Conditional Expressions
  • Lecture 1:
    General Functions – Advanced
    30 Minute
  • Lecture 2:
    Conditional Expressions
    30 Minute
  • Lecture 3:
    Advanced – Searched Case Expression
    30 Minute
  • Lecture 4:
    DECODE Function
    30 Minute
Group Functions & Group by Clause 
  • Lecture 1:
    Group Functions and Null Values
    30 Minute
  • Lecture 2:
    Group by Clause Usage notes – I
    30 Minute
  • Lecture 3:
    Group by Clause Usage notes – II
    30 Minute
  • Lecture 4:
    Where vs Having
    30 Minute
  • Lecture 5:
    Nesting Group Functions
    30 Minute
SQL Join Operations
  • Lecture 1:
    ANSI Joins
    30 Minute
  • Lecture 2:
    Creating Natural Joins
    30 Minute
  • Lecture 3:
    Creating Joins with the USING Clause
    30 Minute
  • Lecture 4:
    Using Table Aliases with the USING Clause
    30 Minute
  • Lecture 5:
    Creating Joins with the ON Clause
    30 Minute
  • Lecture 6:
    Creating Three-Way Joins with the ON Clause
    30 Minute
  • Lecture 7:
    Joining a Table to Itself – Self Join
    30 Minute
  • Lecture 8:
    Self-Joins Using the ON Clause
    30 Minute
  • Lecture 9:
    Simple Join - Equijoins
    30 Minute
  • Lecture 10:
    Join – Nonequijoins
    30 Minute
  • Lecture 11:
    Returning Records with No Direct Match with Outer Joins
    30 Minute
  • Lecture 12:
    LEFT OUTER JOIN
    30 Minute
  • Lecture 13:
    RIGHT OUTER JOIN
    30 Minute
  • Lecture 14:
    FULL OUTER JOIN
    30 Minute
  • Lecture 15:
    Creating Cross Joins
    30 Minute
Using Sub queries
  • Lecture 1:
    The HAVING Clause with Subqueries
    30 Minute
  • Lecture 2:
    INLINE VIEWS
    30 Minute
  • Lecture 3:
    Advanced Subqueries
    30 Minute
  • Lecture 4:
    Correlated Sub Query
    30 Minute
  • Lecture 5:
    Multiple Column Sub Query
    30 Minute
Set Operators
  • Lecture 1:
    Set Operators rules
    30 Minute
  • Lecture 2:
    Matching the SELECT Statement
    30 Minute
  • Lecture 3:
    Arithmetic vs SET operators
    30 Minute
DMLs and TCLs
  • Lecture 1:
    Inserting Special Values into table
    30 Minute
  • Lecture 2:
    Copying Rows from another Table
    30 Minute
  • Lecture 3:
    Updating Two Columns with a Subquery
    30 Minute
  • Lecture 4:
    Updating Rows Based on another Table
    30 Minute
  • Lecture 5:
    Deleting Rows Based on another Table
    30 Minute
  • Lecture 6:
    Savepoint and Partial Rollbacks
    30 Minute
  • Lecture 7:
    Explicit Transaction Control Statements
    30 Minute
  • Lecture 8:
    Rolling Back Changes to a Marker
    30 Minute
  • Lecture 9:
    Read Consistency
    30 Minute
  • Lecture 10:
    FOR UPDATE Clause in a SELECT Statement
    30 Minute
  • Lecture 11:
    Examples of different Database Objects
    30 Minute
Examples of different Database Objects
  • Lecture 1:
    DDL- Naming Rules
    30 Minute
  • Lecture 2:
    Creating Tables with sub query without copying data
    30 Minute
  • Lecture 3:
    Data Types
    30 Minute
  • Lecture 4:
    Defining constraints at Table Level
    30 Minute
  • Lecture 5:
    FOREIGN KEY Constraints – Advanced
    30 Minute
  • Lecture 6:
    Alter - Read-Only Tables
    30 Minute
  • Lecture 7:
    Dropping a Table – Advanced
    30 Minute
Views, Synonyms, Sequences & Indexes
  • Lecture 1:
    Simple Views and Complex Views
    30 Minute
  • Lecture 2:
    Creating a Complex View
    30 Minute
  • Lecture 3:
    Performing DML Operations on a Complex View
    30 Minute
  • Lecture 4:
    Using the WITH CHECK OPTION Clause
    30 Minute
  • Lecture 5:
    WITH READ ONLY clause
    30 Minute
  • Lecture 6:
    SEQUENCE – Advanced
    30 Minute
  • Lecture 7:
    When to use CURRVAL
    30 Minute
  • Lecture 8:
    Index – Notes
    30 Minute
  • Lecture 9:
    Index Creation Guidelines
    30 Minute
  • Lecture 10:
    Index - Advanced
    30 Minute