Courses
Level: 1
Age group: All
This course Includes
15 live tutoring sessions
70 topics
Access on mobile
Certificate of completion
Understanding of Core Concepts of Database structure
Skill in Database Architecture and Granting Privileges
Ability to manage data with ILM
Proficiency in Database Security
Mastery in Database and RDBMS Concepts
70 topics
Introduction to Database
What is Oracle Database
Oracle Database 12c Installation
Non-CDB Oracle System Data Mixed with User Data
Multitenant Container Database
Pluggable Database
Architecture of Oracle Database 12c
Architecture of Oracle server
key components – Oracle Instance and Oracle Database
Various file types – data files, control files, redo log files
Benefits of CDB
Management of the Database
Support for Oracle Database Resource Manager
Contents of CDB and Pluggable DB
Shared Oracle Supplied Metadata
Data Dictionary and Creation of PDB’s
Oracle Storage Structures
Basics of Oracle Storage Structures
Logical Storage Units like Tablespaces, Data Blocks, Extents and Segments
Database Schemas, Schema Objects
CDB, Containers, Root Containers
Local User and Common User
Local Privileges and Common Privileges
Steps to Create a container Database
Database Configuration Assistance
Oracle process and memory architecture
Shared Pool, Redo log Buffer, and Buffer Cache
Different Methods of Creating PDB
Steps involved in PDB, using PDB$SEED
Memory & Process Architecture
Using PDB$SEED, without FILE_NAME_CONVERT
Synchronization Process
Plug a non-CDB into CDB Using DBMS_PDB
Clone PDBS
Plug Unplugged CDB in to CDB
Alert & Trace files
Oracle Background Process Errors
Deployed of Trace Files and Alert Logs for Oracle Administration and Support
Trace Files and Alert Logs
Database Startup & User Requests
The Methodology of Starting a Database Instance
Initializing Parameter Files to Prepare for Startup
Serving User Requests
Understanding of the Server Process and User Process
Administrative Activities on PDB
New Views Associated with PDBS
Functions, Opening, Closing, and Altering the Open Mode of PDBS
Setting the Default and Temporary Tables Places for a PDB
Using the Alter System Command from Within a PDB
Instance Parameter Change Impact
Managing data with ILM
Automatic Data Optimization
ILM Components
ILM Challenges
What is Automatic Data Optimization
Heat Map and ADO
DBA Heat Map Segment View
Monitoring Statistics
creating compression polices
creating storage tiering policy,
preparing evolution and execution
Database Security
Oracle Database Security Features
Data Privacy
Regulatory Compliance, “create user” Process, Altering and Dropping Users
Generating Profiles and Limiting Resources
Auditing
Activity Monitoring and Blocking
Assignments
Assignments
Here's why more and more people are joining EnthuZiastic
Customize your lessons to meet your individual goals.
Top rated teachers to guide you through the learning process.
Attend classes anytime, anywhere. Make your own schedule.
Gain experience in organizing live events such as 'Show What You Know,' competitions, and cultural celebrations to develop self-assurance and confidence.
A compassionate support team to listen to your needs.
You will get a certificate for the completion of the course.
Enroll for the course of your liking by selecting 1:1 or group classes. Choose the type of instructor you want to learn with.
Download Enthu app and schedule classes for the day and time that works best for you. You own your learning schedule.
Join classes on Zoom and start learning with lessons customized for you. Make most of our student success program.
Basic SQL knowledge
Basic knowledge of UNIX/LINUX commands
Enthuziasm to learn
A PC or Laptop with Internet Connection
Oracle Database Software installed in the system
Expand all
Who can join this course?
All the enthuziast who are willing to start their career as Oracle Database Administrator or want to learn oracle database administration can join this course.
Why join this course?
If you have no prior knowledge of the database or you are familiar with the oracle database and just want to enhance your knowledge, this course is the right place. You will be guided step-by-step with hands-on examples.
What can I expect after this course?
By the end of this course, you will have an understanding of database management and security. You will also have some hands-on experience.
What next after this course?
Join our online course Oracle Database Administration Level 2, and take a deep dive into all the skills required for professional Oracle Database Administrator.
Are these classes Live?
Yes, all our classes are conducted online. These classes are no different than taking up face-to-face, physical chess training. Taking up online lessons help you save significant time, money, and energy.
How will I be able to join classes?
You will need to download Enthu app. It will have all your classes and all your schedule in one place. You can join classes directly from the app (both mobile and desktop app are available). You will get regular reminder for classes on the app so that you never forget a class. App can also be used to share feedback for each session.
How many students will there be in a class?
We have 1:1 as well as n:1 classes. You can make your choice when enrolling in the course. For group classes, we take only small batches not exceeding 5 students at a time.
What if I miss a class?
In the case of 1:1 class, you can easily reschedule your class with the help of support team or through the app. In the case of group classes, class recording will be available to you in the Enthu app. You can watch them and get any doubts you have answered in the next class.
Do you follow a curriculum?
Yes, our curriculum has been designed by our teachers with more than a decade of experience in the respective subject. It is a tried and tested curriculum to help you uncover your best.
What are the privacy steps followed by you for these classes?
We take utmost care to ensure privacy during our online live sessions. Only verified students can join the sessions. This makes our sessions completely safe and secure. We do not share this personal information with any third parties.
Whom to reach out if I need any help during session or otherwise?
You can reach out to support team on Enthu App or email at support@enthu.com
What is your cancellation policy?
You can cancel your enrollment by emailing at support@enthu.com within 5 working days of your registration.
What is your refund policy?
We offer 30 Day Money Back Guarantee. You can ask for refund by emailing at support@enthu.com.
Fill this form and we will respond back, on priority.
16192 Coastal Hwy
Lewes
DE 19958
+18044084086
912 Techno IT Park, Link Road, Borivali (W)
Mumbai, MahaRashtra
400092 (India)
+91-76708-58585