Simple play icon Course
Skills Expanded

Oracle Developer Essentials: Views, Synonyms and Triggers

by David Berry

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

What you'll learn

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

David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove... more

Ready to upskill? Get started