Oracle PL/SQL Fundamentals vol. I & II

4.4 (4397)
MOOC
Oracle PL/SQL Fundamentals vol. I & II
Payment
Learning paid
Language
English
Duration
20 hours course
Course by Udemy
Oracle PL/SQL Fundamentals vol. I & II
What will you learn?
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
About the course

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 will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Program
Oracle 11g PL/SQL Fundamentals I
Introduction
The instructor has provided additional resources and example files for you to use.If you would like to access these, please download the attached .zip file, which contains the files shown in this course.
Course Setup
Selecting the Appropriate Database Tool
Understanding PL/SQL
PL/SQL Blocks
Working with SQL Plus
DECLARE Clause Objects
PL/SQL Available Data Types
Declaring Simple Data Types and Assignments
Declaring Complex Data Types and Assignments
Declaring Complex RowTypes and Assignments
Requirements
  • Familiarity with database and programming principles
Lecturers
Intellezy Trainers
Intellezy Trainers
Computer Training Specialists
Platform
/storage/img/providers/udemy.svg
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.4
(2377)
(1520)
(409)
(72)
(50)
Comments (4397)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.