Register Now For Free

DBA Courses

Introduction Oracle DBA

  • Explore the Oracle 10g database architecture
  • Core DBA tasks and tools
  • Plan an Oracle installation
  • Use optimal flexible architecture
  • Install software with the Oracle Universal Installer (OUI)
  • Creating an Oracle Database
  • Managing the Oracle Instance

Managing Database Storage Structures

  • Table data storage (in blocks)
  • Purpose of tablespaces and data files
  • Understand and utilize Oracle Managed Files (OMF)
  • Create and manage tablespaces
  • Obtain tablespace information

Administering User Security

  • Create and manage database user accounts
  • Authenticate users
  • Assign default storage areas (tablespaces)
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Schema Objects

  • Schema objects and data types
  • Create and modify tables
  • Constraints
  • View the columns and contents of a table
  • Create indexes, views and sequences
  • Manage data through SQL
  • Monitor and resolve locking conflicts

Managing Undo Data

  • DML and undo data generation
  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor

Implementing Oracle Database Security

  • DBA responsibilities for security
  • Apply the principal of least privilege
  • Enable standard database auditing
  • Specify audit options
  • Review audit information

Duration

6 week| 3 months| 6 Months| 1 year stipend based

Pre-requisite

Basic computer knowledge| R & D

Career Options

After completing your full course stipend or Job on behalf of performance during Training period


Project Work

Two project will be covered in the class and then individual projects will be assigned to students. As the project is desktop application and students will be asked to give professional Look, Feel and Functionality to applications.

6 months industrial training in Chandigarh | Mohali | Internship

Our India Address

HEAD OFFICE - MOHALI

C-134, PUNCOM TECHNOLOGY PARK PHASE-8 INDUSTRIAL AREA MOHALI
Contact: 95698-06826,7355303131

BRANCH OFFICE - CHD

SCO 85-86,4th floor Sector 34-A,Chandigarh 160022 INDIA
Contact: 95698-06826,7355303131

BRANCH OFFICE - CHD

Plot J7,FCS Building 1st Floor, IT Park Chandigarh

BRANCH OFFICE - CANADA

EME Technologies 1551 Riverside Drive, Apt. 406, Ottawa, ON K1G 4B5 (Canada) +1-(613)-869-1089

Enquiry Form