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
Size: 1.86 GB