Information About free session on Oracle DBA

Dear Reader,

We are going to start a free training/sessions on Oracle DBA. This would be job oriented and will cover all the practical senario based on industrial work. Thus it would be helpful for those people who are seeking the job as Oracle DBA and who want to switch the job.

We are starting this course from scratch, the introduction video has already been uploaded.

Please click on below link and subscribe the channel to get notifications about the sessions and help to start the session soon.

https://youtu.be/6XBRnKwLHv8?si=7tSLdREJN_CeT2UH

Thanks & Regards-

The DataBase Techies HuB Team

(Akm)

Career In Oracle Database

There are two roles in oracle database field.

• Oracle database developer
• Oracle database Administrator (Oracle DBA)

Skills Required :

For Developer:  sound knowledge of Sql, PL/Sql & any programming language preferable.

For DBA : knowledge of Sql, PL/Sql , Database architecture, OS, some basic concepts of networking and the DB monitoring/management tools provided/supported by the oracle.

We are going to discuss about the skills required for Oracle DBA. The topics are given below on which we are about to discuss one by one.

• About Sql and PL/Sql
• Operating systems (OS) concept.
• Oracle Database architecture 
• Oracle installation and DB creation
• User management 
• Tablespace management 
• ASM
• RAC
• Backup & recovery 
• RMN
• Utility used for the activities 
• Performance tuning 
• Neccessary activities (for maintenance & Management purpose)
• Data guard
• Replication tool
• Upgrade & Patching
• DB Migration
• OEM
• Security issue dealing
• Incident management 
• Errors handling as a DBA.
• Database decommission request.
• Etc.

Oracle Database :

Now, we are going to discussed about most popular database that is Oracle database, it is leading in the market in these days.

Introduction of Oracle Database:

Oracle is a relational database management system developed by 'Oracle Corporation'. It is very large multi user based database management system.
Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data over the network.

It is an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers such as Linux , windows ,AIX etc.

History of Oracle:

Oracle started in 1977 - Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories to undertake development work .

1979 - Version 2.0 of Oracle was released and it became first commercial relational database and first SQL database. The company changed its name to Relational Software Inc. (RSI).

1981 - RSI started developing tools for Oracle. 1982 - RSI was renamed to Oracle Corporation.

1983 - Oracle released version 3.0, rewritten in C language and ran on multiple platforms.

1984 Oracle version 4.0 was released. It contained features like concurrency control - multi-version read consistency, etc.

1985 - Oracle version 4.0 was released. It contained features like concurrency control - multi-version read consistency, etc.

2007 - Oracle released Oracle11g. The new version focused on better partitioning, easy migration, etc.

Features of the Oracle:

The mentioned points below are the main features of Oracle RDBMS.

• Data mining
• Concurrency
• Materialized views
• Bitmap indexes
• Table compression
• Parallel Execution
• Analytic SQL
• Partitioning
• Read Consistency
• Locking Mechanisms
• Quiesce Database
• Portability
• Self-managing database
• Resource Manager
• Data Warehousing
• SQL*Plus
• ASM
• Scheduler

Concept Of Database :

Database is an organized collection of structured information or data. So that it can be easily accessed and managed.

Data is a piece of information about something, which can be processed to make a meaningful information.

For example: Data can be personal details of anyone in the form of text, picture, audio or video.

In the beginning. data was being stored in the files like spreadsheet etc. So we can say file system used as a database to store the data in organized way.

Relational database is a collection of data, organized in a predefined relationship where data is stored in one or more tables of columns & rows or relations, making it easy to access the data to find meaningful information and easy to understand how different data structure relate to each other.

Relationship/Relation is a logical interconnection between different tables, established based on interaction among these tables.

DBMS: A software used to facilitate the relational database and following the relational model to store the data, is called the database management system.

Relational Model : represent the database as a collection of relation, a relation is a table of values. Every row in the tables represent the collection of related data value. These row in table denotes a entity or relationship. The table name and column name help to interpret the meaning of value in each row. The data is represent as a set of relations.

In the relational model, data has been stored in the tables. Although, the physical Storage of data will be independent of the way the data are organized in logical way.

Popular RDBMS:

• Oracle
• MySQL
• Microsoft SQL server 
• PostgreSQL
• SQLite
• etc.

Techies message

Dear All,

We are pleased to start this blogs with the bless of the Lord Venkateshwara (Tirupati-Tirumal Balaji) to help on technical challenges in the field of Science & Technology to the working professionals in I.T. industries and those students/freshers who are looking an opportunity to make career in the I.T. Industries. We will help to achieve the specialization in the field of Database, shell scripting, python, data analytics and cloud technology etc.

I believe this would be helpful for you, we will try in our level best as a team.

"Be willing to be a beginner every single morning" 

Thank you so much to all of you and wish you all the best for great future ahead!!

Yours Sincerely                                     

Techies (AKM)