Oracle Database 11g: New Features this course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems ensuring high availability and more.
Oracle 11 g DBA Online/Classroom Training
₹21,999.00
1452 in stock
1452 Students |
Duration: 30 hours |
Lectures: 30 sessions |
Video: Recordings would also be shared |
course completion would be given after the training |
- Basic understanding of databases
- Working knowledge of RDBMS concepts & SQL
- Working knowledge of Oracle 9i or 10g
The Oracle database environment
- Reviewing basic architecture concepts
- Oracle 10g Architecture
- Main features of 9i and 10g
Basic SQL*PLUS commands
- Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL
Basic SELECT Statement
- Writing the statement in sql plus, Running the SELECT statement
Ordering the output
- Single Column, Descending order, multiple column sorts
Conditional retrieval of data
- Working with complex conditions, AND OR NOT LIKE BETWEEN
Working with variables
- Creating and using variables, Command substitution
Pseudo columns and functions
- Pseudo Columns, Row num, Sys date, User & UID, the Dual Table
- Working with character functions
- UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(),
TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE
- Working with date functions
- TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()
Using non-character function
- ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins
Using the SET operators
- Union, Intersect, minus
Aggregating data using group functions
- GROUP BY, HAVING
Creating Sub queries
- Single Row sub queries, Multiple row Sub queries
Enhancing groups function
- ROLLUP, CUBE
Transaction Control Language
- Rollback, Commit, save point
Processing hierarchies
- creating the Tree structure, LEVEL, CONNECT BY
Data Manipulation Language
- INSERT, UPDATE, DELETE
Data Definition Language
- CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE
Using Declarative Constraints
- Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS,USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized Views, Other Data dictionary views
Database Security
- Object Privileges, Granting access to objects
Improving query performance
- Planning and managing the tuning process, Employing tuning tools,
Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output,
Optimizer concepts, Fundamentals of access paths, Gathering object and system
statistics with DBMS_STATS, Utilizing hints and optimizer mode,
Specifying first-rows optimization, Determining the driving table
Other Concepts
- The Relational Database Model, The system Development Lifecycle, Overview of normalization
PL/SQL
Blocks
- Structure, Writing Anonymous Blocks
Variables
- Oracle Data types, TYPE and ROWTYPE declarations, Value assignments
Control structures
- IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement,
LOOP END , LOOP statement, WHILE condition, FOR condition
Cursors
- Implicit and Explicit Cursors, Cursor Manipulation statements,
OPEN FETCH CLOSE EXIT WHEN
Printing Values to Screen
Procedures
- Creating and Calling Procedures
Functions
- Creating and Calling Functions
Packages
- Package Header, Package Body
Design Tips and Techniques
- Format of standard packages in an application, Spec and Body, NOCOPY hint
Triggers
- Database triggers, calling procedures from triggers
Dynamic SQL
- EXECUTE IMMEDIATE, DBMS_SQL package
Oracle Supplied packages
- DBMS_OUTPUT, UTL_FILE
Collection data types
- Associative Arrays, Nested tables, VARRAYs
Vasudevan, USA
Just wanted to update you that I cleared my Oracle certification exam today. Jagadeesh – I would like to thank you for the training & guidance you have provided me throughout. thanks for introducing me to a brilliant trainer (Jagadeesh) and providing all necessary support.
Mohita, Australia
I have completed my Testing training with Kumar and I am very satisfied with the quality of training and support that he gave me. I am now in a very confident position to begin my career in Testing Platform. Because of the quality of the training I received, I will be recommending friends and colleagues to take up similar courses with your training provision
Rashel, Australia
As being of your customer, I am really happy with Mr Rao and his capabilities and the Datastage training capability. Training over the online, it is not only matter of providing training…there should have some sort of caring and relationship with end user which Mr Rao has got in a full pace… Thanks Mr Rao. I really appreciate your help. We will be in contact.
Anupama, Singapore
We have completed the Teradata training as per the curriculum. Thanks a lot Girish for your detail explanation, i hope you continue the same after, in-case any doubts.
Ahmed, USA
Testing Selenium is complete now. 1) I am impressed by your sincere dedication to make students understand the concepts and then testing the students by conducting the mock interviews & QA… I have not seen this type of dedication anywhere. 2) Your quick replies on any technical questions helped me alot. 3) Your soft, humble manners made me give you a name. In my friends circle, I refer you as a Professional Center for Testing Training.
Mahendra, USA
Please be informed that, I have finished the basic Java course with Krishna. He has done a good job. I am on a Project now, however, I will go through the recorded session, as and when I find time and reach him for any clarification required
James, USA
Syam Kumar did a wonderful job in training the DBA class. He was eloquent, knowledgeable and extremely helpful in making sure we understand every concept. I would definitely recommend the class to my peers.
Asim, Aus
My Salesforce Admin training has been completed and the consultant, Mr.Vasant is very supportive. He explains each and every concept in detail with practical examples. He provide lots of help while practicing topics. Finally in fact he has very sound technical knowledge. He satisfies each query and do not ignore any question till student get full understanding.
Dharan, Aus
Thank you for delivering the SAS course. Your delivery method was excellent and the course material covered I believe is enough for me to start as a SAS Professional. The best thing was that you were organised and you stuck to the schedule. I will now complete few excercises as discussed over the next two weeks to wrap it off.
Danny, USA
The Informatica instructor is clear and on target, overall the training sessions were excellent. Just scheduling is some times difficult,but at the end i would say the training was satisfactory and i could able to learn configuration in detail.I am happy to refer others to this course with you guys.
Sneha, USA
I am quite satisfied with the OBIEE training. Abhinav is good at explaining the concepts with simple examples which make us understand clearly and he is always ready to accept and clear the doubts. Sessions are being very interactive and informative.
Reviews
Average Rating
Detailed Rating
Stars 5 |
|
0 |
Stars 4 |
|
0 |
Stars 3 |
|
0 |
Stars 2 |
|
0 |
Stars 1 |
|
0 |
There are no reviews yet.