O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Path: Professional Oracle Developer

Video Description

This Learning Path includes Oracle SQL Performance Tuning for Developers LiveLessons, Oracle PL/SQL Advanced Programming LiveLessons, and Toad for Oracle LiveLessons.

Prerequisites:

Working knowledge of the SQL query language

Overview:
The focus of Oracle SQL Performance Tuning for Developers LiveLessons is to illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. Oracle PL/SQL Advanced Programming LiveLessons teaches developers with PL/SQL experience the new and advanced features of the PL/SQL language along with performance tuning techniques. Toad for Oracle LiveLessons video training covers the latest features of TOAD necessary to view, extract, and manipulate data within the Oracle database. This course is designed for both the developer using Toad to aid in programming Oracle objects, as well as for the business analyst using Toad as a query tool for data extraction and analysis. There is even a complete lesson for the database administrator.

Skill Level:

Beginner-to-Intermediate

Downloads:

Oracle_SQL_LiveLessons_File_Download.zip

PLSQL_Fundamentals_LiveLessons.zip

Adv_PLSQL_LiveLessons.zip

Toad_Live_Lessons_Download.zip

About the Instructor

Dan Hotka is a training specialist and an Oracle ACE director with more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well-published with 12 Oracle books and over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons, Oracle SQL, and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com.

About LiveLessons

The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons.

Table of Contents

  1. Introduction
    1. Oracle SQL Performance Tuning for Developers LiveLessons: Introduction 00:04:14
  2. Lesson 1: Oracle Database Architecture
    1. Learning Objectives 00:00:47
    2. 1.1 Explore how Oracle processes SQL 00:16:10
    3. 1.2 Understand Library Cache Internals 00:05:12
    4. 1.3 Handle SQL with Bind Variables handling 00:04:27
    5. 1.4 Explore the performance advantages of SQL using Functions 00:03:53
    6. 1.5 See what's new for Oracle12: SQL Directives 00:03:56
    7. Put it all together 00:01:29
  3. Lesson 2: Oracle Execution Plans/Explain Plans
    1. Learning Objectives 00:00:53
    2. 2.1 Understand Explain Plans 00:01:41
    3. 2.2 Set up and use the PLAN_TABLE 00:04:24
    4. 2.3 Use SQL*Plus 00:11:59
    5. 2.4 Use TOAD 00:03:33
    6. 2.5 Use SQL Developer 00:01:27
    7. 2.6 Use Rapid SQL 00:01:47
    8. 2.7 Use JS Tuner 00:03:02
    9. 2.8 Use SQL Trace 00:15:37
    10. 2.9 Get the correct information from Oracle to solve SQL performance issues 00:06:23
    11. Put it all together 00:01:22
  4. Lesson 3: Explain Plan Content
    1. Learning Objectives 00:00:24
    2. 3.1 Understand Explain Plan Anatomy 00:08:24
    3. 3.2 Explore the Oracle SQL Parsing Process 00:07:05
    4. 3.3 Understand the Cost-Based Optimizer steps 00:14:25
    5. 3.4 Explore the Explain Plan Line-Item Content 00:13:01
    6. 3.5 Understand Table Joins 00:10:13
    7. 3.6 Explore the Optimizer Choices 00:15:46
    8. 3.7 See common issues with poorly performing Partitioned queries 00:05:33
    9. 3.8 Use Driving Table Hints 00:07:05
    10. Put it all together 00:01:20
  5. Lesson 4: Indexes
    1. Learning Objectives 00:00:53
    2. 4.1 Understand how Indexes work 00:06:20
    3. 4.2 Explore the Complete Index syntax 00:19:32
    4. 4.3 See how the CBO chooses which Index to use 00:02:14
    5. 4.4 Utilize Index Monitoring 00:06:40
    6. 4.5 Understand Index Clustering Factor 00:10:46
    7. 4.6 Utilize Bitmap Indexes 00:05:41
    8. 4.7 Understand Index-organized tables 00:03:13
    9. 4.8 Explore Index tips and techniques 00:05:26
    10. 4.9 Use some helpful Index Hints 00:05:39
    11. Put it all together 00:01:22
  6. Lesson 5: Where Clause Processing
    1. Learning Objectives 00:00:31
    2. 5.1 Understand how the CBO arrives at row estimations 00:03:16
    3. 5.2 Explore where the math goes wrong 00:01:49
    4. 5.3 Use the proper data types for better performance 00:07:21
    5. 5.4 Look at the Where clause content 00:02:46
    6. Put it all together 00:00:58
  7. Lesson 6: Sorts/Views/Sub-Query Processing
    1. Learning Objectives 00:00:31
    2. 6.1 Look at SQL that has Sorts 00:04:08
    3. 6.2 Explore how the CBO processes views 00:03:02
    4. 6.3 Understand Sub-query processing 00:07:13
    5. 6.4 Control the Explain Plan via Sub-queries 00:08:49
    6. 6.5 Use Hints in Sub-queries 00:03:33
    7. Put it all together 00:01:09
  8. Lesson 7: Problem SQL Review
    1. Learning Objectives 00:00:28
    2. 7.1 Spot Problem SQL via Explain Plan 00:02:21
    3. 7.2 Review Problem SQL 1 00:02:32
    4. 7.3 Review Problem SQL 2 00:01:39
    5. 7.4 Review Problem SQL 3 00:01:54
    6. 7.5 Use Table Alias for code readability 00:05:05
    7. 7.6 Review Hints 00:07:08
    8. Put it all together 00:00:46
  9. Lesson 8: Data Types and Statistics
    1. Learning Objectives 00:00:27
    2. 8.1 Use the proper data types 00:03:16
    3. 8.2 Understand CBO Histograms 00:08:36
    4. 8.3 Explore Oracle12 Adaptive Statistics 00:01:39
    5. 8.4 Review Oracle Adaptive SQL Plans 00:06:29
    6. Put it all together 00:01:05
  10. Summary
    1. Oracle SQL Performance Tuning for Developers LiveLessons: Summary 00:00:59
  11. Introduction
    1. Toad for Oracle: Introduction 00:06:02
  12. Lesson 1: Toad for Oracle Course Overview
    1. Learning objectives 00:00:28
    2. 1.1 Understand the course pre-requisites 00:00:53
    3. 1.2 Understand the course database objects and the course download 00:03:18
    4. 1.3 Introduce Toad for Oracle Unleashed book 00:00:42
    5. Put it all together 00:00:19
  13. Lesson 2: Toad Configuration and Setup Option
    1. Learning objectives 00:00:27
    2. 2.1 Install Toad 00:00:46
    3. 2.2 Understand login panel options and configuration 00:06:05
    4. 2.3 Explore useful Toad options panels 00:14:30
    5. 2.4 Customize the Tool bar 00:05:11
    6. Put it all together 00:00:43
  14. Lesson 3: SQL and the Editor Window
    1. Learning objectives 00:00:44
    2. 3.1 Use the editor window 00:06:49
    3. 3.2 Work with the describe panel 00:06:45
    4. 3.3 Discover useful SQL code 00:05:58
    5. 3.4 Work with the Toad SQL history feature 00:04:35
    6. 3.5 Discover useful user enhancements 00:04:02
    7. 3.6 Introduce Toad's Code Review 00:05:05
    8. 3.7 Hands-on Lab 00:08:24
    9. Put it all together 00:00:41
  15. Lesson 4: The Schema Browser
    1. Learning objectives 00:00:35
    2. 4.1 Use the Toad schema browser panel to configure the interface LHS and RHS options 00:04:39
    3. 4.2 Manage vast numbers of objects 00:06:18
    4. 4.3 Create object wizards from navigator tree 00:04:50
    5. 4.4 Explore additional data grid features 00:07:07
    6. 4.5 Export data from the data grid 00:05:45
    7. 4.6 Create reports from data grids using the Fast Reports interface 00:04:48
    8. 4.7 Hands-on Lab 00:14:08
    9. Put it all together 00:00:51
  16. Lesson 5: PL/SQL Tips and Techniques
    1. Learning objectives 00:00:28
    2. 5.1 Explore PL/SQL 00:06:27
    3. 5.2 Work with code templates 00:06:11
    4. 5.3 Use the PL/SQL symbolic debugger 00:13:28
    5. 5.4 Hands-on Lab 00:02:44
    6. Put it all together 00:00:35
  17. Lesson 6: Toad as a SQL Tuning Tool
    1. Learning objectives 00:01:03
    2. 6.1 Utilize Toad Explain Plan features 00:06:46
    3. 6.2 Use the query viewer 00:01:43
    4. 6.3 Work with auto trace 00:01:28
    5. 6.4 Use Auto Optimize SQL/SQL Tuning Advisor 00:04:50
    6. 6.5 Utilize Session Browser to show SQL, wait events and locking 00:09:55
    7. 6.6 Work with SQL Trace (10046 trace) 00:04:13
    8. 6.7 Work with the PL/SQL profiler 00:06:01
    9. 6.8 Hands-on Lab 00:06:47
    10. Put it all together 00:00:49
  18. Lesson 7: Toad for the Database Administrator
    1. Learning objectives 00:00:42
    2. 7.1 Utilize Toad monitoring features for the DBA 00:06:20
    3. 7.2 Review Toad's tablespace management options 00:03:39
    4. 7.3 Work with statistics and useful monitoring assistance 00:08:25
    5. 7.4 Review additional DBA topics in Toad 00:03:49
    6. Put it all together 00:00:25
  19. Lesson 8: Other Useful Features of Toad
    1. Learning objectives 00:00:38
    2. 8.1 Explore Automation Designer 00:03:51
    3. 8.2 Utilize Finding Objects 00:02:36
    4. 8.3 Work with HTML doc generator 00:05:32
    5. 8.4 Use Toad's compare features 00:04:36
    6. 8.5 Create objects and scripts using Toad 00:04:56
    7. 8.6 Explore various Toad reports 00:02:40
    8. 8.7 Review useful keystrokes in Toad 00:04:27
    9. 8.8 Hands-on Lab 00:03:44
    10. Put it all together 00:00:42
  20. Lesson 9: Object and Data Relationship Features, Query Builder Features
    1. Learning objectives 00:00:28
    2. 9.1 Discover master/detail data browsing 00:02:50
    3. 9.2 Use Entity Relationship Diagram 00:02:44
    4. 9.3 Use Query Builder 00:05:22
    5. 9.4 Hands-on Lab 00:05:17
    6. Put it all together 00:00:55
  21. Summary
    1. Toad for Oracle: Summary 00:01:49
  22. Introduction
    1. Oracle PL/SQL Programming: Fundamentals to Advanced: Introduction 00:02:00
  23. Introduction
    1. Oracle PL/SQL Programming Fundamentals LiveLessons: Introduction 00:05:21
  24. Lesson 1: PL/SQL Course Overview
    1. Learning Objectives 00:00:18
    2. 1.1 Understand the course pre-requisites 00:01:11
    3. 1.2 Learn the Oracle database objects to be used in this course 00:02:33
    4. 1.3 Review the command-line SQL*Plus tool 00:03:48
    5. 1.4 Review SQL Developer tool 00:03:28
    6. 1.5 Review TOAD tool 00:03:04
    7. Put it all together 00:00:52
  25. Lesson 2: Oracle PL/SQL Overview
    1. Learning Objectives 00:00:27
    2. 2.1 Review Oracle architecture 00:04:02
    3. 2.2 Review PL/SQL overview 00:07:58
    4. Put it all together 00:00:43
  26. Lesson 3: PL/SQL Basics and Variables
    1. Learning Objectives 00:00:18
    2. 3.1 Explore PL/SQL basics 00:05:03
    3. 3.2 Use PL/SQL variables 00:22:38
    4. Put it all together 00:00:33
  27. Lesson 4: Logic Flow
    1. Learning Objectives 00:00:21
    2. 4.1 Understand IF/THEN/ELSE logic 00:09:14
    3. 4.2 Explore the CASE statement 00:06:28
    4. 4.3 Utilize looping syntax 00:12:41
    5. Put it all together 00:00:16
  28. Lesson 5: PL/SQL Cursors
    1. Learning Objectives 00:00:18
    2. 5.1 Introduce PL/SQL cursors and the implicit cursor 00:05:01
    3. 5.2 Explore explicit cursors 00:10:31
    4. Put it all together 00:00:48
  29. Lesson 6: PL/SQL Exception Handling
    1. Learning Objectives 00:00:33
    2. 6.1 Introduce PL/SQL exceptions 00:02:06
    3. 6.2 Explore PL/SQL exception basic syntax 00:03:44
    4. 6.3 Discover implicit vs explicit exceptions 00:04:32
    5. 6.4 Work with SQLCODE and SQLERRM features 00:02:43
    6. 6.5 Understand user-defined exceptions 00:02:12
    7. 6.6 Use application-defined exceptions 00:05:30
    8. Put it all together 00:01:08
  30. Lesson 7: PL/SQL Procedures and Functions
    1. Learning Objectives 00:00:30
    2. 7.1 Introduce PL/SQL procedures and functions 00:02:08
    3. 7.2 Explore PL/SQL procedures 00:04:33
    4. 7.3 Understand PL/SQL functions 00:06:05
    5. 7.4 Work with parameter passing 00:15:06
    6. Put it all together 00:00:42
  31. Lesson 8: PL/SQL Packages
    1. Learning Objectives 00:00:18
    2. 8.1 Introduce PL/SQL packages 00:02:56
    3. 8.2 Explore the package syntax 00:03:13
    4. 8.3 Review executing code in packages 00:07:54
    5. Put it all together 00:00:30
  32. Lesson 9: PL/SQL Triggers
    1. Learning Objectives 00:00:23
    2. 9.1 Introduce PL/SQL triggers 00:03:25
    3. 9.2 Explore the trigger syntax 00:03:54
    4. 9.3 Review the order of trigger processing and other restrictions 00:02:44
    5. 9.4 Work with useful examples 00:08:00
    6. Put it all together 00:00:49
  33. Lesson 10: PL/SQL New Features
    1. Learning Objectives 00:00:15
    2. 10.1 Introduce PL/SQL new features 00:00:40
    3. 10.2 Explore the new features with tips and techniques 00:13:23
    4. Put it all together 00:00:47
  34. Lesson 11: PL/SQL Collections
    1. Learning Objectives 00:00:36
    2. 11.1 Introduce PL/SQL collections 00:01:25
    3. 11.2 Explore the collection syntax 00:03:03
    4. 11.3 Review code examples 00:05:13
    5. 11.4 Explore bulk binding techniques 00:07:25
    6. Put it all together 00:00:33
  35. Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips
    1. Learning Objectives 00:00:43
    2. 12.1 Introduce PL/SQL debugging, PL/SQL profiling, PL/SQL coding tips 00:00:22
    3. 12.2 Explore the TOAD debugger 00:08:39
    4. 12.3 Explore the SQL developer debugger 00:05:41
    5. 12.4 Review the PL/SQL profiler 00:01:44
    6. 12.5 Use the PL/SQL profiler with SQL*Plus 00:05:26
    7. 12.6 Use the TOAD PL/SQL profiler 00:03:53
    8. 12.7 Review PL/SQL coding tips 00:09:36
    9. Put it all together 00:00:39
  36. Oracle PL/SQL Programming Fundamentals LiveLessons: Summary
    1. Summary 00:00:47
  37. Introduction
    1. Oracle PL/SQL Advanced Programming: Introduction 00:07:11
  38. Lesson 1: Oracle PL/SQL Advanced Course Overview
    1. Learning objectives 00:00:33
    2. 1.1 Review LiveLessons course objectives and pre-requisites 00:01:25
    3. 1.2 Understand the course database objects and the course download 00:04:35
    4. 1.3 Introduce the course tools 00:09:58
    5. 1.4 Review the Oracle Architecture 00:04:44
    6. 1.5 Explore the PL/SQL Architecture 00:07:50
    7. Put it all together 00:01:01
  39. Lesson 2: PL/SQL Compiler Options: Part I
    1. Learning objectives 00:00:49
    2. 2.1 Introduce function/procedure/package advanced syntax 00:06:57
    3. 2.2 Review Oracle11 result cache 00:11:57
    4. 2.3 Explore PL/SQL limits including Oracle12 new limits 00:05:33
    5. 2.4 Hands-on Lab 00:02:47
    6. 2.5 Work with identity columns 00:02:27
    7. 2.6 Utilize sequences 00:01:15
    8. 2.7 Understand date fields 00:04:30
    9. 2.8 Utilize definer rights 00:02:43
    10. 2.9 Discover Oracle12 select lists 00:00:41
    11. 2.10 Explore Oracle12 new privilege features 00:02:56
    12. 2.11 Work with Autonomous Transactions 00:02:50
    13. 2.12 Explore compiling with Purity features 00:01:32
    14. 2.13 Hands-on Lab 00:06:00
    15. Put it all together 00:00:47
  40. Lesson 3: PL/SQL Compiler Options: Part II
    1. Learning objectives 00:00:38
    2. 3.1 Invoke the PL/SQL compiler 00:03:07
    3. 3.2 Utilize compiler warnings 00:03:02
    4. 3.3 Work with inlining 00:01:24
    5. 3.4 Use the conditional compilation 00:05:43
    6. 3.5 Review Oracle12 compiler directives 00:00:25
    7. 3.6 Introduce native compilation 00:01:29
    8. 3.7 Hands-on Lab 00:01:58
    9. Put it all together 00:00:41
  41. Lesson 4: PL/SQL Compiler Options and Packages
    1. Learning objectives 00:00:30
    2. 4.1 Review PL/SQL packages syntax 00:02:35
    3. 4.2 Work with PL/SQL packages Pragma declarations 00:02:44
    4. 4.3 Introduce PL/SQL packages optional block 00:01:59
    5. 4.4 Discover PL/SQL packages forward declaration 00:01:45
    6. 4.5 Hands-on Lab 00:04:44
    7. Put it all together 00:00:27
  42. Lesson 5: PL/SQL Coding Style and New Features
    1. Learning objectives 00:00:45
    2. 5.1 View PL/SQL source code 00:03:10
    3. 5.2 Work with data dictionary information 00:04:44
    4. 5.3 Use source code encryption 00:02:20
    5. 5.4 Work with overloading 00:04:45
    6. 5.5 Review bodiless package 00:01:37
    7. 5.6 Discover code dependencies 00:01:45
    8. 5.7 Explore new PL/SQL syntax 00:03:32
    9. 5.8 Hands-on Lab 00:03:54
    10. Put it all together 00:00:33
  43. Lesson 6: Oracle Database Triggers
    1. Learning objectives 00:00:37
    2. 6.1 Introduce Oracle triggers 00:03:12
    3. 6.2 Explore trigger types and syntax 00:06:15
    4. 6.3 Review trigger restrictions 00:02:43
    5. 6.4 Work with trigger management 00:00:47
    6. 6.5 Understand trigger new features: updateable views 00:03:32
    7. 6.6 Hands-on Lab 00:02:55
    8. 6.7 Review triggers that audit 00:03:50
    9. 6.8 Explore event triggers 00:04:36
    10. 6.9 Hands-on Lab 00:05:47
    11. Put it all together 00:00:42
  44. Lesson 7: Cursors
    1. Learning objectives 00:00:35
    2. 7.1 Introduce reference cursors (ref cursors) 00:04:06
    3. 7.2 Explore ref cursor syntax 00:03:04
    4. 7.3 Work with implementation of ref cursors 00:01:24
    5. 7.4 Review working examples 00:04:34
    6. 7.5 Discover cursor sharing 00:03:05
    7. 7.6 Utilize cursor parameters 00:01:52
    8. 7.7 Hands-on Lab 00:06:44
    9. Put it all together 00:00:52
  45. Lesson 8: PL/SQL Collections
    1. Learning objectives 00:00:55
    2. 8.1 Introduce user-defined types 00:03:30
    3. 8.2 Understand collection types and methods 00:02:10
    4. 8.3 Explore Associative Arrays description and syntax 00:04:25
    5. 8.4 Discover Nested Tables description and syntax 00:08:19
    6. 8.5 Work with Varrays description and syntax 00:03:50
    7. 8.6 Hands-on Lab 00:06:10
    8. 8.7 Introduce bulk binding 00:01:44
    9. 8.8 Use BULK COLLECT 00:07:18
    10. 8.9 Work with FORALL 00:03:01
    11. 8.10 Explore collection exception processing 00:09:15
    12. 8.11 Hands-on Lab 00:01:41
    13. 8.12 Review array timings and comparisons 00:01:34
    14. 8.13 Discover collections tips and techniques 00:04:35
    15. 8.14 Hands-on Lab 00:03:23
    16. Put it all together 00:01:05
  46. Lesson 9: Oracle Built-in Packages
    1. Learning objectives 00:00:45
    2. 9.1 Discover built-in packages 00:04:14
    3. 9.2 Understand DBMS_OUTPUT package 00:03:48
    4. 9.3 Work with UTL_FILE package 00:10:38
    5. 9.4 Use the DBMS_UTILITY package 00:04:25
    6. 9.5 Utilize DBMS_APPLICATION_INFO package 00:01:30
    7. 9.6 Review Oracle12 new features 00:02:32
    8. 9.7 Hands-on Lab 00:04:03
    9. 9.8 Discover DBMS_ALERT package 00:03:57
    10. 9.9 Utilize DBMS_PIPE technology 00:06:13
    11. 9.10 Review UTL_MAIL 00:01:41
    12. 9.11 Hands-on Lab 00:04:18
    13. 9.12 Discover DBMS_JOB and DBMS_SCHEDULER 00:09:47
    14. 9.13 Explore DBMS_LOCK package 00:01:10
    15. 9.14 Utilize DBMS_RANDOM number generators 00:01:52
    16. 9.15 Hands-on Lab 00:03:10
    17. 9.16 Review DBMS_STATS package with collections 00:01:54
    18. Put it all together 00:00:50
  47. Lesson 10: Dynamic SQL
    1. Learning objectives 00:00:37
    2. 10.1 Introduce dynamic SQL in the Oracle RDBMS 00:04:02
    3. 10.2 Explore DBMS_SQL package 00:08:00
    4. 10.3 Hands-on Lab 00:01:58
    5. 10.4 Work with Native Dynamic SQL (Execute Immediate) 00:03:59
    6. 10.5 Review SQL injection and other malicious attacks 00:08:03
    7. 10.6 Discover SQL creating SQL tips and techniques 00:06:04
    8. 10.7 Hands-on Lab 00:03:24
    9. Put it all together 00:00:40
  48. Lesson 11: PL/SQL Performance
    1. Learning objectives 00:00:57
    2. 11.1 Introduce PL/SQL table functions 00:02:26
    3. 11.2 Work with Pipelined Table functions 00:02:19
    4. 11.3 Explore Cursors and Pipelined Table functions 00:04:29
    5. 11.4 Discover Chaining Pipelined Table functions 00:02:33
    6. 11.5 Review Compilers Options (function performance perspective) 00:04:40
    7. 11.6 Hands-on Lab 00:01:54
    8. 11.7 Introduce updating large tables in parallel 00:01:39
    9. 11.8 Utilize Parallel Execute Chunk Processing 00:01:07
    10. 11.9 Explore Parallel Execute Chunk Management Code Examples 00:03:22
    11. Put it all together 00:00:32
  49. Lesson 12: Large Objects
    1. Learning objectives 00:00:35
    2. 12.1 Understand large object processing 00:02:20
    3. 12.2 Review syntax and working examples 00:02:19
    4. 12.3 Hands-on Lab 00:02:55
    5. 12.4 Work with clobs and BFILES 00:01:11
    6. 12.5 Explore additional code resources 00:01:06
    7. 12.6 Utilize code examples 00:03:36
    8. 12.7 Hands-on Lab 00:02:20
    9. Put it all together 00:00:41
  50. Lesson 13: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips
    1. Learning objectives 00:01:01
    2. 13.1 Introduce PL/SQL debugging, PL/SQL profiling, PL/SQL coding tips 00:00:32
    3. 13.2 Work with the PL/SQL Trace 00:03:18
    4. 13.3 Explore the Toad debugger with live demonstration 00:08:06
    5. 13.4 Explore the SQL Developer debugger with live demonstration 00:04:40
    6. 13.5 Use the PL/SQL profiler with SQL*Plus 00:03:19
    7. 13.6 Use the Toad PL/SQL profiler 00:01:18
    8. 13.7 Review the Hierarchical profiler 00:03:58
    9. 13.8 Watch the live profiling demonstration 00:03:35
    10. 13.9 Review PL/SQL coding tips 00:13:41
    11. Put it all together 00:00:31
  51. Summary
    1. Oracle PL/SQL Advanced Programming: Summary 00:01:11
  52. Summary
    1. Oracle PL/SQL Programming: Fundamentals to Advanced: Summary 00:01:26