Creating database

DEGREE:B.E, B.TECH, M.C.A, M.E, Ph.D, B.B.A, B.COM, B.SC, B.B.M, DIPLOMA, M.Phil LOCATION:Coimbatore DURATION:3 Months ABOUT COMPANY:PROMPT INFOTECH is a division of PITH Pvt Ltd, an ISO 9001:2015 certified company. Our services include Software Development, IT Support, BPO Services, Web Development, Electronics product Development and Training & Development. SYLLABUS: SQL: Retriving data using the SQL select statement, Restricting and sorting data, Using single row function to customize output, Reporting aggregated data using the grout function, Displaying data from multiple tables, Displaying data from multiple tables-II, Using sub queries to solve problems, Using set operators, Manipulating data, Using DDL statements to create and manage tables, Creating other schema objects, Managing objects with data dictionary, Controlling User access, Managing schema objects, Manipulating large data sets, Generating report by grouping related data, Managing data in different time zones, Retrieving data using sub queries, Hierarchical retrieval, Regular expression support. PL/SQL: Introduction, Declaring Variables, Writing Executable Statements, Interacting with Oracle Server, Writing Control Structures, Working with Composite Data Types, Writing Explicit Cursors, Writing Implicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Managing Subprograms, Creating Packages, More Package concepts, Oracle supplied Packages, Manipulating Large Objects, Creating Database Triggers, More Trigger concepts, Managing Dependents For more details Kindly contact PROMPT INFOTECH A Division of PITH Pvt Ltd 319 / A, 2nd Street, Gandhipuram, Coimbatore Landmark:Above Krishna Bakes Mobile:+91 9894011716 / 0422 4212 616

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

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

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)

Duration: 40 Hours Prerequisites •Basic understanding of any database/ SQL is good Course Contents 1.Introduction to NoSQL Database •What in NoSQL? •Difference between NoSQL and RDBMS •Benefits of NoSQL 2. Introduction & Overview of MongoDB •Objectives •Design Goals. •The Mongo Shell •JSON Introduction •JSON Structure 3. MongoDB Installation •Installing Tools •Overview of Blog Project. •Swig, Express •Node Packaged Modules (npm) 4.CRUD Operation in MongoDB •CRUD (Creating, Reading & Updating Data) Mongo Shell •Query Operators •Update Operators and a Few Commands 5.Data Modeling •Schema Design Pattern •Case Studies & Tradeoffs 6.Indexing and Performance Considerations •Performance Using Indexes, •Monitoring And Understanding Performance. •Performance In Sharded Environments. 7.Aggregation •Aggregation Framework Goals •The Use Of The Pipeline •Comparison With SQL Facilities. 8.MongoDB Replication •Application Engineering Drivers •Impact Of Replication And Sharding On Design And Development. 9.Introduction to Mongoose

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... Amazon Web Services Training Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... AWS Course Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN Contact us +917702999361 / 371

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... AWS Course Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN

Excellent ORACLE training is provided by PERIDOT SYSTEM with oracle certified professionals expert trainers. Our institutes focus on each individual and satisfy their needs through best quality of training. Students are placed in top MNC’S company after completed their training and we tie-up with 50+ companies. We give space for the students to develop the knowledge on SAS by interacting with our expert trainers. FRINGE BENEFITS •Free interview preparation •Demo classes are conducted for two days •Technical support is provided till placement •100% placement assurance •Interactive classes •Limited batch size •Low cost when compared to other institute •LCD projector is available •Certification will be provided after completion of course ORACLE Developing and marketing computer hardware systems and enterprise software products are developed by oracle Company and this oracle corporation is an American multinational computer technology Corporation. Oracle is the second largest software maker by revenue in . The database development and system of middle tier software tools are built by Oracle Company. SYLLABUS OF ORACLE •Retrieving data using the SQL select statement •Using sub queries to solve problems •Creating other schema objects •Displaying data from multiple tables •Managing data in different time zones •Regular expression support •Managing schema objects •Declaring Variables •Creating Database Triggers •Managing Dependents •Using DDL statements to create and manage tables •Generating report by grouping related data •Oracle managed file(OMF) •Installing the Oracle Database Structure •Locking Mechanism and etc…. Mobile No: (student advisor) Landline No: 044- Tags: best oracle training institute in Chennai, best training institute in Chennai, oracle training institute

Excellent ORACLE training is provided by PERIDOT SYSTEM with oracle certified professionals expert trainers. Our institutes focus on each individual and satisfy their needs through best quality of training. Students are placed in top MNC’S company after completed their training and we tie-up with 50+ companies. We give space for the students to develop the knowledge on SAS by interacting with our expert trainers. FRINGE BENEFITS • Free interview preparation • Demo classes are conducted for two days • Technical support is provided till placement • 100% placement assurance • Interactive classes • Limited batch size • Low cost when compared to other institute • LCD projector is available • Certification will be provided after completion of course ORACLE Developing and marketing computer hardware systems and enterprise software products are developed by oracle Company and this oracle corporation is an American multinational computer technology Corporation. Oracle is the second largest software maker by revenue in 2011. The database development and system of middle tier software tools are built by Oracle Company. SYLLABUS OF ORACLE • Retrieving data using the SQL select statement • Using sub queries to solve problems • Creating other schema objects • Displaying data from multiple tables • Managing data in different time zones • Regular expression support • Managing schema objects • Declaring Variables • Creating Database Triggers • Managing Dependents • Using DDL statements to create and manage tables • Generating report by grouping related data • Oracle managed file(OMF) • Installing the Oracle Database Structure • Locking Mechanism and etc…. Mobile No:8056102481 (student advisor) Landline No: 044-42115526 Mail us: papitha.v@peridotsystems.in Tags: best oracle training institute in Chennai, best training institute in Chennai, oracle training institute

Advance Diploma in Software Engineering is a diploma level Information Technology course. The course trains you for the programming aspects of software development, generally required for, academics, making customized software, web-based applications, creating database designs and enterprise applications over a heterogeneous network. You will learn programming techniques, project management, database design, software development, web application development, architecture framework, and lot more.

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

Creating a brand presence of Aimfill International and our subsidiary Lakshya 9 among students and educational institutes in the region. Collection of database of students of class 12th in the region Reaching out to students via seminars and counseling

TekSlate’s syndicate of online trainers are experienced experts in knowledge transfer. The best place for learning, if you are aiming to learn the crux of any technology Big Data Green Plum DBA Online Training Course Content: Greenplum Architecture Greenplum Master Greenplum Segments Greenplum Interconnect Greenplum Concepts, Features and Benefits Redundancy and Failover in Greenplum Database Segment Mirroring Master Mirroring Data Distribution in greenplum Checking for Uneven Data Distribution Database Installation and Configuration Lab – Database Installation and Configuration Access Control and Security Managing Roles and Privileges Security Best Practices for Roles and Privileges Creating New Roles (Users) Altering Role Attributes Creating Groups (Role Membership) Managing Object Privileges Configuring Client Authentication Allowing Connections to Greenplum Database Editing the pg_hba.conf File Limiting Concurrent Connections Accessing the Database Establishing a Database Session Supported Client Applications Greenplum Database Client Applications PgAdmin III for Greenplum Database Database Application Interfaces Third-Party Client Tools Troubleshooting Connection Problems Lab Managing Workload and Resources Overview of Greenplum Workload Management How Resource Queues Work in Greenplum Database Steps to Enable Workload Management Configuring Workload Management Resource Queues Database Administration Defining Database Objects (databases, schema, table, sequence etc) Creating and using databaseso Creating and using schemas Creating and Using Sequences Indexes in Greenplum Database Creating and Managing Views Managing Data Vacuuming the Database Querying Data Query Performance EXPLAIN Output, EXPLAIN ANALYZE Output Partitioning Large Tables Understanding Table Partitioning in Greenplum Database Deciding on a Table Partitioning Strategy Creating Partitioned Tables Loading Partitioned Tables Maintaining Partitioned Tables Lab Greenplum Database Loading Tools Overview About External Tables About gpload About COPY Using the Greenplum Parallel File Server (gpfdist) System Administration Starting and Stopping Greenplum Routine admin tasks Uploading Configuration File Changes Only Configuring Your Greenplum System About Greenplum Master and Local Parameters Setting Configuration Parameters Setting a Local Configuration Parameter Setting a Master Configuration Parameter Enabling Alerts and Notifications Checking for Failed Segments Recovering a Failed Segment Recovering a Failed Master Backing up and Restoring Databases Backup and Restore Operations Expanding a Greenplum System Lab Monitoring a Greenplum System Monitoring Database Activity and Performance Monitoring System State Enabling System Alerts and Notifications Checking System Stateo Checking Disk Space Usage Routine System Maintenance Tasks Routine Vacuum and Analyze System Catalog Maintenance Managing Greenplum Database Log Files Performance Tuning Common Causes of Performance Issues Identifying Hardware and Segment Failures Managing Workload Maintaining Database Statistics Identifying Statistics Problems in Query Plans Tuning Statistics Collection Optimizing Data Distribution Optimizing Your Database Design Lab GP-development Functions Basic shell scripts Investigating a Performance Problem Checking System State Checking Database Activity Checking for Active Sessions (Workload) Checking for Locks (Contention) Checking Query Status and System Utilization Troubleshooting Problem Queries gp_toolkit administration schema System catalog Performance issues and tips Automation scripts for GPDB administration Lab Materials/tools used 1. Training ppts 2. Greenplum admin guide. 3. Greenplum installation guide. 4. Pg admin installer for windows. (Greenplum client for windows) 5. Greenplum community edition. 6. Putty 7. GP connectivity tools. Expected from audience (for Lab) 1. Laptop or desktop with centos installed. 2. Internet.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)-

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)-

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC.

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here

PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training - l

PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Type Computer Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented SQL Server Training Courses in bangalore. Our SQL Server training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time SQL Server projects knowledge which will provide you an edge over other training institutes. Our SQL Server training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in SQL Server Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our SQL Server Training course content and syllabus based on students requirements to achieve everyone's career goal. Our SQL Server Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for SQL Server Training in our centres located across bangalore. We also provide Online Training Classes for SQL Server Training Course. Contact us today to schedule a free demo and complete course details on SQL Server Training Course. What is SQL Server Training ? SQL Server Training Objectives Installing Microsoft SQL ServerUpgrading to SQL Server Management StudioMonitoring the Database ServerDatabase and Index MaintenanceUsing the Database Tuning AdvisorSQL Server Disaster RecoveryDatabase AvailabilityReplicating InformationHTTP Synchronization for Merge ReplicationOLE DB Command objectMonitoring and Performance Training Prerequesites Any Programming Language Knowledge.Good understanding of relational databasesSome experience with client databases, such as Access. Course Details SQL Server Overview Availability and Scalability Features Security Features Data Management Features Administration and Maintenance Features Development Features To enable SQLiMail Testing mail delivery Installing SQL Server SQL Server Editions Installing Microsoft SQL Server System Requirements Preparing for a SQL Installation Installation Checklist Setup Features Using the System Consistency Checker Component Install Unattended Installation Installation Sequence Installation Maintenance Upgrading to SQL Server Management Studio Management Studio Windows Registered Servers Object Explorer Review Database Objects Modify Database Properties Create Database Scripts The Maintenance Plans Node Solution Explorer Query Editor Template Explorer Dynamic Help Upgrading to SQL Server Computer Manager SQL Server Services node SQL Server Network Configuration node SQL Server Native Client Configuration node The SQLCMD Management Utility SQLCMD Syntax SQLCMD Variables Dedicated Administrative Connection SQL Server Management Studio SQLCMD Mode Securing SQL Server Implementing Securable New Security Features Principals Securable Permissions Permission Types Managing Logins Managing Schemas Managing Users Schema Definition Using Schemas Managing Execution Context Managing Permissions Manage Server Permissions Manage Server-Scope Securable Permissions Manage Database Permissions Manage Database-Scope Securable Permissions Native Data Encryption Code and Module Signing Database Availability SQL Data Availability Database Mirroring The Witness Server and Automatic Failover Configuring Database Mirroring Transaction Safety Level Operating Modes High Availability Operating Mode High Protection Operating Mode High Performance Operating Mode Monitoring Mirroring Database States for Database Mirroring Prepare the Servers Configure Mirroring Verify Principal and Mirror Access Execute the Mirror Failover Verify Mirror and Witness Status Terminating the Mirror Session SQL Server Integration Services Creating the Database Objects Creating a Package Using Business Intelligence Studio Integration Services Project Template OLE DB Command object Column Mappings Adding a Data Viewer Monitoring the Database Server Managing Metadata Views Metadata Storage System Views Information Schema Catalog Views Sys All Dynamic Management Views System Stored Procedures Database and Index Maintenance Index Management New Index Features Creating Indexes Online Index Maintenance Parallel (multiple CPU) Index Operations Lock Options Included Columns in Indexes Partitioned Tables and Indexes XML Index Support Altering an Index Rebuilding an Index Reorganizing an Index Disabling an Index Dropping an Index Index Fragmentation Using the Database Tuning Advisor SQL Server Disaster Recovery Disaster Recovery SQL Disaster Recovery Feature Enhanced Features Database Snapshots Creating a Snapshot Common Snapshot Applications Undeleting table rows Undoing a table update Recovering a dropped object Backup and Restore Media Integrity Changes Recovering the MASTER Database Create a mirrored backup Restore from the backup mirror Create a snapshot Restore the snapshot data Automate the creation of daily snapshots Replicating Information Replication Enhancements Stand-alone Replication Monitor Support for Oracle Publishing HTTP Synchronization for Merge Replication Subscriber Initialization Replicating DDL Statements Modified User Interface Replication Management Objects To Configure Publishing and Distribution Configuring Peer-to-Peer Replication Create a Publication Create a Subscription with RMO Monitoring and Performance SQL Server Profiler Optimal Data Storage Diagnostic Tools Query Analyzer Database Engine Tuning Advisor Index Optimization Federated Database Servers Partitioned Indexes Lock Optimization SQL Server Training Course Details Duration:30 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Type Computer Oracle RAC Training in Bangalore & Best Oracle RAC Training Institutes in Bangalore Not Rated About Oracle RAC Training ? Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Oracle RAC Training Courses in bangalore. Our Oracle RAC training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Oracle RAC projects knowledge which will provide you an edge over other training institutes. Our Oracle RAC training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Oracle RAC Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Oracle RAC Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Oracle RAC Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Oracle RAC Training in our centres located across bangalore. We also provide Online Training Classes for Oracle RAC Training Course. Contact us today to schedule a free demo and complete course details on Oracle RAC Training Course. What is Oracle RAC Training ? Grid Infrastructure Concepts What is a Cluster Grid Foundation Components Oracle Clusterware Architecture Oracle Clusterware Software and Storage Describe ASM Architecture Creating and Managing ASM Disk Groups Creating and Managing ASM Cluster Filesystems Grid Infrastructure Installation and Configuration Hardware Requirements Network Requirements DNS and DHCP Configuration Grid Plug and Play Considerations Single Client Access Names Post installation tasks Administering Oracle Clusterware Managing Clusterware with Enterprise Manager Determining the Location of the Oracle Clusterware Configuration Files Backing Up and Recovering the Voting Disk Adding, Deleting, or Migrating Voting Disks Locating the OCR Automatic Backups Oracle Local Registry Migrating OCR Locations to ASM Managing Network Settings Managing Oracle Clusterware Prerequisite Steps for Extending a Cluster Using addNode.sh to Add a Node to a Cluster Rolling Patches, And Rolling Upgrades Comparing Software Versions With the Active Version Installing A Patchset With the OUI Utility Installing A Patch With The opatch Utility Administering ASM Instances ASM Initialization Parameters Adjusting ASM Instance Parameters in SPFILEs Starting and Stopping ASM Instances Using srvctl Starting and Stopping ASM Instances Using ASMCA and ASMCMD Starting and Stopping ASM Instances Containing Cluster Files Starting and Stopping the ASM Listener Administering ASM Disk Groups Creating And Deleting ASM Disk Groups ASM Disk Group Attributes ASM Disk Group Maintenance Tasks Preferred Read Failure Groups Viewing ASM Disk Statistics Performance And Scalability Considerations For ASM Disk Groups ASM Files, Directories, and Templates Using Different Client Tools to Access ASM Files Fully Qualified ASM File Name Format Creating and Managing ASM files, Directories and Aliases Managing Disk Group Templates Real Application Clusters Database Installation Installing The Oracle Database Software Creating A Cluster Database Post–database Creation Tasks Single-Instance Conversion Using the DBCA Single-Instance Conversion Using rconfig Background Processes Specific to Oracle RAC Oracle RAC Administration Enterprise Manager Cluster Database Pages Redo Log Files In A RAC Environment Undo Tablespaces In A RAC Environment Starting And Stopping RAC Databases And Instances Initialization Parameters In A RAC Environment Quiescing RAC Databases Managing Backup and Recovery for RAC Protecting Against Media Failure Parallel Recovery in RAC Archived Log File Configurations Archived Redo File Conventions in RAC Channel Connections to Cluster Instances Distribution of Backups Monitoring and Tuning the RAC Database Determining RAC-Specific Tuning Components Tuning Instance Recovery in RAC RAC-Specific Wait Events, Global Enqueues, and System Statistics Implementing the Most Common RAC Tuning Tips Using the Cluster Database Performance Pages Using the Automatic Workload Repository in RAC Using Automatic Database Diagnostic Monitor in RAC Services Configure and Manage Services in a RAC environment Using Services with Client Applications Using Services with the Database Resource Manager Configuring Services Aggregation and Tracing Managing Services From the Command Line Managing Services With Enterprise Manager 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 CacheFusion 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 Extend your cluster using Grid Control Patch Oracle Clusterware Testing Transparent Application Failover Oracle RAC Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 3 - 4 Hours per day: 12 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

OSB industry level training in elegant it services Importance of SOA Evolution of Oracle SOA Why Oracle SOA? Components in Oracle SOA Introduction to XML Concepts Introduction to XML Purpose of the XML Why XML? XML Guidelines Well formed XML and Valid XML Introduction to XSD Importance of XSD Defining an XSD Simple Type and Complex Type Importance of Namespace XSD Validations Introduction to XSL Transformation Introduction to WSDL Introduction to Web services Introduction to SOAP Message Oracle SOA Installations Installing Database Running RCU Installing Weblogic Server Installing SOA Suite Creating a Domain Installing JDeveloper Applying SOA Extension in JDeveloper Introduction to JDevloper Creating Application Creating Project Introduction to SCA Architecture Creating IDE/ Application Connection Creating Application Server Connection Connection to SQL Worksheet Introduction to Application Navigator Introduction to Component Palette Introduction to Resource Palette Introduction to Structure Window Introduction to Mediator Component Why Mediator? Creating a Mediator Target Type Echo/Service/Event Understanding Importance of Source and Target in Transformation Creating a Transformation Request/Reply Applying Filtration Understanding the Importance of various Templates Invoking External Services Introduction to Expression Builder Introduction to MDS What is MDS? Why MDS? Types of MDS Setup/Configuring MDS Ways to deploy the Artifact’s to MDS Creating MDS Connection Deploying Artifact’s to MDS through JDevloper Accessing MDS Objects Introduction to BPEL Component What is BPEL? Performing Orchestration in Oracle SOA Creating a BPEL Process Introduction to Default Variables Understanding the main Scope Introduction to Partner Links Creating Partner Links Understanding the Importance of various Templates Introduction to BPEL Constructs Introduction to Oracle Extensions Introduction to SOA Components Introduction to BPEL Services Difference between Scope/Sequence Difference between Local Variables/Global Variables Difference between Receive and Pick Activity Introduction to Database Adapter Introduction to Database Adapter Creating Data sources Creating a Connection Pool Introduction to SOA Introduction to ESB Introduction to Oracle Service Bus Why Oracle Service Bus? When should we go for OSB? Oracle Service Bus Functional Features Adaptive Messaging Service Security Service Virtualization Service Management Configuration Framework OSB and the Service Life Cycle OSB Architecture Introduction to Proxy Service Introduction to Business Service Introduction to Binding Layer Introduction to Transport Layer OSB Message Flow Definitions Oracle Service Bus Installations Installing DB Running RCU Installing Weblogic Server Installing SOA Suite Installing OSB Suite Applying OEPE Creating a Domain Installing JDeveloper Applying SOA Extension in JDeveloper Opening Eclipse Introducing OSB Services Understanding/Creating a new OSB Configuration in Eclipse OEPE Creating a new OSB Project in Eclipse OEPE Creating the folder structure to place the artifacts Creating a business service based on the WSDL Generating a simple pass-through Proxy Service based on the Business Service Creating a connection/server to deploy the OSB services Testing the proxy service through the OSB console Exploring OSB Artifacts in Eclipse OEPE Importing OSB Project Exporting OSB Project Moving artifacts in Eclipse OEPE by drag-and-drop Copying artifacts in Eclipse OEPE from one folder to another Moving artifacts in Eclipse OEPE inside the same OSB project Copying artifacts from one project into another in Eclipse OEPE Debugging services through Eclipse OEPE OSB Message Flow Modeling Operational Pipelines Branch Nodes Route Nodes Pipeline Pairs Operational Branching Service Callouts OSB Communication Actions OSB Flow Control Actions OSB Message Processing Actions OSB Reporting Actions OSB Message Processing Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87

WARM WELCOME FROM VELGRO TECHNOLOGIES!!! We are providing training for WEB DESIGNING Training is provided by well experienced (REAL TIME) Faculty!!! Fee structure Course fees: RS./- WEB DESIGNING (PHP with MYSQL) Installation • Introduction to PHP and Mysql • PHP Installation • MySQL Installation • Apache Installation. • XAMPP and WAMPP Installation PHP Basics • Embedding PHP in HTML • Embedding HTML in PHP • Introduction Variable • Using variables • Using Operators • Writing Statements and Comments • Using Conditional Statements If(), else if() and else if condition Statement Arrays and Custom Functions • Creating an Array • Modifying Array Elements • Processing Arrays with Loops • Grouping Form Selections with Arrays Using Array Functions • Creating User-Defined Functions • Defining and Invoking Functions Creating basic programs with PHP • Reading and Writing Files • Reading Data from a File • Writing Data to a File • Testing File Attributes. • Managing Sessions and Using Session Variables • Creating a Session and Registering Session Variables • Destroying a Session • Storing Data in Cookies • Setting Cookies • Retrieving Cookie Data • Dealing with Dates and Times • Executing External Programs MySQL SERVER • Understanding an RDBMS • Understanding a Relational Database Understanding Tables, Records, and Fields Understanding Primary and Foreign Keys Understanding SQL and SQL Queries Understanding Database Normalization Using the MySQL Command-Line Client Working with Databases and Tables • Creating Databases • Creating Tables • Specifying Field Data Types • Selecting the Most Appropriate Data Type Adding Field Modifiers and Keys • Selecting a Table Type • Altering Tables • Altering Table and Field Names • Altering Field Properties • Adding and Removing Fields and Keys Altering Table Types • Backing Up and Restoring Databases and Tables • Backing Up Databases and Tables • Restoring Databases and Tables from Backup Dropping Databases and Tables Viewing Database, Table, and Field Information Editing Records and Performing Queries: • Inserting Records • Editing and Deleting Records • Performing Queries • Retrieving Specific Columns • Filtering Records with a WHERE Clause Using Operators • Sorting Records and Eliminating Duplicates Limiting Results • Using Built-In Functions • Grouping Records • Joining Tables • Using Table and Column Aliases Using PHP with MySQL: • Managing Database Connections Performing Queries • Processing Result Sets • Queries Which Return Data Queries That Alter Data Handling Errors Creating Forms with HTML • HTML Basics • Creating Forms with HTML Validations with JavaScript • Introduction to Java Scripting Types of Java Scripts • Variables, operators, loops Using Objects, Events • Common java script functions Using JavaScript in Dreamweaver • Java Script Validations Project contact person: SUJITHA Venue Address: #st floor,Gandhi Road, Velachery Email Id:velgrotechnologies at gmail dot com info at velgrotechnologies dot com Website:www dot velgrotechnologies dot com