HamroCSIT Logo
HAMRO CSIT


Shape | Hamro CSIT Shape | Hamro CSIT Shape | Hamro CSIT Shape | Hamro CSIT
Subject

Database Administrator

This course familiarizes students with different concepts of database administration including DBA Roles and responsibilities, tablespace and storage management, DB backup, restoration and recovery, security, multitenant, and performance tuning.

Subject Image | Hamro CSIT
Introduction

DBA Roles and Responsibilities; Database Architecture; ORACLE logical and physical database structure; Memory and Process Structure, SQLPLUS Overview, creating a database;

DBA Roles and Responsibilities; Database Architecture; ORACLE logical and physical database structure; Memory and Process Structure, SQLPLUS Overview, creating a database;

326+ Students

Questions : 0+

Read Note
Tablespace and Storage management

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing;

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing;

208+ Students

Questions : 0+

Read Note
Managing Database Objects

Working with Tables and Constraints; Working with Indexes, Views, Synonyms, and Sequences; Partitioning and Materialized Views, Introduction of PLSQL, Stored Procedure, Funct. . .

Working with Tables and Constraints; Working with Indexes, Views, Synonyms, and Sequences; Partitioning and Materialized Views, Introduction of PLSQL, Stored Procedure, Functions,Trigger, package.

170+ Students

Questions : 0+

Read Note
Database Backup, Restore, and Recovery

Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options; Data Dump; User-Managed Backup . . .

Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options; Data Dump; User-Managed Backup and Recovery; Configuring RMAN; RMAN Backups, Restore and Recovery; High Availability Features; Oracle Data Guard; Flashback operations.

137+ Students

Questions : 0+

Read Note
Database Security and Auditing

Database Security and Auditing; Database Authentication Methods; Database Authorization Methods; Data Encryption Techniques, Virtual Private Database; Managing Users and Secu. . .

Database Security and Auditing; Database Authentication Methods; Database Authorization Methods; Data Encryption Techniques, Virtual Private Database; Managing Users and Security: Profiles, managing users, managing privileges, managing roles,

90+ Students

Questions : 0+

Read Note
Multitenant Database Architecture

Understanding the Multitenant Architecture, Pluggable Architecture; Creating CDB; Administrating Root Container; Creating Pluggable Databases (PDBs) within a CDB; Administrat. . .

Understanding the Multitenant Architecture, Pluggable Architecture; Creating CDB; Administrating Root Container; Creating Pluggable Databases (PDBs) within a CDB; Administrating Pluggable Databases; Backup and Recovery in multitenant Environment; Databases in the Cloud

91+ Students

Questions : 0+

Read Note
Database Tuning

Tuning Application Design; Tuning Memory Usage; Tuning Data Access; Tuning Data Manipulation; Reducing Network Traffic; Using Automatic Workload Repository(AWR); Automatic Da. . .

Tuning Application Design; Tuning Memory Usage; Tuning Data Access; Tuning Data Manipulation; Reducing Network Traffic; Using Automatic Workload Repository(AWR); Automatic Database Diagnostic Monitor(ADDM), Tuning SQL; SQL Tuning Advisor, Performance Tuning in a Multitenant Environment; Distributed Databases and Networking Tool

91+ Students

Questions : 0+

Read Note
7th sem exam offer
HAMROCSIT.COM

Copyright 2024 | HAMROCSIT.COM | All Right Reserved - Nymna Technology