MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Oracle Database Administration for Absolute Beginners

Course Summary

Learn to become an Oracle Database Administrator in a month. It is one of the stable and 'high in demand' IT jobs.


  • +

    Course Syllabus

    • Introduction to Database
      • What is a Database?
    • Introduction to Database Objects
      • What is a Table?
      • Table - Additional Details
    • Database Languages
      • Data Definition Language
      • Data Definition Language - Recap
      • Data Manipulation Language
      • Data Control Language
    • Database Objects - Index and View
      • What is an Index?
      • What is a View?
    • Relational DBMS (RDBMS) - Introduction
      • What is a Foreign Key?
      • What is a RDBMS?
      • What is a Primary Key?
      • What is an Unique Key?
      • What is the Difference between Primary Key and Unique Key?
    • Computers and Databases
      • Computers and Databases
      • What is Data Concurrency?
      • What is Data Consistency?
    • Oracle Database Architecture
      • Overview of Oracle Database Architecture
    • How to install oracle 11g on windows 7 64 bit
      • Installation Part 1 of 5
      • Installation Part 2 of 5
      • Installation Part 3 of 5
      • Installation Part 4 of 5
      • Installation Part 5 of 5
    • Oracle Storage Structures
      • Oracle Physical Storage Structures
      • Oracle Logical Data Structures
      • Where can the Oracle Physical Structure files be stored?
      • What is a Raw Device?
      • What is a File System?
      • What is an Oracle ASM?
      • What is a Cluster File System?
    • Oracle Parameter Files
      • What is a Parameter file?
      • What is a SPFILE?
      • What is a PFILE?
    • Oracle Instance vs Database
      • What is an Oracle instance?
      • What is an Oracle database?
      • Difference between Oracle Instance and Oracle Database
    • Connecting to an Oracle Database
      • How to connect to a Oracle Database?
      • How does an Oracle database start?
      • Demo of various starting methods of an Oracle database
      • How to log in to an Oracle Database?
      • Oracle Database Dictionary
      • How to log in to an Oracle Database? - Answer Video
    • Basics of Oracle Database Internals and Security
      • Basics of Oracle Internal Structure
      • What is a Database Control?
      • How to create an user in Oracle Database?
      • Default Tablespace and Temporary Tablespace for a new Oracle Database user
      • Oracle Roles and Privileges
      • Oracle System Privileges
    • Oracle SQL Developer
      • How to install Oracle SQL Developer in Windows 7?
      • How to use Oracle SQL Developer?
    • Basic Oracle Database Operations
      • How to verify the Oracle Database Name?
      • How to find the version of the Oracle Database?
      • How to view the user accounts within an Oracle Database?
      • How to use DBA view in SQL Developer?
      • How to find the tablespaces in an Oracle Database?
      • Oracle Tablespaces
      • What is an Oracle User?
      • What is an Oracle Schema?
      • Difference between an Oracle user and schema
      • General user architecture of a database
    • Structured Query Language (SQL)
      • SQL Structured Query Language
      • SQL CTAS method
      • SQL SELECT Statement
      • SQL INSERT Statement
      • SQL DELETE Statement
      • SQL UPDATE Statement
    • Oracle Memory and Background Processes
      • Oracle Background Processes
      • Dedicated Server vs Shared Server
      • SGA System Global Area of an Oracle Database
      • PGA Program Global Area of an Oracle Database
      • UGA User Global Area of an Oracle Database
    • SGA and Database Buffer
      • SGA Database Buffer Part 1
      • SGA Database Buffer Part 2
      • SGA Database Buffer Part 3
      • SGA Database Buffer Part 4
      • SGA Database Buffer Part 5
      • SGA Database Buffer Part 6
      • SGA Database Buffer Part 7
      • SGA Database Buffer Part 8
      • SGA Database Buffer Part 9
      • SGA Database Buffer Part 10
      • SGA Database Buffer Part 11
    • Programmable Objects
      • What is an Oracle Package?
      • What is an Oracle Procedure?
      • What is an Oracle Function?
      • What is an Oracle Trigger?
      • What is an Oracle Type?
    • Oracle Backup and Recovery Concepts
      • Oracle Backup and Recovery Part 1
      • Oracle Backup and Recovery Part 2
      • Oracle Backup and Recovery Part 3
    • Oracle Database 12c
      • How to install Oracle 12c Database in Windows 7?
      • Connecting to the Oracle 12c Database
      • Introduction to Oracle Enterprise Manager Express
      • Connecting to Oracle Enterprise Manager Express
      • Exploring Oracle Enterprise Manager Express
      • INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 PC - DOWNLOADING THE SOFTWARE
      • INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 PC - INSTALLATION
      • CONNECTING TO THE ORACLE 12C DATABASE IN WINDOWS 8.1 PC
    • Oracle Networking
      • Oracle Networking Concepts
      • Oracle SID and Service Name
      • Oracle Listener
      • Oracle Client Side Networking
      • Naming Method
    • Diagnostic Data
      • Automatic Diagnostic Repository
      • Alert Log
      • Trace Files
      • Dump Files and Core Files
      • DDL Logs
      • ADRCI
    • LAB
      • LAB 1 - Scenario
      • LAB 2 - Connect String
      • Lab 3 - CREATE TABLESPACE
      • LAB 4 - Creating Schema User
      • LAB 5 - Logging in as the Schema user
      • LAB 6 - CREATE TABLE
      • LAB 7 - CREATE INDEX
      • LAB 8 - ALTER TABLE
      • LAB 9 - INSERT
      • LAB 10 - DELETE
      • LAB 11 - UPDATE
      • LAB 12 - Creating a ROLE
      • LAB 13 - Creating an Application user
      • LAB 14 - Testing the Application user
      • LAB 15 - Revoking the permissions
      • LAB 16 - Dropping the application user
      • LAB 17 - Dropping the Schema user
      • LAB 18 - Dropping the Tablespace
    • Conclusion
      • Conclusion


Course Fee:
USD 125

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top