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: Beginner Oracle Developer

Video Description

Overview

This Learning Path includes Oracle SQL LiveLessons, Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons, and Toad for Oracle LiveLessons.

Prerequisites

Basic knowledge of what is a database, especially RDBMS and what is a computer programming language

Overview

Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons begins with a fundamentals module that covers the basics of Oracle's language extension for SQL and the Oracle relational database. The focus is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and packages using the PL/SQL language. The advanced module 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.

Downloads

Oracle_SQL_LiveLessons_File_Download.zip


About the Instructor

Dan Hotka is a training specialist and an Oracle ACE director who has 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 well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons 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 Video Training

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: Introduction 00:06:20
  2. Lesson 1: Oracle SQL Course Overview
    1. Learning objectives 00:00:32
    2. 1.1 Understand the course pre-requisites 00:00:49
    3. 1.2 Utilize the course download 00:01:36
    4. 1.3 Understand the course database objects 00:01:36
    5. 1.4 Introduce the Database Relational Model 00:07:10
    6. 1.5 Introduce the Oracle Architecture 00:08:10
    7. Put it all together 00:00:45
  3. Lesson 2: Introduction to the Course Tools
    1. Learning objectives 00:00:55
    2. 2.1 Work with SQL*Plus 00:05:56
    3. 2.2 Utilize SQL*Developer 00:05:30
    4. 2.3 Explore Toad 00:05:00
    5. Put it all together 00:01:00
  4. Lesson 3: Introduction to SQL
    1. Learning objectives 00:00:16
    2. 3.1 Understand Simple SQL queries 00:03:41
    3. 3.2 Work with Where clauses 00:05:46
    4. 3.3 Hands-on Lab 00:06:55
    5. Put it all together 00:00:21
  5. Lesson 4: Table Joins
    1. Learning objectives 00:00:37
    2. 4.1 Discover available tables/columns 00:03:15
    3. 4.2 Use the tools to create SQL without typing 00:09:10
    4. 4.3 Understand multiple table joins 00:08:09
    5. 4.4 Work with ANSI syntax 00:03:01
    6. 4.5 Use Oracle12 new ANSI join syntax 00:00:59
    7. 4.6 Explore sorting options 00:01:47
    8. 4.7 Hands-on Lab 00:04:45
    9. Put it all together 00:00:56
  6. Lesson 5: Functions and Pseudocolumns
    1. Learning objectives 00:00:43
    2. 5.1 Utilize pseudocolumns 00:02:37
    3. 5.2 Review character/string functions 00:02:19
    4. 5.3 Explore date functions 00:07:28
    5. 5.4 Understand number functions 00:02:11
    6. 5.5 Work with Decode/Case/regular expressions/pattern matching functions 00:03:34
    7. 5.6 Work with Group By functions 00:02:34
    8. 5.7 Use multiple functions 00:05:47
    9. 5.8 Use the functions from the tools 00:02:40
    10. 5.9 Hands-on Lab 00:06:15
    11. Put it all together 00:00:54
  7. Lesson 6: Advanced Queries Using Sub-Queries
    1. Learning objectives 00:00:25
    2. 6.1 Understand sub-queries 00:09:33
    3. 6.2 Work with in-line views 00:04:12
    4. 6.3 Utilize SQL coding tips and techniques 00:02:35
    5. 6.4 Hands-on Lab 00:05:05
    6. Put it all together 00:00:35
  8. Lesson 7: Oracle Data Manipulation and Definition Language
    1. Learning objectives 00:00:40
    2. 7.1 Understand how to create tables 00:14:19
    3. 7.2 Utilize subsets of tables 00:01:24
    4. 7.3 Work with inserting data 00:03:57
    5. 7.4 Explore updating data 00:01:57
    6. 7.5 Utilize deleting data 00:03:59
    7. 7.6 Use the MERGE command 00:00:45
    8. 7.7 Utilize the tools to perform DML and DDL operations 00:08:49
    9. 7.8 Hands-on Lab 00:10:15
    10. Put it all together 00:00:45
  9. Lesson 8: Database Management
    1. Learning objectives 00:00:26
    2. 8.1 Work with sequences 00:05:12
    3. 8.2 Understand identity columns 00:01:58
    4. 8.3 Explore creating views 00:03:21
    5. 8.4 Understand permissions 00:06:00
    6. 8.5 Use indexes to increase SQL performance 00:08:55
    7. 8.6 Introduce SQL performance tuning 00:04:05
    8. 8.7 Hands-on Lab 00:04:26
    9. Put it all together 00:00:44
  10. Lesson 9: Data Relationships
    1. Learning objectives 00:00:29
    2. 9.1 Learn what referential integrity is 00:02:27
    3. 9.2 Explore your data relationships 00:01:03
    4. 9.3 Use entity-relationship diagrams 00:03:35
    5. 9.4 View related data 00:01:21
    6. 9.5 Save related data (useful for test data/reports) 00:01:51
    7. 9.6 Live Demonstration 00:06:27
    8. Put it all together 00:00:32
  11. Lesson 10: Analytical SQL
    1. Learning objectives 00:00:31
    2. 10.1 Introduce analytical SQL 00:02:29
    3. 10.2 Use analytical functions 00:02:47
    4. 10.3 Explore partitioning functions 00:04:04
    5. 10.4 Utilize windowing functions 00:02:35
    6. Put it all together 00:00:55
  12. Lesson 11: Simple Reports Using SQL*Plus
    1. Learning objectives 00:00:29
    2. 11.1 Introduce SQL*Plus formatting commands 00:08:00
    3. 11.2 Build simple reports 00:05:59
    4. 11.3 Utilize HTML reports 00:02:38
    5. 11.4 Explore creating pivot tables 00:04:38
    6. 11.5 Introduce Oracle scripting 00:14:24
    7. 11.6 Hands-on Lab 00:03:43
    8. Put it all together 00:01:11
  13. Lesson 12: Toad and SQL Developer Reports
    1. Learning objectives 00:00:19
    2. 12.1 Use the Toad Report Writer 00:03:26
    3. 12.2 Explore creating reports using SQL Developer 00:03:41
    4. 12.3 Hands-on Lab 00:07:37
    5. Put it all together 00:00:18
  14. Lesson 13: Spreadsheets and Saving the Data Using the Tools
    1. Learning objectives 00:00:31
    2. 13.1 Explore saving data/creating spreadsheets using SQL*Plus 00:03:41
    3. 13.2 Utilize saving data/creating spreadsheets using SQL Developer 00:01:55
    4. 13.3 Work with saving data/creating spreadsheets/Access databases using Toad 00:01:44
    5. 13.4 Hands-on Lab 00:04:53
    6. Put it all together 00:00:22
  15. Lesson 14: Microsoft Office Programs with Oracle SQL
    1. Learning objectives 00:00:25
    2. 14.1 Introduce ODBC drivers 00:01:01
    3. 14.2 Implement Oracle connections using ODBC 00:00:50
    4. 14.3 Explore SQL from Excel 00:01:24
    5. 14.4 Understand SQL from Access 00:00:57
    6. Put it all together 00:00:24
  16. Summary
    1. Oracle SQL: Summary 00:01:37
  17. Introduction
    1. Oracle PL/SQL Programming Fundamentals LiveLessons: Introduction 00:05:21
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. Oracle PL/SQL Programming Fundamentals LiveLessons: Summary
    1. Summary 00:00:47
  31. Introduction
    1. Toad for Oracle: Introduction 00:06:02
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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
  37. 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
  38. 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
  39. 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
  40. 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
  41. Summary
    1. Toad for Oracle: Summary 00:01:49