Oracle sql courses

...To acquire knowledge and skills in Oracle 10g OCP. Suitable for: Anyone...

...This Oracle Application Express course introduces the delegate to Oracle's Application Express version 4 software. It is designed to give delegates practical experience in using Application Express version 4, also known as Apex, for building web-based applications for an Oracle database...

...This is a practical course covering Oracle's flagship report writing tool, Oracle Reports v6/6i and also v3. The course aims to cover ground level techniques necessary to understand the product and implement enterprise standard reports within the development business environment. Suitable...

... concepts of PL/SQL... Learn about: Access Control...

... with constructing a Client/Server system based on an Oracle 10G RDBMS. Suitable for: The course has been designed for management, business analysts, system architects and others who need a high level overview of how an Oracle 10G based Client/Server system is constructed...

... administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. Suitable for: Database administrators...

..., Enterprise JavaBeans and Web Services. The course explores the full functionality of the, now. Suitable for: Oracle Web Developers. Oracle Analyst/Programmers. Oracle Developers. Web Technicians. Java Developers...

... of the inefficient SQL statements. Students learn to interpret execution plans, and the different ways in which data can be accessed. They will learn how the optimizer chooses the path and how to influence the optimizer to ensure that the best method is used. This course covers Automatic SQL Tuning tools... Learn about: Database training...

... an Oracle based application. Use the standard features and facilities of Oracle to. Suitable for: The course is for support or operations staff who are required to provide ad-hoc assistance to the Oracle DBA function. Such delegates might include PC support, mainframe operators or UNIX system administrators...

...This course is designed to give you a thorough grounding in the use of the ORACLE relational database management system (RDBMS). You will be given a detailed introduction into the concepts of an RDBMS, the use of SQL to interrogate and manipulate data on a database, how to create a database scheme...

...) which built on thefunctionality introduced with Release 1and was substantially different. Suitable for: Oracle Database Administrators. Oracle System Administrators. Oracle Support Engineers. Oracle Network Administrators. Oracle 9iAS/10gOAS. Administrators...

... of the inefficient SQL statements. Students learn to interpret execution plans, and the different ways in which data can be accessed. They will learn how the optimizer chooses the path and how to influence the optimizer to ensure that the best method is used. This course covers Automatic SQL Tuning tools... Learn about: Database training...

..., which will hide the complexity of the data source and provide a user-friendly view of. Suitable for: This course is for Oracle Administrators supporting Discoverer...

...What is Oracle Discoverer? Overview Discoverer Components The Discoverer Administration Interface The Data Page The Hierarchies Page The Item Classes... Learn about: Oracle 10g...

... features offered in the latest release of the Oracle database. Suitable for: Database Administrators. Support Engineer. Data Warehouse Administrator. Technical Consultant. Project Managers...

..., and execute stored procedures and functions.Design and use PL/SQL packages.Create overloaded package subprograms for more flexibility.Utilize Oracle supplied packages in application development.Create triggers to solve business challenges.Build and execute SQL statements dynamically.Manage PL/SQL subprograms... Learn about: Application Development, Database training...

... interfaces. Suitable for: This course is for programmers and developers who need to design applications to access the Oracle database. This course takes students though application development in Developer Forms 10G beginning with basic form design and ending up with fully integrated applications rollout...

... Applications. This course is also suitable for delegates intending to sit the Oracle Internet. Suitable for: This course is designed to equip programmers and software developers with the main techniques and essential knowledge required to develop web-based database applications using Oracle Forms...

... to, and as they develop. We cover all aspects of internal database tuning on an Oracle. Suitable for: Oracle Database Administrators. Oracle Systems Engineers. Oracle Support Engineers... Learn about: Oracle 10g...

... for Optimal PerformanceManaging StatisticsCreating and Using IndexesStructuring SQL Statements for PerformanceExamining and Interpreting the Execution Plan of a SQL Statement using EXPLAIN PLANExamining the Efficiency of SQL Statements using SQL Trace and AutotraceUsing the SQL Tuning AdvisorIdentifying... Learn about: Database training...