Database Management and Administration (DMA)

The admission of 9th Batch of IAC courses is going on.

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 Database Storage Structures
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

Oracle Procedures, Functions, Triggers, Packages

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

Database Storage Structures

Concepts of Database Physical Structures, i.e., Tablespaces, Segments, Extents, Data blocks, Datafiles, Creating and Managing Tablespaces, Managing Undo Tablespaces, Managing Temporary Tablespaces

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.

Course Teachers

Dr. M. Sohel Rahman, Associate Professor, Department of CSE, BUET
Sukarna Barua, Lecturer, Department of CSE, BUET

Further Query