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 moreHas discount |
|
||
---|---|---|---|
Expiry period | Lifetime | ||
Made in | English | ||
Last updated at | Sun Jun 2022 | ||
Level |
|
||
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 |
|