Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Hi,

I will share with you Step by Step Oracle Database Tutorials for beginners.

 

If you don’t know Oracle database and want to learn, you are at the right adress.

You can learn Oracle database step by step with following steps. I have started  Oracle database Tutorials from beginning, so read each article in order.

 

This Tutorial post is Guide for Junior DBA and includes Article links sequential will be updated with new articles.
I have shared last post of each tutorial series not to be complex, so you can find previous articles of each tutorial series from last post.

 

 

Before Oracle Database Tutorial, Oracle DBA ( Database Administrator ) needs useful scripts to monitor, analyze and check Oracle database for routine database operations and monitoring, If you don’t have Oracle DBA Scripts, you can read following Article.

https://ittutorial.org/oracle-dba-scripts-useful-database-administration-scripts/

 

 

Lesson 1- What is the Data, Information and Database ?

What is the Data & Information and Data Volumes

What is the Database and Relational Database Management System (RDBMS)

What is the Database, Why Database ?

Most Popular Database Management Systems in the World

 

 

Lesson 2- Oracle History, Release and Editions &  Oracle Database Architecture

Read 3 Articles related with Oracle database architecture to learn architecture of Oracle database.

https://ittutorial.org/oracle-database-history-oracle-release-versions/

Oracle Database Editions & Oracle Features

 

https://ittutorial.org/oracle-database-architecture-3/

 

 

Lesson 3- Oracle Database Installation Step by Step

You can find Oracle 11g, Oracle 12c , Oracle 18c and Oracle 19c Software and Database installation with following links.

 

Oracle 19c

Oracle Database 19c on Linux 7.6 Step by Step Installation -2

 

 

Oracle 18c

https://ittutorial.org/oracle-database-18c-step-by-step-installation-on-linux-7-6-2/

 

Oracle 12c

Oracle Database 12c Silent Installation

 

Oracle 11g

Oracle 11g Software and Database Installation-2

 

 

Lesson 4– Create ASM Disk & Oracle Automatic Storage Management ( ASM ) Installation Step by Step

You can learn what is the ASM ( Automatic Storage Management ) and Filesystem with following links.

Oracle Automatic Storage Management 18c Step by Step Installation -2

https://ittutorial.org/oracle-automatic-storage-management-2-2/

 

https://ittutorial.org/how-to-create-and-configure-oracle-asm-disk-on-linux-using-oracleasm-asmlib-utility/

https://ittutorial.org/acfs-what-is-the-oracle-asm-cluster-filesystem-acfs-and-how-to-create-acfs/

How to Change Hostname of a Standalone Oracle Restart ( ASM )

 

 

Lesson 5– Oracle Database Startup and Shutdown Step

Learn how to startup and shutdown Oracle database and what is going on during these operation.

Oracle Database Startup and Shutdown Steps

 

 

Lesson 6– Oracle Database Parameter Files

Learn What are the parameter files of Oracle database and what are the differences.

https://ittutorial.org/oracle-database-12c-parameter-files-spfile-pfile/

https://ittutorial.org/oracle-database-parameters-change/

 

 

Lesson 7– Oracle Database Archivelog Mode

Learn Oracle database Archivelog and noarchivelog mode.

https://ittutorial.org/oracle-database-enable-archivelog-mode/

 

 

Lesson 8– Oracle Data Pump Export Import

Learn how to export and import database, schemas, tables in Oracle database.

https://ittutorial.org/oracle-data-pump-export-import-4/

 

 

Lesson 9– Oracle Database Backup with RMAN ( Recovery Manager )

Learn how to backup database, tablespace, datafiles, controlfiles in Oracle database.

https://ittutorial.org/oracle-rman-recovery-manager-backup-tutorials-8/

 

 

Lesson 10– Oracle Database Restore and Recover with RMAN ( Recovery Manager )

 

Learn how to restore and recover database, tablespace, datafiles, controlfiles in Oracle database.

https://ittutorial.org/oracle-rman-recovery-manager-restore-recover-tutorials-5/

https://ittutorial.org/restore-oracle-database-via-rman-from-tape-backup-how-to/

 

 

Lesson 11– Oracle Dataguard – Disaster Recovery

What is the Disaster recovery and dataguard and How to install Oracle Dataguard ?

https://ittutorial.org/oracle-dataguard-architecture-3/

 

Oracle DataGuard Step by Step Installation with RMAN Duplicate Method -2

Snapshot Standby ( Read Write ) in Oracle Dataguard

Active Dataguard in Oracle

 

Lesson 12– Oracle Flashback Technology

Oracle Flashback Database

Flashback Table in Oracle Database

Restore Any Lost Datafile with Flashback Database Technology -2

Flashback Data Archive in Oracle Database

 

 

Do you want to learn Oracle Database Performance Tuning detailed, then read the following articles.

 

https://ittutorial.org/oracle-database-performance-tuning-tutorial-12-what-is-the-automatic-sql-tuning-and-how-to-automated-sql-tuning/

 3,293 views last month,  44 views today

About Mehmet Salih Deveci

blank
I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

3 comments

  1. blank

    I don’t know whether it’s just me or if perhaps everyone else encountering problems with your website. It appears as though some of the written text on your posts are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This could be a problem with my internet browser because I’ve had this happen previously. Cheers|

Leave a Reply