Home Contact IAC IAC Facility Booking Gallery

***Classes of 26th batch courses start on September 24, 2022***



Course Title: Database Management and Administration (DMA)

Introduction


The Database Management and Administration (DMA) using Oracle Database 11g course offered from Information Access Center (IAC) is an essential database course for all database professionals who want to have a strong foundation and expertise in the industry's most advanced database management system, Oracle 11g.

Objectives

  • To develop skills for efficiently managing and administering an Oracle database.
  • To manage the industry's most advanced information systems which will help to gain access to better career opportunities
  • To help professionals earn Oracle Certifications, i.e. OCA, OCP

Outcome of the Learning


Students completing this course successfully will be able to -
  • Gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.
  • Install and maintain an Oracle database.
  • Create an operational database and properly manage the various structures in an effective and efficient manner.
  • Effectively learn performance monitoring, database security, user management, and backup/recovery techniques.
  • Earn skills required for working with basic SQL.
  • Use advanced features of SQL in order to query and manipulate data within the database.
  • Control privileges at the object and system level, and use advanced querying and reporting techniques.

Class Schedule


The course length will be 8 weeks with two classes in each week and 3 hours in each class. The lecture plan of the course is as follows:

Week# Content
1 Oracle SQL-1
2 Review Quiz
Oracle SQL-2
3 SQL Hands-On Exam
Oracle PL/SQL-1
4 Review Quiz
Oracle PL/SQL-2
5 PL/SQL SQL Hands-On Exam
Database Architecture
The Oracle Instance
6 Review Quiz
Oracle Data Dictionary Views
User Security
7 Review Quiz
Oracle Network Environment
Moving Data
8 Review Quiz
Creating Oracle Database
Database Backups & Recovery
9 Final Exam


Detailed Course Content

Oracle SQL-1

Relational Database Systems, Examining SQL, SQL Developer and SQL Plus, Examining the Database and Schema, Select statements, Data Definition and Data Manipulation Languages, Using Where and Order by clauses, Single Row Functions, Group Functions, Joins

Oracle SQL-2

Basic sub queries, Complex sub-queries, Set operations, Creating and working with Views, Indexes, Sequence, Synonyms

Oracle PL/SQL-1

Concepts of PL/SQL blocks, Unnamed and named blocks, Working with blocks, logic statements, If-Else, Loop, Exception Handing, Input/Output Statements

Oracle PL/SQL-2

Introduction to Oracle Procedures, Functions, and Triggers

Database Architecture

Architectural Components of the Oracle Database, Memory Structures, Server Processes and Background Processes, Logical and Physical Storage Structures

The Oracle Instance

Installing the Oracle Software using OUI, Starting and Stopping the Oracle Database, Using the Oracle Enterprise Manager, Access a Database with SQL*Plus, Database Start-up, Database Shutdown, Use the password file, Modify Database Initialization Parameters, Viewing the Alert Logs

User Security

Create and Manage User Accounts, Grant and Revoke Privileges, Create and Manage Roles, Create and Manage Profiles

Oracle Data Dictionary Views

Using the Oracle Data Dictionary, Types of Views and Querying the Data Dictionary View Information, Using the Dynamic Performance Views

Oracle Network Environment

Concepts of SQL* Net, Concepts of Oracle Listeners, Creating and Configuring Additional Listeners, Creating Oracle Net Service Aliases, Connecting using different methods

Moving Data

Moving Data and Creating Directory Objects, Loading Data with the SQL Loader, Creating and Reading External Tables, Using Oracle Data Pump Export and Import

Creating an Oracle Database

Concepts of Creating Oracle Database, Configuring and Understanding necessary Parameters for Creating a new Database, Creating the Database, Configuring the Listeners for connections

Database Backups & Recovery

Managing Backups and the Flash Recovery Area, Concepts of Hot and Cold Backups, Consistent and Inconsistent Backups, Backing up Control files, Datafiles, Using Archived Log Techniques, Using the RMAN Command Line, Recovering from a Lost Control File, Recovering Non Critical and Critical Data Files

Learning and Evaluation Method

  • The class room will be equipped with the multimedia projector
  • The electronic document of class notes will be supplied
  • Two faculty members of CSE, BUET will be teaching during the demonstration in each class
  • Each student will get a PC to do proper practice and the class size will be not more than 35 students
  • There will be on line (during the classes) exams and offline (home work) assignments to solve practical problems
  • There will be quizzes in every week to evaluate the class performances of the last two classes.
  • A final exam will be held at the end of the course.

Further Query

Email: iac@cse.buet.ac.bd
Phone: 9665650-80 Ext-6438, mobile : 01741 686742