Oracle Dba
Download Brochure
Download Sample Class
Book Free Demo Class
An Oracle DBA is a senior-level manager who often earns as much as a Vice President, and has lots of responsibility, managing the mission-critical data for the whole company.
Database Administration
- Installing Oracle Database 11g Software, Identify system requirements.
- Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- Identify and configure commonly used environment variables, Creating an Oracle Database
- Use SQL*Plus and iSQL*Plus to access the Oracle Database 11g.
- Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
- Use Optimal Flexible Architecture, Install software with Oracle Universal Installer.
- The Oracle Database 11g Administration is primarily intended for Oracle Database 11g administrators that have a strong foundation and expertise in the industry’s most advanced database management system.
- Installing Oracle Database 11g Software, Identify system requirements.
- Identify and configure commonly used environment variables, Creating an Oracle Database
Tasks of a Database Administrator
Module topics
- Exploring the Oracle Database Architecture, Preparing the Database Environment
- Creating an Oracle Database, Managing the Oracle Instance
- Configuring the Oracle Network Environment,
- Managing Database Storage Structures, Managing Data and Concurrency
- Managing Undo Data, Implementing Oracle Database Security, Database Maintenance
- Performance Management, Intelligent Infrastructure Enhancements
- Backup and Recovery Concepts, Performing Database Backups, Performing Database Recovery.
- Overview of Data Recovery Advisor, Use Data Recovery Advisor to Perform recovery(Control file, Redo log file and Data file), Moving Data
Oracle 11g – Developer
- Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data.
- These features will help you query and manipulate data within the database, use the dictionary
- views to retrieve metadata and create reports about their schema objects.
- Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL
Overview
- Create reports of sorted and restricted data, Run data manipulation statements (DML).
- Control database access to specific objects, Manage schema objects.
- Manage objects with data dictionary views. Retrieve row and column data from tables.
- Understanding the basic concepts of relational databases ensure refined code by developers. This course helps the participants to write sub-queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Controlling privileges at the object and system level are also dealt with in detail.
Module topics
- Retrieving Data Using the SQL SELECT Statement, Restricting and Sorting Data.
- Using Single-Row Functions to Customize Output,Using Conversion Functions and Conditional
- Expressions
- Reporting Aggregated Data Using the Group Functions, Displaying Data from Multiple Tables.
- Using Subqueries to Solve Queries, Using the Set Operators, Manipulating Data.
- Using DDL Statements to Create and Manage Tables, Creating Other Schema Objects.
- OEM – Enterprise Manager Oracle 11g.
- Oracle 11g New Features Programming Language Support, Oracle 11g PL/SQL New Features.
- Oracle SQL optimizer (CBO) Improvements, Oracle 11g Business Intelligence & OLAP, Oracle
- 11g data mining.
Oracle Database 11g Advanced PL/SQL
- This Oracle Database: Program with PL/SQL course begins with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language.
- Expert Oracle University instructors will teach you how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- You’ll also enhance your developer skills by learning to develop, execute and manage PLSQL stored program units like procedures, functions, packages and database triggers.
- Understanding the basic functionality of how to debug functions and procedures using the SQL
- Developer Debugger gives way to refined lines of code
Module topics
- Use PL/SQL packages to group and contain related constructs.
- 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 and 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 and functions.
- Create PL/SQL applications that use collections.
- Implement a virtual private database with fine-grained access control.
- Write code to interface with external C and Java applications.
- Write code to interface with large objects and use SecureFile LOBs.
- Write and tune PL/SQL code effectively to maximize performance.
Rolla Academy Dubai
Al Tawhidi Building II - 201 - 2 Al Mankhool Road - دبي
-
I'm happy with the training which I received from Rolla Institute Dubai. The trainer Lagiru good with the subject and the manager is very helpful. I recommend … More Rolla for everyone.
-
Rolla Academy is the best platform to prepare IELTS in the entire Dubai Area.
Specially, Dear Surjit Singh Sir, Thank you for refilling my confidence in me. You … More are a wonderful tutor and i always appreciate your guidance and encouragement . -
My experience at Rolla Academy Dubai was very good as I took up few IELTS classes by Mr. Surjith Sir who taught me everything from the start. He made the learning … More experience easy and quick by providing materials and earphones to listen to the audios during listening test. Overall it was a very good experience as I got to work on my mistakes and learn more
-
First of i would like to thanks Mr Surjit sir for extra ordinary teaching support, guidance, easy IELTS trics and the way of teaching style is awesome. Becouse of … More this great teaching style finally i
achieved my Academic IELTS result with good score. Rolla academy staff is very friendly and helpful. Once again thanks to Professor Surjit Sir IELTS tutor and Mr Suddam ( Rolla academy) and all faculty professiors. -
From the beginning I wasn’t sure if I can actually learn digital marketing until Rolla Academy assigned Abishek as my trainer this young man is full of knowledge. … More
The school manager has the best personality I have seen for a very long time
He handle every complain with respect ✊
I will really recommend this school for any of your learning specially digital related
Thank Rolla academy -
Am happy and so blessed for having discovered Rolla Academy Dubai,great thanks to my teacher Mr.Mohamed Irfan,what sets him apart is his unwavering dedication to … More us the student success.Throughout the course, he fostered a supportive, inclusive learning environment where by questions from me as a student were not only welcomed but he encouraged them,Mr.Irfan took the time to address each inquirythoroughly ensuring that am not left behind at any topic in miscrosoft,He was so kind,gentle,polite,patient with me because the fact I joined his classes when am so ignorant about computer and all the basics but he helped me to Excel.I am so thankful to Mr.Irfan for his attentiveness in every interaction making for a truly enriching learning experience. Thanks alot to Mr.Irfan and to Rolla Academy to help me Excel in fact am looking forward to enroll with Rolla to an Advanced level.
-
I recently completed the MS Office Basic course at Rolla Academy Dubai, and I must express my gratitude to Surjit Sir and the entire academy team! The course was … More comprehensive, well-structured, and Surjit Sir's teaching style made complex concepts easy to understand.
The practical insights and hands-on experience gained during the sessions were invaluable. Surjit Sir's dedication to ensuring each student's understanding is commendable. Thank you for making learning MS Office a seamless and enjoyable experience.
I highly recommend Rolla Academy Dubai for anyone looking to enhance their skills. Thank you, Surjit Sir, and thank you, Rolla Academy Dubai!
More Courses You Might Like
40 hours
Oracle E-business Suite Financials R12 (end-user)
END USER LEVEL COURSE: 1. Accounts Receivable (05 Hours) Invoice Process Flow • Invoice creation process • Revenue Recognition • Credit memo creation process • Invoice conversion, Multi Org • Receipts • Lock box for receipts • Reports 2. General Ledger (05 Hours) • Create a Chart Of Accounts • Define the Accounting Calendar •
30 hours
Oracle Purchasing Course
Duration: 25 Hours Oracle Procurement – EBS R12 Overview of Oracle Purchasing Supplier Management Supplier Modification Item Attributes and Setup RFQ & Quotations Approved Suppliers & Sourcing Rules Purchase Requisitioning Processing Purchase order Processing Purchase order Receipt Processing Integration with other Modules Enterprise Structure overview Raising I-procurement Requisitions Receipting PO in I-Procurement Non-Catalog Requests Purchasing
30 hours
Oracle Finance
Oracle Corporation groups these applications into “suites”, which it defines as sets of common, integrated applications designed to execute specific business processes.
