Oracle Application Development and PL/SQL for beginners

Focused View

Bluelime Learning Solutions

4:29:12

381 View

1. Introduction to Databases

1. Introduction.html

2. What is a Database Understanding Data Storage, Management, and Retrieval.html

3. Overview of SQL vs. NoSQL, RDBMS.html

4. The Role of a Database Developer Responsibilities and Career Path.html

5. Understanding Data and Information.html

6. Introduction to Database Systems.html

2. Oracle Database Setup

1. What is an Oracle Database.html

2. Oracle installation requirements.mp4

01:27

3. Download Oracle.mp4

03:03

4. Install Oracle.mp4

01:58

5. What is SQLPlus.mp4

09:34

6. Connect SQLPlus to Oracle.mp4

03:13

7. How to start and stop Oracle Database.mp4

01:26

8. What is SQL Developer.mp4

02:41

9. Connect SQL Developer to Oracle.mp4

02:29

10. What are Schemas.html

11. Download sample schemas.mp4

02:12

12. Unlock sample HR Schema Account.mp4

05:18

13. Unlock sample schema tables.mp4

04:39

14. Connect schema account to Oracle.mp4

01:49

15. What are TNS Names.mp4

04:09

16. Creating TNS Names.mp4

06:43

17. Connect Oracle with TNS Names.mp4

03:20

18. What is TOAD.html

19. Install TOAD.mp4

03:21

20. Connect TOAD to Oracle.mp4

02:42

21. Create a new connection in TOAD.mp4

02:29

3. Programming with 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. Executing PLSQL Variable Assignemt using TOAD.mp4

05:35

13. Intitializing Variables in PLSQL using TOAD.mp4

02:30

14. PLSQL Literals.mp4

00:31

15. PLSQL Constants using TOAD.mp4

04:19

16. Variable Scopes in PLSQL using TOAD.mp4

03:41

17. Introduction to PLSQL Functions.mp4

03:20

18. Creating functions.mp4

06:21

19. Creating PLSQL Functions using TOAD.mp4

07:51

20. What are PLSQL Stored Procedures.mp4

02:23

21. How to create stored procedure in TOAD.mp4

03:24

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

04:03

23. PLSQL Nested Block.mp4

02:17

24. Syntax for Nested PLSQL Blocks.mp4

01:19

25. Nested Block Scopes.mp4

07:17

26. Creating a nested PLSQL Block with TOAD.mp4

07:54

27. Data types.html

28. PLSQL IF Statements.mp4

02:59

29. PLSQL If statement examples using TOAD.mp4

10:46

30. PLSQL CASE Statement.mp4

03:11

31. PLSQL CASE Statement Example using TOAD.mp4

05:21

32. PLSQL Searched Case Statement.mp4

01:20

33. PLSQL Searched Case Statement Example using TOAD.mp4

06:00

34. PLSQL CURSOR.mp4

03:10

35. PLSQL Cursor Example using Toad.mp4

09:56

36. Introduction to PLSQL Package.mp4

01:07

37. Creating a PLSQL Package Specification using TOAD.mp4

04:28

38. Creating a PLSQL Package Body using TOAD.mp4

07:05

39. Referencing PLSQL Package Elements using Toad.mp4

05:08

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. How to create a workspace.mp4

03:04

10. How to create a new APEX user.mp4

03:17

11. What is an APEX Workspace.html

12. Sign in to APEX as new User.mp4

01:40

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

Description

Unlocking the Power of Databases: A Beginner's Journey through Oracle APEX and PL/SQL

What You'll Learn?

Fundamentals of Relational Databases
PL/SQL Variables and Control Structures
Creating and Using Functions and Procedures
Triggers and Cursors in PL/SQL
Navigating the Oracle APEX Environment
Building APEX Applications

Who is this for?

Aspiring Database Professionals

Software Developers

IT Students

Business Analysts and Data Analysts

Technical Managers

Career Changers

Hobbyists and Enthusiasts

What You Need to Know?

Basic Understanding of Databases

Fundamental Computer Skills

Introductory Programming Knowledge

Oracle Database Access

Internet Connection

Eagerness to Learn

More details

Description
Oracle Application Development and PL/SQL for Beginners isÂ designed to usher beginners into the vast and dynamic world of Oracle database technologies. This course aims to demystify Oracle Application Express (APEX) and PL/SQL, empowering students with the skills needed to build sophisticated, database-driven applications.
PL/SQL, isÂ Oracle's powerful extension for SQL. Through engaging lectures and hands-on exercises, participants will explore the syntax and structure of PL/SQL, learning how to declare variables, write control structures, and utilize PL/SQL's powerful features to create procedures, functions, packages, and triggers. This module is meticulously designed to transform beginners into proficient PL/SQL developers capable of writing efficient, secure, and maintainable code.
The journey continues with a deep dive into Oracle Application Express (APEX), a low-code development platform that enables rapid application development. Students will learn how to navigate the APEX environment, create and manage applications, and understand the core components that make up an APEX application, including forms, reports, and interactive grids. Special attention is given to user interface design, ensuring that participants can craft applications that are not only functional but also intuitive and visually appealing.
Students will apply the concepts learned in real-world scenarios, building their own APEX applications from scratch. This hands-on approach reinforces learning, encourages experimentation, and builds confidence in oneâ€™s ability to tackle real-world challenges.
"Oracle Application Development and PL/SQL for Beginners" is more than just a course; it's a gateway to a career in database and application development. It is ideally suited for aspiring database professionals, software developers looking to expand their skill set, IT students seeking practical experience, and even business analysts who wish to harness the power of Oracle technologies for data analysis.
Upon completion of this course, participants will have gained a solid understanding of Oracle APEX and PL/SQL, equipped with the knowledge and skills to build robust, scalable, and secure applications. They will be prepared to explore further into the Oracle ecosystem, pursue professional certifications, or embark on a career in the technology sector. Join us on this transformative learning experience and take the first step towards becoming an Oracle application development expert.

Who this course is for:
Aspiring Database Professionals
Software Developers
IT Students
Business Analysts and Data Analysts
Technical Managers
Career Changers
Hobbyists and Enthusiasts

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.