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: Oracle Databases

Learning Path: Oracle Databases

by O'Reilly Media, Inc.
Publisher: O'Reilly Media, Inc.
Release Date: February 2017
ISBN: 9781491980149
View table of contents
Start watching

Video Description

This learning path offers a solid a foundation in Oracle databases, from the fundamentals of the SQL language and how to build an Oracle database to automating many ETL (extract, transform, load) and analytical tasks and building applications on top of an Oracle database.

Table of Contents

  1. Introduction To Oracle SQL
    1. Introduction And About The Author 00:02:58
    2. What Is SQL? 00:05:31
    3. Relational Databases Explained - Part 1 00:06:51
    4. Relational Databases Explained - Part 2 00:06:22
    5. How To Query Data From A Database 00:06:52
    6. The Difference Between SQL And PL/SQL 00:03:58
    7. Setting Up An Oracle Apex Account 00:09:53
    8. Running SQL Using Oracle Apex 00:06:50
    9. Assignment 1 00:00:44
    10. Assignment 1 - Solution 00:01:30
  2. Basic SQL Select Statement
    1. Retrieving All Data From A Table 00:05:31
    2. Retrieving Some Data From A Table 00:02:02
    3. Restricting The Retrieval Of Rows From A Table 00:05:29
    4. Using Mathematical And Text Expressions 00:06:09
    5. Sorting The Results Using Column Names 00:05:42
    6. Assignment 2 00:02:27
    7. Assignment 2 - Solution 00:06:37
  3. Restricting Data - The Basics
    1. What Is A Primary Key? 00:06:13
    2. Comparison Operators 00:04:49
    3. Logical Operators 00:07:36
    4. Dealing With Null Values 00:08:14
    5. Sorting The Results Using Column Position 00:03:53
    6. Assignment 3 00:01:28
    7. Assignment 3 - Solution 00:06:19
  4. Joining Tables - The Basics
    1. What Is A Foreign Key? 00:04:24
    2. Inner Joins With The Using Clause 00:06:49
    3. Joins With The On Clause 00:05:31
    4. Joins And The Order Of Processing 00:04:35
    5. Assignment 4 00:01:02
    6. Assignment 4 - Solution 00:04:49
  5. Summarizing Data
    1. Aggregate Functions 00:06:45
    2. The Count Functions 00:05:10
    3. The Min And Max Functions 00:04:28
    4. The Avg And Sum Functions 00:02:38
    5. Concatenating Data 00:04:27
    6. Aggregates - Order Of Processing 00:03:33
    7. Assignment 5 00:00:51
    8. Assignment 5 - Solution 00:01:29
  6. Joining Multiple Tables
    1. Many-To-Many Relationships - Part 1 00:07:16
    2. Many-To-Many Relationships - Part 2 00:04:22
    3. Join Multiple Tables With The Using Clause 00:07:31
    4. Join Multiple Tables With The On Clause 00:06:57
    5. Eliminating Duplicate Rows From The Results 00:05:32
    6. Sorting The Results Using Column Aliases 00:01:45
    7. Assignment 6 00:01:09
    8. Assignment 6 - Solution 00:03:36
  7. Data Subsets
    1. Using The Group By Clause 00:07:50
    2. Using The Having Clause 00:04:43
    3. Having With Compound Conditions 00:03:18
    4. Assignment 7 00:01:03
    5. Assignment 7 - Solution 00:04:18
  8. Restricting Data - Advanced Concepts
    1. Using The In Operator 00:04:04
    2. Using The Between Operator 00:06:30
    3. Using The Like Operator For Pattern Matching 00:09:32
    4. Outer Joins 00:11:48
    5. Assignment 8 00:00:58
    6. Assignment 8 - Solution 00:03:38
  9. Using Subqueries - The Basics
    1. How Do Subqueries Work? 00:06:47
    2. Subqueries With The In Operator 00:09:25
    3. Subqueries Using A Comparison Operator 00:07:21
    4. Subqueries Vs. Joins 00:04:12
    5. Using A Subquery Vs. A Self-Join 00:04:23
    6. Assignment 9 00:01:05
    7. Assignment 9 - Solution 00:04:33
  10. Data Modeling - The Basics
    1. How Data Is Organized In A Relational Database 00:04:13
    2. The Entity-Relationship Approach 00:08:26
    3. Normalization Guidelines - Part 1 00:07:14
    4. Normalization Guidelines - Part 2 00:07:06
    5. Assignment 10 00:01:47
    6. Assignment 10 - Solution 00:02:52
  11. Creating Tables And Manipulating Data
    1. Creating Tables - Part 1 00:06:48
    2. Creating Tables - Part 2 00:09:06
    3. Specifying Keys 00:04:33
    4. The Check Constraint 00:06:50
    5. Creating Indexes 00:06:58
    6. Modifying And Removing Tables 00:05:58
    7. More Constraints 00:04:26
    8. Adding Data To A Table 00:06:59
    9. Changing Data In A Table - Part 1 00:04:50
    10. Changing Data In A Table - Part 2 00:03:12
    11. Removing Data From A Table 00:03:23
    12. Assignment 11 00:01:17
    13. Assignment 11 - Solution 00:01:15
  12. Single-Row Functions
    1. String Functions - Part 1 00:08:02
    2. String Functions - Part 2 00:04:15
    3. Number Functions 00:05:50
    4. Date Functions 00:07:53
    5. Limiting Rows And The Dual Table 00:06:07
    6. Assignment 12 00:01:56
    7. Assignment 12 - Solution 00:02:27
  13. Creating And Using Views
    1. Creating And Using Views 00:09:18
    2. Set Operators 00:09:23
    3. Assignment 13 00:00:52
    4. Assignment 13 - Solution 00:01:50
  14. Database Management
    1. Transaction Management 00:02:58
    2. Concurrency Control 00:04:00
    3. Security Considerations 00:06:32
    4. Stored Procedures And Triggers 00:04:37
    5. Database Integrity 00:03:23
    6. Assignment 14 00:00:57
    7. Assignment 14 - Solution 00:01:57
  15. Legacy SQL Techniques
    1. Implicit Joins 00:05:46
    2. Subqueries With Modifiers 00:05:13
    3. Subqueries Using The Exists Clause 00:07:08
    4. Assignment 15 00:01:21
    5. Assignment 15 - Solution 00:03:34
  16. Conclusion
    1. Difference Between Oracle And Other SQLs 00:04:45
    2. SQL In A Programming Language 00:05:41
    3. Embedded SQL 00:04:42
    4. What Is Next? 00:01:14
  17. Introduction
    1. What You Should Expect From This Course 00:04:04
    2. About The Author 00:03:48
    3. What is Oracle? 00:04:01
  18. The Oracle Technology Family
    1. Hardware 00:02:49
    2. Operating Systems 00:04:30
    3. Virtualization 00:05:19
    4. Middleware And Java 00:04:41
  19. Oracle Database Technology
    1. What Is A Database? 00:06:16
    2. Oracle RDBMS 00:05:14
    3. Oracle Database Server Editions 00:05:38
    4. Oracle Database Server Versioning 00:07:41
    5. Oracle Database Options 00:07:17
    6. Software 00:08:59
    7. Documentation 00:06:30
    8. SQL Developer 00:08:40
  20. Database Architecture
    1. The Oracle RDBMS - Instance And Database 00:03:50
    2. The Instance - Background Memory Processes 00:12:09
    3. The Instance - System Global Area 00:07:18
    4. The Instance - Program Global Area 00:05:58
    5. The Database - Core Datafiles 00:10:10
    6. The Redo Architecture 00:05:51
    7. Real Application Clusters 00:05:56
    8. Container Databases 00:04:35
    9. Pluggable Databases 00:05:43
  21. Installing The Oracle Software
    1. Planning An Installation 00:06:04
    2. The Oracle Universal Installer 00:05:41
    3. Installing The Software - Part 1 00:06:26
    4. Installing The Software - Part 2 00:03:48
  22. Creating An Oracle Database
    1. Planning Database Creation 00:04:58
    2. Running NETCA And DBCA 00:04:43
    3. Stepping Through Database Creation - Part 1 00:06:43
    4. Stepping Through Database Creation - Part 2 00:07:06
    5. Stepping Through Database Creation - Part 3 00:06:21
    6. Setting Up The SQL Developer 00:04:39
  23. Structured Query Language (SQL)
    1. What Is SQL? 00:06:56
    2. Select 00:07:03
    3. Insert 00:06:07
    4. Update 00:04:26
    5. Deletes 00:05:55
    6. Joins 00:08:58
    7. Single Row Functions 00:09:02
    8. Data Aggregation 00:07:04
    9. Optimizer And Execution Plans 00:09:40
    10. Transactions And Concurrency 00:04:51
  24. PL And SQL
    1. What Is PL And SQL? 00:05:53
    2. Anonymous Blocks 00:06:28
    3. Procedures 00:05:26
    4. Functions 00:05:39
    5. Packages 00:06:15
    6. Object Types 00:06:39
  25. Oracle Storage Structures
    1. Blocks 00:08:19
    2. Extents 00:07:30
    3. Segments 00:06:56
    4. Datafiles 00:07:46
    5. Smallfile Tablespaces 00:06:38
    6. Bigfile Tablespaces 00:07:43
    7. Automatic Storage Management - ASM 00:10:01
  26. Database Objects
    1. Tables 00:07:50
    2. Partitions 00:09:21
    3. Temporary Tables 00:04:18
    4. B-tree Indexes 00:07:46
    5. Bitmap Indexes 00:05:50
    6. Index Organized Tables 00:04:03
    7. Function Based Indexes 00:05:08
    8. Views 00:04:49
    9. Primary And Unique Keys 00:06:53
    10. Foreign Keys 00:06:40
    11. Check Constraints 00:06:13
    12. Synonyms 00:05:39
    13. Sequences 00:08:31
  27. Database Security
    1. Principles Of Database Security 00:08:09
    2. Oracle Schema Based Approach 00:04:46
    3. Creating And Dropping Users 00:06:53
    4. System Privileges 00:06:44
    5. Object Privileges 00:05:53
    6. Roles 00:10:15
    7. Profiles 00:07:07
    8. Auditing 00:10:15
  28. Database Administrative Tasks
    1. Instance Startup 00:06:17
    2. Instance Shutdown 00:07:15
    3. Parameter File 00:06:47
    4. Modifying Parameters 00:08:18
    5. The Data Dictionary 00:12:15
    6. Password File 00:06:03
    7. ADRCI 00:05:17
    8. Alert Log And Trace Files 00:07:02
    9. Memory Management 00:06:28
    10. Monitoring Sessions 00:08:29
    11. Monitoring Space Usage 00:05:17
  29. Database Backup And Recovery
    1. Backup And Recovery Concepts 00:09:48
    2. RMAN Backups 00:04:25
    3. RMAN Incremental Backups 00:06:57
    4. RMAN Complete Recovery 00:04:51
    5. RMAN Incomplete Recovery 00:07:28
    6. RMAN Backup Maintenance 00:05:19
  30. Data Migration
    1. SQL Loader 00:08:11
    2. External Tables 00:04:39
    3. Data Pump Export 00:07:22
    4. Data Pump Import 00:04:40
  31. Oracle Networking
    1. Understanding Oracle Connections 00:04:37
    2. Networking Configuration Files 00:04:52
    3. Listener Control 00:04:12
  32. Conclusion
    1. Wrap-Up And Review 00:03:12
  33. Introduction/The Basics
    1. Course Introduction 00:04:55
    2. About The Author 00:01:50
    3. Block Structure 00:04:09
    4. Scalar Variables 00:01:31
    5. Rowtype Variables 00:02:22
    6. Introduction To Tables 00:03:16
    7. Index By Tables 00:03:12
    8. Nested Tables 00:03:05
    9. Varrays 00:04:05
    10. Loops 00:05:51
    11. Control Structures 00:01:15
  34. Errors
    1. Error Introduction 00:05:14
    2. Predefined Exceptions 00:05:44
    3. Exception Handlers 00:05:13
    4. User Defined Exceptions 00:03:16
  35. Data Manipulation
    1. Query Introduction 00:03:02
    2. Cursors 00:09:08
    3. Ref Cursors 00:03:45
    4. Nested Cursors 00:03:31
    5. Cursor Loops 00:01:53
    6. Bulk Fetch 00:03:40
    7. Inserting Data 00:02:31
    8. Bulk Inserts 00:02:52
    9. Insert Returning 00:02:43
    10. Insert Save Exceptions 00:04:34
    11. Updating Data 00:03:38
    12. Bulk Updates 00:03:13
    13. Update Returning 00:05:02
    14. Update Save Exceptions 00:03:55
    15. Deleting Data 00:02:56
    16. Bulk Deletes 00:02:40
    17. Delete Returning 00:03:39
    18. Delete Save Exceptions 00:04:18
    19. Merge 00:06:17
  36. Database Procedure
    1. Procedures 00:04:29
    2. Calling Procedures 00:04:06
  37. Packages
    1. Package Specification 00:03:24
    2. Package Bodies 00:03:07
    3. Package Private And Public 00:02:55
    4. Calling Packages 00:04:35
  38. Triggers
    1. DML Triggers 00:08:16
    2. Trigger Ordering 00:03:05
    3. Compound Triggers 00:03:12
    4. DDL Triggers 00:05:31
    5. Instead Of Triggers 00:07:43
    6. Event Triggers 00:05:28
    7. After Suspend Triggers 00:06:39
  39. Functions
    1. Functions 00:03:52
    2. Result Cache Functions 00:02:52
    3. Table Functions 00:05:46
    4. Pipelined Functions 00:02:55
    5. Parallel Table Functions 00:06:38
    6. Streaming Table Functions 00:04:12
  40. Code Compilation
    1. PLSQL Compilation 00:03:29
    2. Inquiry Directives 00:04:42
    3. Conditional Compilation 00:04:35
    4. PLSQL Optimize 00:02:19
  41. Code Assessment
    1. PLSQL Warnings 00:05:51
    2. PLSQL Profiler 00:03:47
    3. PLSQL Trace 00:01:35
    4. PLSQL Scope 00:06:42
  42. Security
    1. Invoker Rights 00:05:45
    2. Security Roles 00:02:58
    3. Accessible By 00:03:24
    4. Bequeath View 00:02:27
    5. Inherit Privileges 00:03:48
    6. Secure Roles 00:03:53
  43. Dynamic SQL
    1. Dynamic SQL 00:02:40
    2. Dynamic SQL Parameters 00:04:25
    3. Dynamic SQL Returning 00:02:55
  44. Data Definition Language
    1. DDL Create 00:03:06
    2. DDL Modify 00:02:34
    3. DDL Drop 00:04:10
  45. Tansactions
    1. Transactions 00:08:22
    2. Read Only Transactions 00:02:38
    3. Serializable Transactions 00:04:22
    4. Autonomous Transactions 00:04:13
    5. Savepoints 00:04:58
  46. PLSQL In SQL
    1. PLSQL In SQL 00:06:09
  47. Wrap Up
    1. Wrap Up 00:00:40
  48. Apex - Installation And Administration
    1. Introduction And About The Author 00:01:45
    2. What Is Oracle Application Express? 00:02:27
    3. The Apex Architecture 00:01:44
    4. Downloading And Installation 00:08:01
    5. High-Level Overview Of Apex Pages 00:01:19
    6. Apex Hierarchy - Workspaces, Applications, Pages, Regions And Items 00:04:24
    7. Creating A Workspace 00:07:20
    8. Creating Workspace Users 00:06:48
    9. Setting Workspace-Level Attributes 00:05:37
    10. Setting Security Attributes 00:01:56
  49. Apex Basics - Applications, Pages And Regions
    1. Types Of Apex Applications - Part 1 00:07:46
    2. Types Of Apex Applications - Part 2 00:07:04
    3. Creating A New Application - Part 1 00:06:30
    4. Creating A New Application - Part 2 00:06:37
    5. Understanding Pages And Regions 00:07:15
    6. Using The Wizards - Part 1 00:08:52
    7. Using The Wizards - Part 2 00:06:41
    8. After The Wizards - Part 1 00:06:00
    9. After The Wizards - Part 2 00:05:26
    10. Page Rendering - Part 1 00:05:55
    11. Page Rendering - Part 2 00:06:12
    12. Page Rendering - Part 3 00:06:09
  50. Apex Regions - Forms, Reports, Charts And More
    1. Forms - Part 1 00:06:07
    2. Forms - Part 2 00:05:16
    3. Forms - Part 3 00:06:24
    4. Forms - Part 4 00:04:45
    5. Forms - Part 5 00:04:59
    6. Forms - Part 6 00:08:09
    7. Reports - Part 1 00:07:25
    8. Reports - Part 2 00:08:09
    9. Reports - Part 3 00:01:51
    10. Reports - Part 4 00:03:16
    11. Reports - Part 5 00:03:16
    12. Charts - Part 1 00:06:19
    13. Charts - Part 2 00:04:45
    14. Maps 00:03:18
    15. Trees 00:04:33
    16. Calendars 00:03:19
    17. Other Types 00:08:32
    18. Shared Components - Part 1 00:07:07
    19. Shared Components - Part 2 00:05:24
    20. Dynamic Actions 00:03:38
    21. Tabs 00:05:24
    22. Linking To Other Pages - Part 1 00:05:51
    23. Linking To Other Pages - Part 2 00:08:04
  51. User Interface, Templates And Themes
    1. What Is A Template? 00:08:42
    2. What Is A Theme? 00:07:22
    3. Applying Themes And Templates To Your Application 00:04:18
    4. Making Changes To A Template 00:03:56
    5. Allowing Users To Make Their Own Changes 00:05:23
  52. Creating Mobile Applications
    1. Mobile Vs. Desktop 00:05:41
    2. The Apex Mobile Theme - Part 1 00:06:26
    3. The Apex Mobile Theme - Part 2 00:03:50
    4. ThemeRoller And PhoneGap 00:04:54
  53. Apex Advanced Topics - Security, Performance And Team Development
    1. Authentication Schemes 00:05:44
    2. Other Security Features 00:04:26
    3. Debugging And Tuning Your Application For Performance 00:04:15
    4. Team Development Features 00:05:42
    5. The Apex Listener 00:03:38
    6. Web Services 00:06:04
  54. Conclusion
    1. Wrap-Up 00:03:48