Sql oracle

Home tutor for C/C++/Java/ORACLE/SQL Server.Currently I am working in leading MNC in Gurgaon. I am an Oracle Certified Professional, Java Programmer.

Oracle DBA courseware bookset Oracle 9i programming with SQL Oracle 9i Database performance tuning Oracle 9i Database administration Oracle Database 10g Streams Oracle Database 10g RAC Oracle application server 10g BEA Tuxedo application administration Oracle 10g Data Guard administration

AllTechZ Solutions is a one of the Best Oracle Training Institute in Chennai. AllTechZ Solutions offers real time and placement Oriented Oracle Training in Chennai.Our oracle database course involves basic to advanced level. In our Ats Oracle Training system, you will learn Oracle fundamentals, RDBMS Database, Oracle DBA, Oracle PL/SQL, Oracle forms & reporting, oracle performance training, oracle real time project and oracle database placement training. ATS trainers are oracle certified experts and experienced working skills with hands on real time different Oracle projects knowledge. Oracle training provides on day time classes, weekend Oracle training classes, evening batch classes and fast track Oracle training classes.

Oracle 10G SQL / PL-SQL Online Training --------------------------------------- i-Solutions provides the best Software’s training for various Computer IT courses through Webex, Gotomeeting. We are providing Oracle SQL & PL SQL Training based on specific needs of the learners especially we will give innovative one to one Classes which has great opportunities in the present IT market. Learners can grasp the technology-subject from our highly experienced & certified trainers which will be helping the students to work in real time projects. Learners can choose either regular course or fast track classes or weekend Training classes. Course Overview: This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. The course is designed to incorporate both theoretical and hands on sessions so as to benefit the learners to build in-depth knowledge on Oracle SQL and PL-SQL. What Is Oracle SQL & PL/SQL ? SQL is a query language that allows you to issue a single query or execute a single insert/update/delete. PL-SQL is Oracle's "Programming Language" SQL, which allows you to write a full program (loops, variables, etc.,) to accomplish multiple selects/inserts/updates/deletes. PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database. Contact: Ganesh Ch, Mobile # +91

Oracle DBA is certification oriented course which covers FIVE major parts as: 1. UNIX 2. PL/ SQL 3. DBA Admin Part1 on 11g 4. DBA Admin Part2 on 11g 5. Real Application Cluster (RAC) Syllabus: *** UNIX Fundamentals Architecture Commands File System The vi Editor The SHELL & Shell Scripting ***PL/ SQL Creating and altering tables and views Writing and running PL/ SQL programs from SQL*Plus or SQL Developer Using SQL statements within PL/ SQL Conditional execution and loop constructs Triggers, Cursors Trapping and handling errors and exceptions in code Implementing nested and labeled loops and blocks Exceptions Handling PL/ SQL records and tables ***DBA Admin1 on 11g Installing and Configuring Oracle 11g Creating and Managing Database Storage Structures Managing Users, Profiles, Privileges and Roles Maintaining Database Security Monitoring the Performance of the Database Backing Up and Recovering the Database *** DBA Admin2 on 11g Planning a backup strategy and a disaster recovery strategy Altering a database to ARCHIVELOG and NOARCHIVELOG modes Performing online and offline backups Recovering a database from non-critical losses Performing logical backups with the export and import utilities Reviewing database logs for diagnostic purposes Automating management tasks with the scheduler ***Real Application Cluster (RAC) Installing and configuring an Oracle 11g RAC Database Administering and Monitoring a RAC database using Enterprise Manager and command line tools Using configuration and management tools for RAC databases Administering ASM using command line and GUI clients Setting up services for workload management and application high availability Backing up, restoring and recovering a RAC database Creating duplicate and standby databases in a RAC Environment Monitoring and tuning the performance of a RAC database Faculty: We are having world class faculty having 8+ years of experience in the DBA field. Two certifications are: Paper I: OCA: Oracle Certified Associates Paper II: OCP: Oracle Certified Professional Duration of this course would be approx 5. 5-6 months. Batch Timings would be Morning:- 7 AM to 9AM Evening:- 7 PM to 9PM Contact details: Hemant Dhole , Cympac Software Solution Pvt Ltd Office No.15,First Floor,Punit-Yash Arcade,Karve Road,Near Kothrud Stand,Kothrud- SysAdminExperts - Pune

SQL Stands For Structured Query Language. and it is generally referred to as SEQUEL. SQL is Simple Language to Learn. SQL is a Non Procedural Language, as compared to the procedural or third generation Language (3GLs) such as COBOL and C. This course is intended to give users an understanding of Oracle SQL and Oracle PL-SQL. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. The course is planned to integrate both theoretical and hands on sessions so as to benefit the learners to build in-depth knowledge on Oracle SQL and PL/SQL. VirtualNuggets is progressive online education assistance team related to software programming and other IT services. VirtualNuggets offer you efficient yet affordable services with quality as the main objective. Feel Free to Contact For Free Demo On Oracle PL/SQL : web URL : http://www.virtualnuggets.com/best-oracle-sql--pl-sql-online-training-institute.html Email : info@virtualnuggets(dot)com Contact : +1-707 666 8949(USA) +91-888 556 0202(India) Blogger : http://oraclesqlplsqlonlinetraining.blogspot.in/

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

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

SQL/PLSQL Training in Hyderabad This course is designed to give students an understanding of Oracle SQL and Oracle PL/SQL languages. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. DATABASE DESIGN ORACLE STANDARD INTERFACES DATA DEFINITION LANGUAGE (DDL) DATA MANIPULATION LANGUAGE (DML) TRANSACTION CONTROL LANGUAGE (TCL) SQL OPERATORS SQL FUNCTIONS PL-SQL (Procedure Language – SQL) EXCEPTIONS in PL/SQL DATABASE TRIGGERS in PL/SQL Upon completion of this course, students will be able to: •Explain the difference between SQL, PL/SQL. •Write basic SQL queries to retrieve desired data. •Use DML statements (insert, update, and delete). •Use DDL statements (create, alter, and drop). •Use transaction control statements to commit, rollback, and create savepoints. •Write advanced queries and scripts. •Control access to your database objects. •Write a PL/SQL block using all elements of block structure. •Write PL/SQL statements using lexical units, declared variables, and assignment statements. •Use control structures to loop, branch, and jump. •Use PL/SQL named exceptions and user-defined exceptions. •Use explicit cursors.

Oracle PL/SQL is a combination of SQL along with the procedural features of programming languages. Oracle PL/SQL includes procedural language elements such as conditions and loops. You can declare constants and variables, procedures and functions, types and variables of those types, and triggers. FEATURES: Course Duration: Hours Access: With 2 months server access Trainer Details: 8+ Years Real Time Consultant Training: We train people Online on Oracle PL/SQL and Oracle Apps Technical, Functional Modules Prerequisites: Any Bachelor Degree student can learn this course Material: Soft Copy of Training Course Materials, Session Video Recordings will be provided After Training: Resume preparation, Interview Questions Career Support will be provided Support: we will give direct access to our server to each trainee with individual login 24×7 support Offered Other Modules: SAP: SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM, CRM, HANA, FSCM, IS UTILITIES, BO DATA SERVICES, APO…. etc Data Warehouse: AB INITIO, AJAX, INFORMATICA, DATA STAGE, HADOOP, WEBSPHERE Oracle & Hyperion: ESSBASE, PLANING, DQM, FM….and more Please contact us for Free Demo: India:+ USA:+

Oracle SQL, PL/SQL Training online We are offering Oracle SQL and PL/SQL training online with 100% result Certification will be provided For details contact

Oracle PL SQL Online Training Oracle PL SQL is most demanding course in the market. Having basic knowledge on SQL helps o grab quickly pl/sql online training course but don’t worry we will cover them as part of the course. There are very good jobs available with good billing both in India & USA for PL SQL skill set. Course Content If you have any quires feel free to contact us

Oracle PL SQL Online Training Oracle PL SQL is most demanding course in the market. Having basic knowledge on SQL helps o grab quickly pl/sql online training course but don’t worry we will cover them as part of the course. There are very good jobs available with good billing both in India & USA for PL SQL skill set.

Oracle PL SQL Online Training Oracle PL SQL is most demanding course in the market. Having basic knowledge on SQL helps o grab quickly pl/sql online training course but don’t worry we will cover them as part of the course. There are very good jobs available with good billing both in India & USA for PL SQL skill set. Thanks & Regards, Jilani Shaik +91-91009-98433 / 34 (WAPP) +1-224-676-9882

Oracle Apps Technical Online Training (One to One Online Training) Duration: 25 Sessions, Fee: 25,000 INR Oracle Apps Technical Course Content Introduction to ERP • Definition of ERP • Overview of popular ERP’S • Comparison of Oracle Apps with other ERP’S • AIM documentation standards • Oracle Application Architecture. • Database structure of OA • Using TOAD Types of Roles • Functional Consultant and Roles • Technical Consultant and Roles • Techno-Functional Consultant and Roles • Oracle Application DBA and Roles Application Object Library • System Administration and Application Object Library (AOL) • Defining an Applications User and Assigning the Responsibilities. • Understanding AOL and its Components • WHO columns • Creating Responsibilities • Request group creation • Menu Creation Application development • Defining concurrent program • Concurrent programs with parameters • Working with multiple concurrent programs • Concurrent Program incompatibilities • Creating Request Set • Default Types • Value sets Registration of Custom Objects • Report registration • Registration of a Table • Using AD_DD Package to register Database Component in AOL Interfaces and Conversions • Introduction to Interfaces • Difference Between Interfaces and Conversions • Outbound Interfaces o Using UTL_FILE package • Inbound Interfaces o Using SQL * Loader tool • SQL * Loader Concepts o Data File. o Control File. o Bad File. o Discard File. o Log File. • Working with staging table script • Developing validations package • Standards to be followed in conversions • Using oracle API’s in Interfaces and Conversions • Interface Tables and Error Tables Flex Fields • Overview of flex fields • Types of Flex Fields o Descriptive Flex Fields o Key Flex Fields • Step in creation of DFF • Flex fields tables and relations Profiles • Overview of profile options • Different levels in Setting profiles • Steps in setting a profile option • Some important profile options • Some important API’s of profiles Value sets • Overview of value sets • Options in value sets • Types of value sets • Creation of value set • Overview of value set tables • Usage of $FLEX and $PROFILE Multi Org Concepts • What is Multi Org and why we need. • Multi Org Tables. • Multi Org Viiews. Functional Modules Overview • Overview of Procure to Pay Flow (P2P Cycle) • Overview of Order to Cash Flow (O2C Cycle) • Major setups and transactions • Overview of important tables in PO,INV,OM,AP,AP,GL Reports in Oracle Applications • Introduction and Usage of USER_EXITS. • Developing a Report from scratch as per Client Requirement. • Developing a Report based on MD 50 Document. • Customization of Oracle Standard Reports. • Reports Registration Steps in Oracle Applications • Standards to develop a report in Oracle Apps Forms in Oracle Applications • New Form Development Process • Form Registration in Oracle Applications. • Calling one Form to another Form by using Button • Master-Detailed Forms • Form Personalization in Oracle Applications • Form Personalization v/s Form Customization Development of XML Reports FAQ’S in Oracle Apps Technical

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

Oracle 11 G DBA What you will learn This Oracle Database: Introduction to SQL training helps you write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Benefits to You Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. 1. Oracle Database 11g: Administration Workshop I 2. Oracle Database 11g: Administration Workshop I I Reasons to study at Systems Domain • Oracle Authorized WDP Partner Status. • Experienced trainers who understand a candidate’s needs • Good track record of students being placed in reputed companies • Weekend batches, if required • Frequent events like Group Discussion, Personality Development, Interview Tips, and Presentations on Saturdays.

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact VENKI, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com ,,,,

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. ................................................................................................... You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes| We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.... You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.|||||||||||||||| You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training../,. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.,./.// You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL, PL/SQL The Programming Language Of Oracle 3rd Revised Edition Book. each 75₹ (price negotiable)

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

SQL Online Training (One to One Online Training) Duration: 6 Sessions, Fee: 6,000 INR SQL Online Training Contents. Introduction to RDBMS. Oracle Data Types. Introduction to SQL. Classifications of SQL. DDL,DML, TCL, and DCL Commands. Integrity Constraints. Operators -Arithmetic - Comparison - Character -Logical -Set. Functions -Character -Number -Date -Conversion. Joins. Sun Queries using Any, Some, All, exists,not exists etc.. Database Objects FAQ’S in SQL

Oracle SOA Suite 11g Basic Concepts and Architecture •Overview of service-oriented architecture (SOA) • Overview XML, XSD, X Path, XSLT, SOAP, WSDL, UDDI •The basic concepts of Oracle BPEL Process Manager • BPEL Process Manager components Installation •Overview of the fusion architecture •Overview of the Web logic server •Overview of the soa server and bam server and Meta data schemas. •Creating the soa domain •Creating the soa server and bam server •Installation steps soa suite 11g •Preparing the start and stop scripts for soa server •Start and stop the admin server Interaction Patterns •Orchestrate services through BPEL for a Synchronous Service •Orchestrate services through BPEL for One-way. •Orchestrate services through BPEL for an Asynchronous Service SCA Architecture •Description of Composite xml. •Source code Explanation of BPEL File. •Source code Explanation WSDL File. •Source code Explanation of Component Type File. Hello World BPEL Process •Synchronous Hello World process. •Explanation of Below Activities. oReceive Activity Syntax. oInvoke Activity Syntax. oReply Activity Syntax. oAssign Activity. oBPEL Variables. oRelationship between BPEL Variables and WSDL messages. oDeploying the application Creation the connection for SOA server. Major & Minor Application Version. Compilation Build Deployment Tab SOA oApplication Testing in the SOA Server Parallel Processing and Conditional Branching •Processing with Parallel Flows oUsing Flown activity oUsing Flow activity •Conditional Branching oSwitch Activity oLimitation of the Receive activity oPick activity to implement the timeouts oPick activity to receive inputs from multiple operations into a single BPEL Fault Handling and Exception Management •Fault types oSystem Faults oBusiness Faults •Fault handling Process based fault handling System fault handling •For synchronous services •For asynchronous Business Faults oFor synchronous services oFor asynchronous Policy based fault handling Transformation Services •Transformation Service • Map Testing and Analysis • XSLT Mapping Tool Adapters and Accessing Adapter from BPEL •Adapter Framework •File Adapter oRead Operation oWrite Operation oSync Read Operation oList of files. •FTP Adapter oGet a file oPut a file oSynchronous get file oList of files •Advanced Queuing •Database Adapters oCalling stored Procedure oCRUD operations Insert Select Update Delete oRead Poll oCustom sql •JMS adapters. oJMS Producer oJMS Consumer •Oracle Apps Adapter introduction •Fault handling in the ADAPTERS •Transaction handling in Adapters Mediators •Introduction to mediators. •Working with mediators. •Event driven networks via mediator •Schematron files, parallel flows, sequential flows •Fault handling in the Mediator •Transaction handling in the Mediators Human Workflow and Work list Application •Human Workflow Service Concepts •Features of workflow service •Workflow service components •Modeling Workflows •Work list Application Features Business Rule and Decision Tables •Introduction to Business Rules. •Using Business Rules and Decision tables in BPEL Working with BAM •Oracle BAM Server •Oracle BAM Application •Features of Oracle BAM Application •Defining Data Object •Defining BAM Dashboard •Configuring BAM Adapter on WebLogic •Adding BAM Connection to application OSB WSDL Preparation and uploading into SBConsole Business service development Proxy service development Fault handling Message flows in the OSB OSB Faqs AIA AIA fundamentals CDMs AIA components ABM EBO EBM ABCS EBS EBF ABCS preparations EBS preparations One PIP explanation Other Topics SOA Suite 10g examples Migration from 10g to 11g OSB basics AIA Basics Dynamic partner link Correlations Preference variables DVMs XRef Tables ANT scripts MDM MDM upload scripts SOA Testing. SOA Production support. SOA Faqs. Resume Preparation help. SOA project explanation. Other Courses Offered by Sadguru Technologies: Web Logic & SOA Administration Oracle Service Bus (OSB) Oracle Application Integration Architecture (AIA) Oracle Business Process Management (BPM) Oracle Application Development Framework (ADF) Oracle Applications Framework (OAF) Web Sphere Application Server (WAS) Oracle Billing & Revenue Management (BRM) Sales Force CRM, Siebel CRM Business Analyst (BA) JAVA Oracle Identity Access Management (OIAM) Oracle Data Integrator (ODI) Web Center Oracle Apps (Functional, Technical) Contact at SADGURU TECHNOLOGIES H. No: , Flat No: 102, SaiManor Apartment, S.R. Nagar Main Road, Hyderabad-, Landmark: Beside Umesh Chandra Statue Mob: 91-, Ph: 040-