12 reviews

Oracle 12 Cloud: Advanced SQL/PLSQL Hands-On

Learning Oracle cloud Advance SQL hands-on using Oracle cloud Virtual Appliance and SQL commands and scripts

Instructor

Zulqarnain Hayat

Category

Database Design & Development

Development

4,823 Students enrolled

Description
Curriculum
FAQ
Reviews

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

1

Welcome

Video lesson

SQL Sub-queries

Indexes

The Oracle Data Dictionary

Database Concurrency

Advanced Oracle Schema Objects

Table Partitioning

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

3.95

12 reviews

Please, login to leave a review

Stars 5

Stars 4

Stars 3

Stars 2

Stars 1