Oracle Developer Essentials: Views, Synonyms and Triggers

English | 18 Feb 2015 | mp4 | H264 1024x768 | AAC 2 ch | 1 hr 40 min | 217 MB

eLearning | Level: Beginner

This course covers the essentials of creating and using views, synonyms, sequences, and triggers in your Oracle database.

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.