Oracle DBA - Beginners To Master
About Course
Are you new to ORACLE DBA or need a refresher?
Oracle is a relational database. In a relational database, all data is stored in two-dimensional tables that are composed of rows and columns. The Oracle Database enables you to store data, update it, and efficiently retrieve it.Oracle provides software to create and manage the Oracle database.
The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system
What Will You Learn ?
- Oracle Database Administration
- Oracle Database Architecture
- How to install Oracle Database Software on the server without GUI
- How to access Oracle Database via sqlplus, sqlcl, and SQL Developer
- Oracle Net Services
- Administering User Access, Privileges & Roles, Resource Limitation
- Transparent Data Encryption (TDE)
- Creating and Managing Tablespaces
- Managing UNDO Data
- Practicing different Backup and Recovery scenarios via RMAN
- Moving Data: Data Pump, SQL Loader
- Data Guard Configuration
- Applying the latest Database Patch
- Database Upgrade from 19c to 21c
Course Content
- Basic Linux commands
- File command, File transfer
- Disk usage
- File permission & compression
- Process related
- Crontab, Shell script
- SSH Login
- Linux keyboard shortcut
- System Information
- Directory Navigation
- SQL Overview, SQL commands, SQL RDBMS Concepts
- Retrieving Data Using SELECT Statement
- Clauses
- Restricting And Sorting Data
- Single Row Functions
- Multiple row Functions
- General Functions
- Date functions
- Conversion Functions
- Join
- Subquery
- Set Operator
- Constraints
- Database Objects
- ORACLE DATABASE CREATION
- ORACLE ARCHITECTURE
- ORACLE INSTANCE
- MAINTAINING THE CONTROL FILE
- MANAGING DATABASE STORAGE STRUCTURE
- MANAGING THE REDOLOGFILES
- TABLESPACE
- TEMPORARY TABLESPACE
- MANAGING UNDO TABLESPACE
- ADMINISTERING USER SECURITY
- PROFILE creation
- LISTENER
- DATA PUMP-expdp
- DATA PUMP-impdp
- Introduction to Rman, Backup commands
- Types of Rman backup
- Recovery
- Show all parameters
- Cloning
- Dataguard
- ASM (Automatic Storage Management)
- Performance Tuning
Enquire
Key Points
- Certification
- Skill Development
- Practical Experience
- Industry-Relevant Knowledge
- Networking Opportunities
- Portfolio Building
- Lifelong Learning
- Job Placement Assistance
- Personality developmet with efficient soft skill
Requiremnets
- Basic Linux Knowledge
- Understand what is a process in linux
- Basic SQL Knowledge
Audience
- This course is meant for TOTAL beginners in ORACLE DBA
- No programming experience is needed at all.
Course Instructor
