Database Management and Administration (DMA)
IntroductionThe 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.
- 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 LearningStudents 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 ScheduleThe 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:
SQL Hands-On Exam
PL/SQL SQL Hands-On Exam
The Oracle Instance
Oracle Data Dictionary Views
Database Storage Structures
Oracle Network Environment
Creating Oracle Database
Database Backups & Recovery
Detailed Course Content
Oracle SQL-1Relational 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-2Basic sub queries, Complex sub-queries, Set operations, Creating and working with Views, Indexes, Sequence, Synonyms
Oracle PL/SQL-1Concepts of PL/SQL blocks, Unnamed and named blocks, Working with blocks, logic statements, If-Else, Loop, Exception Handing, Input/Output Statements
Oracle PL/SQL-2Oracle Procedures, Functions, Triggers, Packages
Database ArchitectureArchitectural Components of the Oracle Database, Memory Structures, Server Processes and Background Processes, Logical and Physical Storage Structures
The Oracle InstanceInstalling 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 SecurityCreate and Manage User Accounts, Grant and Revoke Privileges, Create and Manage Roles, Create and Manage Profiles
Database Storage StructuresConcepts 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 ViewsUsing the Oracle Data Dictionary, Types of Views and Querying the Data Dictionary View Information, Using the Dynamic Performance Views
Oracle Network EnvironmentConcepts of SQL* Net, Concepts of Oracle Listeners, Creating and Configuring Additional Listeners, Creating Oracle Net Service Aliases, Connecting using different methods
Moving DataMoving 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 DatabaseConcepts of Creating Oracle Database, Configuring and Understanding necessary Parameters for Creating a new Database, Creating the Database, Configuring the Listeners for connections
Database Backups & RecoveryManaging 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 TeachersDr. M. Sohel Rahman, Associate Professor, Department of CSE, BUET
Sukarna Barua, Lecturer, Department of CSE, BUET
Phone: 9665650-80 Ext-6438, mobile : 01816908993