Oracle PL/SQL course Beginner level by ABCIS LEARNING Pvt Ltd

Overview of Oracle-SQL:

Oracle Corporation is an American multinational computer technology corporation headquartered in Redwood Shores, California. The company specializes primarily in developing and marketing database software and technology, cloud engineered systems, and enterprise software products particularly its own brands of database management systems. In 2018, Oracle was the third-largest software maker by revenue, after Microsoft and Alphabet.
The company also develops and builds tools for database development and systems of middle-tier software, enterprise resource planning (ERP) software, customer relationship management (CRM) software, and supply chain management (SCM) software.
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. The latest generation, Oracle Database 18c, is available on-prem, on-Cloud, or in a hybrid-Cloud environment. 18c may also be deployed on Oracle Engineered Systems (e.g. Exadata) on-prem, on Oracle (public) Cloud or (private) Cloud at Customer. At Openworld 2017 in San Francisco, Executive Chairman of the Board and CTO, Larry Ellison announced the next database generation, Oracle Autonomous Database.

What this Course can do for you:
Used in Developing field
Database management
Software testing

Prerequisite: Basic Computer operating

Oracle-SQL Database Contents.

Oracle SQL

Introduction of Oracle SQL
What is Database
What is DBMS & RDBMS
SQL Data Types
SQL Operators
Create Database
SQL DROP Database
SQL SELECT Database
SQL Table
SQL CREATE TABLE
SQL DROP, DELETE ,TRUNCATE TABLE
SQL ALTER TABLE
INSERT Statement
SQL SELECT Statement
SQL Clause
SQL UPDATE Statement
SQL DELETE Statement
SQL GROUP BY
SQL ORDER BY
HAVING vs Where
Union
Union All
SQL JOIN
SQL Outer Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Cross Join
SQL Keys
Primary Key, Foreign Key, Unique key

Oracle Advance

Oracle Procedure
Oracle Function
Oracle Cursor
Oracle Trigger
PL/SQL Contents

Overview of PL/SQL
Features of PL/SQL
PL/SQL Variables
PL/SQL Constant
PL/SQL Operators
PL/SQL Control Flow Statements
PL/SQL Loops
PL/SQL Procedure
PL/SQL Function
PL/SQL Cursor
PL/SQL Exception
PL/SQL Trigger

Oracle Database Administration

Overview & Introduction
Roles & Responsibilities of Database
Installation of Oracle 11
Database Creation
Creating Oracle Database in using DBCA
Creating User Accounts Database
Managing Tablespaces And Datafiles
Managing REDO LOGFILES
Managing Control Files
Managing The UNDO TABLE SPACE
Export & Import Utilities
Flash Back Feature
BACKUP AND RECOVERY
Recovering from the Loss of a Datafiles.