Acrobat X Files

Home > Programming > Oracle Programming

DB50 5Day Oracle 10g / PLSQL SQL Training

Sort Desciption:

by Oracle together with PL/SQL programming tools and techniques and. Oracle DBA topics including tuning database backup and recovery and ...

Content Inside:

DB50 5Day Oracle 10g / PLSQL SQL Training Page 1V1.1 Oak Lodge Consulting LtdCambridge 01223890390www.oaklodgeconsulting.co.ukDB5 0 5Day Oracle 10g / PLSQL SQL Training This tailored course presents the SQL language as implemented via SQL*PLUS by Oracle together with PL/SQL programming tools and techniques and Oracle DBA topics including tuning database backup and recovery and performance monitoring. Delegates will learn how to design and declare tables and how to write effective SQL statements to query update delete and insert records into a relational database. The creation and test of Stored procedures and Triggers using PL/SQL is presented and supported by numerous exercises. Techniques for analysing the efficiency of Queries are described and attendees will also see how to use MS Access to frontend to Oracle for userfriendly support. Oracle 9i architecture and DBA functions including user management backup and recovery database cloning and monitoring are also covered in depth.Course Objectives On completing this course delegates will be able to: Perform ER analysis and design leading to effectiveRDBMS implementationShow how RDBMS are an integral part of distributed systems. Explain the reasons for SQL Understand relational databases in theory and practice Write SQL statements to query relational databases Write SQL statements to insert modify or delete records Understand how to join multiple tables and why this is necessary. Be familiar with the various forms of the SQL Query Be able to create and debug Stored Procedures in PL/SQLUnderstand the use of Data Control Language Develop Triggers in PL/SQL and use them for maintaining database integrity.Be able to define Views Use Access to connect to RDBMS. Understand how to monitor the performance of Queries Understand the architecture of Oracle and its current features Be familiar with the tools and utilities of Oracle Manage Users and Roles andeffectively Be able to create maintain and configure a database Und ...

Source: www.oaklodgeconsulting.co.uk

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...