3738 Administration courses in Whetstone delivered Online

Description: The 70-647 - Windows Server Enterprise Administration course explains how to maintain the Windows Server 2008 R2 environment and prepare you for the Exam 70-647 - Windows Server Enterprise Administration Throughout the course, you will learn the system of planning for active directory, network infrastructure, active directory issues, and active directory administration. You will also learn the ways of deploying Windows 2008 to the small and medium-sized offices, using remote desktop services and application setup. The course will also teach you how to secure the network, how to support PKI (Public Key Infrastructure) and the CA hierarchy. Finally, the course explains various virtualisation solutions by using virtualisation and planning virtualisation for applications, windows updates and how to protect the environment by making data security that still available to the user. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-647 - Windows Server Enterprise Administration is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-647 - Windows Server Enterprise Administration is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Planning for Active Directory Logical Design 01:14:00 Physical Topology 00:50:00 Network Infrastructure DNS 01:01:00 Planning IP Distribution 00:49:00 Advanced Active Directory Issues Migration Strategies 00:13:00 Working with Other Forests 00:18:00 Active Directory Administration Active Directory Administration 01:07:00 Using Group Policies 00:38:00 Deploying Windows 2008 to the Small/Medium Office Small/Medium Office 00:44:00 Small/Medium Server Security 00:43:00 Using Remote Desktop Services and Application Setup Planning for Remote Desktop Services 00:19:00 License Server 00:10:00 Deploying Applications 00:34:00 Securing the Network Designing a Secure Perimeter 01:03:00 Introducing NAP 00:26:00 Domain and Server Isolation 00:04:00 Supporting PKI What is PKI? 00:30:00 The CA Hierarchy 00:28:00 Managing Certificates 00:26:00 Virtualization Solutions Using Virtualization 00:41:00 Planning Virtualization for Applications 00:08:00 Windows Updates WSUS 00:39:00 Software Update Compliance 00:22:00 Making Data Secure and Available Sharing and Collaborating Your Data 00:32:00 Protecting Data at Rest 00:27:00 System Recoverability and Availablity 00:34:00 Mock Exam Mock Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Final Exam Final Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course, 'Administration of Emergency Medical Gases,' provides comprehensive training in the safe and effective use of medical gases in emergency situations. Covering essential topics from safety protocols to administration techniques, this course equips participants with the knowledge and skills required to handle medical gases in critical healthcare scenarios. Learning Outcomes: Safety Proficiency: Understand safety protocols and guidelines for the handling of medical gases in emergency settings. Gaseous Knowledge: Identify and comprehend the common medical gases and their specific applications. Storage and Documentation: Learn proper storage, transportation, and documentation procedures to ensure gas integrity. Administration Mastery: Develop proficiency in the administration techniques of medical gases and their monitoring. Hands-On Simulation: Gain practical skills and real-world experience through simulation exercises. Emergency Preparedness: Prepare for emergency situations by understanding the role of medical gases in critical care. Effective Communication: Enhance communication skills to collaborate seamlessly within emergency medical teams. Regulatory Compliance: Stay informed about legal and regulatory requirements governing medical gas administration. Why buy this Administration of Emergency Medical Gases?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Administration of Emergency Medical Gases you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Administration of Emergency Medical Gases course is ideal for Emergency Medical Personnel: Paramedics, EMTs, and first responders. Nurses and Doctors: Seeking specialized knowledge in emergency medicine. Healthcare Administrators: Ensuring proper protocols and safety in healthcare facilities. Pharmacists: Handling and dispensing medical gases in healthcare settings. Prerequisites This Administration of Emergency Medical Gases was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Emergency Medical Technician (EMT): £20,000 - £40,000 Registered Nurse: £25,000 - £45,000 Emergency Physician: £60,000 - £120,000 Healthcare Facility Manager: £30,000 - £60,000 Pharmacist: £30,000 - £60,000 Course Curriculum Module 01: Introduction to Medical Gases Introduction to Medical Gases 00:14:00 Module 02: Safety and Handling Guidelines Safety and Handling Guidelines 00:12:00 Module 03: Common Medical Gases Common Medical Gases 00:12:00 Module 04: Storage, Transportation, and Documentation Storage, Transportation, and Documentation 00:15:00 Module 05: Administration Techniques and Monitoring Administration Techniques and Monitoring 00:14:00 Module 06: Practical Skills and Simulation Practical Skills and Simulation 00:11:00

Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Imagine a career where you play a vital role in healthcare, making a difference in people's lives daily. You have the opportunity to do just that in Phlebotomy, Anesthesiology, and Medicine Administration. In the UK, professionals in these areas can earn an average annual salary ranging from £25,000 to £60,000. Now, picture yourself with the knowledge and skills to excel in these critical healthcare disciplines. Introducing our captivating bundle of courses: "Phlebotomy, Anesthesiology, and Medicine Administrations." This extraordinary bundle combines three comprehensive courses to provide you with the expertise required to thrive in the healthcare industry. By enrolling in this bundle, you are investing in your professional growth and positioning yourself for a rewarding career in the medical field. Whether you aspire to work in hospitals, clinics, or research institutions, the knowledge and skills gained from these courses will set you apart. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Immerse yourself in these diverse, enthralling subjects, each designed to fuel your curiosity and enhance your knowledge. Dive in now! The courses in this bundle include: Phlebotomy Training Anesthesiology Training Control and Administration of Medicines Online Training Learning Outcomes: Acquire comprehensive knowledge and practical skills in the art of blood collection, ensuring accurate sample collection for diagnostic purposes. Develop a deep understanding of anaesthesia principles, techniques, and patient management, ensuring comfort and safety during surgical procedures. Gain proficiency in medication management, including medication classification, dosage calculations, and proper administration routes. Enhance your infection control practices, promoting safety and preventing the spread of infections in healthcare settings. Master effective communication and interpersonal skills, fostering compassionate patient care and establishing patient trust. Apply ethical and legal principles in phlebotomy, anesthesiology, and medicine administration, maintaining patient confidentiality and privacy while adhering to professional standards. This captivating bundle combines three essential courses to equip you with the knowledge and skills to excel in phlebotomy, anesthesiology, and medicine administration. In the Phlebotomist Training course, you will embark on a journey to master the art of blood collection. Through a combination of theoretical knowledge and practical skills, you will learn various phlebotomy techniques and understand the importance of accurate sample collection. From infection control to patient communication, this course will equip you with the expertise needed to excel as a phlebotomist and provide compassionate patient care. The Anesthesiology Training course is designed to provide you with a comprehensive understanding of anaesthesia administration. Delve into the principles and techniques of anaesthesia, from assessing patient risk factors to managing anaesthesia-related emergencies. In addition, gain hands-on experience in airway management, vital signs monitoring, and anaesthesia delivery. By completing this course, you will be prepared to contribute to the safe and effective administration of anaesthesia in surgical settings. The Control and Administration of Medicines Online Training course is your gateway to mastering medication management principles. Dive into the world of medications, from understanding different drug classifications to ensuring accurate dosing and safe administration. Learn about medication interactions, adverse effects, and the importance of proper documentation. This course will equip you with the knowledge and skills to maintain medication safety and deliver optimal patient care. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Bundle is Suitable For: Individuals are aspiring to become phlebotomists, anaesthetists, or medication administration professionals. Healthcare professionals seek to expand their knowledge and skills in these specialised areas. Medical students or graduates aiming to enhance their understanding and practical proficiency. Allied healthcare professionals are looking to diversify their skill sets and career opportunities. Individuals considering a career change into the healthcare sector. Career path People tend to pursue these career paths in this sector: Phlebotomist: £18,000 - £25,000 per year Anaesthetist Assistant: £25,000 - £35,000 per year Medication Administrator: £20,000 - £30,000 per year Operating Room Technician: £22,000 - £30,000 per year Laboratory Technician: £18,000 - £25,000 per year Anaesthesia Technician: £22,000 - £30,000 per year Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - £9.99 Unlock your potential and showcase your accomplishments with our CPD Quality Standards certificates! Upon successful completion of the course, learners can obtain a CPD Quality Standards PDF certificate for Phlebotomist Training absolutely free! Upon finishing Anaesthetist and Control and Administration of Medicines, you'll have the opportunity to obtain valuable proof of your achievement. For just £4.99, we'll send you a CPD Quality Standards PDF Certificate via email, or if you prefer, you can get a beautifully printed hardcopy certificate for £9.99 in the UK. If you're located internationally, don't worry! We offer a printed hardcopy certificate for £14.99, ensuring your success knows no boundaries. Grab your certificate and celebrate your success today!

Duration 5 Days 30 CPD hours This course is intended for This advanced course is for individuals who are experienced AIX system administrators with TCP/IP networking and AIX Logical Volume Manager (LVM) experience, who are responsible for the planning and installation of a PowerHA SystemMirror 7.1 and later cluster on an IBM power systems server running AIX 6.1 or later. The lab exercises are conducted on an AIX 7.1 TL2-level system. Overview Explain what high availability is Outline the capabilities of PowerHA SystemMirror Design and plan a highly available cluster Install and configure PowerHA SystemMirror in the following modes of operation: Single resource group on a primary node with standby node Two resource groups in a mutual takeover configuration Implement the trusted execution feature of AIX 6.1 Configure resource group startup, fallover, and fallback policies Perform system administration tasks for PowerHA Perform customization for PowerHA Perform problem determination and recovery This course is designed to prepare you to perform administration on a highly available cluster using PowerHA SystemMirror for AIX. It introduces concepts; design and planning considerations; installation and configuration; customization; and maintenance. Day 1 Introduction to PowerHA SystemMirror Planning and configuring network and storage Day 2 Configuring applications for PowerHA SystemMirror Configuring a PowerHA SystemMirror cluster Day 3 Cluster validation and testing PowerHA SystemMirror administration Day 4 PowerHA SystemMirror event processing Basic Troubleshooting Day 5 PowerHA SystemMirror installation

The Control and Administration of Medication is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Control and Administration of Medication consists of several modules that take around 6 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Module 01: Introduction to Safe Handling of Medicines Introduction to Safe Handling of Medicines 00:23:00 Module 02: Legislation and guidance of medication management Legislation and Guidance of Medication Management 00:17:00 Module 03: Principles of Safe and Appropriate Handling of Medicines Principles of Safe and Appropriate Handling of Medicines 00:30:00 Module 04: Medication Risk Assessment Guidance Medication Risk Assessment Guidance 00:20:00 Module 05: Handling Medicines in Social Care Settings Handling Medicines in Social Care Settings 00:56:00 Module 06: Consent to Treatment Consent to Treatment 00:27:00 Module 07: Requirements for Specific Services Requirements for Specific Services 00:41:00 Module 08: Levels of Care and Support Levels of Care and Support 00:10:00 Module 09: Procedure for Handling Medication Procedure for Handling Medication 00:15:00 Module 10: The Six Rights of Medication Administration The Six Rights of Medication Administration 00:19:00 Module 11: Covert Administration of Medication Covert Administration of Medication 00:18:00 Module 12: Recording Procedures Recording Procedures 00:17:00 Module 13: Storage of Medication Storage of Medication 00:11:00 Module 14: Transfer and Disposal of Medication Transfer and Disposal of Medication 00:14:00 Module 15: Drug Formulation and Ways of Taking It Drug Formulation and Ways of Taking It 00:56:00 Mock Exam Mock Exam - Control and Administration of Medication 00:20:00 Final Exam Final Exam - Control and Administration of Medication 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The Administration and Control of Medicines course is crucial in today's world, emphasizing the importance of risk management in medicine management. With modules covering the fundamentals, effective prescribing, and pharmacological management, this course equips individuals with the skills needed to navigate the complexities of modern healthcare. Understanding risk management is essential for ensuring patient safety and optimizing medication use, which is particularly vital in residential aged care facilities. The course also delves into palliative care, law, and legislation, underscoring the critical role of risk management in adhering to legal standards and improving patient outcomes. Graduates of this course are well-positioned for job opportunities in the UK, where the demand for healthcare professionals with expertise in medicine management and risk management is high. The average salary for such roles can range from £25,000 to £40,000 annually, depending on experience and specific job functions. The sector is experiencing significant growth, with an expected increase of 6-8% in job opportunities over the next decade. This course not only enhances employability but also ensures that healthcare professionals are adept at implementing effective risk management strategies, thereby improving overall healthcare delivery and patient care. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Course Curriculum: Module 01: Medicine Management Fundamentals Module 02: Importance Of Medicine Management Module 03: Prescribing Medication Effectively Module 04: Common Problems - Pharmacological Management Module 05: Common Medicines To Use Module 06: Palliative Care Module 07: The Four Principles Of Medicine Optimisation Module 08: Managing Medication In Residential Aged Care Facilities Module 09: Law And Legislation Learning Outcomes: Identify fundamentals of managing medicines for effective administration control. Analyze the importance of proper medicine management techniques. Implement effective prescribing methods to ensure patient safety and wellness. Recognize common pharmacological issues and apply appropriate management strategies. Utilize common medicines efficiently according to prescribed guidelines. Apply principles of medicine optimization in various healthcare settings. CPD 10 CPD hours / points Accredited by CPD Quality Standards Administration and Control of Medicines 2:56:01 1: Module 01: Medicine Management Fundamentals Preview 21:43 2: Module 02: Importance Of Medicine Management 15:12 3: Module 03: Prescribing Medication Effectively 17:31 4: Module 04: Common Problems - Pharmacological Management 42:27 5: Module 05: Common Medicines To Use 12:18 6: Module 06: Palliative Care 14:37 7: Module 07: The Four Principles Of Medicine Optimisation 15:11 8: Module 08: Managing Medication In Residential Aged Care Facilities 24:36 9: Module 09: Law And Legislation 11:26 10: CPD Certificate - Free 01:00 Who is this course for? This Administration and Control of Medicines course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Administration and Control of Medicines. Moreover, this course is ideal for: Healthcare professionals seeking advanced medicine management knowledge. Nurses aiming to enhance medication administration skills for patient care. Pharmacists interested in improving medication prescribing and management practices. Caregivers in residential aged care facilities requiring comprehensive medication management training. Healthcare administrators and policymakers involved in developing medicine-related protocols. Requirements There are no requirements needed to enrol into this Administration and Control of Medicines course. We welcome individuals from all backgrounds and levels of experience to enrol into this Administration and Control of Medicines course. Career path After finishing this Administration and Control of Medicines course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Administration and Control of Medicines are: Mental Health Nurse - £24K to 40K/year Pharmacist - £31K to 53K/year Care Home Manager - £28K to 45K/year Clinical Nurse Specialist - £35K to 55K/year Palliative Care Nurse - £25K to 40K/year Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Get ready for an exceptional online learning experience with the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The IT Administration, Networking, Cyber Security Awareness Training & GDPR is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the IT Administration package has something for everyone. As part of the IT Administration, Networking, Cyber Security Awareness Training & GDPR package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the IT Administration bundle to confidently navigate your career path or personal development journey. This Bundle Comprises the Following CPD Accredited Courses: IT Administration and Networking Encryption Advance Windows 10 Troubleshooting for IT HelpDesk Building Your Own Computer Cyber Security Awareness Training Secure Programming of Web Applications Cloud Computing / CompTIA Cloud+ (CV0-002) CompTIA A+ (220-1001) Data Center Training Essentials: General Introduction Information Management Bash Scripting, Linux and Shell Programming Learn Ethical Hacking From A-Z: Beginner To Expert Computer Networks Security from Scratch to Advanced GDPR UK Training Cisco ASA Firewall Training Course Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle , you will be able to: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the IT Administration Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the IT Administration. Build a strong knowledge base in your chosen course via IT Administration. Benefit from the flexibility and convenience of online learning. With the IT Administration package, validate your learning with a CPD certificate. Embrace the future of learning with the IT Administration, Networking, Cyber Security Awareness Training & GDPR, a rich anthology of 15 diverse courses. Each course in the IT Administration, bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle offers you the flexibility and convenience to learn at your own pace. Make the IT Administration, package your trusted companion in your lifelong learning journey. Enrol IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle today and start your career growth! CPD 205 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol in this IT Administration, Networking, Cyber Security Awareness Training & GDPR course. Career path Unleash your potential with the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path in IT. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.