1. Урок 1. 00:04:54
    Course introduction
  2. Урок 2. 00:01:49
    About the author
  3. Урок 3. 00:06:22
    Block structure
  4. Урок 4. 00:04:09
    Scalar variables
  5. Урок 5. 00:01:30
    Rowtype variables
  6. Урок 6. 00:02:22
    Introduction to tables
  7. Урок 7. 00:03:15
    Index by tables
  8. Урок 8. 00:03:12
    Nested tables
  9. Урок 9. 00:03:05
    Varrays
  10. Урок 10. 00:04:04
    Loops
  11. Урок 11. 00:05:51
    Control structures
  12. Урок 12. 00:03:22
    How to access your working files?
  13. Урок 13. 00:05:13
    Error introduction
  14. Урок 14. 00:05:43
    Predefined exceptions
  15. Урок 15. 00:05:12
    Exception handlers
  16. Урок 16. 00:03:16
    User defined exceptions
  17. Урок 17. 00:03:01
    Query introduction
  18. Урок 18. 00:09:08
    Cursors
  19. Урок 19. 00:03:45
    Ref cursors
  20. Урок 20. 00:03:31
    Nested cursors
  21. Урок 21. 00:01:52
    Cursor loops
  22. Урок 22. 00:03:39
    Bulk fetch
  23. Урок 23. 00:02:30
    Inserting data
  24. Урок 24. 00:02:52
    Bulk inserts
  25. Урок 25. 00:02:43
    Insert returning
  26. Урок 26. 00:04:34
    Insert save exceptions
  27. Урок 27. 00:03:38
    Updating data
  28. Урок 28. 00:03:13
    Bulk updates
  29. Урок 29. 00:05:01
    Update returning
  30. Урок 30. 00:03:55
    Update save exceptions
  31. Урок 31. 00:02:55
    Deleting data
  32. Урок 32. 00:02:40
    Bulk deletes
  33. Урок 33. 00:04:18
    Delete save exceptions
  34. Урок 34. 00:06:17
    Merge
  35. Урок 35. 00:04:28
    Procedures
  36. Урок 36. 00:04:06
    Calling procedures
  37. Урок 37. 00:03:23
    Package specification
  38. Урок 38. 00:03:07
    Package bodies
  39. Урок 39. 00:02:55
    Package private and public
  40. Урок 40. 00:04:34
    Calling packages
  41. Урок 41. 00:08:16
    DML triggers
  42. Урок 42. 00:03:04
    Trigger ordering
  43. Урок 43. 00:03:12
    Compound triggers
  44. Урок 44. 00:05:31
    DDL triggers
  45. Урок 45. 00:07:43
    Instead of triggers
  46. Урок 46. 00:05:27
    Event triggers
  47. Урок 47. 00:06:38
    After suspend triggers
  48. Урок 48. 00:03:51
    Functions
  49. Урок 49. 00:02:51
    Result cache functions
  50. Урок 50. 00:05:45
    Table functions
  51. Урок 51. 00:02:55
    Pipelined functions
  52. Урок 52. 00:06:37
    Parallel table functions
  53. Урок 53. 00:04:12
    Streaming table functions
  54. Урок 54. 00:03:29
    PLSQL compilation
  55. Урок 55. 00:04:42
    Inquiry directives
  56. Урок 56. 00:04:35
    Conditional compilation
  57. Урок 57. 00:02:18
    PLSQL optimize
  58. Урок 58. 00:05:51
    PLSQL warnings
  59. Урок 59. 00:03:46
    PLSQL profiler
  60. Урок 60. 00:01:35
    PLSQL trace
  61. Урок 61. 00:06:41
    PLSQL scope
  62. Урок 62. 00:05:44
    Invoker rights
  63. Урок 63. 00:02:57
    Security roles
  64. Урок 64. 00:03:24
    Accessible by
  65. Урок 65. 00:02:27
    Bequeath view
  66. Урок 66. 00:03:48
    Inherit privileges
  67. Урок 67. 00:03:53
    Secure roles
  68. Урок 68. 00:02:40
    Dynamic SQL
  69. Урок 69. 00:04:24
    Dynamic SQL parameters
  70. Урок 70. 00:02:55
    Dynamic SQL returning
  71. Урок 71. 00:03:06
    DDL create
  72. Урок 72. 00:02:33
    DDL modify
  73. Урок 73. 00:04:09
    DDL drop
  74. Урок 74. 00:08:22
    Transactions
  75. Урок 75. 00:02:38
    Read only transactions
  76. Урок 76. 00:04:22
    Serializable transactions
  77. Урок 77. 00:04:13
    Autonomous transactions
  78. Урок 78. 00:04:58
    Savepoints
  79. Урок 79. 00:06:09
    PLSQL In SQL
  80. Урок 80. 00:00:40
    Wrap up