Oracle SQL

Database Fundamentals and Advanced Concepts with Oracle SQL

  • The expertise gained from this course will enable a rapid and competitive career growth path and advancement in software programming.

  • This course is designed to gain hands-on expertise in core fundamentals of Oracle and SQL and prepares for building real world applications from day one. We also prepare you for Oracle 11g SQL Certification exam as part of the course.

Batch Duration Start Date Timings
Batch 1 12 weeks Mar 6th, 2017 Mon to Fri
5:00pm-7:00pm

What participants will learn

With a heavy focus on hands-on excercises, the following topics are covered:
  • Creating Database Tables
  • Manage Database Objects
  • Data Access and Manipulation using SQL
  • Controlling User access
  • Oracle 11g: SQL certification exam preparation

Intended Audience

  • Professionals who want to build a quick grasp of database concepts on Oracle.
  • Students and recent Graduates who want to get a head-start in pursuing a career in software programming

Course Pre-requisites

  • The participants should have basic computer fundamental knowledge.

Course Details

  • Fundamentals of Oracle 10g/11g
  • The Power of SQL Functions
  • Constraints in Oracle
  • DQL, DDL, DML, TCL, DCL
  • Joins
  • Sub-Queries
  • Hierarchical and Recursive Queries
  • Pseudo Columns in Oracle
  • Working with SET Operators
  • Views
  • Indexes
  • Fundamentals Of Database Security
  • Synonyms
  • Sequences
  • OLAP Features in Oracle
  • Object Oriented Concept in Oracle
  • Dynamic SQL
  • Scalar Query
  • Deletion And Updation
  • Industrial Level Of Expertise with SQL

Venue Details

Location 1
Corporate Software Park,
Ashoka Plaza Tower B,
Next to Hotel Hyatt Regency,
Viman Nagar,
Pune-411014. Click here for Map
Location 2
La-Gloriosa Bldg,
Near Arnold's High School,
Kalyani Nagar,
Pune-411014. Click here for Map

Fees

Call for Pricing Info.
Subject to availability of seats. Registration is first come first serve basis.


Register Today»