> > > >

Instructor Led Oracle Database Training

Oracle Database Training Provider? - Tell us about your Training!

Please select the location nearest to you: United States Pakistan India Canada United Kingdom

online course

instructor-led class

learn at home

group study

self-directed study

cd-based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer-based learning

discount pricing

online tutorial

Oracle Database Training Seminars and Classes

From Wintrac Inc.

Oracle Database 11g R2 - SQL Tuning This learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/ SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance more...

Introduction to Oracle9 i- PL-SQL Language The Oracle PL/ SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment are considered. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Introduction to Oracle9i - Advanced SQL Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as more...

Oracle9i Database Administration - DBA I ...ourse provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical more...

Oracle9i Database Performance Tuning ... finding performance or configuration problems within the Oracle database and solving those problems. Manual techniques as well as those employing the specialty Packs within Oracle Enterprise Manager are considered. Workshop exercises allow participants the opportunity to examine the internal operation of an Oracle instance, isolate problems, test possible solutions and implement effective more...

Oracle9i Network Administration ...Oracle database middleware contained within Oracle Net / SQL*Net. All of the configuration files are considered along with their contents and how these can be customized. The Oracle Net assistant is also covered and this tool is used for multi-threaded server configuration of the database, activating the Oracle Names Server and the Oracle Connection Manager. You can get a complete list of more...

Oracle9i Data Warehouse Administration ...tar schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, partitioned tables, materialized views, and others. Emphasis is placed on the parallel execution features of the database and how these can yield significant more...

Oracle 9i Architecture For Developers ...pers are acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals. The objective is to provide developers with the skills needed to properly build and tune applications for optimum performance compatible with the architecture of the Oracle database. You can get a complete list of other Oracle classes at more...

Oracle Database 10g Performance Tuning ...rmance problems which might arise in the operation of the Oracle database server. Beyond reactive measures, proactive actions which can be taken to avoid performance issues before they arise or are recognized are also considered. This course goes beyond basic automatic tuning techniques discussed elsewhere within our database administrator curriculum and covers the whole range of tuning issues, more...

Oracle Database 10g Administration I This Oracle 10g courseware training guide book will allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification You can get a complete list of other Oracle classes at more...

Oracle Enterprise Manager 10g Grid Control ...nd effectively use the tool to administer and monitor the Oracle Database and Operating System. During this class participants learn the Oracle Enterprise Manager architecture, setup the console, use a variety of integrated applications, learn about reports, implement job- and event-based system management. This enables participants to administer and monitor the Oracle platform from a single, more...

Oracle Database 10g - Data Modeling This Oracle 10g courseware training guide book will consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. (This same course is also known by the name RELATIONAL DATABASE DESIGN). This course is one common starting point for the entire database curriculum. You can get a complete list of other Oracle classes more...

Oracle Database 10g - Advanced PL-SQL Programming & Tuning This Oracle 10g courseware training guide book will teach experienced PL/ SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Program With PL-SQL COMPLETE LIBRARY ...ntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. This course is taught using the following two volumes. Each volume may be presented as a standalone course. However, It is also frequently combined for this presentation as the "complete library" to consider more more...

Oracle Database 10g - Program With PL-SQL Part II This Oracle 10g courseware training guide book will consider grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 10g - Program With PL-SQL Part I This Oracle 10g courseware training guide book will consider the grammar, syntax and benefits of using the PL/ SQL language within an Oracle database environment. The Oracle PL/ SQL language provides for programming logic features not contained within SQL. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 10g R1 R2- New Features For Administrators This Oracle 10g courseware training guide book will review all of the major administration features and improvements introduced with Release 1 and Release 2 of the Oracle database version 10g. Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements. You can get a complete more...

Oracle Database 10g- Administration II This Oracle 10g courseware training guide book will presents all the standard failure scenarios and the best recovery strategies for each. One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. Strategies for on-line backups, complete and incomplete recovery, media recovery vs. more...

Oracle Database 10g- New & Advanced Features For Developers This Oracle 10g courseware training guide book will present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle10g release or have been substantially improved with that release You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 10g - Implement Parallel SQL & Partitioning For Data Warehouses ...creases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the Oracle database yet some of the least understood and utilized. You can get a complete more...

Oracle Database 10g - Implement Parallel ...creases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the Oracle database yet some of the least understood and utilized. You can get a complete more...

Oracle Database 10g- SQL Tuning This Oracle 10g courseware training guide book will equip developers to build efficient SQL statements and to tune applications from the standpoint of an application developer. When this effort is complemented by database server and possibly PL/ SQL application tuning, then a highly efficient environment has been built. You can get a complete list of other Oracle classes at more...

Oracle Database 10g- Introduction to SQL - Complete Library This Oracle 10g courseware training guide book will provide an introduction to the SQL database language within the context of an Oracle database. This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 10g- Architecture For Developers This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers and technical managers. With a series of in-depth lectures students are progressively acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals, advanced more...

Oracle Database 10g - Introduction To SQL - Part II This Oracle 10g courseware training guide book will consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. You can get a complete list of other Oracle classes at more...

Oracle Database 10g- Introduction To SQL - Part I This Oracle 10g courseware training guide book will provide an introduction to the SQL database language within the context of an Oracle database. This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 11g- Data Warehousing & Oracle Warehouse Builder ...raining guide book will highlight the features within the Oracle database specifically intended to support data warehouses and data mining operations. It is presented as a two-volume set. The first volume considers data warehousing concepts and the requirements to initially configure a data warehouse installation. The second volume discusses how the Oracle Warehouse Builder (OWB) product may be more...

Oracle Database 11g- Backup & Recovery This Oracle 11g courseware training guide book will consider the latest and most advanced elements of a robust backup and recovery strategy for the Oracle database platform. It is intended to allow a database administrator to become certified as a backup and recovery specialist. You can get a complete list of other Oracle classes at more...

Oracle Database 11g R2 - PLSQL Fundamentals II - Develop Program Units This Oracle 11g courseware training guide book will equip students to develop database server-side PL/ SQL program units within an Oracle database. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 11g - New Features For Administrators This Oracle 11g courseware training guide book will assist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring. You can get a complete list of other Oracle classes at more...

Oracle Database 11g -Administration II This Oracle 11g courseware training guide book will bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. You can get a complete list of other Oracle classes at more...

Oracle Database 11g- Advanced PL SQL Programming & Tuning .... The PL/ SQL programming language is at the core of most Oracle database applications. First, we will explore the advanced features of the language which allow powerful and effective database applications to be built. Next, we will discuss performance tuning techniques which allows these applications to run efficiently. Finally, we will consider critical security measures which should be more...

Oracle Database 11g R2 -PL and SQL Fundamentals - Complete Library This Oracle 11g courseware training guide book will provide an introduction to the PL/ SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/ SQL program units within an more...

Oracle Database 11g R2- PL and SQL Fundamentals I This Oracle 11g courseware training guide book will provide an introduction to the PL/ SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. You can get a complete list of other Oracle classes at more...

Oracle Database 11g -New & Advanced Features For Developers This Oracle 11g courseware training guide book will present some of the most advanced features available to database developers. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 11g R2- SQL Fundamentals - Complete Library This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. This training course reference book is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete more...

Oracle Database 11g R2 -SQL Fundamentals II This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 11g SQL Fundamentals I This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed. This training course book is a common starting point in the Oracle database curriculum for administrators, developers and business users. You can get a complete list of other more...

Oracle11g Administration 1 This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. You can get a complete list of other Oracle classes at more...

Hands-On Oracle for Non-Programmers ...support and other personnel supporting or working with an Oracle database. You will benefit from this class if you but need to interact with Oracle but are not faced with the day-to-day task of programming. Through classroom lecture and demonstration and ample hands-on workshops, you will learn how to query the database with SQL, create reports with SQL*Plus, control (grant and revoke) database more...

Oracle Database 11g SQL Fundamentals

...Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest more...

From Alliance Training and Solutions

Oracle 10g R2 Real Application Cluster RAC

... introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid configure and use database Load Balancing Advisory in a RAC more...

Oracle 11g Database Administrator OCA and OCP

...Oracle Database 11g extends Oraclea ™s unique ability to deliver the benefits of grid computing with more self-management and automation. Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industrya ™s most advanced database management system. Required Prerequisites: Candidate more...

Oracle 10g Developer Certification Track

...abase-centric Internet applications for both Oracle9i and Oracle Database 10g. Oracle Forms Developer Certified Professionals (OCP) gain greater credibility, a higher level of efficiency, and improved job performance as application developers. Required Prerequisites: Candidate with good English command may pursue this course. Training cost: PKR 36, 000. 00 inclusive of course material, exam more...

From L'Obel IT-Palaestra

L'Obel Certified Informatica Training ...ure and Real Time support from Mainframe, SQL Server, and Oracle database sources. Informatica PowerCenter is available to run on Windows, various UNIX platforms, and Mainframe. PowerCenter represents a paradigm shift in programming since it is a functional programming (such as XSLT for XML) tool instead of an iterative one (such as PL/ SQL or Java). With Informatica, construction effort more...

From Technology Education Academy

Oracle 11g OCP-DBA Training Certification

...Oracle Database 11g: OCP-DBA Track Training & Certification at 60% Discounted Fee Dear Professionals/ Students, Greetings! We are offering the ( Tuesday & Thursday a Evening Hours ) batch for Oracle 11g OCP-DBA training & certification at 60% Discounted Fee, which is scheduled to commence from Tuesday, November 01, 2011 for students and professionals. If you wish to join more...

R12 Oracle Financial Consultant Training Certification

Technology Education Academy proudly offers first time in Pakistan: R12 Oracle Financial Consultant Training (Learning Path: General Ledger Management Fundamentals) at affordable cost and with maximum benefits to participant for accessing quality training: Oracle Certified Professional (OCP) Certification Course: Module 1. R12. x Oracle E-Business Suite Essentials for Implementers Module more...

Oracle 11g Database Developers OCP

Oracle 11g: Oracle Certified Professional (OCP) on Database and Developer's Track Certification available first time in Pakistan, the arrangements are done by Technology Education Academy, the most trusted name in Technology Training, Testing, and Human Resource Development to meet the challenges of 21st Century. The Performance-based Oracle Database and Developers Training & Testing provides more...

Oracle in Pakistan

The management of Technology Education Academy realizes the need of the time to playing an effective and vital role as ICT & OST Solution Provider by synchronizing with the cutting-edge technologies for the Country and the region. Technology Education Academy focuses to develop the human resource, which should get sound knowledge and technical competence to meet the challenges in various industry more...

Training Certification Program R12 Oracle E-Business Suite - Oracle Certified Expert OCE Financial Consultant - Payable

Technology Education Academy is the official Training, HR Development, and Testing Partner to the leading I. T. vendors of the world: 1. Authorized Prometric Test Center (APTC) 2. Microsoft I. T. Academy - Program Member (Advanced Level) 3. Cisco Networking Academy 4. Oracle University 5. Linux Professional Institute (LPI) - Exclusive and Comprehensive Training and Testing Partner in more...

Oracle Database 11g Training for OCP-DBA Certification

We are offering the Weekenda ™s (Saturday & Sunday only) batch for Oracle 11g OCP-DBA training & certification at NED University of Engineering & Technology, which is scheduled to commence from Saturday, March 05, 2011 for professionals. If you wish to join this training, you are requested to rush-up for registration for reserving the seat. Please have a look on details for the program: more...

Supply Chain Management Oracle E-Business Suite R12 Certification

Please note that we are commencing fresh batch on Supply Chain Management Course from Saturday, March 12, 2011 Discount of 82% (one time offer) at our training facility. Following is the course details on EBS R12 and find attached the courseoutlines for each of the modules covered in the training for timely registration. more...

From Software Training Academy, Inc

Oracle 10g Administration

...Oracle supplied users SYS and SYSTEM. Connect to the Oracle database as SYSDBA, both from a host server or - via the use of password files - over a network. Start and stop an Oracle database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT. View and alter initialization parameter values, create and startup with secondary parameter files. more...

Oracle 10g 11g PL SQL Programming

...es. Use the UTL_MAIL package to send email from an Oracle database Use the DBMS_PROFILER package to profile and tune PL/ SQL programs Do simple benchmarking of PL/ SQL code with the DBMS_UTITLITY package Target Audience Developers, Analysts and Database Administrators or any Oracle professional who knows a programming language will also benefit. Course more...

Oracle 10g 11g Advanced SQL

...ills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability directly from the database"), Oracle10g regular expressions for pattern more...

Oracle 10g 11g Introduction to SQL

... to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING OBJECTIVES Describe the principal features of a relational database more...

From Dbametrix Solutions

Oracle 9i DBA course

...maximum benefit for your valuable investment for learning oracle database in depth. All training faculties are well experienced and oracle certified professionals to offer a hands-on and depth knowledge. We develope personal relationship with each student to learning more and make full confidence. We create healthy environment for each and every student for more learning and take more benefits more...

From NobleProg - IT training courses

Oracle Database 11g Performance Tuning

...and Baselines * Limitation of Base Statistics * Oracle Database 11g Solution: Metrics * Benefits of Metrics * Viewing Metric History Information * Statistic Histograms * Database Control Usage Model and Setting Thresholds * Server-Generated Alerts, Creating and Testing an Alert Module 5. Using Baselines * Comparative Performance Analysis with AWR more...

Oracle Database 11g New Features for Administrators DBA Release 2

... 7: Automatic SQL Tuning * Automatic SQL Tuning in Oracle Database 11g * Selecting Potential SQL Statements for Tuning * Controlling the Automatic SQL Tuning Task * Configuring Automatic SQL Tuning * Using the PL/ SQL Interface to Generate Reports Module 8: Intelligent Infrastructure Enhancements * Using New Automatic Workload Repository Views * more...

ORACLE PLSQL Fundamentals

This 3 day course gives an introduction to ORACLE PL/ SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/ SQL commands. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core more...

ORACLE SQL Fundamentals

This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2. The course takes the format of a workshop, with a mix of more...

Oracle BPM basics Training Course

Requirements The course requirements are Oracle bpm studio, Oracle BPM enterprise server, SQL/ Oracle database, Windows OS more...

Oracle 10g XE Administration

This course has been created for database administrators. It covers the concepts and day-to-day Oracle database administrator activities. Requirements Good SQL language knowledge. more...

Oracle 10g DBA Training Course

...-on practice, delegates will be prepared to undertake the Oracle Database 10g Administrator Certified Associate (OCA) Exam (code 1Z0-042). Please note that candidates who wish to obtain the more advanced Oracle Database 10g Certified Professional (OCP) credential must attend one Oracle authorised instructor-led class or instructor-led online class. Further information can be obtained from the more...

From Last Minute Training

Oracle Database 10g Administration I Technical This course Oracle Database 10g Administration will address critical skills needed by Oracle Database 10g administrators and prepare students for the Oracle Database 10g Administration I 1Z1-042 exam. more...

50068A Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator MS Certification This four-day instructor-led course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system. more...

Plsql Programming for Oracle Professionals This course runs for five full days; from 8:30 am to 4:30 pm. PL/SQL is quickly becoming the most widely used programming language for Oracle. In this instructor-led course, we will explore topics such as: * The Oracle Development Environment * Creating the Database * Creating Tables * Structured Query Language Basics * Advanced Structure Query Language * PL/SQL more...

7033 Microsoft SQL Server 2005 for the Experienced Oracle Database Administrator MS Certification The purpose of this 4-day instructor-led course is to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system. more...

From IIHT-Vadapalani

Oracle DBA Training in Chennai ...erviews. and many more. ORACLE CERTIFICATION PROGRAM: Oracle Database 11g Administrator: 1. OCA-Oracle Certified Associate 2. SQL Certified Expert Oracle Certified Associate The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with more...

From NR Computer Learning Center

Introduction to SQL Language course 2 Days In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index more...

Introduction to SQL Language 2 Days In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index more...

From AAZAM College of Technology

Training Certification Program R12 Oracle E-Business Suite - Oracle Certified Expert OCE Financial Consultant - Payable

1. Authorized Prometric Test Center (APTC) 2. Microsoft I. T. Academy - Program Member (Advanced Level) 3. Cisco Networking Academy 4. Oracle University 5. Linux Professional Institute (LPI) - Exclusive and Comprehensive Training and Testing Partner in Pakistan 6. Red Hat Linux: Academic, Training and Testing Partner 7. Novell Suse Linux: Academic Training and Testing Partner 8. Sun more...

Oracle Database 11g One Year Diploma

...Oracle Database 11g: Introduction to SQL Duration: 5 Days What you will learn In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. more...

From Modulus

Introduction to Oracle 10g PLSQL Programming Training

...se triggers which run in the optimized environment of the Oracle Database server. The Oracle10g release has greatly enhanced the features and functionality of PL/ SQL. This advanced course helps PL/ SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle to develop and tune efficient and effective PL/ SQL subprograms. Students more...

Oracle 10g New Features for Programmers Training

This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle 10g databases. more...

Oracle 11g New Features Training

This four day workshop will get students hands-on with all of the important new Oracle 11g features they will need. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. DBA features for memory management, flashback, tables, and new Enterprise Manager tabs will then be covered. The course covers new performance and security more...

Introduction to XML Training

From Ducat

Oracle 10G Developer Training Noida Ghaziabad Faridabad Gurgaon ... data manipulation statements (DML) to update data in the Oracle Database 10g Use the SET operators to create subsets of data Create tables to store data Utilize views to display and retrieve data Create sequences to generate numbers Obtain meta data by querying the dictionary views. Identify the major structural components of Oracle Database 10g Create reports of sorted and restricted data more...

From Webucator

Comprehensive Introduction to Oracle SQL on Oracle 10g

This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide a comprehensive introduction to the SQL database language within the context of an Oracle database. This course can be tailored for application designers and developers, database administrators, and business users and more...

Comprehensive Introduction to Programming with PL/SQL on Oracle 10g

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. This course can be tailored for Application designers and developers or Database administrators. more...

From DTecH IT Education

Oracle 11g Database Administration Workshop I ...participants a firm foundation in basic administration of Oracle Database 11g. In this class, participants learn how to install and maintain Oracle Database 11g. They gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. They also learn how to create an operational database and properly manage the various structures in an more...

From Affinity IT Training, LLC

Oracle Database 11g Administration I

...an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle more...

Oracle Database 11g Administration II

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application more...

Oracle Database 11g New Features For Administrators

The purpose of this course is to present some of the most advanced features available to database administrators which were either introduced with the Oracle 11g release or have been substantially improved with that release. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must more...

Oracle Database 11g PL SQL Fundamentals - Complete Coverage

...nguage, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database. Audience:All Oracle professionals, both business and systems professionals. Among the specific more...

Oracle Database 11g PL SQL Fundamentals I

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups more...

Oracle Database 11g PL SQL Fundamentals II

The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are Application designers and developers and Database administrators. more...

Oracle Database 11g SQL Fundamentals - Complete Coverage

...ion to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL more...

Oracle Database 11g SQL Fundamentals I

...Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are more...

Oracle Database 11g SQL Fundamentals II

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and more...

ADO NET Using Oracle and C

... essential elements of ADO.NET and how to build effective Oracle database applications. The course includes coverage of the Oracle Data Provider for .NET (ODP.NET). There is a practical discussion of data binding and its use in both Windows Forms and Web Forms (ASP.NET) applications. Students will gain a familiarity with creating a Data Access Layer, as it applies to traditional three-tier more...

From Unirac Software Technologies

Oracle Database 10g Administrator Certified Associate 1Z0-042

...Oracle Database 10g Administrator Certified Associate 1Z0-042 Topics Architecture [ ] Outline the Oracle Architecture and its main Components [ ] Explain the Oracle instance architecture Installing the Oracle Database Software [ ] Identify common database administrative tools available to a DBA (1) [ ] Use optimal flexible architecture [ ] Install software with Oracle more...

Oracle Database 10g Database Administrator Oracle Certified Professional-1Z0-043

...Oracle Database 10g Database Administrator Oracle Certified Professional-1Z0-043 Topics Using Globalization Support Objectives [ ] Customize language-dependent behavior for the database and individual sessions [ ] Specify different linguistic sorts for queries [ ] Use datatime datatypes [ ] Query data using case insensitive and accent insensitive searches [ ] Obtain more...

From Ids System Pvt Ltd Bangalore

Oracle R12 HRMS Certification Training

...Oracle Database professionals have used Oracle Certified Professional certification to advance their careers, increase their value, and gain prestige. Now IT professionals can take advantage of the same opportunity with the new Oracle E-Business Suite 11i Applications certification program. Oracle Certifications are tangible, industry-recognized credentials. They are reliable validation of more...

From Ora Training

Oracle Applications DBA training

Oracle Applications DBA training aims at providing complete understanding of Oracle 11i Applications DBA duties to a beginner in Oracle 11i Applications DBA domain. This training would cover Oracle Applications architecture, multi-node installations, Patching, Cloning, Troubleshooting, use of various AD utilities, Oracle Applications file system structure and environment files, managing more...

From Performance Tuning Corporation

Oracle Times Ten In-Memory Database This course provides students with a working knowledge of the Oracle TimesTen 7. 0. 5 IMDB architecture. Students will learn how to install and administer a TimesTen data store, create an operational data store and properly manage the various elements including user and privilege management and connection configuration modes. Students will learn how to tune the database system and gain an more...

Oracle Database 11g R2 New Features for Administrators In this class, the student will learn to implement manageability features to simplify database management, utilize database advisors to provide proactive database monitoring, and increase data availability by using improved ASM, RMAN, and Flashback features. Below are some of the topics covered in the course. more...

Oracle Database 10g RAC for Administrators ...Oracle Database: 10g RAC for Administrators course combines in-depth technical training on Oracle database and clustering, to provide the student with a comprehensive ability to plan, configure and administer Oracle RAC for performance and high availability. After completing this class, the student will have learned skills necessary to configure and maximize the performance of their Oracle RAC more...

Oracle Database 11g R2 RAC and Grid Infrastructure for Administrators ...nclude how to configure Cluster Ready Services (CRS), the Oracle Database instances, and Oracle Net in a RAC environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues more...

Oracle Database 11g RAC Deployment Workshop This course provides users familiar with the Oracle database with experience in configuring and deploying Oracle 11g RAC. Students will gain experience in Oracle clusterware, ASMLib, ASM, OCFS2 and Oracle RAC. The student will become proficient in configuring Oracle RAC on Linux, including the upgrade process. This course is also available for Oracle 10g. more...

From High Technologies Solutions

ERP Functional training at Noida ERP (SAP) courses: Functional Who Should Attend: The audience for this course is MBA (any stream), B. Com, CA, CS, PGDBM, ICWA. FI/ CO (Finance & Controlling) SAP FI - Here SAP handles accounting and finance postings. The main activity is Accounts Receivable (customers) and Accounts Payable (suppliers), and normal General Ledger accounting, for example bank accounts. But also cash more...

ERP SDCRM training at NOIDA ERP SD - SAP handles sales activities and distribution, also called shipping. The main activities are the sales order handling, and the distribution of shipments to customers. Also the billing process, customer invoice, is handled from the SD module. This course will give you a good and broad overview of SAP SD sales and distribution. You will learn to perform the most important tasks in SAP more...

ERP BASIS training in 60 hrs T he R/ 3 basis software is the set of programs and tools which interfaces with computer operating system the underlying database, the communication protocols, and the presentation interfaces. This software enables the R/ 3 applications (FI, CO, SD, etc.) to have the same functionality and work exactly the same way no matter what operating system or database the system is installed on. The R/ 3 more...

ERP ABAP4 Training at NOIDA ABAP / 4 - ABAP is SAP's ERP fourth generation language. All of R/ 3's applications and even parts of its basic system are developed in ABAP. ABAP is used for customization and modification of ERP (SAP) applications. a ABAP PROGRAMMING LANGUAGE a COMPONENTS OF ABAP DICTIONARY a REPORTS & Event Handling a ABAP QUERY a ERP SCRIPTS / FORM PAINTERS a LSMW (LEGACY SYSTEM more...

ERP technical training at Noida ERP (SAP) courses: Technical: Who Should Attend: The audience for this course is MCA, BCA, B.Sc(IT),M. Sc(IT),B. Sc, B.Tech or B. E(Any Branch),O Level, A Level. Administration and networking BASIS T he R/ 3 basis software is the set of programs and tools which interfaces with computer operating system the underlying database, the communication protocols, and the presentation more...

ERP Technical - Functional Training at Noida SAP: Systems, Applications & Products in Data Processing SAP is an ERP software package (Enterprise Resource Planning) developed in Germany. SAP provides a range of solutions to empower every aspect of the business operations. Companies or Organizations using SAP gain the visibility to pinpoint inefficiencies, and the capabilities to transform them into competitive advantage. They gain the more...

From Sennovate Infotech (India)

Live Training in Oracle 10g11g11i12i DBARACDGWeb Tec ... comprehensive launch pad for anyone aspiring to become a Oracle Database Administrator or Data warehousing Professional. It is designed to help aspiring IT professional gain the competence and depth of skills in Oracle. Addressees: This Oracle training is designed for the Students who wantsa ™ to build their career in Oracle database administration. This includes any computer more...

From Microsys Technologies and Solutions Pvt. Ltd.,

Oracle 10g DBA

...Oracle Database 10g Installation Oracle Database Creation Oracle Database Architecture Oracle Database Operations Managing Storage Managing Users, Privileges and Roles Oracle Database Security Managing Schema Objects Transporting Data Oracle Net Services Oracle Shared Server Performance Monitoring Diagnostic Sources Monitoring and Managing Memory Undo Management Locks Management Backup more...

From Matrix Zeroone systems

Best institute to learn java in pune Java pune ... * JDBC-Struts Application * The Road Ahead Oracle Database * What is DBMS and RDBMS * Database concepts * Oracle installation * Overview of SQL(DDL, DML, DCL, DQL) * Database, User, Table creation * Constraints * Operators * Oracle Functions * Joins and subqueries * Indexes * Views, clusters and sequences * more...

From Mercury Solutions Limited

Upgrade to Oracle10g ...Oracle Database 10g DBA OCP the students gain in-depth knowledge and skills to create and configure Oracle database, manage back up & recovery, handle networking and security, and they also learn about the new features in Oracle Database 10g Release 2 - the database for Grid computing. Pursuing this course, the students get a clear understanding of the usage of Database 10g new features to more...

Oracle OCA OCP DBA 9i 10g 11g This great combo gives a solid fundamental as well as professional level knowledge of Oracle 9i, 10g & 11g. Pursuing this course, the candidate gains in-depth- knowledge of the Oracle database concepts, design and technologies. The holder of Oracle OCA & OCP DBA 9i, 10g & 11g combo certificate can expertly install, design and manage the database, as well as handle backup and recovery procedures more...

OCA OCP DBA 9i Oracle certifications remain the most popular certifications in the IT industry. Oracle 9i has two levels of certifications on its path. * Oracle Certified Associate (OCA) a validates basic 9i DBA skills * Oracle Certified Professional (OCP) a validates advanced 9i DBA skills OCA/ OCP DBA 9i accreditation demonstrates deep knowledge of basic Oracle database management. Earning more...

OCA DBA 9i Oracle certifications remain the most popular certifications in the IT industry. Oracle 9i has two levels of certifications on its path. * Oracle Certified Associate (OCA) a validates basic 9i DBA skills * Oracle Certified Professional (OCP) a validates advanced 9i DBA skills The Oracle OCA DBA 9i is a foundation level certification and highlights onea ™s basic knowledge of more...

Oracle Database 10g Backup and Recovery In this course, the students learn to identify the recovery requirements and device a proper strategy for the backup and recovery. They also learn to perform backup and recovery operations using RMAN and Enterprise Manager. Getting certified for Oracle Database 10g Backup and Recovery course, the candidate proves his expertise in installing and configuring Oracle secure back up to back up database more...

Oracle Database 10g Data Guard Administration Release 2 This course will teach you how to use Oracle Data Guard, Data Guard design & structure and the creation of physical and logical standby databases. A certified Oracle Database 10g: Data Guard Administration Release 2 professional is deft at using various Data Guard features and various troubleshooting techniques to protect data loss. Upon the completion of this course, the student will be able more...

Oracle Database 10g RAC for Administrators Release 2 ...Oracle Database 10g: RAC for Administrators Release 2 certification course teaches IT professionals about the common features and functionalities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Upon the completion of this course, the candidates can successfully: * Install, administer and examine the Real Application Clusters database * Administer Oracle more...

Oracle Database 10g Performance Tuning This Oracle Database 10g Performance Tuning certification course teaches how to best use 10g Database through Performance Tuning. Performance tuning maximizes the efficacy of the database. Through performance tuning and practicing the manual tuning methods using the stats pack tool, the students learn to derive the maximum out of Oracle Database 10g. more...

OCA OCP 10g Forms Developer Certified Professional The Oracle 10g DBA OCA & OCP and Upgrade to 11g training enables IT professionals to successfully install, manage, and troubleshoot all aspects of Oracle 10g OCA/ OCP and also manage the advanced level OCA 11g Database. OCA/ OCP DBA10g and Upgrade to 11g certified professionals stand above the rest for their expertise in handling the industry's most advanced information systems. They can more...

OCA OCP DBA 10g This credential enables IT professionals to successfully install, manage, and troubleshoot all aspects of Oracle database. OCA DBA 10g and Oracle10g OCP certified professionals are highly valued and highly paid for effectively managing the industry's most advanced information systems. more...

Oracle 11g PLSQL Developer OCA With Oracle Database 11g: Program with PL/ SQL certification course, the students learn the basics of using PL/ SQL within a database environment. The PL/ SQL is needed to create; procedures, database triggers, packages and functions. more...

Oracle Database SQL Expert Oracle Database SQL Certified professionals highlight a wide range of skills and knowledge required for working with the SQL programming language. These include: * Retrieving data * Restricting and sorting data * Manipulating data within the database * Controlling user access * Creating schema objects * Managing schema objects more...

Oracle Database 11g Data Warehousing Fundamentals With Oracle Database 11g: Data Warehousing Fundamentals certification course, the candidates learn the basics of data warehousing. Upon the completion of this course, they can effectively plan, design and maintain a data warehouse using various Oracle Database features. more...

Oracle Database 11g Performance Tuning The Oracle Database 11g: Performance Tuning certification validates the in-depth knowledge to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor and Automatic Workload Repository and Automatic Database Diagnostic Monitor. more...

Oracle Database 11g New Features for Oracle 9i DBA ...Oracle Database 11g: New Features for Oracle 9i DBAs accreditation teaches about the usage of new features of Oracle Database 10g and Oracle Database 11g. The new features such as ASM, RMAN, and Flashback, help increase the database availability and streamline the entire database management. Taking this certification course, the database administrators learn how to upgrade Oracle9i database to more...

Oracle 10g DBA OCA OCP and Upgrade to 11g The Oracle 10g DBA OCA & OCP and Upgrade to 11g training enables IT professionals to successfully install, manage, and troubleshoot all aspects of Oracle 10g OCA/ OCP and also manage the advanced level OCA 11g Database. OCA/ OCP DBA10g and Upgrade to 11g certified professionals stand above the rest for their expertise in handling the industry's most advanced information systems. They can more...

OCA OCP DBA 11g The internationally recognized OCA DBA 11g and OCP DBA 11g certification validates deep knowledge and wide range of skills required to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, etc. Upon the completion of this course, the candidate, becomes proficient in the user and security administration, backup and more...

OCA DBA 11g The OCA DBA 11g certification proves onea ™s expertise to perform all basic Oracle tasks for database administration or application development. Ita ™s a basic Oracle qualification that helps candidates consolidate their skills to install, implement, administer and troubleshoot Oracle database, which in turn brings industry recognition. more...

Microsoft SQL Server 2008 for Experienced Oracle Database Administrator This course teaches students how to make the most of their skills and knowledge as an Oracle DBA to manage a Microsoft SQL Server system. The Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator certification course helps Oracle database administrators to distinguish and compare Oracle database management to SQL Server database management. Upon the successful completion of more...

From Oracle DBA Live Scenarios and Real Training

oracle dba training in chennai live real time focus Sabari a Chennai a 9994408197 Oracle DBA - Database Administration in Oracle 9i DBA / Oracle 10g DBA New Features / RAC 10gDBA / Oracle 10g DataGuard, Providing effective Training with DBA Project Oriented and Real Time focus with live scenarios by excellent experienced and working Technical DBA Lead professional. For Complete Oracle DBA Training Details, Visit: more...

From Corporate Education Group

Oracle Database 10g Program with PL SQL

...Oracle Database 10g users. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They more...

From Object Arena

ORACLE 10g11gDBA TrainingObjectArena Chennai ... - The oracle enterprise architecture - Creating AN oracle database & database instance - Manage Database Storage Structures: Tablespaces - DML, DDL, DCL statements - Triggers & Stored Procedures - SQL loader Export / Import data - Managing concurrency & locks - Database maintenance & performance management - Backup & recovery concepts & configuration Realtime Project more...

From Victoria International College of Business and Technology

Oracle Database 10g Administration DBA Certificate Training in Toronto ...Oracle Database (10g) Administration (DBA) Certificate Training Free Info Seminar: Jan 10, Sat 2: 30pm-4pm; Jan 17, Sat 4pm-5: 30pm We welcome you to attend the free Info Seminar on Sat! Please call David Li at 647-290-5809 or email at davidli@viccollege. com for further inquiry and reservation. Who Should Take the Course: Anyone who wants to go through a complete Oracle DBA more...

From Impart IT Training

Introduction to PLSQL This course will give you an introduction to Oracle Corporationa s proprietary procedural extension to the SQL database language, PL/ SQL. PL/ SQL (Procedural Language/ Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle more...

From Arthur McNeil Institute

Oracle Database Administrator Certification

The Oracle Certified Professional Program establishes a highly recognized standard of excellence in today's I.T. market. This course provides a comprehensive foundation for designing, building and working with relational databases, enabling students to understand and use commercially available relational DBMS products effectively. Arthur McNeil provides the Oracle Database training more...

From GB Education

REAL APPLICATION CLUSTER (RAC)

Introduction Oracle RAC 10g Overview Shared-Storage Overview FireWire Technology Install the Linux Operating System Network Configuration Obtain and Install a Proper Linux Kernel Create "oracle" User and Directories Creating Partitions on the Shared FireWire Storage Device Configure the Linux Servers Configure the hangcheck-timer Kernel Module Configure RAC Nodes for Remote Access Check RPM more...

From Corporate Education Group

Oracle Database 10g Administration Workshop I

...n this class, you'll learn how to install and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, more...

Oracle Database 10g Administration Workshop II

...ration. In this class, you'll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database more...

Oracle Database 10g Introduction to SQL

...Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets more...

Oracle Database 10g: New Features for Administrators

...Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to more...

Oracle9i Database Performance Tuning

This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning, rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, participants will learn to recognize, more...

Oracle9i DBA Fundamentals I

...Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students will gain a conceptual understanding of the Oracle9i database architecture and how the architectural structures work and interact with one another. Students will also create an operational database and properly manage the various structures in an effective and efficient manner, resulting in a more...

Oracle9i DBA Fundamentals II

...Oracle database administrator (DBA) a firm foundation in fundamental database administrative tasks. Students will examine loading and transporting techniques for databases, and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, and solutions for common network problems. In hands-on exercises, students configure more...