Oracle – media3training

  • Contact : +91-9032 0661 66, +91-9959 4999 33

    • ORACLE

    Media3 stands as a proactive, growth-oriented organization aiming at professional excellence with a pool of talented and dedicated work force. Our key strengths are motivated associates; value based work ethics, experienced personnel (live tech leads) and state of the art infrastructure.

    ORACLE

    ORACLE DATABASE 12c

    INTRODUCTION TO DATABASE

    BASIC SQL COMMANDS

    SUB LANGUAGES IN SQL

    • DDL
    • DML
    • DRL/DQL
    • DCL
    • TCL

    DATA TYPES IN ORACLE

    GENERAL FUNCTIONS

    • NVL
    • NVL2
    • NULIF
    • COALESCE
    • CASE
    • DECODE

    CHARACTER, NUMBER AND DATE FUNCTIONS

    INTEGRITY CONSTRAINTS

    • NOTNULL
    • UNIQUE
    • PRIMARY KEY
    • FOREIGN KEY
    • CHECK
    • DEFAULT

    JOINS

    • EQUI
    • NON EQUI
    • SELF
    • OUTER
    • CROSS
    • NATURAL
    • INNER
    • SUB QUERIES
    • VIEWS
    • WORKING WITH INDEXES
    • SEQUENCE
    • INTRODCUTION TO PL/SQL
    • WRITING CONTROL STRUCTURE
    • CURSORS
    • EXCEPTION HANDLING
    • PROCEDURES
    • FUNCTIONS
    • PACKAGES
    • TRIGGERS
    • SQL LOADER

  • Course Features

    • Duration

      12 weeks

    • Live Projects

      Yes

    • Internship

      Yes

    • Limited Seats

    • Leave A Comment

      RELATED COURSE

    • GET IN TOUCH
      Call: 903 206 6166
      Mail: info@media3training.com

    • Head Office

      Media3 Empire,Kshatriya Kalayanamandapam
      Seethammadhara, Visakhapatnam – 530013

    • Hyderabad

      205, Aditya Trade Center, Ameerpet, Hyderabad,Telangana 500016,  90320  66166

    • Vijayawada

      Opp. Sweet Magic, DV Manor Road, Below Kotak Mahindra Bank, Bandar Road, Vijayawada, Andhra Pradesh  520002, 90320 66166,  90009 14648

    • Vizianagaram

      Suit-303, Vijaya Mansion, Opp.Commercial Tax Office,LIC Complex  Back Side, Lower Tank Bund Road, Siddarth Nagar, Vizianagaram 535003,  90320 66166

    • Kurnool

      9642668768, 9121099933

    • Tirupathi
      D/No:7-43-46, Venkatadri Plaza Building Main Road, near Flipkart Office, Mangalam, Tirupati, Andhra Pradesh 517501
      9642668768, 9121099933

      • Rajahmundry

      47-7-47, Upstairs of AYASYA showroom ,PARK road Danvaipeta,Rajahmundry 9542055666, 8555003678

      • ©2020 Media3 International Pvt. Ltd. All rights reserved.