Oracle Engineer/Developer – ( PL/SQL ,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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024