get familiar with the fundamentals of the Oracle database, including tables, constraints, writing SQL queries, and using Oracle SQL Developer
Oracle SQL is a necessary skill for any Oracle professional. In this course we overs advanced aspects of coding using SQL in an Oracle Database 12c environment.The following key topics that can help you develop your Oracle SQL expertise including database concurrency transactions Oracle-specific schema objects such as indexes and PL/SQL procedures, functions, and packages; and table partitioning.
- Setting up the Oracle Database 12c environment
- Writing subqueries and inline views
- Creating table indexes to boost query performance
- Using the Oracle Data Dictionary
- Database transactions
- Creating sequences and triggers
- Table partitioning benefits
- Using LIST, RANGE, and HASH partitions
Setting Up the Environment
SQL Sub-queries
Indexes
The Oracle Data Dictionary
Database Concurrency
Advanced Oracle Schema Objects
Table Partitioning
-
19Introduction to sequences
-
20Creating sequences
-
21Using identity columns
-
22Introduction to table triggers
-
23Creating triggers
-
24Introduction to PL/SQL procedures
-
25Introduction to PL/SQL functions
-
26Introduction to PL/SQL packages
-
27Creating PL/SQL procedures and functions
-
28Creating synonyms
-
29Creating simple views
-
30Creating complex views
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!