Compare with 1 courses

Oracle 11g/12c

Oracle 11g/12c

Free

Overview DB Concepts - SQL Concepts - Table Creation Inserting Records Null Values - Fetch Data Ordering Data - DML Commands and DDL Commands - DCL Commands and TCL Commands - Operators - Data Integrity Constraints Key & Domain Constraints - User Friendly Names for Constraints - Referential Integrity Constraints - Set Operators - Cross Join and Equi join - Equi Join and Inner Join - Self Join - Outer Join - Sub Queries Single and Multi Row - Sub Queries Correlated Sub Queries - Oracle Views - Types of Views - Indexes - Sequences and Synonyms - PL SQL Introduction - PL SQL Anonymous Blocks - Stored Procedures - PLSQL Functions - Procedures and Functions - Type Compatibility Keywords % Type and % Row Type - PL SQL Conditional Statements - PL SQL LOOPS - PL SQL Cursors - PL SQL Implicit Cursors - PL SQL Explicit Cursors - PL SQL Exceptions - PL SQL Triggers - PL SQL Packages

Learn more
Has discount
Expiry period Lifetime
Made in English
Last updated at Sun Jun 2022
Level
Beginner
Total lectures 21
Total quizzes 0
Total duration 06:00:42 Hours
Total enrolment 0
Number of reviews 0
Avg rating
Short description Overview DB Concepts - SQL Concepts - Table Creation Inserting Records Null Values - Fetch Data Ordering Data - DML Commands and DDL Commands - DCL Commands and TCL Commands - Operators - Data Integrity Constraints Key & Domain Constraints - User Friendly Names for Constraints - Referential Integrity Constraints - Set Operators - Cross Join and Equi join - Equi Join and Inner Join - Self Join - Outer Join - Sub Queries Single and Multi Row - Sub Queries Correlated Sub Queries - Oracle Views - Types of Views - Indexes - Sequences and Synonyms - PL SQL Introduction - PL SQL Anonymous Blocks - Stored Procedures - PLSQL Functions - Procedures and Functions - Type Compatibility Keywords % Type and % Row Type - PL SQL Conditional Statements - PL SQL LOOPS - PL SQL Cursors - PL SQL Implicit Cursors - PL SQL Explicit Cursors - PL SQL Exceptions - PL SQL Triggers - PL SQL Packages
Outcomes
Requirements