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|
|Knowledge of Oracle SQL|
|Familiar with Virtual Box|
|Basic knowledge of Linux commands|
|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|
StartUser Connectivity in Oracle (23:16)
StartPhases of SQL Execution (5:18)
StartSelect Statement Processing (15:04)
StartDML / DDL Statement Processing (22:05)
StartOracle Architecture Components (12:14)
StartOracle Background Processes (12:09)
StartOracle Files (14:49)
StartQuiz - Test your knowledge!
StartDownloading Oracle Database Software (0:50)
StartDatabase Installation Prerequisites (1:03)
StartLab Activity – Pre Installation Tasks (6:17)
StartLab Activity – Installing Oracle 11g Software (3:35)
StartLab Activity – Post Installation Tasks (1:13)
StartQuiz - Test your knowledge!
Meet Your Instructor!
Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.
I am an Oracle Certified Expert, Oracle RAC Certified Implementation Specialist and Oracle Certified Professional along with few more credible certifications under my hat.
Frequently Asked Questions
Instructor is very good, I respect the way he teaches and really like the interest he comes with, i'm impressed. Concepts are clear, undertanding is obtained, Nice to be part of DBA Genesis. Good job!
Oracle is the market leader in relational database with a 48.35% market share!
"I always enjoyed the training classes at DBA Genesis!. The exciting part of the lectures were always the Q&A session at the end of the lecture where I got to hear some practical/real-world tips and directions from the instructor." Samuel
An Oracle DBA can earn $94,000 in the United States
"Brilliant content and delivery. Support team turnaround time is remarkable. Many Thanks. Looking forward for further courses in future." Joseph