Course Description

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!

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

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.

Learn to administer multi-terabyte databases with this course!

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.

What you'll learn

	Install and configure Oracle 11g database on Linux
	Manage database space allocation with tablespace administration
	Add, remove, lock and provide roles & privileges to database users
	Configure database listener and tns entries for external connection
	Manage database listener with LSNRCTL untility
	Perform database export and import using Data Pump utility
	Import CSV file into Oracle database using Oracle SQL * Loader

Course Requirements

	Knowledge of Oracle SQL
	Familiar with Virtual Box
	Basic knowledge of Linux commands

Target Audience

	College freshers planning to start Oracle DBA career
	Software engineers or developers planning to switch to Oracle DBA career
	IT managers who would like to learn RDBMS concepts and manage a DBA team