tailieunhanh - The Wise Approach to Oracle Training phần 2

Tham khảo tài liệu 'the wise approach to oracle training phần 2', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Ị Oracle PL SQL Programming and Tuning Curriculum Development This course was designed by Donald K. Burleson a leader in Oracle programming with over 30 years of database programming experience. Author of more than 30 database books Burleson designed this course to get people started fast in writing debugging and deploying PL SQL as he shares his secrets in this intense training. Course Oracle PL SQL Programming and Tuning Duration Five 5 days Cost 15 plus travel expenses Size Up to twenty 20 students Description PL SQL Programming Tuning is an intense hands-on course that is designed to get the student writing Oracle PL SQL quickly. The student learns by doing and this class has dozens of in-class exercises and the student will be guided from very simple SQL commands to increasingly complex PL SQL coding techniques. The topics start with the basics of SQL and progress into increasingly complex queries including table joins sub-queries and creating Oracle views. The PL SQL section begins with simple concepts and the student gradually masters PL SQL through increasingly challenging classroom exercises. Prerequisites Prior experience with Oracle is not required but experience using SQL with a relational database is highly desirable as-is experience with any procedural language. Target Audience This course is ideal for any Oracle professional who needs to write and implement PL SQL programming. This course is popular with Oracle developers and DBAs but it is also useful for any technical staff that must interact with Oracle. Course Objectives By the end of this course the student should be able to write advanced PL SQL code blocks and use advanced features such as ref cursors and bulk fetches. The student will also become familiar with the internals of Oracle9i PL SQL and compiling PL SQL for super fast performance. Course Book Oracle PL SQL 101 Christopher Allen ISBN 007212606X Syllabus Topics PL SQL Tables Ensuring Complete Error Checking PL SQL Structures .