Oracle Database 11g/12c Administration (Oracle DBA)

Course Title Oracle Database 11g/12c Administration (Oracle DBA)
Course Duration 48 hrs workshop within 3 months project (one-to-one project based learning)
Course Topics
  • Course Overview;
  • Core Concepts and Architecture of Oracle Database;
  • Common DBA Tasks & Tools;
  • Installing Database Software and creating database, Configuring Network Environment;
  • Oracle SQL – Basics of SQL statements, Restricting and sorting data, Single row functions, Aggregating Group functions, Displaying data from multiple table, Sub-queries, Manipulating data, Creating and managing tables, etc.; Oracle PL/SQL – PL/SQL blocks, logic statements, If-Else, Loop, Exception Handing, Input/Output Statements, Procedures, Functions, and Triggers; Administering User Account and Security – Create and Manage User Accounts, Grant and Revoke Privileges, Create and Manage Roles, Create and Manage Profiles;
  • Data Dictionary Views – Using Data Dictionary, Types of Views and Querying the Data Dictionary View Information, Using the Dynamic Performance Views;
  • Managing Schema Objects – Tables, Index, Views etc.;
  • Performing 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;
  • Monitoring and tuning Database.
Course Benefits
  • Oracle is the world’s no.1 Database Management System;
  • By learning this course, you can be Oracle Database Administrator (Oracle DBA);
  • This course will also help you to earn Oracle Certifications, i.e. OCA, OCP.
Who Should Attend
  • Those who aim to be Database Administrator;
  • Those who are performing the role of Database Administrator/
  • Technical Administrator/Support Engineer/Technical Consultant/Software Developer in the ICT sector.
Trainer Info Engr. Ilias Ahmed
20 years of Experience in ICT
B.Sc. (EEE), OCP (DBA), MCSE
Fees BDT 15,000
Contact + 8801767-888422, info@digitalenterprisebd.com
Enroll This Course