Currently Empty: £0.00
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.
Oracle Database Setup
Programming with PL/SQL
-
7What is an Oracle Database
-
8Oracle installation requirements
-
9Download Oracle
-
10Install Oracle
-
11What is SQLPlus
-
12Connect SQLPlus to Oracle
-
13How to start and stop Oracle Database
-
14What is SQL Developer
-
15Connect SQL Developer to Oracle
-
16What are Schemas
-
17Download sample schemas
-
18Unlock sample HR Schema Account
-
19Unlock sample schema tables
-
20Connect schema account to Oracle
-
21What are TNS Names
-
22Creating TNS Names
-
23Connect Oracle with TNS Names
-
24What is TOAD
-
25Install TOAD
-
26Connect TOAD to Oracle
-
27Create a new connection in TOAD
Oracle Application Development -APEX
-
28What is PL/SQL
-
29Viewing HR Schema Objects with SQLPlus
-
30Viewing employees table properties with SQLPlus
-
31Viewing employees table data with SQLPlus
-
32PL/SQL Variables
-
33PL/SQL Variable declaration
-
34PLSQL Variable Assignment
-
35PLSQL Variable Anchors
-
36PLSQL Block structure
-
37Execute a PLSQL annonymous block using TOAD
-
38Edit a PLSQL Code block using SQL Plus
-
39Executing PLSQL Variable Assignemt using TOAD
-
40Intitializing Variables in PLSQL using TOAD
-
41PLSQL Literals
-
42PLSQL Constants using TOAD
-
43Variable Scopes in PLSQL using TOAD
-
44Introduction to PLSQL Functions
-
45Creating functions
-
46Creating PLSQL Functions using TOAD
-
47What are PLSQL Stored Procedures
-
48How to create stored procedure in TOAD
-
49How to execute or call a stored procedure in TOAD
-
50PLSQL Nested Block
-
51Syntax for Nested PLSQL Blocks
-
52Nested Block Scopes
-
53Creating a nested PLSQL Block with TOAD
-
54Data types
-
55PLSQL IF Statements
-
56PLSQL If statement examples using TOAD
-
57PLSQL CASE Statement
-
58PLSQL CASE Statement Example using TOAD
-
59PLSQL Searched Case Statement
-
60PLSQL Searched Case Statement Example using TOAD
-
61PLSQL CURSOR
-
62PLSQL Cursor Example using Toad
-
63Introduction to PLSQL Package
-
64Creating a PLSQL Package Specification using TOAD
-
65Creating a PLSQL Package Body using TOAD
-
66Referencing PLSQL Package Elements using Toad
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!
Please, login to leave a review