Oracle Engineer/Developer - ( Pl/Sql ,Apex , Data Migration)

Migrate SQL Server to Oracle ,Create stored procedures, Build Applications

What you'll learn

Install Oracle Database Server

Connect TOAD to Oracle

Connect SQLPlus to Oracle

Connect SQL Developer to Oracle

Migrate SQL Server Database into Oracle

Build applications quickly using Oracle APEX

Create and execute PL/SQL stored procedures

Create PL/SQL Functions

Create nested PL/SQL Blocks

Implement conditional statements

Create PL/SQL Packages

Requirements

Knowledge of basic database concepts advised.

Oracle database required. (The installation is covered in the course)

Description

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.  In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance.  A database server also prevents unauthorized access and provides efficient solutions for failure recovery.Oracle Application Express (APEX) is a low-code application platform for Oracle Database. APEX Application Development, Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) are fully managed services, pre-integrated and pre-configured with APEX, for rapidly building and deploying modern data-driven applications in Oracle Cloud. Business users, citizen and application developers can create enterprise apps 20X faster with 100X less code—without having to learn complex web technologies with just a browser. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.Data migration is the process of moving data from one location to another, one format to another, or one application to another. We will migrate a SQL Server database into an Oracle database server environment.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.

Overview

Section 1: Oracle Database Setup

Lecture 1 Introduction

Lecture 2 What is Oracle

Lecture 3 Oracle installation requirements

Lecture 4 Download Oracle

Lecture 5 Install Oracle

Lecture 6 What is SQLPlus

Lecture 7 Connect SQLPlus to Oracle

Lecture 8 How to start and stop Oracle Database

Lecture 9 What is SQL Developer

Lecture 10 Connect SQL Developer to Oracle

Lecture 11 What are Schemas

Lecture 12 Download sample schemas

Lecture 13 Unlock sample HR Schema Account

Lecture 14 Unlock sample schema tables

Lecture 15 Connect schema account to Oracle

Lecture 16 What are TNS Names

Lecture 17 Creating TNS Names

Lecture 18 Connect Oracle with TNS Names

Lecture 19 What is TOAD

Lecture 20 Install TOAD

Lecture 21 Connect TOAD to Oracle

Section 2: Microsoft SQL Server Setup

Lecture 22 What is SQL Server

Lecture 23 Installation requirements

Lecture 24 Download SQL Server

Lecture 25 Install SQL Server

Lecture 26 Install SQL Server Management Studio - SSMS

Lecture 27 Connecting to SQL Server

Lecture 28 Install sample database.

Section 3: Data Migration: SQL Server Database to Oracle

Lecture 29 Create a database user

Lecture 30 Creating a repository

Lecture 31 Configure third party database connection: part 1

Lecture 32 Configure third party database connection: part 2

Lecture 33 Capturing source data

Lecture 34 Convert captured data model to Oracle

Lecture 35 Translate third party T-SQL Objects to Oracle

Lecture 36 Generate Scripts to create target database

Lecture 37 Moving data from SQL Server to Oracle

Section 4: Oracle Application Development -APEX

Lecture 38 What is Oracle APEX

Lecture 39 Oracle APEX Installation Requirements

Lecture 40 Download Oracle APEX

Lecture 41 Installing Oracle APEX

Lecture 42 Installing Java Development Kit - JDK

Lecture 43 Download Oracle Rest Data Services

Lecture 44 Installing Oracle Rest Data Services

Lecture 45 How to sign into Oracle APEX

Lecture 46 What is an APEX Workspace

Lecture 47 How to create a workspace

Lecture 48 How to create a new APEX user

Lecture 49 Sign in to APEX as new User

Lecture 50 How to request a cloud APEX Workspace

Lecture 51 How to activate a cloud APEX Workspace

Lecture 52 Build applications from datasets

Section 5: Oracle PL/SQL

Lecture 53 What is PL/SQL

Lecture 54 Viewing HR Schema Objects with SQLPlus

Lecture 55 Viewing employees table properties with SQLPlus

Lecture 56 Viewing employees table data with SQLPlus

Lecture 57 PL/SQL Variables

Lecture 58 PL/SQL Variable declaration

Lecture 59 PLSQL Variable Assignment

Lecture 60 PLSQL Variable Anchors

Lecture 61 PLSQL Block structure

Lecture 62 Execute a PLSQL annonymous block using TOAD

Lecture 63 Edit a PLSQL Code block using SQL Plus

Lecture 64 Create a new connection in TOAD

Lecture 65 Connecting to Oracle Database HR Schema with SQLplus

Lecture 66 Executing PLSQL Variable Assignemt using TOAD

Lecture 67 Intitializing Variables in PLSQL using TOAD

Lecture 68 PLSQL Literals

Lecture 69 PLSQL Constants using TOAD

Lecture 70 Variable Scopes in PLSQL using TOAD

Lecture 71 Introduction to PLSQL Functions

Lecture 72 Creating functions

Lecture 73 Creating PLSQL Functions using TOAD

Lecture 74 What are PLSQL Stored Procedures

Lecture 75 How to create stored procedure in TOAD

Lecture 76 How to execute or call a stored procedure in TOAD

Lecture 77 PLSQL Nested Block

Lecture 78 Syntax for Nested PLSQL Blocks

Lecture 79 Nested Block Scopes

Lecture 80 Creating a nested PLSQL Block with TOAD

Lecture 81 data types

Lecture 82 PLSQL IF Statements

Lecture 83 PLSQL If statement examples using TOAD

Lecture 84 PLSQL CASE Statement

Lecture 85 PLSQL CASE Statement Example using TOAD

Lecture 86 PLSQL Searched Case Statement

Lecture 87 PLSQL Searched Case Statement Example using TOAD

Lecture 88 PLSQL CURSOR

Lecture 89 PLSQL Cursor Example using Toad

Lecture 90 Introduction to PLSQL Package

Lecture 91 Creating a PLSQL Package Specification using TOAD

Lecture 92 Creating a PLSQL Package Body using TOAD

Lecture 93 Referencing PLSQL Package Elements using Toad

Anyone who wants to learn Oracle engineering and development skills