Step-by-step database administration for beginners

Learn the RDBMS concepts, database installation, and oracle database administration using different tools and utilities that will help you to administer, monitor any production database.

Build strong foundation in database administration with this tutorial for absolute beginners

• Oracle database installation
• User connectivity and SQL execution
• Oracle database architecture
• Manual database creation
• Tablespace and user administration
• Oracle networking and utitlities

Oracle DBA is one of the highly stable jobs!

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA!

Course Overview

With 70 lectures, 34 lab activities and 20 hours of content, you will learn the Oracle database administration and get an understanding of RDBMS. At the end of each lesson we have quiz to help you retain your knowledge. In order to prepare you for Oracle DBA interview, every lesson ends with most important dba interview questions.

Starting with the database architecture, this course will take you through database installation, basic administration, user administration, tablespace administration and more. By working on lab activities, you will establish a strong database administration skill.

With the basic database administration knowledge, the course will take you through Oracle networking by teaching you how Oracle client and server connectivity is done, installation of Oracle client on windows, configuring tns entries and configuration of database listener.

By completing Lab Activities, you will be able to work along with the author and learn database administration. You can even download lab activities files and practice on your test machine at home.