Oracle database admin course

ORACLE DATABASE ADMIN COURSE CONTENT Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in ORACLE DATABASE ADMIN COURSE CONTENT 1: Creating the Database 2: Starting Up and Shutting Down • Viewing the Quiesce State of an Instance • Suspending and Resuming a Database 3: Managing Oracle Database Processes • Terminating Sessions • Identifying Which Session to Terminate • Terminating an Active Session • Terminating an Inactive Session 4: Monitoring the Operation of Your Database • Server-Generated Alerts • Monitoring the Database Using Trace Files and the Alert Log • Monitoring Locks • Monitoring Wait Events • Process and Session Views 5: Oracle Database Structure and Storage • Managing Control Files • Managing the Redo Log • Managing Archived Redo Logs 6: Managing Table spaces Transportable Table spaces 7: Managing Data files and Temp files 8: Managing the Undo Table space undo retention, switching undo table space 9: User management creation of users and roles, assign privileges 10:Automatic Storage Management create ASM instance, create disk groups 11:Managing Schema Objects • Tables, indexes, views, synonyms and sequence generator • Space management • Managing resumable space allocation, reclaiming wasted space • Managing Tables • adding, renaming and dropping of table columns • Managing Indexes • B*tree, bitmap • Managing Partitioned Tables and Indexes • Range, hash,list and composit partitioning • Managing Clusters • creation and altering of clusters • Managing Views, Sequences, and Synonyms • Oracle Network • Listener and tnsnames • Distributed Database Concepts • Utilities • Data pump , SQL*Loader • Backup and Recovery • Rman • Performance Tuning • Data Guard • configuring physical standby database • Miscellaneous Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support

Overview: Oracle Database 12c introduces a new multitenant architecture that makes it easy to deploy and manage database clouds. Innovations such as Oracle Multitenant, for consolidating multiple databases quickly, and Automatic Data Optimization with Heat Map, for compressing and tiering data at a higher density, maximize resource efficiency and flexibility. These unique advancements, combined with major enhancements in availability, security, and big data support, make Oracle Database 12c the ideal platform for private and public cloud deployments. ABOUT ECORPTRAININGS: Ecorp Trainings are one of the best institute providing quality level of training in E-learning process.This is instructor led online training. We also provide corporate training , if group of people interested in same technology. Contact us for detailed course content & register for a free demo. We also provide support in client interviews , resume preparation , ticket resolving. Contact us for custom designed training course by experts exclusively for yourself. We provide training for almost all IT technologies i.e ; JAVA , DOTNET , SAP ,ORACLE , PEOPLESOFT ,HYPERION etc, contact us if you have any particular need. ECORP TRAININGS. Gtalk ID : ecorptrainings Skype ID : ecorptrainings

Introduction (Database Architecture 11G/12C) Installing the Oracle Database Software Creating an Oracle Database Managing the Oracle Instance Managing Database Storage Structures Administering User Security Managing Schema Objects Managing Undo Data Implementing Oracle Database Security Configuring the Oracle Network Environment Backup and Recovery Concepts (Cold,Hot,Exp/Imp,Expdp/Impdp) Configuring Recovery Manager (RMAN) Cloning (Cold,Hot,RMAN) Installing Patching and PatchSet Performing Database Upgradation/Migration Automatic Storage Management(ASM) DataGuard GOLDENGATE Performing Flashback Using Utilities(Expdp/Impdp,SqlLoader,Rman...) Real Application Clusters(RAC) Certification Course: --------------------- Oracle Certified Associate (OCA) Oracle Certified Professional (OCP)

The Oracle Database Administrator 12c course aims to put the students in a position to effectively manage an Oracle database instance, configure the network environment and perform database maintenance. They will also learn how to create an operational database and properly manage the various structures effectively and efficiently, including performance monitoring, database security, user management, and backup / recovery techniques.

Oracle Fusion Middleware Admin(100% job guarantee) Course Contents Introducing Oracle Fusion Middleware Platform •Describing the Oracle Fusion Middleware Environment •Describing How WebLogic Server Supports Various Fusion Middleware Suites •Describing How Various Fusion Middleware Suites Augment the Functions of WebLogic Server Defining Java Enterprise Edition Terminology •Explaining the Motivation behind Distributed Systems •The Major Components of the Java Platform Enterprise Edition 5 (Java EE) Specification Installing Oracle WebLogic Server •Explaining Oracle WebLogic Server Installation Steps •Installing WebLogic Server Using Both the Graphical User Interface (GUI) and Command Line •Describing the Organization and Contents of the WebLogic Server Directory Structure •Navigating the WebLogic Server Online and Offline Documentation Configuring a Simple Domain •Describing the Common Elements in a WebLogic Server Domain •Describing how Domains are Used in the Enterprise •Comparing Administration and Managed Servers •Configuring a Domain •Describing the Organization and Contents of the WLS Directory Structure •Describing the use of WLST Offline to Manage Domains •Creating a Simple Domain with One Managed Server •Checking the Port Numbers that are used for Components Configuring a Domain Using Templates •Describing the Internal Process Used to Create or Update a Domain Using a Template •Describing the Process of Extending a Domain Template •Explaining the Domain Templates Provided for Setting up JDeveloper, SOA, and WebCenter Using Administration Console and WLST •Identifying Dynamic and Nondynamic Attribute Changes in the Administration Console •Customizing Monitoring Tables Within the Administration Console •Using the WebLogic Scripting Tool (WLST) Command-line Utility •Invoking WLST and Navigate Through the Domain Structure •Describing How Change Management is Performed Internally Using Java Management Extension (JMX) and Mbeans Configuring Managed Servers •Configuring Managed Servers Using the Administrative Console •Configuring Managed Servers Using WebLogic Scripting Tool (WLST) •Starting Managed Servers •Shutting Down a Server or an Entire Domain Using WLST or the Administrative Console •Configuring Managed Servers on a Computer Separate from the Sdministration Server •Explaining Administration and Managed Server Independence (MSI) Configuring Node Managers •Defining the Oracle WebLogic Server Machine •Configuring a Machine and Assign Servers to it by Using the Console and WebLogic Scripting Tool (WLST) •Explaining the Node Manager Architecture •Describing the Organization and Contents of a Node Manager Directory Structure •Configuring, Starting, and Stopping Node Managers •Describing How to Start and Stop Procedures Viewing and Managing Logs in Oracle WLS Environment •Defining and Configuring Server and Domain Logs •Viewing and Interpreting the Format of Domain and Server Log Files Using the Administration Console •Configuring Server Standard Output Settings Using the Console •Describing How Applications Can Integrate With WLS Logging Infrastructure (Apache commons, log4j) •Accessing Online Log Message Catalogs •Creating and Applying a Log Filter Using the Console •Configuring Log Filter Expressions Deployment Concepts •Contrasting Autodeploy With Manual Deployment •Configuring and Deploying Web Applications Via the Administration Console, Command Line, and WLST •Configuring Deployment Descriptors •Testing Deployed Applications •Describing the Role of Web Servers •Tracing a Typical Web Interaction Flow •Contrasting Static and Dynamic Content and Deployment •Front-end Deployed Applications With a Web Server Deploying Java EE Applications •Describing Java EE Web Applications •Describing Enterprise Deployment Architectures •Packaging Web Applications in Several Forms •Defining Web Application Structure and Web Application Archive •Explaining Why WebLogic Augments Standard Java EE Deployment Descriptors With weblogic*.xml Files •Looking at Deployment Descriptors web.xml and weblogic.xml •Describing URLs and Web Applications Advanced Deployment •Configuring an Application for Multiple Development Environments •Creating a Deployment Plan •Staging a Deployment Plan •Using Production Redeployment Understanding JDBC and Configuring Data Sources •Configuring JDBC and JDBC Data Sources •Configuring Data Source Scope •Contrasting Two-tier and Multi-tier JDBC Architecture •Configuring a Connection Pool •Describing How Data Sources are Used •Deploying JDBC Resources to a Target •Explaining the Components of JDBC URLs •Monitoring and Testing a Data Source Setting Up Java Message Service (JMS) Resources •Describing JMS •Describing How Oracle WebLogic Server JMS is Implemented •Configuring JMS Server •Configuring Connection Factories •Configuring Queues and Topics •Configuring Persistent Messages •Deploying an Application that Uses JMS •Monitoring JMS Resources and Messages Introduction to Clustering •The Benefits of Oracle WebLogic Cluster •Basic Cluster Architecture •Multitier Cluster Architecture •Communication Among Clustered Server Instances •The Key Criteria for Selecting Suitable Cluster Architecture Configuring a Cluster •Preparing Your Environment for a Cluster •Creating and Configuring a Cluster •Adding Servers to a Cluster •Starting Up and Shutting Down Clustered Servers Managing Clusters •Deploying Applications to a Cluster •Describing the Replication of a Session State in a Cluster •Configuring Replication Groups •Configuring In-memory Replication •Configuring Java Database Connectivity (JDBC) Replication •Configuring File Replication •Configuring a Multitier Cluster for Enterprise JavaBeans (EJB) Applications Security Concepts and Configuration •Using the WebLogic Server (WLS) Security Architecture •Configuring Security Realms •Configuring Users and Groups •Configuring Roles •Configuring Policies •Configuring Protection for Web Application Resources and EJBs Protecting Against Attacks •Describing the Process of Configuring Secure Sockets Layer (SSL) •Using the Keytool Utility to Configure Keys and Obtain Digital Certificates •Configuring SSL for the WLS Server •Configuring Countermeasures for Some Web-based Attacks Backup and Recovery Operations •Recommending a Backup and Recovery Strategy •Performing a Full Offline Backup and Recovery •Performing an Online and Offline Domain Backup •Performing an Offline Domain Recovery •Performing an Instance Home Backup and Recovery SSL Messaging Horizontal clustering Thread dumps etc

sadguru technologies 8179736190 ​Course name : WEBLOGIC11G 24*7 technical support faculty : Realtime experience Rs Trainings:is a brand and providing quality online and offline trainings to students in world wide. We are giving best online training on WEBLOGIC Highlights in our training service: Every faculty has Real Time experiance .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Teamviewer, webex.Supporting the resource with Top 100 Interview questions. Résumé built in best corporate standards according to the job description. We will market the resume for top technolgy countries.After each week a status exam is conducted. Offline online trainings are conducted everyday.Weekend trainings for job goers.flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Aquintance with Production,development and testing environments.Real time scenarios covered accross Software Development Life Cycle.for every 10 hours One hour catered to resolve the doubts.Explaining bugs and critical issues and development activities 24*7 technical supports sevices. Course content: WEBLOGIC ADMINISTRATION 11G ( on Linux Environment ) Description An enterprise application consists of various components and resources such as Enterprise JavaBeans, Servlets, JSPs, Database Connections, HTML files, XML files, etc. After application developers finish developing the various components, it is the system administrator's job to put everything together into the WebLogic Server environment and make it available to users at Web browsers. As a WebLogic Server Administrator, you are responsible for, among other things: • Starting and stopping servers • Balancing the load on servers or connection pools • Selecting and monitoring the configuration of resources • Detecting and correcting problems • Monitoring and evaluating system performance • Deploying Enterprise JavaBeans, Web Applicatio

Our GreensTechnologys is a Oracle Training in Chennai with provided by 100% best training institute in Chennai with real-time practical knowledge and placements. Our No 1 Oracle Training Institute in Chennai provides by a Oracle training with real-time working professional which help with the students and trainees to get trained in practical real-time scenarios along with theory. Our Oracle Certification Training in Chennai will definitely help you to complete certification and clearing interviews. Our Oracle Certification is focuses on the giving students will basic to advanced level.Our Trainers have Technical Architects and Project Leads for working in MNC's and will help with real time Oracle projects. Advanced Oracle 11g Exadata Implementation Specialist for Best Oracle Certification in Chennai Our Training Institute has offers for a Oracle Training with choice of multiple training locations across Chennai. Our Oracle Database Training centers are equipped with the lab facilities and excellent infrastructures. We are also provide by a Oracle Database Certification Training path for ollowing students in Chennai. Our Oracle Training Centers are trained by more than 250+ per month oracle students in we provided a placements. We have Learn basic SQl to advanced PL/SQL topics and like List of the features. Our Oracle Database 11g updated and Log on to the database using SQL Developer environment and generate a report for Log On data from the output data. Our Training Institute has provide by a Oracle International Certification for RDBMS Database, Oracle fundamentals, Oracle PL/SQL, Oracle DBA, Oracle forms & Reporting, Oracle Performance Tuning with given certification exams. Oracle Training course content and Syllabus in Chennai Introduction to ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Tablespaces & Segments) Administering User Security Managing Data Concurrency Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Database Maintenance Managing Performance by SQL Tuning Oracle Training Sessions: Regular Classes (Morning, DayTime & Evening) Duration: 25 Days Weekend Training Classes (Saturday, Sunday & Holidays) Duration: 8 Weeks Fast Track Training Classes (5+ hours Daily) Duration: Within 15 Days We are the offered by a Oracle Training in Chennai with Overall Oracle Certification in Chennai with course details with fees - 10k Only

Course Contents: Oracle Database 12c Introduction Oracle Database Architecture: Overview CDB & PDB Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database memory Structures Process Architecture Process Structures Process Startup Sequence Oracle Software Installation Basics Installation Planning Your Installation Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM Operating System Groups and Users Environment Variables Configuring the Oracle Software Owner Environment Using Oracle Universal Installer (OUI) Installation Option: Silent Mode Installing Oracle Database Software System Requirements for Oracle Database Creating Operating System Groups and Users Types of Installations DB creation Creating an Oracle Database by Using DBCA Planning the Database Storage Structure Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are Used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Oracle Database Management Tools startup and shutdown Introducing Oracle Database Management Tools Using SQL*Plus Using SQL Developer Logging in to Oracle Enterprise Manager Database Express Using the Enterprise Manager Database Express Home Page Understanding the Enterprise Manager Cloud Control Framework Using Enterprise Manager Cloud Control Managing the Database Instance Initialization Parameter Files Starting an Oracle Database Instance Shutting Down an Oracle Database Instance Viewing Log Files Using Trace Files Using the Dynamic Performance Views Data Dictionary Configuring the Oracle Network Environment 12c network Oracle Net Services Overview Database User Accounts Storage Structures Understanding Storage of Data Undo Data Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Configuring Undo Retention Guaranteeing Undo Retention Changing an Undo tablespace to a Fixed Size Managing Data Concurrency Overview of Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts Implementing Oracle Database Auditing Separation of Responsibilities Database Security Monitoring for Compliance Standard Database Auditing Unified Audit Data Trail Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles) Configuring the Audit Trail Specifying Audit Options Backup and Recovery Concepts Categories of Failures Configuring for Recoverability Backup Solutions Overview

ORACLE 10G/11G DBA ADMINISTRATOR OVERVIEW The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts. We at AllTechZ Solution provide quality training in ORACLE DBA 10g and 11g on RHEL/Windows platforms respectively. ORACLE 10G /11G TRAINING COURSE MODULES Following modules are included in ORACLE 10g/11g training programme SQLPLUS Retrieving data using SELECT statement Restricting & sorting data Single row functions Group functions Joins DDL & DML statements Data dictionary Controlling user access Managing schema objects Advanced subqueries Workshop I Introduction Install Oracle Database 10g and configure a database Manage the oracle instance Create manage and administer user accounts Manage privileges, roles and profiles Monitor, administer and configure oracle net services Perform backup & recovery of database Using export/ import utilities Workshop II Introduction Use RMAN to create and manage backup sets and image copies Use Oracle Secure Backup to backup and recover a database Use Oracle's Flashback technology to recover your database Detect block corruptions and take appropriate measures to correct them Use the various Database advisors and views to monitor and improve database performance Control database resource usage with the Resource Manager Simplify management tasks by using the Scheduler Review database log files for diagnostic purposes Customize language-dependent behavior for the database and individual sessions Database cloning Catalog Database Patching Overview of dataguard. All the advanced concepts of 11g BENIFITS OF THE TRAINING After the completion of 10g/11g course you will be aple to find you self in a position where you are technically strong both.the are technically & practically. you will and have the knowledge of now things get done in live scenarios for this will help you in clearing the interview. For further detail cpntact @

Oracle RAC DBA (10g/11g) Training The course focuses on RAC architecture, installation, patching, administration, backup and recovery and tuning. The course will also include specialized Oracle RAC tuning script for monitoring all of the critical RAC performance areas. Oracle RAC DBA (10g/11g) Training- SADGURU TECHNOLOGIES is one of the leading IT training Institutions which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry. SADGURU TECHNOLOGIES is started by a group of highly talented faculty in their respective courses. Acute Soft is a passion for our team members.We are the one among the Computer Institutes in Hyderabad,India,USA,UK where faculty has enthusiasm, professionalism and high level of technical knowledge Course Aims The objective of this Oracle 11g Release 2 RAC & Grid Infrastructure Administration course is to provide the skills needed to plan, implement, manage and troubleshoot Oracle RAC database configurations in an Oracle Grid Infrastructure environment. The course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment. Delegates will learn how to install, create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment. Who Should Attend This course is designed for experienced database administrators who are required to plan, implement and administer Oracle Real Application Clusters configurations for Oracle databases. NOTE: Delegates wishing to attend this course should have a working knowledge of Oracle Database Administration. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. Pre-requisite courses are: Oracle Database 11g Release 2 DBA - Part I Oracle Database 11g Release 2 DBA - Part II MORE Details: + OR

Oracle RAC DBA (10g/11g) Training The course focuses on RAC architecture, installation, patching, administration, backup and recovery and tuning. The course will also include specialized Oracle RAC tuning script for monitoring all of the critical RAC performance areas. Oracle RAC DBA (10g/11g) Training- SADGURU TECHNOLOGIES is one of the leading IT training Institutions which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry. SADGURU TECHNOLOGIES is started by a group of highly talented faculty in their respective courses. Acute Soft is a passion for our team members.We are the one among the Computer Institutes in Hyderabad,India,USA,UK where faculty has enthusiasm, professionalism and high level of technical knowledge Course Aims The objective of this Oracle 11g Release 2 RAC & Grid Infrastructure Administration course is to provide the skills needed to plan, implement, manage and troubleshoot Oracle RAC database configurations in an Oracle Grid Infrastructure environment. The course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment. Delegates will learn how to install, create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment. Who Should Attend This course is designed for experienced database administrators who are required to plan, implement and administer Oracle Real Application Clusters configurations for Oracle databases. NOTE: Delegates wishing to attend this course should have a working knowledge of Oracle Database Administration. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. Pre-requisite courses are: Oracle Database 11g Release 2 DBA - Part I Oracle Database 11g Release 2 DBA - Part II

Oracle 11 G DBA Course content near marathahalli / kundalahalli / Whitefield What you will learn This Oracle Database: Introduction to SQL training helps you write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Benefits to You 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. Oracle Database 11g: Administration Workshop I What you will learn This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. Oracle Database 11g: Administration Workshop I I What you will learn This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. Reasons to study at Systems Domain • Oracle Authorized WDP Partner Status. • Experienced trainers who understand a candidate’s needs • Good track record of students being placed in reputed companies • Weekend batches, if required • Frequent events like Group Discussion, Personality Development, Interview Tips, and Presentations on Saturdays. For more detail contact Asma #2, 3rd Floor, Balaji Complex,Next To State Bank of Mysore Marathahalli Main Road, Near Marathahalli Bridge Junction Bangalore-

Oracle RAC DBA (10g/11g) Training The course focuses on RAC architecture, installation, patching, administration, backup and recovery and tuning. The course will also include specialized Oracle RAC tuning script for monitoring all of the critical RAC performance areas. Oracle RAC DBA (10g/11g) Training- SADGURU TECHNOLOGIES is one of the leading IT training Institutions which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry. SADGURU TECHNOLOGIES is started by a group of highly talented faculty in their respective courses. Acute Soft is a passion for our team members.We are the one among the Computer Institutes in Hyderabad,India,USA,UK where faculty has enthusiasm, professionalism and high level of technical knowledge Course Aims The objective of this Oracle 11g Release 2 RAC & Grid Infrastructure Administration course is to provide the skills needed to plan, implement, manage and troubleshoot Oracle RAC database configurations in an Oracle Grid Infrastructure environment. The course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment. Delegates will learn how to install, create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM) and Oracle Clusterware in a RAC environment. Who Should Attend This course is designed for experienced database administrators who are required to plan, implement and administer Oracle Real Application Clusters configurations for Oracle databases. NOTE: Delegates wishing to attend this course should have a working knowledge of Oracle Database Administration. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. Pre-requisite courses are: Oracle Database 11g Release 2 DBA - Part I

Oracle DBA Training Course Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Database Administrator Job Growth DBAs play an important and responsible role in every company's Information Technology (IT) department. PRE-REQUISITES: SQL, PL/SQL,LINUX. INTRODUCTION TO ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Table spaces & Segments) Administering User Security Managing Data Concurrency Managing Undo Data Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Use of RMAN Recovery Catalog & Configuring Backup Settings Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Using Flashback Technology I Using Flashback Technology II Implementing Oracle Database Auditing Implementing Oracle Database Auditing Database Maintenance Performance Management Managing Performance by SQL Tuning Diagnosing the Database Managing Space Managing Space for the Database Managing the ASM Instance Duplicating a Database / Cloning Database Data Guard Installing your Oracle Software Database Patches & Database Upgrades Introduction to Real Application Clusters OLTP vs OLAP Data modeling Snake-Flow diagram Dimensions and Facts IQD preparation IQD publishing Cube generation Cube publishing into portal Validations Adhoc reports Zero suppression reports Performance and Tuning with OLAP Backup and recovery in OLAP If you want to know more about Oracle DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

ORACLE DBA TRAINING Oracle DBA Training Course Overview Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Database Administrator Job Growth DBAs play an important and responsible role in every company's Information Technology (IT) department. PRE-REQUISITES: SQL, PL/SQL,LINUX. INTRODUCTION TO ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Table spaces & Segments) Administering User Security Managing Data Concurrency Managing Undo Data Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Use of RMAN Recovery Catalog & Configuring Backup Settings Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Using Flashback Technology I Using Flashback Technology II Implementing Oracle Database Auditing Implementing Oracle Database Auditing Database Maintenance Performance Management Managing Performance by SQL Tuning Diagnosing the Database Managing Space Managing Space for the Database Managing the ASM Instance Duplicating a Database / Cloning Database Data Guard Installing your Oracle Software Database Patches & Database Upgrades Introduction to Real Application Clusters OLTP vs OLAP Data modeling Snake-Flow diagram Dimensions and Facts IQD preparation IQD publishing Cube generation Cube publishing into portal Validations Adhoc reports Zero suppression reports Performance and Tuning with OLAP Backup and recovery in OLAP

Oracle Database 11g Release 2: RAC and Grid Infrastructure Administration Oracle Clusterware Installation •Cluster Setup Tasks •Using Raw Partitions •Cluster Configuration •Oracle Clusterware Installation RAC Installation •Installing Automatic Storage Management •Configure ASM Storage •Install the Database Software Database Creation •Storage Options for Database Files •Create the Database RAC Database Administration •Cluster Database Instance Administration •Topology Viewer •Automatic Undo Management and RAC •Quiescing RAC Databases •Transparent Data Encryption and Wallets in RAC •ASM Instance and Crash Recovery in RAC Backup and Recover of RAC Database •Protecting Against Media Failure •Oracle Recovery Manager RAC Database Monitoring and Tuning •CPU and Wait Time Tuning Dimensions •Dynamic Reconfiguration •ADDM Analysis Services •Workload Dispatching •High Availability of Services in RAC •Services and Resource Manager with EM •Change Service Thresholds •Using Distributed Transactions with RAC High Availability of Connections •Fast Application Notification •Load Balancing Advisory •Transparent Application Failover Oracle Clusterware Administration •Controlling the Oracle Clusterware Stack •Back Up and Recover Your Voting Disks •Back Up and Recover Oracle Cluster Registry •Prevent Automatic Instance Restarts Diagnosing the Oracle Clusterware components •Oracle Clusterware Main Log Files •RAC Diagnostic Infrastructure Node Addition/Removal •Add and Delete Nodes and Instances •Clone Oracle Clusterware Design for High Availability •Maximum Availability Architecture •RAC and Data Guard Topologies •Extended RAC Connectivity •Extended RAC disk mirroring •Patch your RAC system in a rolling fashion RAC Advanced Topics 1 •Discussion about CRS proces •The order of crs startup and discussion about the important diagnostic log files •Discussion about RAC background process •Cache Fusion discussion RAC Advanced Topics 2 •Single Node to RAC conversion •RAC to single node conversion •Rebuild of RAC system after clusterware lost •Adding a Non RAC database to cluster •RAC version upgrade Workshop •Patch Oracle Clusterware •Testing Transparent Application Failover For More Details contact us: Elegant It Services contact no: