Oracle

SHORT TERM COURSES

  • Oracle

Oracle is one of the most popular database management systems used around the globe. It is used to store and retrieve large amount of data in information management.

Oracle

The Oracle courses train you to meet the high demand for Oracle professionals in the IT industry.

Courses:



You can choose one of our short term Oracle courses as per your learning needs:


Introduction to Oracle SQL-11g (OCP)


What you learn?
  • Understand the basic concepts of relational databases
  • Create reports of sorted and restricted data
  • Run data manipulation statements (DML)
  • Control database access to specific objects
  • Create & query external tables

Duration

2 months



Oracle Administration Workshop 1-11g (OCP)


What you learn?
  • Install Oracle Grid Infrastructure
  • Create & manage users
  • Install, configure & administer Oracle Database
  • Create & manage storage structures
  • Perform backup & recovery

Duration

2 months



Oracle Administration Workshop 2-11g (OCP)


What you learn?
  • Diagnose & repair data failures with Flashback technology
  • Manage space to optimize database storage
  • Monitor & manage major database components, including memory, performance & resources

Duration

2 months



Oracle PL/SQL-11g (OCA)


What you learn?
  • Understand conditionally control code flow (loops, control structures)
  • Use PL/ SQL packages to group & contain related constructs
  • Create triggers to solve business challenges
  • Use Oracle supplied PL/ SQL packages to generate screen & file output
  • Create anonymous PL/ SQL blocks, functions & procedures
  • Declare PL/SQL variables

Duration

2 months



Introduction to Oracle SQL-12c


What you learn?
  • Understand the basics of relational databases to ensure refined code by developers
  • Create reports of sorted & restricted data
  • Run data manipulation statements (DML)
  • Control database access to specific objects
  • Manage schema objects, and objects with data dictionary views
  • Retrieve row & column data from tables
  • Control privileges at the object & system level
  • Create indexes & constraints
  • Alter existing schema objects
  • Create & query external tables

Duration

2 months



Oracle Database Administration-12c


What you learn?
  • Oracle Database Architecture & essential database administration tasks
  • Manage database in Oracle Cloud
  • Upgrade an existing Oracle Database to Oracle Database 12c
  • Create & manage an Oracle Database Instance
  • Create & manage storage structures
  • Configure Oracle network environment
  • Create & manage users
  • Monitor database & manage performance
  • Basic information on backup & recovery techniques

Duration

2 months



Oracle Advance Database Administration-12c


What you learn?
  • Backup & recover Oracle 12c database & administer a multi-tenant environment
  • Manage security & performance in Oracle Database Cloud
  • Develop & implement appropriate backup & recovery procedures to address business needs
  • Diagnose & repair data failures
  • Employ Oracle Database recovery procedures to recover from media & other failures
  • Use Flashback Technologies & data duplication
  • Secure database availability

Duration

2 months



Oracle PL/SQL-12c


What you learn?
  • Understand conditionally control code flow (loops & control structures)
  • Use PL/SQL packages to group & contain related constructs
  • Create triggers to solve business challenges
  • Use Oracle supplied PL/SQL packages to generate screen & file output
  • Create anonymous PL/SQL blocks, functions & procedures
  • Declare PL/SQL variables
  • Manage PL/SQL subprograms, triggers, declaring identifiers & trapping exceptions
  • Understand & influence PL/SQL compiler and manage dependencies
  • Create anonymous PL/SQL blocks, focusing on stored procedures & functions

Duration

2 months



Eligibility:

Undergraduates/ graduates/ working professionals/ engineers

Job opportunities:

On completing an Oracle course, you can build a successful career as:

  • SQL developer
  • PL/ SQL developer
  • Database administrator

Interested to join an Oracle course?

Fill the enquiry form to get a call from our career counsellors.

Onlinevarsity - your e-way to learning Aptech provides the new way of learning for all its students! Onlinevarsity is Aptech’s learning app that provides free access to all course-related study material. In addition, students can be part of an online community & interact with industry experts 24X7!

Career Guidance

By clicking on Submit, I allow Aptech Computer Education to call me and send program information on email/sms/phone.

Located outside India? Email your contact details to enquiry@aptech.ac.in







Free Aptitude Test
 

Free Aptitude Test

  • Is an IT career good for you?
    Take this free aptitude test to find out

    Click here

Facts about the IT Industry

  • Indian IT industry worth US $143 billion in 2016*
  • E-commerce to create at least 150,000 additional jobs
  • IT & BPO sector to add 30 million new jobs by 2020

*Source: NASSCOM

know more ›

Back to Top