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

سرفصل های دوره

Migrate SQL Server to Oracle ,Create stored procedures, Build Applications

1. Oracle Database Setup

1. Introduction

2. What is Oracle.html

3. Oracle installation requirements

4. Download Oracle

5. Install Oracle

6. What is SQLPlus

7. Connect SQLPlus to Oracle

8. How to start and stop Oracle Database

9. What is SQL Developer

10. Connect SQL Developer to Oracle

11. What are Schemas.html

12. Download sample schemas

13. Unlock sample HR Schema Account

14. Unlock sample schema tables

15. Connect schema account to Oracle

16. What are TNS Names

17. Creating TNS Names

18. Connect Oracle with TNS Names

19. What is TOAD

20. Install TOAD

21. Connect TOAD to Oracle

2. Microsoft SQL Server Setup

1. What is SQL Server

2. Installation requirements

3. Download SQL Server

4. Install SQL Server

5. Install SQL Server Management Studio - SSMS

6. Connecting to SQL Server

7. Install sample database.

3. Data Migration SQL Server Database to Oracle

1. Create a database user

2. Creating a repository

3. Configure third party database connection part 1

4. Configure third party database connection part 2

5. Capturing source data

6. Convert captured data model to Oracle

7. Translate third party T-SQL Objects to Oracle

8. Generate Scripts to create target database

9. Moving data from SQL Server to Oracle

4. Oracle Application Development -APEX

1. What is Oracle APEX.html

2. Oracle APEX Installation Requirements

3. Download Oracle APEX

4. Installing Oracle APEX

5. Installing Java Development Kit - JDK

6. Download Oracle Rest Data Services

7. Installing Oracle Rest Data Services

8. How to sign into Oracle APEX

9. What is an APEX Workspace.html

10. How to create a workspace

11. How to create a new APEX user

12. Sign in to APEX as new User

13. How to request a cloud APEX Workspace

14. How to activate a cloud APEX Workspace

15. Build applications from datasets

5. Oracle PLSQL

1. What is PLSQL

2. Viewing HR Schema Objects with SQLPlus

3. Viewing employees table properties with SQLPlus

4. Viewing employees table data with SQLPlus

5. PLSQL Variables

6. PLSQL Variable declaration

7. PLSQL Variable Assignment

8. PLSQL Variable Anchors

9. PLSQL Block structure

10. Execute a PLSQL annonymous block using TOAD

11. Edit a PLSQL Code block using SQL Plus

12. Create a new connection in TOAD

13. Connecting to Oracle Database HR Schema with SQLplus

14. Executing PLSQL Variable Assignemt using TOAD

15. Intitializing Variables in PLSQL using TOAD

16. PLSQL Literals

17. PLSQL Constants using TOAD

18. Variable Scopes in PLSQL using TOAD

19. Introduction to PLSQL Functions

20. Creating functions

21. Creating PLSQL Functions using TOAD

22. What are PLSQL Stored Procedures

23. How to create stored procedure in TOAD

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

25. PLSQL Nested Block

26. Syntax for Nested PLSQL Blocks

27. Nested Block Scopes

28. Creating a nested PLSQL Block with TOAD

29. data types.html

30. PLSQL IF Statements

31. PLSQL If statement examples using TOAD

32. PLSQL CASE Statement

33. PLSQL CASE Statement Example using TOAD

34. PLSQL Searched Case Statement

35. PLSQL Searched Case Statement Example using TOAD

36. PLSQL CURSOR

37. PLSQL Cursor Example using Toad

38. Introduction to PLSQL Package

39. Creating a PLSQL Package Specification using TOAD

40. Creating a PLSQL Package Body using TOAD

41. Referencing PLSQL Package Elements using Toad

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training