Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

Oracle training courses and schools
DBA/OCA/OCP

School: Learning Tree International Ltd.
[All Courses]

Oracle PL/SQL
Course Format: Classroom
You Will Learn How To Develop efficient PL/SQL programs to access Oracle databases Create stored procedures and functions for maximum reuse and minimum code maintenance Design modular applications using packages Manage data retrieval for front-end applications Bulk bind collections to increase the speed of data movement operations Invoke native dynamic SQL to develop high-level abs...
 

Oracle Database 10g
Course Format: Classroom
You Will Learn How To Build, query and manipulate Oracle 10g databases to create powerful applications Retrieve and manipulate data efficiently using powerful SQL features Create and manage database tables, views and sequences Maintain data integrity and enforce security with privileges and roles Compose reusable structured PL/SQL code with cursors and procedures Enhance performanc...
 

Oracle Database 11g
Course Format: Classroom
You Will Learn How To Design, build and manage Oracle 11g database applications Establish a data model and a storage framework Retrieve and manipulate data efficiently using SQL Developer Create and manage database tables, sequences and synonyms Ensure data integrity, enforce security and enhance performance Write structured PL/SQL code to develop stored procedures, triggers and pa...
 

School: Harbrook
[All Courses]

Oracle SQL PL
Course Format: Classroom
After completing this course, the student should be able to: Write programs which use some or all of the primary PL/SQL programming constructs. Course outline Program Blocks Variables and Constants Data Types Using SQL Statements within PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and ...
 

Oracle SQL Advanced
Course Format: Classroom
After completing this course, the student should be able to: Use SQL Developer as an alternative to SQL*Plus Manage Schema Objects with Data Dictionary Views Write Multiple Column Subqueries Manage Large Data Sets with Subqueries Construct Hierarchical Queries Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions Manage Data in Different Time Zones Use Regular Expression ...
 

Oracle SQL
Course Format: Classroom
After completing this course, the student should be able to: Describe the basic structure of a relational database Use the command line features of SQL*Plus Use SQL Developer to access an Oracle Database Create SQL statements to select data from an Oracle Database Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous funct...
 

Oracle Database 10g DBA
Course Format: Classroom
After completing this course, the student should be able to: This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database. The Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators...
 

School: qa ltd.
[All Courses]

oracle database 11g: program with pl/sql
Course Format: on-site
this course introduces students to pl/sql and helps them understand the benefits of this powerful programming language. students learn topl/sql blocks of application code that can be shared by multiple forms, reports, and data management applications. students learn toanonymous pl/sql blocks as well as stored procedures and functions. students learn to develop, execute, and m...
 

oracle database 11g Workshop
Course Format: on-site
this course is designed to give students a firm foundation in basic administration of oracle database 11g. in this class, students learn how to install and maintain oracle database 11g. students gain a conceptual understanding of the oracle database architecture and how its components work and interact with one another. students learn how toan operational database and properly manage th...
 

oracleas discoverer 10g
Course Format: on-site
this course introduces students to the querying and analytical capabilities of oracleas discoverer. students will learn how to view data stored in a relational database, and analyze andreports based upon that data using oracleas discoverer plus. in particular, students will learn how to create, modify, and refine ad hoc queries using discoverer’s intuitive and easy-to-use workbook wizar...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 [ Popular Topics ] [ Schools Only ]