Library

Course: Complete Oracle SQL Course for Beginner to Expert

Complete Oracle SQL Course for Beginner to Expert

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

In this Session will cover below topics on Oracle SQL

****************************************************************************

01 - Oracle Introduction

***********************************

What is the Data Base and Data Base Management System?

How we Maintain the Database in Our Real Life

What is the Difference Between DBMS and RDBMS

How to use a Data Base System in our Real Life


02 - DDL Commands

******************************

What are the Data Types in Oracle SQL

What are the SQL Statements in Oracle SQL

How to Create a First Table in Oracle Data Base

How to Modify the Table Structure in Oracle Data Base

How to Drop and Rename the Table in Oracle Data Base

How to work with Insert (DML Statements) in Oracle SQL

How to work with Update (DML Statement) in Oracle SQL

How to work with Delete (DML Statement) in Oracle SQL


03 - TCL Commands

******************************

How to work with Commit (TCL Commands) in Oracle SQL

How to work with Rollback (TCL Commands) in Oracle SQL

How to work with Save Point (TCL Commands) in Oracle SQL

How to work with Truncate (TCL Commands) in Oracle SQL


04 - Clauses 

******************

How to work with Select and Where Clause in Oracle SQL

How to work with Group By Clause in Oracle SQL

How to work with Having Clause in Oracle SQL

How to work with Order By Clause in Oracle SQL

How to work with Distinct Clause in Oracle SQL


05 - Operators Part

****************************

How to work with Arithmetic Operators in Oracle SQL

How to work with Logical Operators in Oracle SQL

How to work with Relational Operators in Oracle SQL

How to work with Special Operators in Oracle SQL

How to work with Set Operators in Oracle SQL


07 - Functions Part

****************************

How to work with Number Functions in Oracle SQL

How to work with String Functions in Oracle SQL

How to work with Translate Function in Oracle SQL

How to work with Replace Function in Oracle SQL

How to work with Decode Function in Oracle SQL

How to work with Case Function in Oracle SQL

How to work with Sub string Function in Oracle SQL

How to work with In string Function in Oracle SQL

How to work with Date Functions in Oracle SQL

How to work with Conversion Functions in Oracle SQL

How to work with General Functions in Oracle SQL

How to work with Aggregate Functions in Oracle SQL


10 - Constraints

***********************

How to work with Primary Key in Oracle SQL

How to work with Composite Primary Key in Oracle SQL

How to work with Unique Key in Oracle SQL

How to work with Not Null in Oracle SQL

How to work with Check in Oracle SQL

How to work with Default in Oracle SQL

How to work with Foreign Key in Oracle SQL


11 - Joins

*************

How to work with Simple Join in Oracle SQL

How to work with Outer Join in Oracle SQL

How to work with Self Join in Oracle SQL


 12 - Synonyms

*********************

What is Synonyms in Oracle SQL

How to work with Private Synonym in Oracle SQL

How to work with Public Synonym in Oracle SQL


13 - Views Part

*********************

How to work with Simple View in Oracle SQL

How to work with Complex View in Oracle SQL

How to work with Force View in Oracle SQL

How to work with Vertical View in Oracle SQL

How to work with Horizontal View in Oracle SQL

How to work with Functional View in Oracle SQL

How to work with Partition View in Oracle SQL

How to work with Materialized View in Oracle SQL

How to work with Inline View in Oracle SQL


15 - Indexes, Clusters & Sequences

**************************************************

How to work with Simple Index in Oracle SQL

How to work with Complex Index in Oracle SQL

How to work with Unique Index in Oracle SQL

How to work with Functional Index in Oracle SQL

How to work with Bitmap Index in Oracle SQL

How to work with Clusters in Oracle SQL

How to work with Sequences in Oracle SQL


16 - Sub Queries

************************

How to work with Sub Queries in Oracle SQL

How to work with Sub Queries with Examples


Basic knowledge
  • Basic Knowledge on Computers
What you will learn
  • Student should learn Complete Oracle SQL
Curriculum
Number of Lectures: 20
Total Duration: 03:25:37
Oracle Introduction
  • What is the Data Base and Data Base Management System?  

    What is the Data Base and Data Base Management System?

  • How we Maintain the Database in Our Real Life  

    How we Maintain the Database in Our Real Life

  • What is the Difference Between DBMS and RDBMS  

    What is the Difference Between DBMS and RDBMS

  • How to use a Data Base System in our Real Life  

    How to use a Data Base System in our Real Life

DDL Commands
  • What are the Data Types in Oracle SQL  

    What are the Data Types in Oracle SQL

  • What are the SQL Statements in Oracle SQL  

    What are the SQL Statements in Oracle SQL

  • How to Create a First Table in Oracle Data Base  

    How to Create a First Table in Oracle Data Base

  • How to Modify the Table Structure in Oracle Data Base  

    How to Modify the Table Structure in Oracle Data Base

  • How to Drop and Rename the Table in Oracle Data Base  

    How to Drop and Rename the Table in Oracle Data Base

  • How to work with Insert (DML Statements) in Oracle SQL  

    How to work with Insert (DML Statements) in Oracle SQL

  • How to work with Update (DML Statement) in Oracle SQL  

    How to work with Update (DML Statement) in Oracle SQL

  • How to work with Delete (DML Statement) in Oracle SQL  

    How to work with Delete (DML Statement) in Oracle SQL

TCL Commands
  • How to work with Commit (TCL Commands) in Oracle SQL  

    How to work with Commit (TCL Commands) in Oracle SQL

  • How to work with Rollback (TCL Commands) in Oracle SQL  

    How to work with Rollback (TCL Commands) in Oracle SQL

  • How to work with SavePoint (TCL Commands) in Oracle SQL  

    How to work with SavePoint (TCL Commands) in Oracle SQL

  • How to work with Truncate (TCL Commands) in Oracle SQL  

    How to work with Truncate (TCL Commands) in Oracle SQL


Clauses
  • How to work with Select and Where Clause in Oracle SQL  

    How to work with Select and Where Clause in Oracle SQL

  • How to work with Group By Clause in Oracle SQL  

    How to work with Group By Clause in Oracle SQL

  • How to work with Having Clause in Oracle SQL  

    How to work with Having Clause in Oracle SQL

Operators
  • How to work with Arithmetic Operators in Oracle SQL  

    How to work with Arithmetic Operators in Oracle SQL

Reviews (0)