Oracle PL/SQL For beginners using TOAD and SQL Developer

Focused View

Bluelime Learning Solutions

1:58:52

345 View

1. Oracle Database Setup

1. Introduction.mp4

00:20

2. Oracle Installation requirements.mp4

01:27

3. Download Oracle.mp4

03:59

4. Install Oracle.mp4

01:58

5. Connect SQLPlus to Oracle.mp4

03:13

6. How to start and stop Oracle Database Server.mp4

01:26

7. What is SQL Developer.mp4

02:41

8. Install SQL Developer.mp4

03:41

9. Connect SQL Developer to Oracle.mp4

02:29

10. Download Sample Schemas.mp4

02:12

11. Unlock sample HR Schema Account.mp4

05:18

12. Unlock sample schemas tables.mp4

04:39

13. Connect Schema account to Oracle.mp4

01:49

14. What is TOAD.html

15. Install TOAD.mp4

03:21

16. Connect Toad to Oracle.mp4

02:42

17. Create a new connection in TOAD.mp4

02:29

2. PLSQL Essentials

1. What is PLSQL.mp4

01:02

2. PLSQL Block Structure.mp4

03:13

3.1 anonymous-block.zip

3. Execute a PLSQL Anonymous Block using TOAD.mp4

03:41

4. PLSQL Variables.mp4

01:55

5. PLSQL Variable Declaration.mp4

02:15

6. PLSQL Variable Assignment.mp4

05:31

7. PLSQL Variable Anchors.mp4

04:07

8. Executing PLSQL Variable Assignment using TOAD.mp4

05:35

9. Initializing Variables in PLSQL using TOAD.mp4

02:30

10. PLSQL Literals.mp4

00:31

11. Variable Scopes in PLSQL using TOAD.mp4

03:41

12. Introduction to PLSQL Functions.mp4

03:20

13. Creating Functions.mp4

06:21

14. Creating PLSQL Functions using TOAD.mp4

07:51

15. What are PLSQL Stored Procedures.mp4

02:23

16. How to create stored procedure using TOAD.mp4

03:24

17. How to execute or call a stored procedure using TOAD.mp4

04:03

18.1 Overview of PLSQL Data Types.pdf

18.2 plsql data types.zip

18. PLSQL Data Types.html

19. PLSQL IF Statements.mp4

02:59

20. PLSQL IF Statements example using TOAD.mp4

10:46

Description

Build PL/SQL Programs like Functions and Stored Procedures

What You'll Learn?

Create an anonymous PL/SQL block
Execute a PL/SQL anonymous PL/SQL Block
Create PL/SQL Variables
Execute a PL/SQL Variable assignment
Initialize Variables
Create PL/SQL Functions
Create a PL/SQL stored procedures
Execute a stored procedure
Implement conditional statements

Who is this for?

Software Professionals, who want to learn PL/SQL

Beginner SQL Developers

More details

Description
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.
This course is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. This tutorial will give you great understanding on PL/SQL Programming concepts, and after completing this course, you will be at an intermediate level of expertise from where you can take yourself to a higher level of expertise.
Before proceeding with this course, you should have a basic understanding of software basic concepts like what is database, source code, text editor and execution of programs, etc. If you already have an understanding on SQL and other computer programming language, then it will be an added advantage to proceed.

PL/SQL is tightly integrated with SQL.
It offers extensive error checking.
It offers numerous data types.
It offers a variety of programming structures.
It supports structured programming through functions and procedures.
It supports object-oriented programming.
It supports the development of web applications and server pages.

Who this course is for:
Software Professionals, who want to learn PL/SQL
Beginner SQL Developers

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.