This short Oracle Database Administration training course explores the fundamentals of basic database administration. The course is suitable for versions of Oracle database up to and including 12. The course is based around using the command line, but will provide Enterprise Manager Express to complement and enhance the learning experience.
• Oracle Concepts Overview
The Oracle Instance
The Oracle Database
Grid Infrastructure Overview
Automatic Storage Management
• Oracle Database Software Installation
• Oracle Database Creation
Using the Database Configuration Assistant
• Managing an Oracle Database Instance
Connecting as a privileged user
Startup and Shutdown
Understanding Oracle Processes
Understanding System Global Area Components
Managing the System Global Area size
Understanding Program Global Area Components
Managing the Program Global Area size
The Automatic Diagnostic Repository
The Data Dictionary
• Control Files and Tablespaces
Understanding the role of Control Files
Understanding Data Files
Oracle Managed Files
• Redo Logging
Understanding the role of Redo Logging
Redo Log Groups
Redo Log File Multiplexing
• Undo Management
Receive the latest version of this course by email & subscribe to our Newsletter
07/10/2019: In recent years, the introduction of microservices has allowed businesses to build and scale large software applications using independent teams. The approach allows an app to be broken down into separate services, which can then be independently developed and deployed. Each team is responsible for its own service and can code it in the most appropriate programming language for the task in hand. The different services then communicate with each other through a framework. Microservice architecture Benefits of Micro FrontEnds To explain the benefits, let’s consider a microservice ecommerce...
25/09/2019: The IT landscape in the UK is rapidly transforming by adopting the latest tech trends. By adopting these tech trends, businesses stand to gain more insight into their data, get more value from their systems, and innovate new businesses systems fit for the digital age. Let's take a look at where businesses are focusing their attention: Machine Learning and AI Artificial Intelligence is frequently used as an umbrella term, under which Machine Learning (ML), and Deep Learning (DL) sit. Businesses in the UK are rapidly taking to incorporating ML and AI solutions because of the plethora of...
09/09/2019: When it comes to training your workforce in new skills, you want to ensure you get the best value for money and your time, and that means access to the best instructors. Organizations are under increasing pressure to train their employees in the latest technical skills that can help advance their business in the modern age. A Failure to adapt to the latest breakthroughs sweeping across all industries can leave businesses falling behind. This is particularly critical in the fields of Artificial Intelligence (AI) and Machine Learning (ML), which is advancing businesses in a huge way. The...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics or Economics) are selected from Tier 1 Universities and accepted into the program and receive training. They are then placed in Production and Application support roles within the Bank. The training program included Production and Application training modules covering Unix , Oracle SQL, Perl, Python, C++, C#, Java and ITIL. The initial success and feedback of the trial program has led to a request to increase the number of core modules, doubling...
31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum methodology and implementing it in the attendees’ workplace. They start by describing Agile principles and benefits and then progress into using Scrum as a methodology for implementing Agile. They use fun, team based exercises to illustrate and reinforce the Scrum principles and practices. These exercises can be run by the attendees with their colleagues when they return to their workplace in order to describe and distribute the knowledge they...
AI & ML training course
React training course
Threat Modelling training course
Python for Data Analysts training course
Power BI training course
Machine Learning training course
Spring & Boot Microservices training course
Terraform training course
Kubernetes training course
C++ training course
Biztalk training course