ORACLE COURSE DETAILS

SQL

  • Retriving data using the SQL select statement
  • Restricting and sorting data
  • Using single row function to customize output.
  • Reporting aggregated data using the grout function.
  • Displaying data from multiple tables –I
  • Displaying data from multiple tables-II
  • Using sub queries to solve problems
  • Using set operators
  • Manipulating data
  • Using DDL statements to create and manage tables
  • Creating other schema objects
  • Managing objects with data dictionary
  • Controlling User access
  • Managing schema objects
  • Manipulating large data sets
  • Generating report by grouping related data
  • Managing data in different time zones
  • Retrieving data using sub queries
  • Hierarchical retrieval
  • Regular expression support

PL/SQL

  • Introduction
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Writing Explicit Cursors
  • Writing Implicit Cursors
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Managing Subprograms
  • Creating Packages
  • More Package concepts
  • Oracle supplied Packages
  • Manipulating Large Objects
  • Creating Database Triggers
  • More Trigger concepts
  • Managing Dependents

    Regular Classes

  • 3 Months
  • Weekend Classes

  • 30 Days (4 Hours of class)

    Training By Certified and Experienced Real Time Developer

  • Our Trainer Conduct Classes according to Current Market Scenario and shape your Career.
  • Working on Live Project

  • We provide Live Project Development that helps our student to build their career as Developer
  • Interview Preparation Classes

  • We Conduct Technical Events like quiz competition, Debates that enhance your knowledge about technology
  • We conduct Interview preparation classes by our Recruitment Department that aware you, how to crack the interview
  • 100% Job assistance on every Course

  • Our IT Staffing Team all time working for our Student's job placement
  • Future Guidance

  • We provide one year free student membership forLatest Technology Enhancement
  • Smart Class Rooms

  • We provide wifi enabled class rooms.
Provide your information
Powered by DLK TECHNOLOGIES