Oracle Database on AWS: EC2 & RDS from Scratch
I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS.
We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this.
The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows:
We will start with the very basics like : What is Cloud Computing , What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share.
A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console.
We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing : Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,
A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows.
EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images.
We will do a demo to create an EC2 Instance in Custom VPC , Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage.
RDS: What is RDS / RDS for Oracle , Backup/ Recovery , Monitoring , Oracle Vs RDS commands
A demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle.
A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity.
We will also discuss what is REST API and using a tool Postman call an RDS REST API.
Here is the list of Top Cloud Computing service providers who can give your business a new shift. Cloud technology is the new phase of business augmentation where the tailored business needs are taken forward to resolve various resource security...
Here is the list of Top Cloud Computing service providers who can give your business a new shift. Cloud technology is the new phase of business augmentation where the tailored business needs are taken forward to resolve various resource security, resource utilization, and resource management needs. The Cloud computing service offering firms here are assorted with discreet research on their potentiality on handling projects professionally and their positively reviewed services.
List of Best Cloud Computing Service Providing Companies is here.
Learn about storage and compute auto-scaling, just some of the MongoDB Atlas features that help you automate capacity management. Auto-Scaling with MongoDB Atlas, the Fully Managed Cloud Database
Learn about storage and compute auto-scaling, just some of the MongoDB Atlas features that help you automate capacity management.
Real time Oracle database administration interview questions
Course targeting to those students who wanted to start there carrier as Oracle Database administration. I have covered most of the topic including real time scenario. I will keep posted the same on your demand.
Please send me mail on below email ID if you have any queries. I will try to solve the same as soon as possible.
Following are the interview questions are covered along with practical solution. All the questions are frequently asked in interview.
RAC(Real application cluster)
ASM(Automatic Storage management)
Oracle 12C Administration
Basic understanding of ITIL Process
All videos contain the real time scenario which you will face in daily DBA routine. We create the problem and then provide the way to get the solution
New Videos will be added to course on Daily or Weekly basis
All the interview questions are frequently asked in interview
Answers are provided in with practical presentation
On Demand Videos will be added
you can reach directly vie mail or message for any technical query
Who is the target audience?
Student and Experienced folks looking forward to crack Oracle DBA interview
Basic knowledge of SQL and Linux. We are here to help you out for more understanding
Laptop or PC with 2GB RAM
What will you learn
Easily Crack oracle database interview with real time interview question
Oracle database administration