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.
Publisher resources
Table of contents
- Introduction To Oracle SQL
- Basic SQL Select Statement
- Restricting Data - The Basics
- Joining Tables - The Basics
- Summarizing Data
- Joining Multiple Tables
- Data Subsets
- Restricting Data - Advanced Concepts
- Using Subqueries - The Basics
- Data Modeling - The Basics
-
Creating Tables And Manipulating Data
- Creating Tables - Part 1
- Creating Tables - Part 2
- Specifying Keys
- The Check Constraint
- Creating Indexes
- Modifying And Removing Tables
- More Constraints
- Adding Data To A Table
- Changing Data In A Table - Part 1
- Changing Data In A Table - Part 2
- Removing Data From A Table
- Assignment 11
- Assignment 11 - Solution
- Single-Row Functions
- Creating And Using Views
- Database Management
- Legacy SQL Techniques
- Conclusion
- Introduction
- The Oracle Technology Family
- Oracle Database Technology
- Database Architecture
- Installing The Oracle Software
- Creating An Oracle Database
- Structured Query Language (SQL)
- PL And SQL
- Oracle Storage Structures
- Database Objects
- Database Security
- Database Administrative Tasks
- Database Backup And Recovery
- Data Migration
- Oracle Networking
- Conclusion
- Introduction/The Basics
- Errors
- Data Manipulation
- Database Procedure
- Packages
- Triggers
- Functions
- Code Compilation
- Code Assessment
- Security
- Dynamic SQL
- Data Definition Language
- Tansactions
- PLSQL In SQL
- Wrap Up
-
Apex - Installation And Administration
- Introduction And About The Author
- What Is Oracle Application Express?
- The Apex Architecture
- Downloading And Installation
- High-Level Overview Of Apex Pages
- Apex Hierarchy - Workspaces, Applications, Pages, Regions And Items
- Creating A Workspace
- Creating Workspace Users
- Setting Workspace-Level Attributes
- Setting Security Attributes
-
Apex Basics - Applications, Pages And Regions
- Types Of Apex Applications - Part 1
- Types Of Apex Applications - Part 2
- Creating A New Application - Part 1
- Creating A New Application - Part 2
- Understanding Pages And Regions
- Using The Wizards - Part 1
- Using The Wizards - Part 2
- After The Wizards - Part 1
- After The Wizards - Part 2
- Page Rendering - Part 1
- Page Rendering - Part 2
- Page Rendering - Part 3
-
Apex Regions - Forms, Reports, Charts And More
- Forms - Part 1
- Forms - Part 2
- Forms - Part 3
- Forms - Part 4
- Forms - Part 5
- Forms - Part 6
- Reports - Part 1
- Reports - Part 2
- Reports - Part 3
- Reports - Part 4
- Reports - Part 5
- Charts - Part 1
- Charts - Part 2
- Maps
- Trees
- Calendars
- Other Types
- Shared Components - Part 1
- Shared Components - Part 2
- Dynamic Actions
- Tabs
- Linking To Other Pages - Part 1
- Linking To Other Pages - Part 2
- User Interface, Templates And Themes
- Creating Mobile Applications
- Apex Advanced Topics - Security, Performance And Team Development
- Conclusion
Product information
- Title: Learning Path: Oracle Databases
- Author(s):
- Release date: February 2017
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491980132
You might also like
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
video
Learning Oracle 12c
In this Oracle 12c training course, expert author Steve Ries will teach you how to everything …
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …