Certified Advanced Oracle Database Admin

Certified Advanced Oracle Database Admin

Oracle Database Programming & Architecture

Course contents


video Introduction to Database Management Systems
video Data Vs Information
View this lesson as a free preview

Understanding Data, various sources,...More
video Data Abstraction & Database System
video History of DBMS
for a beginner we should know about the history of Database Management Syst...More
video Normalization
Concept of Normalization
video Introduction to SQL
video Retrieving Data using SQL
video Restricting and Sorting Data
video Using Single Row Functions
video Group Functions
video Displaying Data from Multiple Tables - Joins
video Set Operators
video Data Manipulation Language - DML
video Data Definition Language - DDL
video Database Transaction Control
video Sub-Queries
video Introduction_to_PLSQL_v1
video Declaring PLSQL Variables
video Writing Anonymous PLSQL blocks
video Writing Executable Statements
video Using SQL Statements in PLSQL blocks_v2
video Writing Control Structures
video Working with composite data types
video Using_Explicit_Cursors
video Handling_Exceptions
video Stored Procedures
video Stored-Functions
video Triggers
video Oracle Architecture
Oracle Architecture
video Shared Pool
Shared Pool
video DB Buffer Cache
DB Buffer Cache
video Redo Log Buffer
Redo Log Buffer
video Pools & Fixed SGA
Pools & Fixed SGA
video PGA
PGA
video Process Architecture
Process Architecture
video Memory Structures
Memory Structures
video Multitenant Architecture
Multitenant Architecture
video ASM
ASM
video Administering-security
video Alert log file
video Create profile
video Dynamic performance views
video Free space manegment
video Instance start up files
video Managing Space - Block Space
video Oracle managed files
video Overview of Datablock
video Roles-and-benefits
video Shutdown_mode
video Table compress
video Table space creation
© 2020 Skill Sigma LMS. All Rights Reserved.