Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle SQL PLSQL Training Online Tutorial Course
Rating: 3.9 out of 5(29 ratings)
132 students

Oracle SQL PLSQL Training Online Tutorial Course

Oracle SQL Training, Oracle PLSQL Online Training Course, SQL and PL SQL Tutorial
Created byKoduru Sridevi
Last updated 8/2020
English

What you'll learn

  • Will be creating database
  • Will be manipulating database
  • Will be able to write programs

Course content

3 sections25 lectures9h 20m total length
  • Introduction to RDBMS23:18
    • Introduction to RDBMS
    • Introduction to SQL
  • Oracle data types23:11
    • Oracle data types
    • Classification of sql
  • DDL and DML Commands22:46
    • DDL and DML Commands
  • DDL and DML Commands Continued22:36
    • DDL and DML Commands Continued
  • Integrity Constraints23:43
    • Integrity Constraints
  • SQL Functions23:56
    • SQL Functions
    • Character Functions
    • Number Functions
  • SQL Functions Continued19:45
    • SQL Functions Continued
    • Date Functions 
    • Group Functions
  • Joins27:33
    • Joins
  • Sub Queries and Clauses26:41
    • Sub Queries and Clauses
  • Database Objects23:00
    • Database Objects
  • Database Objects Continued20:14
    • Database Objects Continued
  • DCL and TCL Commands22:44
    • DCL and TCL Commands

Requirements

  • No Prerequisite is needed

Description

Oracle SQL PLSQL Training Course (A Prerequisite Course for Oracle Apps Technical Course Learners)


Topics covered are Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, DDL and DML Commands Continued, Integrity Constraints, SQL Functions, Character Functions, Number Functions, SQL Functions Continued, Date Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages , Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages

Who this course is for:

  • Any Graduate