Demos On 16th / 17th December
PIMPLE SAUDAGAR :    Hadoop BigData (09:00 AM)   |   AWS - Amazon Web Services (11:00 AM)   |   Selenium (11:00 AM)   |   Angular JS (11:00 AM)   |   Informatica (11:00 AM)   |   QTP (2:00 PM)      DECCAN :    Selenium (10:00 AM)   |   AWS - Amazon Web Services (1:00 PM)   |   DevOps (2:00 PM)   |   Manual Testing (2:00 PM)   |   UNIX Shell Scripting (2:00 PM)   |   SAP MM (3:00 PM)      
ISO 9001:2015 Certified Organization  |  Pearson Exam Center

DBMS: Oracle SQL

Overview

SQL is the basic fundamentals to deal with any Database Management System, it gives the understanding of database entity, data normalization and the basic functions which is been used in any DBMS. Oracle SQL is one of the best available DBMS which further separated in to two different tracks i.e. PLSQL in development track and DBA in Administration track. It is useful for any Programmer or Tester to get a better understanding of their work and technology.

Duration : (40 Hours)

Prerequisites : Basic computer Fundamental skills

Training Highlights : This course will give student maximum exposure to Oracle SQL as we cover all the topics as per course contents of Oracle corporation. Best trainers having IT Industry experience and they provide knowledge by giving real time examples, specially from Banking domain. Plenty of exercise material will be provided to the student to gain maximum exposure. Assistance will be provided for Oracle certification. Flexibility in batch timing for candidates working in shifts.

Course Syllabus

DBMS: 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 3RI