Greens Technologys Anna nagar Whatsapp
Demos On August Month
ANNA NAGAR:    Oracle(10:00 AM)   |    AWS(11:00 AM)   |    Selenium (11:00 AM)   |    Angular JS (1:00 PM)   |    Advanced Java (2:00 PM)   |    DevOps(4:00 PM)   |    Data Science(4:00 PM)   | DECCAN :    Selenium (11:00 AM)   |    Java (11:30 AM)   |    Python (12:00 AM)   |    AWS (1:00 PM)   |    DevOps (2:00 PM)   |    PHP (3:00 PM)   |    Angular JS (4:30 PM)   

Oracle SQL

Course Overview

Awarded as the Best Oracle Training Center in Chennai - We Guarantee Your Oracle Training Success in Chennai

Rated as No 1 Oracle Training Institute in Anna nagar for certification and Assured Placements. Our Job Oriented Oracle training in Anna nagar courses are taught by experienced certified professionals with extensive real-world experience. All our Best Oracle training in Anna nagar focuses on practical than theory model.

Course Features

  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Missed Sessions Covered
  • Multiple Batches
  • Flexible Timings
  • Practice Course Material
  • Assistance will be provided for Oracle certification.



PREREQUISITES:

  • Basic Computer Fundamental Skills

Duration:

  • 80 Hours
  • Who can join this course?

    • Individuals who want to become DBA

    Course Syllabus

    Oracle SQL
    1. Writing Basic SQL SELECT Statements
      • SQL Overview
      • Arithmetic Expressions
      • NULL Value
      • Column Alias
      • Concatenation Operator
      • Literals
      • Eliminating Duplicate Rows
    2. Restricting and Sorting Data
      • WHERE clause
      • Logical Operators
      • SQL Operators
      • LIKE Operator
      • AND, OR and NOT Operators
      • ORDER BY Claus
    3. Row Functions
      • Character Functions
      • Number Functions
      • Date Functions
      • Conversion Functions
      • General Functions
    4. Displaying Data from Multiple Tables
      • Types of Joins in Oracle
      • SQL Joins
    5. Aggregating Data Using Group Functions
      • Group Functions
      • Group By Clause
      • HAVING Clause
    6. Subqueries
      • Single Row subqueries
      • Multiple Row Subqueries
      • Correlated Subqueries
    7. Manipulating DataManipulating Data
      • INSERT Statement
      • UPDATE Statement
      • DELETE Statement
      • MERGE Statement
      • Transaction Control
      • Locks
    8. Creating and Managing Tables
      • Data Definition Language
      • Data Types
      • CREATE TABLE Statement
      • ALTER TABLE Statement
      • Rename an Object
      • Comments
    9. Including Constraints
      • Primary Constraints
      • FOREIGN KEY Constraint
      • NOT NULL Constraint
      • UNIQUE Constraint
      • CHECK Constraint
      • ALTER statement
      • Dropping a constraint
      • Disabling Constraints
      • Enabling Constraints
      • Cascading Constraints
      • Viewing Constraint
    10. Views
      • Creating a View
      • Retrieving Data from a View
      • Modifying a View
      • Destroying a View
      • User‐View
    11. Other Database Objects
      • Sequence
      • Index
      • Synonyms
    12. Controlling User Access
      • Privileges
      • System Privileges
      • Object Privileges
      • Role
    13. Using SET Operators
      • UNION Operator
      • UNION ALL Operator
      • INTERSECT Operator
      • MINUS Operator
    14. Oracle Datetime Functions
      • Oracle 9i Date time Support
      • CURRENT_DATE
      • CURRENT_TIMESTAMP
      • LOCALTIMESTAMP
      • DBTIMEZONE and SESSIONTIMEZONE
      • EXTRACT
      • FROM_TZ
      • TO_TIMESTAMP and TO_TIMESTAMP_TZ
      • TO_YMINTERVAL & TZ_OFFSET

    Inquire Now

    

    Student's Reviews about Greens