Oracle EngineerDeveloper ( PLSQL ,APEX , Data Migration)

Oracle Engineer/Developer – ( PL/SQL ,APEX , Data Migration), available at $44.99, has an average rating of 4.5, with 93 lectures, based on 6 reviews, and has 1010 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to learn Oracle engineering and development skills It is particularly useful for Anyone who wants to learn Oracle engineering and development skills.

Enroll now: Oracle Engineer/Developer – ( PL/SQL ,APEX , Data Migration)

Summary

Title: Oracle Engineer/Developer – ( PL/SQL ,APEX , Data Migration)

Price: $44.99

Average Rating: 4.5

Number of Lectures: 93

Number of Published Lectures: 93

Number of Curriculum Items: 93

Number of Published Curriculum Objects: 93

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone who wants to learn Oracle engineering and development skills

Target Audiences

Anyone who wants to learn Oracle engineering and development skills

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.

Course Curriculum

Chapter 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

Chapter 2: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: Installation requirements

Lecture 3: Download SQL Server

Lecture 4: Install SQL Server

Lecture 5: Install SQL Server Management Studio – SSMS

Lecture 6: Connecting to SQL Server

Lecture 7: Install sample database.

Chapter 3: Data Migration: SQL Server Database to Oracle

Lecture 1: Create a database user

Lecture 2: Creating a repository

Lecture 3: Configure third party database connection: part 1

Lecture 4: Configure third party database connection: part 2

Lecture 5: Capturing source data

Lecture 6: Convert captured data model to Oracle

Lecture 7: Translate third party T-SQL Objects to Oracle

Lecture 8: Generate Scripts to create target database

Lecture 9: Moving data from SQL Server to Oracle

Chapter 4: Oracle Application Development -APEX

Lecture 1: What is Oracle APEX

Lecture 2: Oracle APEX Installation Requirements

Lecture 3: Download Oracle APEX

Lecture 4: Installing Oracle APEX

Lecture 5: Installing Java Development Kit – JDK

Lecture 6: Download Oracle Rest Data Services

Lecture 7: Installing Oracle Rest Data Services

Lecture 8: How to sign into Oracle APEX

Lecture 9: What is an APEX Workspace

Lecture 10: How to create a workspace

Lecture 11: How to create a new APEX user

Lecture 12: Sign in to APEX as new User

Lecture 13: How to request a cloud APEX Workspace

Lecture 14: How to activate a cloud APEX Workspace

Lecture 15: Build applications from datasets

Chapter 5: Oracle PL/SQL

Lecture 1: What is PL/SQL

Lecture 2: Viewing HR Schema Objects with SQLPlus

Lecture 3: Viewing employees table properties with SQLPlus

Lecture 4: Viewing employees table data with SQLPlus

Lecture 5: PL/SQL Variables

Lecture 6: PL/SQL Variable declaration

Lecture 7: PLSQL Variable Assignment

Lecture 8: PLSQL Variable Anchors

Lecture 9: PLSQL Block structure

Lecture 10: Execute a PLSQL annonymous block using TOAD

Lecture 11: Edit a PLSQL Code block using SQL Plus

Lecture 12: Create a new connection in TOAD

Lecture 13: Connecting to Oracle Database HR Schema with SQLplus

Lecture 14: Executing PLSQL Variable Assignemt using TOAD

Lecture 15: Intitializing Variables in PLSQL using TOAD

Lecture 16: PLSQL Literals

Lecture 17: PLSQL Constants using TOAD

Lecture 18: Variable Scopes in PLSQL using TOAD

Lecture 19: Introduction to PLSQL Functions

Lecture 20: Creating functions

Lecture 21: Creating PLSQL Functions using TOAD

Lecture 22: What are PLSQL Stored Procedures

Lecture 23: How to create stored procedure in TOAD

Lecture 24: How to execute or call a stored procedure in TOAD

Lecture 25: PLSQL Nested Block

Lecture 26: Syntax for Nested PLSQL Blocks

Lecture 27: Nested Block Scopes

Lecture 28: Creating a nested PLSQL Block with TOAD

Lecture 29: data types

Lecture 30: PLSQL IF Statements

Lecture 31: PLSQL If statement examples using TOAD

Lecture 32: PLSQL CASE Statement

Lecture 33: PLSQL CASE Statement Example using TOAD

Lecture 34: PLSQL Searched Case Statement

Lecture 35: PLSQL Searched Case Statement Example using TOAD

Lecture 36: PLSQL CURSOR

Lecture 37: PLSQL Cursor Example using Toad

Lecture 38: Introduction to PLSQL Package

Lecture 39: Creating a PLSQL Package Specification using TOAD

Lecture 40: Creating a PLSQL Package Body using TOAD

Lecture 41: Referencing PLSQL Package Elements using Toad

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 5 votes

Frequently Asked Questions

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!