Introduction to Oracle Administration
  • 1-Types of users in Oracle
  • 2-Types of Oracle Clients
  • 3-How to connect to SQL*PLUS
  • 4-How to Create user using SQL*PLUS
Oracle Administration User privileges
  • 5-what are User Privileges
  • 6-What is a Schema
  • 7-Create Table using SQL*PLUS
  • 8-How to grant Object privileges to specific user
  • 9-REVOKE Object Privilege From a user
  • 10-Revoke system Privilege from a specific user
  • 11-How to Lock and Expire account
  • 12-Know Oracle Users and User Tables
  • 13(1)-How can I know my System or Object Privileges
  • 13(2)-How to grant or revoke all System or Object Privileges
  • 15-How can a regular user to grant Object Privileges
  • 16-How can a regular user to grant System Privileges
  • 17-How Can HR and SYS USERS select any Table Data
  • 18-How To Drop USER
Oracle Administration with Oracle SQL Developer
  • 19-How to Create user using oracle SQL Developer
  • 20-How to create table using Oracle SQL Developer
  • 21-How can I know the number of connected and make user disconnected
  • 22-How to make disconnected user Connected
Oracle Administration User Roles
  • 23-What are ROLES and Granting
  • 24-Can any user create role
  • 25 - Can User grant update on specific column
Oracle SQL Views
  • 1- Can HR grants select on specific columns to Ramy
  • 2-What and Why Views
  • 3-Types Of Views and View Creation
  • 4-How To Create a simple view
  • 5-Replace existing View
  • 6-Can we do DML operation on views
  • 7-With Check option constraint in views
  • 8-With Read Only constraint in views
  • 9-What is the use of Force Keyword in views
  • 10-Complex Views Example
  • 11 - Drop Simple or Complex views
  • 12-Complex Query Examle 1 with Views
  • 13-Complex Query Example 2 with views
Oracle SQL functions
  • 1-Types of functions
  • 2-Single row functions Character Case Conversion
  • 3-Single row Character manipulation functions
  • 4-Single Row Number Functions and dual table
  • 5-Single Row Date Functions
  • 6-Single Row Conversion Functions
  • 7-Single Row General Functions
Introduction to Oracle PL/SQL
  • 1 - What is PL/SQL
  • 2 - How can I write and execute PL/SQL
  • 3 - print Hello World using PL/SQL through SQL*PLUS
  • 4 - Print Hello World using Oracle SQL Developer
Oracle PL/SQL Variables
  • 5 - How to declare variables
  • 6- adding two numbers in PL/SQL
  • 7 - Using Concatinating operator
  • 8 - Nested Blocks then local and global variables
  • 9 - using Into with variables in PL/SQL
Oracle PL/SQL Functions
  • 10 - How to create user defined function
  • 11 - How to execute functions
  • 12 - User defined functions examples
  • 13 - What is anchored data type and How we use it
  • 14 - How to a function that return a row
  • 15 - Can we do SQL DML Operations in functions
  • 16 - Types of Parameter
  • 17 - how to grant or revoke functions
  • 18 - How to drop a function
Oracle PL/SQL Procedure
  • 19-What is and create and Execute a simple procedure
  • 20-How to make a user create procedure or function
  • 21- SQL DML Procedure Example
  • 22-Types of procedures parameters with example
  • 23-Differences between procedures and functions
Oracle PL/SQL IF/ELSE
  • 24-How to use IF/ElSE conditions in PL/SQL
  • 25-How to apply IF/ELSE condition on procedure or function
Oracle PL/SQL Exception
  • 26-What is exception
  • 27-Predefined Oracle Server Exceptions
  • 28-Non Predefined exception
  • 29-User defined exceptions