PL/SQL by Example - Beginner to Advanced PL/SQL (Udemy.com)
Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application
Created by: Amarnath Reddy
Produced in 2018
What you will learn
- Declare PL/SQL Variables
- Conditionally control code flow (loops, control structures)
- Use some of the Oracle supplied PL/SQL packages to generate screen output
- Create anonymous PL/SQL blocks, functions and procedures
- Use PL/SQL packages to group and contain related constructs
- Catch run time errors using Exceptions
- Perform Data processing using Records and Cursors
- Manage data using Collections
- Create triggers to solve business challenges
- Peform Bulk Processing to improve performance
- Execute SQL using Dynamic SQL
- Pipelining the data as it is processed
- Working with Large Objects (LOB's)
Quality Score
Overall Score : 90 / 100
Course Description
This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.
PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.
In this course participants will learn
Describe the features and syntax of PL/SQLDesign PL/SQL anonymous blocks that execute efficientlyUse the Oracle supplied PL/SQL packages to generate screen outputCreate and debug Stored Procedures and FunctionsDesign PL/SQL packages to group related constructsUse PL/SQL programming constructs and conditionally control code flow Create overloaded package subprograms for more flexibilityHandle runtime errors using ExceptionsWriting manageable code using RecordsStoring and processing data using CollectionsProcessing data using Implicit and Explicit Cursors
Softwares used
Oracle Database 11gSQL DeveloperWho this course is for:
This PL/SQL course is meant for students who want to learn Procedure Language to control SQL Statements.
This course is not for you if you're looking to learn more advanced concepts of PL/SQL
Instructor Details
- 4.5 Rating
256 Reviews
Amarnath Reddy
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.
More courses by Amarnath Reddy
More sql courses
SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)
Provider: Udemy
Time: 5h
$11.99
Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)
- Provider: Udemy
- Time: 20h
$11.99
Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)
- Provider: Coursera
- Time: 3h
Free
Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)
- Provider: Udemy
- Time: 12.5h
$11.99
Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Reviews
- Video Duration:
5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2018 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
