Oracle Databases

Oracle Databases

by O'Reilly Media, Inc.
Released February 2017
Publisher(s): O'Reilly Media, Inc.
ISBN: 9781491980132

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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

Product information

  • Title: Oracle Databases
  • Author(s): O'Reilly Media, Inc.
  • Release date: February 2017
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9781491980132