Understanding And Using Oracle PlSql Programming Language

What you'll learn
Understand the sections of the PL/SQL language
Be able to write simple PL/SQL programs
Ability to write PL/SQL functions and procedures
Ability to use cursors in PL/SQL programs
Requirements
Some understanding of what a database is
Understanding of SQL programming language helpful but not required
Description
This course will give and overview of the Oracle PL/SQL programming language.
This course is a must have for anyone considering learning more about databases and database management
Whether as a DBA or Database application developer, PL/SQL is foundations to understanding how Oracle works and how to change data within the database.
We cover all the fundamental aspects of the language and use real world example to manipulate databases.
Topic covered Include
- Explanation of PL/SQL
- Language Syntax, Sections, Operators, Assignments and Variables
- Using PL/SQL to automatically do updates, inserts and deletion of records of an Oracle Database
- PL/SQL Cursors - to bring in large data sets to work with
- PL/SQL Loops - to loop through tables of data
- PL/SQL Exceptions - to trap and handle coding exceptions both user and machine generated
- PL/SQL Triggers - to have the table automatically change data based on the other data
- PL/SQL Functions - to return a frequently used value and avoid duplicate coding
- PL/SQL Procedures - to get anonymous blocks into reusable coding procedures
- PL/SQL Packages - to put PL/SQL objects together to quicker retrieval
Overview
Section 1: Course Introduction: Course goals and objectives of what will be taught
Lecture 1 Course Introduction: Understanding of how this course will run and goals
Section 2: Tools that will be used in the course to program in PL/SQL
Lecture 2 Sql Developer: Overview of program that will be used to run/test the PL/SQL code
Section 3: SQL Review: Refresher for understanding how SQL works and what it does
Lecture 3 SQL Basics Refesher: Overview of the SQL language so it can be built upon
Lecture 4 SQL Demo: Look at how SQL works and what it's limitations are programmatically
Section 4: PL/SQL overview, declarations and syntax
Lecture 5 PLSQL: What is PL/SQL, who uses it and what are the benefits to the language
Lecture 6 Declarations, variables and constants what they are are and how to use them
Lecture 7 Operators
Lecture 8 Anonymous block example: Writing code in PL/SQL
Lecture 9 Cursors: Bringing multiple rows of data in to the program for manipulation
Lecture 10 Cursor Example
Lecture 11 PL/SQL languge symantics and good practices
Section 5: Execution section and data manipulating
Lecture 12 Executable section: where the code runs and interacts with the database
Lecture 13 Data manipulation language in PL/SQL, Transactional control and Cursor attribute
Lecture 14 Executable section example
Lecture 15 Interacting with the database: SELECT INTO, Assignments and %TYPE attribute
Lecture 16 DML example
Lecture 17 Conditional statements (if...then) and loops in PL/SQL
Lecture 18 IF THEN example
Lecture 19 Exceptions: Error trapping and error handling
Lecture 20 Exceptions examples
Section 6: Bringing the code together
Lecture 21 Functions: What they are and how they work in PL/SQL
Lecture 22 Function examples
Lecture 23 Procedures: What they are and why you will use them frequently
Lecture 24 Procedure Examples
Lecture 25 Packages: Putting together like functions and procedures to save time and memory
Lecture 26 Database Triggers: Automating tables to do things when you make changes to data
Section 7: Wrap up
Lecture 27 Conclusion and Wrap up: Where we have been and where you can go from here
Anyone who wanted to understand how to programmatically interact with Oracle Databases,Anyone interested in being a databas,Anyone who has understanding of databases but wants to learn more about programming in Oracle


Homepage

https://www.udemy.com/course/plsql-programming-language/

Understanding And Using Oracle PlSql Programming Language Fast Download
Understanding And Using Oracle PlSql Programming Language Full Download