Expanded

Oracle Developer Essentials: Views, Synonyms and Triggers

This course covers the essentials of creating and using views, synonyms, sequences, and triggers in your Oracle database.
Course info
Rating
(121)
Level
Beginner
Updated
Feb 17, 2015
Duration
1h 40m
Table of contents
Description
Course info
Rating
(121)
Level
Beginner
Updated
Feb 17, 2015
Duration
1h 40m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Description

Oracle offers a variety of objects that can be used to complement the tables in your database. Views allow you to store a SQL query that defines a logical representation of data in one or more tables, allowing you to create a type of virtual table over your physical tables. Synonyms allow you to define an alternate name for almost any object in Oracle. Sequences help create unique integer values in a thread-safe manner. Triggers allow you to define a behavior when a DML statement is executed against one of your tables. Combined with the tables and indexes in your database, you will be well equipped to handle almost any situation that occurs in your database design.

About the author
About the author

David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.

More from the author
C# Design Patterns: Decorator
Beginner
32m
Jan 2, 2020
More courses by David Berry