Aptech Chowringhee - Best Institute for Oracle Certification in Kolkata

1
(No Transcript)
2
ORACLE
3
ABOUT ORACLE COURSE
72 of I.T. Recruiters demand certifications.
Jumpstart your career in the 58 Billion database
management market with ORACLE CERTIFICATIONS. Ora
cle, the leading provider of Object-Relational
Database Management Systems (ORDBMS), offers
courses for both entry level students and
experienced professionals in domains like
database administration, programming, Web
Development and other advanced technologies. Grab
the requisite skill-sets and become globally
certified, job-ready I.T. professional
4
COURSE COVERS
5
ORACLE DATABASE INTRODUCTION TO SQL (40 HOURS)

• Retrieve data using the SQL SELECT command
• Restrict Sort Data
• Use single-row functions to customize output
• Use conversion functions ad conditional
  expressions
• Repost aggregated data using the group functions
• Display data from multiple tables
• Use subqueries to solve queries
• Use the set operators
• Use DDL statements to create manage tables
• Create other schema objects

6
ORACLE DATABASE ADMINISTRATION WORKSHOP-1 (40
HOURS)

• Install Oracle grid infrastructure
• Create Manage users
• Install configure an Oracle Database
• Create manage storage structures
• Administer the Oracle Database
• Understand the Oracle Database archietecture and
  how its components work and interact with one
  another
• Perform backup recovery

7
ORACLE DATABASE ADMINISTRATION WORKSHOP II
(40 HOURS)

• Diagnose repair data failures with Flashback
  technology
• Manage space to optimize database storage so you
  can respond to growing space requirements
• Monitor and manage major database components,
  including memory, performance resources
• Secure the availability of your database through
  appropriate backup and recovery strategies
• Automate DBA tasks with the Scheduler

8
PROGRAM WITH PL/SQL (40 HOURS)

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

9
ORACLE FORMS DEVELOPER BUILD INTERNET
APPLICATIONS (40 HOURS)

• Customise forms with user input such as check
  boxes, list items, radio groups and Pluggable
  Java components
• Integrate Java into Forms applications using
  JavaBeans
• Control navigation, data access, validation and
  transactions by creating event-related triggers
• Enable Forms applications running on the Web to
  access files and applications on the client
  computer
• Display Forms elements and data in multiple
  canvasses and windows

10
Contact Us
Address 16C Ashutosh Mukherjee Road 1st Floor,
(Near Homeland Mall) Entrance for side lane
Kolkata - 700 020 Phone [phone] / 56 /
57 Mobile  [phone] Email
mailbox_at_aptechchowringhee.com
11
Thanks For Watching
Music http//www.bensound.com