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
Outcome of the Learning
Students completing this course successfully will be able to -
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 Security7
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