Oracle SQL, PL/SQL, ATP by practical examples (21C)

Offered byUDEMY

Oracle SQL, PL/SQL, ATP by practical examples (21C)
at
UDEMY
Overview

Complete SQL and PL/SQL courses by practical examples ( ATP 21C )

Duration	6 hours
Total fee	₹649
Mode of learning	Online
Credential	Certificate

Oracle SQL, PL/SQL, ATP by practical examples (21C)
at
UDEMY
Highlights

Certificate of completion
6.5 hours on-demand video
6 articles and 53 downloadable resources
Full lifetime access
Access on mobile and TV
30-Day Money-Back Guarantee

Oracle SQL, PL/SQL, ATP by practical examples (21C)
at
UDEMY
Course details

Who should do this course?

For Students, Beginner Developers or IT professionals
For Students who wants to be expert in PL/SQL programming
For Junior programmers who need to find better jobs
For Students who want to be expert in PL/SQL programming
For Database Administrators

What are the course deliverables?

Student will:
Create and Work with Autonomous Database in the Oracle Cloud
Learn structured query language (SQL) to an intermediate/advanced level
Be able to write SQL statements that create different database objects.
Working with Composite Data Types
Handling Exceptions
Creating Procedures and Functions
Writing executable statements
Using explicit cursors

More about this course

The course is designed with an emphasis on hands-on experience
Every topic has a detailed explanation video and tasks learner have to perform by Home Assignment

Oracle SQL, PL/SQL, ATP by practical examples (21C)
at
UDEMY
Curriculum

Introduction

Introduction

What is a Database?

What is a Database?

Create ATP database in the Cloud

Create an Always Free Cloud Account

Create ATP database

Install SQL Developer

Connect to ATP ( SQL Developer )

Open ATP if it was stopped

Create ERD

Create ERD

What is SQL?

What is SQL?

DML

SELECT statement

INSERT statement

UPDATE AND DELETE

MERGE statement

Chapter Quiz

Database Objects

Database Objects

Chapter Quiz

Data Types

Data Types

Chapter Quiz

Normalization

Database Normalization

DDL

CREATE TABLE

CREATE INDEX

CREATE SEQUENCE

Practice Exercise: Create table, sequence and index

CREATE TRIGGER

ALTER TABLE

DROP TABLE

Advance topic: A real life example

Chapter Quiz

Oracle SQL, PL/SQL, ATP by practical examples (21C)
at
UDEMY
Faculty details

Oleksiy Gusarov, Database expert at Oracle

My name is Oleksiy and I am a certified DB expert at Oracle USA. Initially I was working with MySQL databases but had to retrain for the Oracle Database. And I have been working with Oracle Technologies for 5 years already. During this time our team has successfully migrated our application from MySQL to Oracle database. And later we were among the first to migrate our database to the cloud ( OCI ). Currently I have the following responsibilities: Define, design, and implement database solutions within a fast-paced, leading edge applications company. Performance trend analysis and manage the server/network capacity. Propose client configuration and implement technical solutions to enhance and/or troubleshoot the database systems.