PL SQL 1-Hour Bootcamp: Learn Fundamental PLSQL Skills Today
3.9 (44 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,057 students enrolled

PL SQL 1-Hour Bootcamp: Learn Fundamental PLSQL Skills Today

Quick introduction to Oracle PL/SQL Development. With practical Oracle plsql exercises to try out your new skills
3.9 (44 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,057 students enrolled
Last updated 2/2018
English
English [Auto-generated]
Current price: $55.99 Original price: $79.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 3 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn the fundamentals of PL/SQL programming
  • Relevant test and exercises
  • The class is condensed to only 1 hour to keep learning simple and help you progress fast!
Course content
Expand all 15 lectures 58:52
+ Learn PL/SQL In 1 Hour
11 lectures 58:28

1. Sections in PL-SQL block
2. PLSQL Program Units
3. A very small code using PLSQL

Preview 02:33

1. Numeric Datatypes
2. Character Datatypes
3. Boolean Datatypes
4. Nulls

Data-types
02:19

1. Declaration and initializing Variables.
2. Assingning values to variables

Preview 03:58

1. IF-THEN Statement
2. IF-THEN-ELSE
3.IF-THEN-ELSIF
4. CASE

Conditions
05:19

1. Basic Loop
2. While Loop
3. For Loop

Loops
09:22

1. Syntax
2. Parts of Procedure
3. Creating Procedure
4. Deleting Procedure
5. Passing Parameters
6. Calling Procedure

Procedures
04:41

1. Syntax
2. Parts of Function
3. Creating Function
4. Deleting Function
5. Calling Functions

Preview 03:20

1. Use
2. Attributes
3. Declaring cursor
4. Opening Cursor
5. Fetching Cursor
6. Closing Cursor

Cursors
11:27

1. Syntax
2. User defined Exceptions
3. Inbuilt Exceptions

Preview 06:08

1. Package Specification
2. Package Body
3. Syntax
4. Calling package elements

Packages
04:58

We will talk about what you have learned so far and where to go from here

Conclusion (And best places to further your PL/SQL knowledge)
04:23
+ Do-It-Yourself Exercises (Test Your Skills)
4 lectures 00:24
QUIZ: Multiple choice PL/SQL exercise
00:05
PRACTICAL: Create 8 PL/SQL programs test
00:07
PRACTICAL: Create 8 PL/SQL programs test with ANSWERS
00:03
Bonus Lecture: Course discounts & newsletter
00:08
Requirements
  • Basic SQL knowledge is helpful, but not necessary
Description

The primary objective of this course is to introduce you to the Oracle plsql programming language fast and to give you the practical skills to be productive as a web developer  working with Oracle databases.


In the course you will be introduced to variety of fundamental PL SQL functions like:

  • How to declare and use PL/SQL Variables

  • How to create functions and procedures

  • Use PL/SQL packages to group and contain related objects

  • Handle run time errors using Exceptions

  • And much much more...

By the end of the course I will give you practical exercises for you to do to test out your new PL/SQL skills in real time. 

You will learn everything you need to jumpstart your PL/SQL programming learning.


WHAT IS PL/SQL (AND WHY IS IT IMPORTANT?)

PL/SQL is a block structured language  that can contain any number of nested sub-blocks. Pl/SQL stands for "Procedural Language extension of SQL" that is used in Oracle. Although PL/SQL is closely integrated with SQL language, it adds some programming constraints that are not available in SQL.


GUARANTEE
If within 30 days of buying the course you decide that its not for you, please get a refund.
We only want happy students.


ARE YOU READY TO TAKE YOUR CAREER TO THE NEXT LEVEL?

Please press the "Take This Course" button and start learning 2 minutes from now!

Who this course is for:
  • Anyone who wants to learn the PL/SQL Programming Language
  • Beginning Oracle SQL developers that wants to further their career
  • Developers that wants a promotion, pay-raise or a new PL/SQL programming job