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

Focused View

Bluelime Learning Solutions

5:58:37

131 View

1. Oracle Database Setup

1. Introduction.mp4

00:20

2. What is Oracle.html

3. Oracle installation requirements.mp4

01:27

4. Download Oracle.mp4

03:59

5. Install Oracle.mp4

01:58

6. What is SQLPlus.mp4

03:23

7. Connect SQLPlus to Oracle.mp4

03:13

8. How to start and stop Oracle Database.mp4

01:26

9. What is SQL Developer.mp4

02:41

10. Connect SQL Developer to Oracle.mp4

02:29

11. What are Schemas.html

12. Download sample schemas.mp4

02:12

13. Unlock sample HR Schema Account.mp4

05:18

14. Unlock sample schema tables.mp4

04:39

15. Connect schema account to Oracle.mp4

01:49

16. What are TNS Names.mp4

04:09

17. Creating TNS Names.mp4

06:43

18. Connect Oracle with TNS Names.mp4

03:20

19. What is TOAD.mp4

03:04

20. Install TOAD.mp4

03:21

21. Connect TOAD to Oracle.mp4

02:42

2. Microsoft SQL Server Setup

1. What is SQL Server.mp4

02:57

2. Installation requirements.mp4

04:21

3. Download SQL Server.mp4

04:31

4. Install SQL Server.mp4

09:43

5. Install SQL Server Management Studio - SSMS.mp4

05:48

6. Connecting to SQL Server.mp4

02:16

7. Install sample database..mp4

06:28

3. Data Migration SQL Server Database to Oracle

1. Create a database user.mp4

03:53

2. Creating a repository.mp4

02:35

3. Configure third party database connection part 1.mp4

06:28

4. Configure third party database connection part 2.mp4

07:25

5. Capturing source data.mp4

07:36

6. Convert captured data model to Oracle.mp4

01:57

7. Translate third party T-SQL Objects to Oracle.mp4

10:11

8. Generate Scripts to create target database.mp4

02:21

9. Moving data from SQL Server to Oracle.mp4

07:55

4. Oracle Application Development -APEX

1. What is Oracle APEX.html

2. Oracle APEX Installation Requirements.mp4

03:31

3. Download Oracle APEX.mp4

04:09

4. Installing Oracle APEX.mp4

07:41

5. Installing Java Development Kit - JDK.mp4

01:53

6. Download Oracle Rest Data Services.mp4

03:09

7. Installing Oracle Rest Data Services.mp4

06:19

8. How to sign into Oracle APEX.mp4

03:20

9. What is an APEX Workspace.html

10. How to create a workspace.mp4

03:04

11. How to create a new APEX user.mp4

03:17

12. Sign in to APEX as new User.mp4

03:20

13. How to request a cloud APEX Workspace.mp4

01:46

14. How to activate a cloud APEX Workspace.mp4

01:37

15. Build applications from datasets.mp4

08:10

5. Oracle PLSQL

1. What is PLSQL.mp4

01:02

2. Viewing HR Schema Objects with SQLPlus.mp4

03:22

3. Viewing employees table properties with SQLPlus.mp4

02:23

4. Viewing employees table data with SQLPlus.mp4

04:18

5. PLSQL Variables.mp4

01:55

6. PLSQL Variable declaration.mp4

02:15

7. PLSQL Variable Assignment.mp4

05:31

8. PLSQL Variable Anchors.mp4

04:07

9. PLSQL Block structure.mp4

03:13

10. Execute a PLSQL annonymous block using TOAD.mp4

03:41

11. Edit a PLSQL Code block using SQL Plus.mp4

02:00

12. Create a new connection in TOAD.mp4

02:29

13. Connecting to Oracle Database HR Schema with SQLplus.mp4

03:11

14. Executing PLSQL Variable Assignemt using TOAD.mp4

05:35

15. Intitializing Variables in PLSQL using TOAD.mp4

02:30

16. PLSQL Literals.mp4

00:31

17. PLSQL Constants using TOAD.mp4

04:19

18. Variable Scopes in PLSQL using TOAD.mp4

03:41

19. Introduction to PLSQL Functions.mp4

03:20

20. Creating functions.mp4

06:21

21. Creating PLSQL Functions using TOAD.mp4

07:51

22. What are PLSQL Stored Procedures.mp4

02:23

23. How to create stored procedure in TOAD.mp4

03:24

24. How to execute or call a stored procedure in TOAD.mp4

04:03

25. PLSQL Nested Block.mp4

02:17

26. Syntax for Nested PLSQL Blocks.mp4

01:19

27. Nested Block Scopes.mp4

07:17

28. Creating a nested PLSQL Block with TOAD.mp4

07:54

29. data types.html

30. PLSQL IF Statements.mp4

02:59

31. PLSQL If statement examples using TOAD.mp4

10:46

32. PLSQL CASE Statement.mp4

03:11

33. PLSQL CASE Statement Example using TOAD.mp4

05:21

34. PLSQL Searched Case Statement.mp4

01:20

35. PLSQL Searched Case Statement Example using TOAD.mp4

06:00

36. PLSQL CURSOR.mp4

03:10

37. PLSQL Cursor Example using Toad.mp4

09:56

38. Introduction to PLSQL Package.mp4

01:07

39. Creating a PLSQL Package Specification using TOAD.mp4

04:28

40. Creating a PLSQL Package Body using TOAD.mp4

07:05

41. Referencing PLSQL Package Elements using Toad.mp4

05:08

Description

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

Who is this for?

Anyone who wants to learn Oracle engineering and development skills

More details

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.

Who this course is for:
Anyone who wants to learn Oracle engineering and development skills

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.