Call Us at : 9872606864, 9417801342, 0161-460 6864

Mail Us at : aptechludhiana@gmail.com

Oracle Database 12c

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.

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

 

Curriculum

INTRODUCTION TO ORACLE SQL-12C
  • 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
ORACLE DATABASE ADMINISTRATION-12C
  • 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
ORACLE ADVANCE DATABASE ADMINISTRATION-12C
  • 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
ORACLE PL/SQL-12C
  • 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

CAREER GUIDANCE


Course Duration:

Oracle database  is a 6 month course, depending on the specialisation chosen & the number of classes held per week. Classes are typically held 2 hours a day/ 3 days a week

Eligibility

10+2/ graduates/ undergraduates

Job Opportunities:

Database Manager