Toggle navigation
  • Courses
    • Certification Courses
      • 2D ANIMATION
      • Accounts Assistant Using Tally
      • ADOBE ILLUSTRATOR
      • Advance Excel
      • After Effects
      • Android - Application Development
      • AngularJS
      • ASP.Net
      • Automation Testing
      • BASIC OF COMPUTERS
      • C & C++ Programming
      • Cisco Certified Network Associate (CCNA)
      • COA
      • CorelDraw
      • DATA ANALYST
      • Data Science
      • Desktop Publishing(DTP)
      • Digital Marketing
      • Diploma In Tally With GST
      • Dreamweaver
      • Electrical Drafting
      • Embedded Systems
      • Ethical Hacking
      • EXPERT ROBOTICS
      • Financial Accounting Using
        Tally.ERP 9
      • FLASH
      • GK
      • GRAPHIC DESIGNING
      • HARDWARE
      • Hardware And Networking
      • HP-Embedded Systems
      • HTML
      • Installing & Configuring Windows Server 2012
      • IT FOUNDATION
      • J2EE
      • Java SE7 Programming
      • Java SE6 Programming
      • Java SE8 Programming
      • JavaScript
      • JUNIOR 2D ANIMATOR
      • JUNIOR ROBOTICS
      • KITTS-MS OFFICE
      • Learning SQL Programming
      • Matlab
      • Microsoft Project - 2016
      • MS Office
      • MS SQL SERVER
      • Network Associate
      • NETWORKING
      • Photoshop
      • PHP WITH MYSQL
      • Premiere
      • Programming In C
      • Programming In C++
      • Programming In JAVA
      • Python
      • R PROGRAMMING
      • React Js
      • ROBOTICS
      • Selenium Testing
      • SEO
      • SketchUp & V-Ray
      • Software Testing
      • Software Testing - UFT
      • SPOKEN ENGLISH
      • SQL Server
      • Tally ACE
      • TALLY ERP 9
      • Tally GURU
      • Tally PRO
      • Video Editing
      • VISUAL BASIC
      • Web Designing
      • Web Development
      • Windows Server Admin
    • Diploma Courses
      • DCA In Office Environment
      • DCA-GRAPHICAL DESIGNING
      • DIPLOMA IN AUTOCAD
      • DIPLOMA IN AUTOCAD ELECTRICAL
      • DIPLOMA IN COMPUTER APPLICATION (DCA)
      • Diploma In Computer Application-Accounting
      • Diploma In Computer Programming
      • Diploma In Digital Marketing
      • DIPLOMA IN DTP
      • Diploma In Hardware And Networking
      • Diploma In Multimedia And Animation
      • Diploma In Office Automation
      • HDCA
      • PG Diploma In Computer Applications
    • International Certification Courses
      • 3DS Max
      • ADOBE AFTER EFFECTS
      • Adobe Photoshop
      • Adobe Premiere
      • Android ATC
      • ANSYS
      • ASP.Net MVC Web
        Applications
      • AUTOCAD
      • AWS
      • BIGDATA HADOOP
      • CATIA
      • Cisco Certified Network Professional (CCNP)
      • CREO
      • HP -Data Structure Using C
      • HP-Android Application Development
      • HP-ASP.NET With C#
      • HP-Big Data Analytics (R Programming)
      • HP-Big Data And Data Science Courses
      • HP-Big Data Programming
      • HP-Core JAVA With Android
      • HP-J2EE Spring With Hibernate Framework
      • HP-J2EE Struts With Hibernate Framework
      • HP-Linux Administration With Scripting
      • HP-Network Concepts With Security
      • HP-Programming Techniques With C++
      • HP-VLSI, VHDL & PCB Design
      • IBM C
      • IBM C++
      • IBM C++
      • Maya
      • Microsoft Certification Program-Dot Net
      • MTA
      • ORACLE
      • Oracle-SQL Expert
      • PLC
      • Primavera P6
      • Revit
      • Software Testing (IBM)
      • SolidWorks
      • Structural Analysis And Design
    • Microsoft Offline Certification
      • Diploma In .Net And SQL
      • Microsoft Cloud Computing
      • MOS (Mirosoft Office Specialist)
      • MTA Software Development Fundamentals
      • VB.NET
    • Summer Courses
      • Cisco
      • KITTS Web Designing
    • Professional Courses
      • Computer Basics
      • KIDS Java Programming
      • Kitts C++ Programming
      • Office Automation
    • Diploma in Beautician and Hair Designer
    • Vmware
  • Student Signup
  • Blogs
  • Download
  • Login

ORACLE

  1. Home
  2. Courses
  3. ORACLE

Course Syllabus

Course Name: ORACLE                                   Duration: (6 months)

Course I :                    

SQL:

  • Retrieving 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

Course II:

SQL:

  • Retrieving 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
  •  

Admin I:

  • Introduction
  • Installing the Oracle Database Structure
  • Creating an Oracle Instance
  • Managing the Oracle Instance
  • Managing Database Storage Structure
  • Oracle managed file(OMF)
  • Creating a table space
  • Administering security
  • Managing Schema Objects
  • Types of Indexes
  • Managing Data and Concurrency
  • Locking Mechanism
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network environment
  • Proactive Maintenance
  • ADDM
  • Performance Management
  • Backup and Recovery Concept
  • Hot Backup
  • Cold Backup
  • Hands on practice
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Hands on practice
  • Flashback version query
  • Moving Data
  • Oracle Data pump

Admin II:

  • Introduction
  • Oracle managed files
  • Configuring recovery manager
  • Using recovery manager
  • RMAN backup types
  • Hands on practice
  • Recovering from non critical loses
  • Database recovery
  • Types of incomplete recovery
  • Flashback
  • Dealing with database corruption
  • Hands on practice
  • Monitoring and managing memory
  • Automatic shared memory management
  • Automatic performance management
  • Automatic workload repository
  • Managed schema objects
  • Hands on practice
  • Clusters
  • Managing storage
  • Automatic storage management
  • ASM disk group
  • Portioning a disk
  • Managing resources
  • Automatic task with scheduler
  • Database security
  • Transparent data encryption
  • Using globalization support
  • Hands on practice

 

S.No Exam % of mark to Certify Timing (in minutes)
1Oracle-Sql - Ora-01 5045
2ORACLE JAVA - Ora-02 5045
3Oracle Admin 1 - OCA1 5045
4Oracle Java Mock - OJM01 5045