Step-by-step Database Administration for Beginners
Build strong foundation in database administration with this video course
Configure Oracle database to function as a Multi-tenant container database (CDB) along with pluggable databases (PDB)
Understand the database lock mechanism and how Oracle protects data from accidental updates
Introduction to DBAAS
Take a look inside the Oracle cloud infrastructure and learn how Oracle is providing Database As A Service (DBAAS)
To help you simplify the scheduling of hundreds or even thousands of tasks, you will setup Oracle scheduler
Setup different types of Oracle database backups and perform simple database files recovery using RMAN backups
Explore Oracle inbuilt Automatic SQL tuning advisor to get recommendations on how to tune poor SQL statements
Oracle 12c introduces multi-tenant architecture which allows you to consolidate multiple databases that helps simplify your IT infrastructure. This course is designed to help you master both Oracle non multi-tenant architecture and Oracle multi-tenant architecture.
Oracle Multi-tenant is next-generation cloud ready database!
Oracle Container Database (CDB) acts as one big container that enables consolidation of multiple Pluggable Database (PDB). Each PDB acts as a normal standalone database and requires no code change at the application level. Creating, cloning, moving pluggable databases is done via simple SQL statements and it just takes few seconds.
Oracle Multi-tenant is the foundation for Oracle Autonomous Database!
Oracle's new architecture change offers time saving for Database Administrators too. To upgrade all pluggable databases, you simply upgrade the container database. To upgrade a single PDB, simply unplug / plug the pluggable database into a container database of higher version and upgrade the PDB.
What you'll learn
|Administer Oracle Multi-tenant Architecture & Oracle Non Multi-Tenant Architecture|
|Download, Install and Create Oracle Database on Linux virtual machine|
|Create and administer database user accounts|
|Setup Oracle networking by configuring Listener and TNS entries|
|Administer tablespaces to provide space to database tables|
|Define backup & recovery strategies for your Oracle database using RMAN|
|Basic knowledge of SQL|
|Familiar with Linux OS and VirtualBox|
|Laptop / system with min 8 GB RAM|
|College students who wants to start career as an Oracle DBA|
|Programmers or developers planning to switch to Oracle DBA career|
|Anyone who is planning to shift their career to Oracle DBA|
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.