Oracle 12 Cloud: Advanced SQL/PLSQL Hands-On

Name: Oracle 12 Cloud: Advanced SQL/PLSQL Hands-On
Rating: 4.6 (83 reviews)

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

(83 ratings)

25,535 students

Created by Zulqarnain Hayat

Last updated 4/2018

English

English [Auto]

What you'll learn

get familiar with the fundamentals of the Oracle database, including tables, constraints, writing SQL queries, and using Oracle SQL Developer

Requirements

you should have prior Oracle database experience, preferably with an Oracle 12c or 11g database

Description

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

Who this course is for:

Oracle Database administrator and developer

Zulqarnain Hayat

Enterprise Database Architect

4.1 Instructor Rating
3,922 Reviews
180,642 Students
29 Courses

I have done Master in Computer science (IT) and additionally I have more than 17 years of professional experience UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat) and working as role Database specialist.I have completed command over following functions and skills.

Key Skills:

· Oracle Database Administration

· MS SQL Server Administrations

· MYSQL/MariaDB Administration

· Sun Solaris Administration (Certified)

· Linux Administration (Red Hat ,CENTOS,UBUNTU)

· Oracle Application Server Administration

· Banner UDC technology stack DBA track

· Application Administration (LAMP,LEMP)

· Oracle EBS Administration

· Oracle Database Administration (RAC, Data Guard)

· Oracle Business Intelligence Administration

· Hyperion /ESBASE/WEB LOGIC

· Windows Server Administration

· Oracle Data Warehouse Builder

· SQL Server Administration

· Project Management

· Problem solving skills and approach

· Systems audit and control

· Oracle OAM 11G,OSSO 10G EBS R12

· Data Center Design and Implementation

· VMware Infrastructure

· EMC Storage and Legato Networker Administration