Call Us:

+91 984-999-8237

-

18+ Years Corporate Experience in USA & India

Online Core DBA Training

Course Brief

Online Core DBA Training is unique @ DBA Technologies which is a blend of Indepth study of concepts with special reference to real world scenarios and practical live demos. All sessions are handled by Mr. Prasad Mynumpati and are highly interactive. You will be proficient in day to day activities of a DBA such as Database Architecture, Oracle and OS Installation, Backup and Recoveries, day to day trouble-shooting activities, ASM, Data Guard, Patching, Cloning, Upgrades and Migrations. You will be learning Oracle Virtualization setups and Network File Sharing and many more...

Course fee: $650 (with Dedicated Server Access)

paypal

  • Content
  • Videos
  • FAQs
  • Interview QA
  • SQL Videos
  • Linux Videos

Week 1:

Session 1 - Architecture I:
button Terminology, Oracle Instance, System Global Area, Mandate memory structures, Optional memory structures, Process, Background processes, foreground processes, daemons, Oracle Database, Control files, Redo log files, data files, Oracle Server. Minimum number of file requirements and corporate standards. One database vs. multiple databases. Physical database and logical database. Purpose of each Tablespace and contents, Application data, Meta data and base tables

Session 2 - Architecture II:
button Quick overview on previous session. User process and server process, Relationship between Instance and database, data access path from client to server, Background process, role and responsibilities of each process. SQL queries processing methodology and architecture, role of optimizer, hard parsing and soft parsing.

Week 2:

Session 3:Installations of OS (OEL 5.4), ORACLE 11gR2:
buttn Identifying certified operating system, Understanding My Oracle Support for certifications, CSI numbers, Understanding operating system installation procedures for oracle database, Configuring operating system (kernel parameters), creating users, creating groups, Installing OEL 5.4 and Oracle database Software 11gR2. Understanding init.ora (initialization files) files, important parameters in parameter file, purpose of Alert log files, location of Alert log files, Maintaining Alert log files, diagnostic destination location, trouble shooting techniques (handling ORA-), oracle related errors and Directory structure of Oracle home. Database startup and shutdown methods and stages involved. Database storage in terms of Tablespaces, Tablespace block sizes, default block size and non default block sizes. Understanding various types of views DBA_, ALL_ and USER_ including v$ dynamic views.

Session 4 - Database, Tablespace Management:
button Database Startup, shutdown procedures with internals, creating, adding, altering and dropping Tablespaces. Tablespace modes, status, logging, plugged in, contents, block size, online, offline, read only, read write, type etc. Database objects – Code objects, Data objects, Hybrid objects and its storage management. What is a segment, extent and data storage mechanism and maintaining the data growth? Data reorganization in Oracle database. Dictionary managed tablespaces, locally managed tablespaces (auto, uniform), Storage parameters and OMF.

Week 3:

Session 5 - User Management:
button User management in corporate world, type of users, creating database users, Authentication methods (local authentication, OS authentication, network authentication). Managing privileges and different types of privileges such as object level privileges and system level privileges. Using Roles for privilege management, Identifying assigned privileges using views for a given user. Understanding profiles and implementing profiles.

Session 6 - UNDO Management:
button Understanding UNDO tablespace features like read consistency, rollback operations, flashback options such as flashback query, flashback version query, flash back transaction query, flashback database, flashback data archive. Setting up FRA area and the purpose. Rollback segments, Pending offline status. Retention policy, Retention guarantee, sizing UNDO tablespaces, addressing ORA-01555 snapshot too old issues.

Week 4:

Session 7 - SPFILE, OMF Introduction to Oracle Networking:
button Purpose of spfile and different between spfile and pfile, Creating spfile and profile from each other, default locations vs. non default locations. Changing parameters using spfile and pfile. Understanding Dynamic, Deferred and offline changes and procedures. Purpose of OMF and advantages and disadvantages of OMF. Created OMF databases and tablespaces. Understanding networking architecture. Configuring network setup between client and server (listeners and tnsnames). Verifying configuration. Establishing network connections to database. Configuration files location and setting TNS_ADMIN for non default locations. Using lsnrctl prompt and maintaining services like status, start, stop and reload etc.

Session 8 - Password file management, Database Links and Materialized view:
button Purpose and concepts of password file, Setting up password file, verifying password file and purpose of password file in a network environment. Why Database Links are required, creating db links and configuring parameters and rules in implementing database links, corporate standards in maintaining database links. Use of Materialized views, refresh types such as (fast, force and complete) and implementation.

Week 5:

Session 9 - Multiplexing Of Redo, Control file and Archiving:
button High availability, protecting Redo log files, Control files using multiplexing to protect from disk failures. Understanding the dynamics of configuring redo log file groups and size. Protecting the content of redo log files by enabling archive log mode, file format and location of archiving and maintenance activities with respect to archiving.

Session 10 - Backup and Database Patching procedures:
button What to backup? Patching methodology, patch repository, patch top, applying cumulative patch (100+ patches). Backup procedures provided by Oracle, Logical backups and purpose, Physical backup’s architecture, understanding complete recovery vs. incomplete recovery, online recovery vs. offline recovery. Purpose of cold backup. HOT backups architecture.

Week 6:

Session 11 - RMAN backup and restore, database cloning:
button RMAN architecture and best practices in corporate world. Different types of recoveries such as complete recovery, incomplete recovery, online recovery and offline recovery. Dynamics of recoveries. Recovery Manager Backups (RMAN), RAMN setup and configuration, with catalog or out catalog. Corporate standards for RMAN backups. Catalog database, Target databases and Auxiliary databases. Performing backups and recoveries using all the methods (logical, physical and RMAN). RMAN Command reference such as list, report, delete etc. Database cloning using RMAN with database duplication as industry standard.

Session 12 - ASM:
button Database storage concepts. ASM (Automated storage management) concepts. Different storage options for database files like file system files, RAW partitions, OMF and ASM. ASM architecture, background processes, creating disk groups, mounting disk groups. Using ASMCMD and asmca GUI tool to manage ASM instances. Grid Infrastructure software installation and configuring ASM for standalone database for its storage.

Week 7:

Session 13 - DATA GUARD Active DG:
button Purpose of Data Guard, Architecture, Physical Standby database setup, Active data guard features. Various protection modes such as Max Performance, Max Availability and Max Protection.

Session 14 - Performance Tuning I:
button Introduction to performance tuning with best possible approaches. Understanding troubleshooting vs. tuning. Best practices, requirements, different levels of performance tuning. Sharing real world personal experiences on tuning techniques. OS level base line statistics, database level maintenance methods with best practices, database level statistics, indexes, optimization methods, Row chaining and migration, DOP (parallelism), monitoring and configuring parallelism related parameters.

Week 8:

Session 15 - Performance Tuning II:
button Role of DBA with respect to application tuning. Explain plans; enabling trace at session level understanding performance statistics during tracing. Understanding TKPROF output. Memory tuning, Automated shared memory management (SGA, SGA+PGA), different types of caches for performance improvement such as keep cache, recycle cache and result cache.

Session 16 - Database Upgrade:
button Database upgrade from 10gR1 to 11gR2

Course FAQs

1. Who is the faculty?

Mr. Prasad Mynumpati (Founder of DBA Technologies) is the senior faculty will be conducting all the sessions. Mr. Prasad is having about 18+ years corporate experience in USA and India. For more details please visit www.dbatechnologies.net and choose “About US”.

2. How is the training conducted?

Online training is conducted using interactive web conferencing software, Trainers desktop will be shared. An URL will be shared with WEEK, SESSION, TOPIC, participant. Each session is with in-depth conceptual discussions with practical demo.

3. What if I have trouble in installation or doing any exercise?

No issues, you can mail us we will get back to you ASAP, if a session is required to address a particular issue we will schedule one and address the same.

4. What about software?

OS (OEL 5.4), ORACLE 11gR2, ORACLE 11gR2 GRID and ORACLE VM BOX Software download instructions are part of the manual.

5. Do I get material for practicing exercises?

Yes, you will be provided with a soft copy manual that which contain all the required lab exercises to get familiar with each topic that is been discussed during session.

6. What if I miss a session?

Upon request recorded session will be available; this is only if you miss a session.

7. Any pre requisites for this course?

Participant should be familiar with Basic UNIX and SQL commands. These are part of the manual. UNIX commands are must because most of implementations are on UNIX flavor of OS and SQL is required to retrieve the data from dictionary views or from dynamic views. In case if participant is not familiar with basics we would provide guided step by step video sessions on basics. In case of any assistant in understanding the same will be provided.

8. What else is required to join the session?

Good quality headphone and microphone to listen the session and to interact with faculty.

Click here for Core DBA OCP / Interview Questions
  • Student Testimonials
  • Video Testimonials
Sreedevi Vemula-USA
I attended Core DBA training online from DBA Technology. I really like the way Mr.Prasad's explain's the concepts. He has very good command on teaching the subject which reflects his experience. All their lab demo videos are very good. I am glad that I attended the training
Basheer K-UAE
It was good experience to learn DBA from DBA Tecnologies.Mr.Prasad teaches every topic with real time examples which is easy to understand.I thanks to DBA TECHNOLOGIES for giving such platform for learning Oracle Technology and make a confident to making the carrier as oracle dba.Regards,Muhammed Basheer.
Sunil Inchal-USA
In my 20 years of IT career, I have attended many trainings by big names like IBM etc. I found Mr. Prasad’s training the best amongst all that I attended so far. This is a NO-NONSENSE training. If you want to become a successful Oracle DBA, I strongly recommend to join Mr. Prasad’s training. I guarantee you will not regret your decission. I took one-on-one training since I wanted a fast track option. Mr. Prasad made himself available at odd hours (Since I’m in USA) and answered all the questions in a way even a novice can also understand.Thank you Mr. Prasad.
Chetana Kakade-USA
This is a wonderful place to get started to know anything and everything about Oracle. Please continue doing this Mr.Prasad. You are doing a wonderful job. The practical sessions shared by Mr.Anurag are just awesome (You need a big applause!) and one would like to store those for their future reference. Hence it would be great if you could share those videos with us rather than just screen casting. Also try installing all the softwares while on sessions so that one can start their practice without any delays..
Gbenga Akindele-USA
Am here in United State but my contact with DBAtechnology under the tutelage of Mr. Prasad has so rewarding for training on core oracle dba11g. He personally handle all the classes, he has the loaded skill for teaching and he is very meticulous with his teaching. He will give you all the time in the world to ask all your questions. I will surely recommend this training center for anyone in need of a good place to acquire skill as oracle dba, distance is no barrier as all my classes were online real time and it was as if am in a physical classroom.Thank you.Gbenga
Vikash Prasad-Fiji Islands
DBA Technologies is an amazing place to start off with Oracle Database Administration learning, i should say that they are a wonderful set of people who are aimed at taking up any challenge to address all doubts and confusions of their students and get your prepared for DBA's daily challenge. I learnt about DBA Technologies after a massive search through the web to locate a organisations that will make Oracle DBA learning simple, interesting and up to the latest production environment trend. After analyzing all responses that i got from online enquiries, i found there was something special with DBA Technologies and i registered for the course
Kanakadas Y
Searching APPS DBA training institute from quite long time in Chennai.Saw Mr.Prasad sir APPS DBA demo in youtube, got very much impressed and Joined Online APPS DBA training.After two weeks of training, started getting very much confident on the apps dba and even I started applying method and procedure told by sir in my current project.Prasad sir teaching methodology is outstanding and crystal clear.He take all real time scenarios to explain APPS DBA concepts.Thank you very much sir, if Projects or company demands, I will under go Golden Gate training
Shakeel Mohammed
Pursuing Oracle 11gR2 RAC dba course at dba technologies was tremendous and to be precise quality training.Mr.Prasad has unique way in providing training. Quality training in terms of explaining concepts, real time scenarios and oracle materials and labs.After pursuing training from Mr.Prasad, I have immense confidence managing RAC databases and complex scenarios.I truly recommend every DBA to pursue Oracle Core/RAC/Apps trainings from Mr.Prasad and this will take us to a different level of working in real time.I am looking forward to pursue Goldengate and many more trainings from Mr.Prasad in future.
Narayanan Palakode V - USA
My Name is Narayanan, Palakode Venkataraman from USA. I was looking for the Oracle RAC/ASM online training course and found that DBA Technologies offers the same. It was a 5 weeks course, each session topics were selected well and were sequenced properly. I was greatly benefitted by attending the course.Mr.Prasad knowledge on the subjects, communication, delivery of the contents,clarification of doubts, off the class support in setting up VM Box,Gust OS,CS,ASM,RAC systems , and engaging the students during the class were outstanding. Group discussion and live demo during the class were good and those learning can be applied to real time situation. Mr.Prasad has both practical and sound theatrical knowledge and is very rare in the training industry.At the end of the course my knowledge on Oracle RAC/ASM and confidence level to support RAC/ASM databases were very high. I would recommend anybody to take the course from DBA Technologies on RAC/ASM. Regards, Narayanan, Palakode Venkataraman
AbdulMoid Mohammed - India
I was struggling to find a better institute for Oracle DBA.After a strong search I found few among which one is quit famous(intentionally dont want to reveal its name) at ameerpet.After attending a demo I come to a conclusion that to catch the points in that massive class I should be a robot .Because there I found paying attention and getting interacted with the lecturer is such a tedous job. One day,one of my friends suggested me to join a demo at "DBA TECHNOLOGIES".Mr PRASAD is such a mentor who easily make his student involve into the subject becoz his way of delivering topics are really impressing.Real time topics are covered and LAB facility is full day. I always wanted to be a part of a game not to just watch a game and I achieved same in "DBA technologies". Thanks, Mohammed
Ramu R - USA
Prasad sir is very experienced and knowledgable. I got a quality Oracle RAC training . The way he is explained is very nice and training sessions more interactive. The main thing about his training he thought best practices and standards and more focused on practical. Thank you sir for providing good training.
Medhanie - Eritrea
This is Medhanie from Eritrea....DBA Technologies is one of the best institute i attend in hyderabad ... Prasad Sir`s teaching is very professional and more believable. Anurag has provided his best and repeats the concepts till we understand. They provide more care and attention for the students and the lab is provided as per our convenience.
Janardhan Sunkara-USA
This is Janardhan, I took Oracle DBA and RAC online training at DBA Technologies. This training was really good. Firstly, I am thankful to Mr. Prasad Mynampati and Anurag. I am felt more comfortable with RDBMS Core,RAC concepts and practicals after interacted with Prasad and Anurag. The way he teaching DBA concepts is really amazing because he took real time scenarios and share his experience with folks so that it gives me more insight into the technology and it is easy for me to remember the concepts. DBA technologies is always ready to assist us. The instructors at DBA technologies are very polite and patience. They are always ready to clear our doubts and solve our issues with the practicals with good real time examples. Another good thing in this training is that they ever rush in order to complete course. In sessions, Mr. prasad taught slowly and he ensure that every folk in the class is understanding the concepts and It helps me a lot because that I am a average student. Moreover, Mr. Prasad is a good affectionate communicator. So that I always feel free to ask all my doubts that in my mind whether it is big or small doubt and he also always feel more happy to address all my doubts. Once again I am thankful to Mr. Prasad and Mr. Anurag. I appreciate DBA technologies for their continuous services to IT field.
Ahmed Abdulla - India
I am a student at DBA Technologies... I think there are a lot of institutes in India that are Specials for Oracle databases, but the difference comes in how to deliver the information and choose the right place to receive these concepts.. So through my studies for a period of more than three months at the Institute I would like to tell you that the Institute is the best and by the way each class was very good and there were a lot of example and scenarios to make us understand very well.. . So for those people who are interested about oracle Cora DBA, RAC and APPSDBA,I recommend to them DBA Technologies.
Vijay - Singapore
Prasad is very knowledge and during training sessions he has not only given attention to detail but also explained live scenarios. I have joined with no DBA knowledge and after 4 sessions I cleared interview as a DBA with one year of experience. Thanks Prasad.
Raza - Switzerland
If you want theory and hand on practice, then you are at the right place. Mr Prasad is an exceptional trainer by any standard.
SEETARAM CHILUKURI
I have got more than 10 years of IT experience in Applications Administration. When it comes to Database Administration, I would say DBA Technologies is the ULTIMATE destination with no second thought. No corporate trainings can come close to DBA Technologies with respect to the QUALITY being delivered here. The commitment and passion that is shown in building up a student is amazing and incomparable. Students walked out of DBA Technologies after successful completion of their training should be very confident to involve in any kind of technical discussions in their entire career path. It is definitely my personal feeling and I would strongly recommend that any fresh graduate as well as those who are in the industry for a while, DBA Technologies is the RIGHT destination to have a strong foundation and to make the journey of their career smooth and confident.
Peraka Sunil
I am Sunil and worked as Linux and Windows Administrator for 4 years. In thirst of upgrading my skills, I planned for doing Oracle DBA. I enquired with different Institutions regarding this and came to know that everybody teaches the subject. After interacting with counselor at DBA Technologies(DSNR), I was satisfied that it is not just they teach but they give real-time scenarios to understand the subject very well. Thanks to Phani Raj, who gave me insight of the subject during the counseling. After having 7 years of experience, I thought that knowing Architecture of any technology is important and the same was dealt excellent by Prasad.M sir. I am really thankful for him for giving deep insight of Architecture. Apart from this it was great with Anurag, who added spice to the subject and been with each of us in the Lab. I deeply feel that everyone has played important role in expanding my knowledge. Thanks to all
Anilkumar Gupta
This is Anil Kumar ,I am working as a SoftwareTest Engineer thought to switch into another platform that is DBA,one of my cousin suggested me to join in DBA Tecnologies at Disukhnagar who is working as a DBA at present.He told me that one of the best institutes for Dba course is DBA technologies Hyderabad the best institute to get into and Excellent faculty and excellent lab facility at Dilsukhnagar Branch, Thanks to MR.Prasad Sir he always takes the real time scenarios and good examples which helps in remembering the concepts, Mr. Anurag our Another faculty conducts the demo following by concepts taken by Mr. Prasad which is very good which in getting understand the subject,I strongly recommend DBA Technologies for people who are looking to join in DBA course.I once again thank Prasad sir and Anurag sir,especially Anurag sir for supporting us in Lab and sharing his knowledge with us. Thanks and Regards, Anil Kumar Gupta.
A Venugopal Reddy - USA
I lived in U.S. for almost 35 years. I have 15 years experience in Oracle products. I worked in Oracle Corporation in U.S.A/ I took many courses through Oracle Education. I am trying to convey that here the DBA concepts are well taught by the owner and instructor Mr.Prasad Mynumpati, who is the best instructor I have seen so far in my life Software Training experience in Hyderabad city. ... I recommend all the young engineering undergraduates to take this Oracle DBA training only at this institute. This will be the best place to start building the future.
Vasu - Boston USA
DBA Technologies is a very good place to learn DBA for freshers. Prasad sir and altaf are very helpful while teaching and lab. They donn\'t hesitate to repeat the topic If you donn\'t understand for first time and I recommend DBA Technologies for any one who want to learn especially freshers.
Gary Adams - USA
I was a student in the Oracle DBA 11g online course. Our instructor Prasad is extremely knowledgeable in all things Oracle and he explained the material clearly and concisely. He took the time to make sure each student understood the material completely and made complicated topics very easy to understand. Prasad made certain that you not only understood all the material but that you would be able to apply everything that you learned to your real work environment. I would highly recommend Prasad and DBA Technologies for anyone who wants to become an Oracle DBA professional.


© 2014 DBA Technologies. All Rights Reserved.              

free hit counter

Website Design by BWT