Oracle 11g/12c

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

Beginner 0(0 Ratings) 0 Students enrolled English
Created by skill expert
Last updated Mon, 13-Jun-2022
+ View more
Course overview
Curriculum for this course
21 Lessons 06:00:42 Hours
Lecture
21 Lessons 06:00:42 Hours
  • SQL FAQs
    Preview 00:09:21
  • PL SQL FAQs
    00:26:36
  • DB Concepts
    00:19:35
  • SQL Concepts Part 1
    00:21:44
  • SQL Concepts Part 2
    00:23:06
  • Table Creation Inserting Records Null Values
    00:13:30
  • Fetch Data Ordering Data
    00:22:51
  • DML Commands and DDL Commands
    00:19:55
  • DCL Commands and TCL Commands
    00:15:53
  • Operators Part 1
    00:11:10
  • Operators Part 2
    00:12:13
  • Data Integrity Constraints Key & Domain Constraints 1
    00:12:38
  • Data Integrity Constraints Key & Domain Constraints 2
    00:14:34
  • Referential Integrity Constraints
    00:13:58
  • Self Join
    00:11:31
  • Oracle Views
    00:16:59
  • Sequences and Synonyms
    00:21:10
  • PL SQL Introduction
    00:12:50
  • Stored Procedures
    00:20:09
  • Type Compatibility Keywords % Type and % RowType
    00:16:19
  • PL SQL Conditional Statements
    00:24:40
+ View more
Other related courses
01:51:15 Hours
Updated Tue, 17-May-2022
0 0 Free
18:07:04 Hours
Updated Tue, 17-May-2022
0 1 Free
01:43:29 Hours
0 1 Free
15:06:52 Hours
Updated Wed, 08-Jun-2022
0 0 Free
14:55:05 Hours
Updated Wed, 08-Jun-2022
0 0 Free
About instructor

skill expert

0 Reviews | 17 Students | 467 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Free
Includes: