‘‘When you have more data you win’’

    Topic
    Learnings
  
    Introduction
    Why database, ACID and BASE properties, E.F. Codd’s Rule, Cardinality, CAP Theorem, Difference between RDBMS and NoSQL database
  
    Database Design
    Normalization Rules, ER diagrams
  
    Architecture
    Introduction to Oracle, Oracle Architecture
  
    Data Types
    Oracle Data types
  
    SQL
    Creation and Manipulation of objects using DML, DDL, DCL, TQL & TCL statements Functions (Single Row, Group, Conversion, Analytic) in Oracle, Oracle Constraints, Oracle Views, Sequences, Synonyms, Indexes, Views
  
    SQL Objects
    Creation of Types, Nested Table, Insertion & Retrieving data from Nested Table
  
    PL/SQL
    Creation of Procedures, Functions, Triggers and Packages in PL/SQL
  
    DBA Overview
    Architecture Overview, Multi-Tenant Architecture, Instance Parameters, Listener Control Overview, Starting up and shutting down database
  
    DB Creation
    Creation of Database using DBCA, Creating a CDB, Creating a PDB from Seed, Other Techniques to create a PDB, Opening and Closing a PDB, Managing PDB
  
    Network
    Configuring Oracle Net Service, Administering Listener, Shared Server Architecture
  
    DBA Account Management
    User Creation, Granting of Roles, Privileges, User Profile, Auditing, Resource Limits
  
    DBA - Data Management
    Storage Structure, Tablespace, UNDO tablespace management, Improving Space Usage
  
    Backup & Recovery
    RMAN, Flashback
  
    Data Transportation
    External Tables, SQL Loader, Data Pump
  
    Maintenance
    Automated Maintenance Tasks,
  
    Performance Tuning
    Performance Tuning and SQL Optimization, Statspack, using ADDM for Performance Monitoring, Automatic SQL Tuning, SQL Advisor, Real Time DB monitoring, TKPROF
  
    Upgrade
    Software upgrade Methods
Database Administration
Course Enquiry