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
- 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: Oracle Databases
- Author(s):
- Release date: February 2017
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491980132
You might also like
video
Oracle DBA Fundamentals
Oracle DBA Fundamentals Complete Video Course presents the architecture, roles, and process of being an Oracle …
book
Practical Oracle SQL: Mastering the Full Power of Oracle Database
Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond …
video
Oracle Database Administration from Zero to Hero
In this course, we cover a wide range of topics to ensure you have a solid …
video
Oracle SQL
Overview Oracle SQL LiveLessons covers the basics of the Oracle SQL programming language. This course covers …