Oracle (SQL + PL/SQL)
The Oracle (SQL+PL/SQL) course explains about the basic concepts of Relational Database Management Systems (RDBMS) and will help you to become an Oracle Database Administrator(Oracle DBA). This course intends to provide you in-depth understanding of the Oracle Database Server Administration. You will learn about the Oracle DBA Architecture, various concepts, database structures, memory and process architecture, security, schema objects, data backup and recovery.
Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team.
This course is absolutely for beginners.
Course Features
- Students 2500 students
- Max Students10000
- Duration12 week
- Skill levelintermediate
- LanguageEnglish
- Re-take courseN/A
-
Database Concepts
-
Introduction to Oracle
-
Installation of Oracle on Windows / Linux
-
Introduction to the SQL *PLUS Environment
-
Structured Query Language (SQL)
-
CREATE TABLE
-
Creating a table from another table
-
ALTER TABLE
-
DROP TABLE
-
RENAME Tables
-
INSERT Command
-
UPDATE Command
-
DELETE Command
-
MERGE Command
-
SELECT Command
-
Constraints
-
Oracle SQL Built-in Functions
-
Views
-
Sequences
-
Indexes
-
Synonyms
-
SET Operators
-
User Management in SQL
-
Introduction to PL/SQL
-
Control Structures in PL/SQL
-
CURSORS
-
PL/SQL Security - LOCKS
-
Error Handling in PL/SQL
-
PL/SQL Functions & Procedures
-
Database Triggers
0.00 average based on 0 ratings