Oracle DBA OCP Training near me in Pune, India

Oracle syllabus SQL Contents * Oracle History * Oracle Architecture - SGA - PGA * The detailed overview of SQL * Different types of SQL - DDL - DML - TCL - DCL * SQL commands for different types of SQL * Practical Implementation of each command * Row filtration using WHERE clause in SQL * Data Types available in SQL * Sorting methods using ORDER BY clause in SQL * Operators available in SQL * Precedence of Operators * Various SQL Functions - Character - Number - Date Conversion -Aggregate - General Functions * GROUP BY and HAVING clauses of SQL * Set operators - UNION - UNION ALL - INTERSECT - MINUS * Oracle Joins - Equijoin - Non-equijoin - Self-join -Natural join -Cross join - Outer join - Left Outer - Right Outer -Full outer - Inner join - Using clause - On clause * All subqueries - Subqueries on multiple columns (Pairwise Comparision) - Subqueries in the FROM clause - Correlated SUB Query - Scalar Subqueries * Top N analysis * WITH clause introduction * EXISTS and NOT EXISTS operators * Global Temporary Tables * ANALYTICAL FUNCTION : - RANK - DENSE_RANK, - FIRST - LAST - LAG - LEAD - LISTAGG - ROLLUP - CUBE - grouping_id - Rowid vs RowNum * Views - Let's modify an existing view - Create View from more than 1 Table * Materialised view - Build - Refresh Mode - Materialized view log * High water mark PL/SQL * Introduction – PL/SQL Architecture * Declaring Variables PLSQL block * Writing Executable Statements * Interacting with Oracle Server * Writing Control Structures * Comments in PLSQL * Variable Scope * Using GOTO * Using the CASE Statement * Using the If-Then-Else * Using the If-Then-Else * Working with LOOPS * Continue Statement * Working with Composite Data Types Cursor * Cursors Implicit * Understanding the Concept and Purpose of Explicit Cursors * Learn about Cursor Attributes * Creating and Using Cursor Parameters * Cursors with Records * Looping with Cursors Exceptions * Difference between Global vs Local Objects and Exceptions * Handling Exceptions * What Are the Types of Exceptions * Creating User-Defined Exceptions * Using SQLCODE and SQLERRM Objects Procedures & Functions * Creating Procedures * Input and Output of procedures * Understanding the Parameter Specification * Standalone procedures * Creating Functions * Managing Subprograms * Overloading the Subprograms * What are Functions & Procedures and Why We Use Creating Packages * Creating & Using & Modifying & Removing the Packages * Visibility of Package Objects * Illegal Object Reference & Forward Declaration * Package Initialization * How Can I Find the Packages? Triggers * Creating Database Triggers * Types of triggers * Statement & Row Level Triggers * Using New & Old Qualifiers in Triggers * Using RAISE_APPLICATION_ERROR Procedure in Triggers * Using WHEN Clause in Triggers * INSTEAD OF Triggers * Exploring & Managing the Triggers * Compound Triggers * Handling Mutating Table Errors Advance PL/SQL What is SQL Tuning and Why to Do That? * How an SQL Statement is Processed * What is "cost" in detail * Plan Generator * Execution Plan and Explain Plan in Details * V$SQL_PLAN View Indexes * Table Access Full * Table Access by ROWID * Index Unique Scan Oracle Database Architecture * PGA * SGA * Shared Pool * Buffer Cache * Redo Log Buffer Tuning : * Collection * Introduction to BULK COLLECT feature * Implementation of BULK COLLECT in PLSQL program * FOR ALL loop with BULK COLLECT * Dynamic SQL * Partitioning * Ref Cursors * Understanding of PLSQL Tables * Arrays * Nested Tables * Associative arrays * Some part of tuning * Bind variable * Function based index * Some part of Hints About Me: Having 9 + Years of experience in MNC IT company I am working as Team Lead - Oracle Project. I am providing training for Oracle, SQL, PL/SQL, Advanced PL/SQL, And Unix Shell. I am providing classroom training as well as On-line training. There are a lot of assignments which will you understand database flow and work in the Software industry.

I'm Principal Consultant working full time in one of the world's largest product based company. Having more than 14 years of experience in IT industry. I have given number of corporate training both internal and external. I can impart real fruitful training which is going to help the person n delivering the project efficiently and on-time .

I am searching to teach oracle dba , i have 4 year of experience in oracle dba core in all aspects .

AWS, Oracle Core DBA Core DBA all Activities i.e RMAN, Export- Import, ASM, Flashback Technology, RAC, Data-Guard, Techno-Functional Analyst with proven success in handling various E projects. More Years of Experience in Oracle HRMS in Core HR, Payroll, Self-service Core areas of skill are: Collecting the requirements, analyzing, defining the problem areas, working out the logical solution, proposing the solution based on the technology available and suitable, planning the design, development, testing, implementing and maintaining the Enterprise Solutions Development of Oracle Alerts, Development of Oracle Reports, Defining Profile Option Defining Key-Flex Field, Descriptive Flex Fields as needed, Personalization of Oracle Seeded Forms, AME Development, Database Trigger, Application Trigger Development Involved in Preparing Technical Documents and Functional Documents Like MD50 and MD70 Documents. Writes code, completes programming and performs testing and debugging of applications.

We have trained tutors who have 5-10 years of experience in Oracle DBA. They are currently working in different IT firms as well as teaching. We will soon be opening our training center in pune but as of now we are teaching from home.

Oracle / sql server T-SQL / SQL PLSQL / linux Admin / Shell Scripting / ORACLE DBA OCP certified professional http://srisri-dba.blogspot.in/

Provided professional Oracle DBA and PL/SQL training in MNC companies and externally in the batches. Conducted many batches where most of the folks are joined in many reputed IT companies.

Unisoft education ventured in certification lead IT training since it’s inception on 14th September 2000. Based out of Nagpur, during the initial years we were known as HAT sellers (only of RED color) and a misplaced high end IT training institute. People found us ahead of times and out of world. In last 12 years we have produced more than 25000 highly successful IT professionals working with best known IT companies across the globe. These success stories includes under-graduate, discontinue education to talented young engineering students. In last 12 years we participated in numerous high-lows and we took every stride as an active participant. We have contributed as a responsible industry player and helped candidates in carving out successful career irrespective of industry turbulence. We are a resource rich, technological updated and adaptive IT training solution organization. We have a network of 15 training centers in 7 states. Our most of centers are market leaders in their respective locations and give formidable challenge to NIITs and likes. Research based innovation, consistent industry interaction helps in developing training program which deliver the high level of customer satisfaction. Our alliance with global major like Oracle, Redhat, Pearson, Prometric, ETS help our students in getting the world’s latest curriculum. Armed with latest certification and supported by our HR practices (mock interviews, aptitude training, Job fest, alumni references) most of our candidates get the best available jobs. Our karm-mantra is based on Honesty and Hard work. We take our employee as our first customers and customers as business partners. We keep it simple and straight. Students get placed because of quality hardwork they invest and we get business because our students know it better than most. IT industry which is most employing industry till has distinct attribute of creating equal number of semi skilled unemployable human resource. The people who are partially trained, are the big market opportunity, to cater these people Unisoft’s career programs like ADNSM, ADHNT, UltraMCA are industry acclaimed and hugely successful individual IT training solutions. Unisoft touches 10000+ lifes every year and help each of them in achieving next level of the career journey. For us each student is just like a new wave on sea sore giving meaning to sea’s existence.

I am working in Oracle Database world from last 5 year. I have strong knowledge on Architecture, RMAN, backup, recover, restoration, standby, data guard. Also have hands on shell scripting to write down script for automation.

I was working with KPIT Cummins, since past 3.5 years, as an Oracle Database administrator as well as a corporate trainer. I have conducted successful training session in Oracle as well as subjects like Design thinking. I volunteer with Make A Difference, I have been also involved in teaching English to the underprivileged kids since past 2 years. I would love teaching opportunities where in I can benefit the students by sharing whatever knowledge I can. I am comfortable with students of different age and experiences , I understand it takes time to learn, but it's all worth it. Please feel free to contact me in case you need help or have any doubts regarding any subjects or career path, I would love to help.

I have 5 years of experience in SQL and PLSQL programming in Oracle/MySQL Databases. I believe that my each and every student should be at par or even better than me in writing SQL Queries and PLSQL blocks once I teach them. They should not be feared of any exam or interview that they face. Believe me, I will make you think on your own. No Bookish knowledge.

I presently work as Oracle DBA with an MNC and have intensively researched, worked and learned on various database technologies. Feel free to leave a message for any clarifications/doubts.

Igniter InfoTech offers best and most comprehensive software training and placement providing institute in technologies like Oracle, AIX, Linux for aspiring IT students and IT professionals. Online and classroom based training to candidates with real time scenarios and real time projects. Igniter has designed its courses ensure with proper training and education people can pass the certification and fulfil their job role efficiently . Our commitment for your success blended with industry experienced trainers with vast experience in their respective fields pave the path for success. Igniter has an established and talented pool of Trainers with high technical proficiency and professional certification. Igniter InfoTech ensures that students gain hands-on-experience through the sessions with lot of simulations which helps students to apply the learning obtained. With state-of-the-art infrastructure and excellent lab facilities, we are able to deliver the best of services to our students. Courses provided by Igniter InfoTech are effective and career focused. We are pioneer in Oracle/AIX/Linux Training with greater flexibility, higher efficiency and lower costs. We are dedicated in providing the best conceptual training courses on Oracle.

Strong knowledge on oracle DBA I am a certified oracle trainer Certifications from oracle Corporate experience in various DBA activities like Upgradation, cloning, Backup and Recovery, Flashback, Moving data and multiplexing.

Having Proficient Skill in the following. 1. RAC 2. Non-RAC 3. GoldenGate 4. MongoDB(NoSQL DB) 5. Performance tunning 6. Recovery and Backups 7. DB Upgrade 8. Oracle 11g, 12c Architecture 9. Export/Import 10. etc...

CRB Tech provides Oracle DBA OCP Training , Oracle DBA OCM Training , Oracle DBA OCA Training , Java Training Classes , Software Testing classes and Computer Maintenance Training .

X Q L DBA Traning Provides MySQL DBA Training , Oracle Training , Oracle DBA OCP Training , Oracle DBA OCM Training , Oracle DBA OCA Training to all Students.

CHETAN MALI provides Oracle Training,Oracle DBA OCP Training to all students.