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


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


  • Knowledge of basic database concepts advised.
  • Oracle database required. (The installation is covered in the course)


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.

Who this course is for:

  • Anyone who wants to learn Oracle engineering and development skills

Created by Bluelime Learning Solutions
Last updated 2/2023
English [Auto]

Size: 1.86 GB

Download Now

Leave A Reply

Your email address will not be published.