課程介紹

★ Last Course Updates:

(Jul 2021): “Oracle-Supplied PL/SQL Packages” section is added!

(Jun 2021): “Using Dynamic SQL & PL/SQL in PL/SQL” section is added!

(May 2021): Closed-Captions are added!

(Apr 2021): New Quiz Questions are added!

…[更多細節]

哪些人適合這堂課？

• Anyone who wants to learn PL/SQL Programming Language
• Anyone who is looking for Beginner PL/SQL Subjects
• Anyone who is looking for Advanced PL/SQL Subjects
• Anyone who wants to pass “Oracle 1Z0-144 Program with PL/SQL” Exam
• Anyone who wants to pass “Oracle 1Z0-148 Advanced PL/SQL” Exam
• Anyone who wants to pass “Oracle 1Z0-149: Program with PL/SQL” Exam with Oracle Database 19c
• SQL Developers (All Levels)
• Beginner & Intermediate PL/SQL Developers
• Database Administrators
• Application Designers
• Software Developers

學習目標

• Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam – on your first try!
• Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam – on your first try!
• Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
• Every Subject is Explained from the Easiest to the Most Advanced.
• Real-World Examples for Every Section
• Some Advanced SQL Techniques
• Use SQL Developer Efficiently for PL/SQL
• Learn PL/SQL Architecture Very Well
• Improve Performance of SQL& PL/SQL Codes
• Create Your Dynamic SQL & PL/SQL Queries
• Learn PL/SQL Object Oriented Programming
• Learn PL/SQL Tuning for Performance
• Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
• Become a Job-Ready Oracle PL/SQL Developer Certified Professional!

課程介紹

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students

…[更多細節]

哪些人適合這堂課？

• Application designers and developers
• Database administrators
• Business users and non-technical senior end users

學習目標

• Over 90 lectures and 20 hours of content
• Prepare your enviornment
• Introducing Database Program Units
• Creating and Maintaining Packages
• Using System-Supplied Packages
• Creating and Maintaining Database Triggers
• Implementing System Event Triggers
• Work with Oracle database tools
• Understand and work work language features
• Work with DECLARE, BEGIN & EXCEPTION clause
• Understand and use nested blocks
• Use explicit cursors

課程介紹

Learn to become a PL/SQL developer in just four weeks.

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

…[更多細節]

哪些人適合這堂課？

• 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

學習目標

• 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)

課程介紹

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-149 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amou

…[更多細節]

哪些人適合這堂課？

• Students who wants to be expert in PL/SQL programming
• Students who wants to be certified in PL/SQL
• Fresh and junior programmers who need to find better jobs by gaining oracle certification
• Students who already know Oracle SQL and they need to move to next level which is PL/SQL

學習目標

• The full track of Oracle university Exam 1Z0-144 : Program with PL/SQL
• Oracle Database 12c Architecture
• Downloading and installing oracle database 12c in details
• Overview of PLSQL
• Declaring PLSQL Variables
• Writing executable statements
• Interacting with Oracle DB Server
• Writing Control structure
• Working with Composite Data Types
• Using explicit cursors
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Creating Packages
• Working with Packages
• Using oracle-supplied Packages in Application Development
• Using dynamic SQL
• Design consideration for PLSQL Code
• Creating triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PLSQL Compiler
• Managing PLSQL Code
• Managing Dependencies

課程介紹

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.Thi

…[更多細節]

哪些人適合這堂課？

• Application designers and developers
• Database administrators
• Business users and non-technical senior end users

學習目標

• Prepare your environment
• Work with Oracle database tools
• Understand and work with language features
• Work with the DECLARE clause
• Work with the BEGIN clause
• Work with the EXCEPTION clause
• Use explicit cursors
• Understand and use nested blocks
• Understand the difference between nested blocks and subprograms

課程介紹

Are you ready for your PL/SQL Developer Interview?

I have about 15+ years of experience in the Database world and have Interviewed 100’s of PL/SQL Developers in my 15+ years span.

Learning how to answer the PL/SQL interview questions is a powerful

…[更多細節]

哪些人適合這堂課？

• This course is meant for PL/SQL Developers who are preparing for a PL/SQL Developer job interview
• This course is not meant for Students who want to learn PL/SQL.

學習目標

• Students will be able refresh their PL/SQL knowledge and will be in a position to answer the most commonly asked PL/SQL Interview questions.

課程介紹

In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and

…[更多細節]

哪些人適合這堂課？

• Users Of All Levels

學習目標

• To Master Oracle PL/SQL – Learn From A Leading Expert

課程介紹

The objective of this Oracle 11g training course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. The areas covered include understanding the basic form and structure of program units store

…[更多細節]

哪些人適合這堂課？

• Application designers and developers
• Database administrators
• Business users and non-technical senior end users

學習目標

• Prepare your environment
• Introducing Database Program Units
• Creating and Maintaining Stored Procedures & Functions
• Creating and Maintaining Packages
• Advanced Cursor Techniques
• Using System-Supplied Packages
• Creating and Maintaining Database Triggers
• Implementing System Event Triggers

課程介紹

Over 20 hours and 100 videos are included in this bundle.

Save 20% by purchasing 3 Oracle/Database courses. This bundle includes:

Oracle PL/SQL Fundamentals vol. I
Oracle PL/SQL Fundamentals vol. II
Database Design Instruction

In this Oracle 11g P

…[更多細節]

哪些人適合這堂課？

• Application designers and developers
• Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design

學習目標

• Over 100 lectures and 20 hours of content
• Understand different types of databases
• Relate tables with IDs
• Understand normalization
• Introducing Database Program Units
• Creating and Maintaining Packages
• Work with DECLARE, BEGIN & EXCEPTION clause
• Understand and use nested blocks
• Use explicit cursors

課程介紹

学会并掌握开发Oracle数据库PLSQL程序，为后续继续学习Oracle奠定基础。

======课程大纲======

第一章：PL/SQL入门基础
（*）安装开发工具：SQL Developer
（*）第一个PL/SQL程序：Hello World
（*）什么是PL/SQL?

第二章：PL/SQL基本语法
（*）使用变量
（*）引用型变量和记录型变量
（*）条件判断语句
（*）执行循环

第三章：PL/SQL中的游标
（*）什么是游标?
（*）游标的基本用法
（*）游标编程

…[更多細節]

哪些人適合這堂課？

• 已经掌握SQL的Oracle数据库开发人员，运维人员，在校大学生。

學習目標

• PL/SQL编程
• SQL Developer