IIRF Online > Office Productivity > Oracle > Oracle Database > Oracle Database Administration for Absolute Beginners
Oracle Database Administration for Absolute Beginners by Udemy
Learn to become an Oracle Database Administrator in a month. It is one of the stable and 'high in demand' IT jobs.
Course Highlights
- Common Goal: To get a job as an Oracle Database Administrator (Oracle DBA)
- For New Graduates: To get a job as an Oracle Database Administrator (Oracle DBA)
- For College Students: To understand the basics of Database and RDBMS concepts
- For those with some IT experience: To get into Oracle Database Administration (Oracle DBA)
- For Information Technology Managers: To understand the basics of RDBMS so that they efficiently manage a DBA team
- For others: To understand the Database and RDBMS concepts
- To understand the fundamentals of Oracle Database (including Oracle 12c and Oracle 11g)
Skills you will learn!
Curriculum
1 Topic
What is a Database?
2 Topics
What is a Table?
Table - Additional Details
4 Topics
Data Definition Language
Data Definition Language - Recap
Data Manipulation Language
Data Control Language
2 Topics
What is an index?
What is a View?
5 Topics
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?
3 Topics
Computers and Databases
What is Data Concurrency?
What is Data Consistency?
4 Topics
Download and Install Oracle 12c in a Windows PC or Laptop
Optional - Install Oracle 12c with Multitenancy in a Windows PC or Laptop
Using Oracle SQL Developer
Troubleshooting Connection Issues
9 Topics
Oracle Instance vs Database
Installation
Files
Starting a Database
Basics of Computing
Client Server Architecture
PGA - Program Global Area
Dedicated Server Mode
Shared Server Mode
7 Topics
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?
3 Topics
What is a Parameter file?
What is a SPFILE?
What is a PFILE?
6 Topics
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
6 Topics
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
10 Topics
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
6 Topics
SQL Structured Query Language
SQL CTAS method
SQL SELECT Statement
SQL INSERT Statement
SQL DELETE Statement
SQL UPDATE Statement
5 Topics
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
11 Topics
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
5 Topics
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?
3 Topics
Oracle Backup and Recovery Part 1
Oracle Backup and Recovery Part 2
Oracle Backup and Recovery Part 3
8 Topics
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
5 Topics
Oracle Networking Concepts
Oracle SID and Service Name
Oracle Listener
Oracle Client Side Networking
Naming Method
6 Topics
Automatic Diagnostic Repository
Alert Log
Trace Files
Dump Files and Core Files
DDL Logs
ADRCI
18 Topics
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
1 Topic
Conclusion
1 Topic
Purpose of ORACLE_BASE
1 Topic
Overview of Oracle Database Architecture
5 Topics
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
3 Topics
What is an Oracle instance?
What is an Oracle database?
Difference between Oracle Instance and Oracle Database
2 Topics
How to install Oracle SQL Developer in Windows 7?
How to use Oracle SQL Developer?
Oracle Database Administration for Absolute Beginners
Related Oracle Database Courses
Thank You!
Your review has been submitted successfully.