17130 Other courses in Haslingden delivered Online

Duration 2 Days 12 CPD hours This course is intended for Experienced VMware vSphere administrators Overview By the end of the course, you should be able to meet the following objectives: Explain the key features and use cases for vSAN Detail the underlying vSAN architecture and components Describe the different vSAN deployment options Detail vSAN cluster requirements and considerations Apply recommended vSAN design considerations and capacity sizing practices Determine and plan for storage consumption by data growth and failure tolerance Design vSAN hosts for operational needs Explain Maintenance Mode use and its impacts on vSAN Apply best practices for vSAN network configurations Manually configure a vSAN cluster using VMware vSphere Client™ Explain and configure vSAN fault domains Understand and apply vSAN storage policies Define encryption in the vSAN cluster Describe the architecture and use cases for stretched clusters Describe the architecture and use cases for two-node clusters Understand the steps involved in creating the vSAN iSCSI target services This two-day, hands-on training course provides you with the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. In this course, you are taught the many considerations that the end vSAN configuration has on the initial planning of the vSAN datastore. You also perform a fully manual configuration of a vSAN cluster. Course Introduction Introductions and course logistics Course objectives Introduction to vSAN Describe vSAN architecture Identify vSAN objects and components Describe the advantages of object-based storage Describe the difference between All-Flash and Hybrid vSAN architecture Explain the key features and use cases for vSAN Discuss the vSAN integration and compatibility with other VMware technologies Planning a vSAN Cluster Identify requirements and planning considerations for vSAN clusters Apply vSAN cluster planning and deployment best practices Determine and plan for storage consumption by data growth and failure tolerance Design vSAN hosts for operational needs Identify vSAN networking features and requirements Describe ways of controlling traffic in a vSAN environment Recognize best practices for vSAN network configurations Deploying a vSAN Cluster Deploy and configure a vSAN cluster using the Cluster Quickstart wizard Manually configure a vSAN cluster using vSphere Client Explain and configure vSAN fault domains Using VMware vSphere© High Availability with vSAN Understand vSAN cluster maintenance capabilities Describe the difference between implicit and explicit fault domains Create explicit fault domains vSAN Storage Policies Describe a vSAN object Describe how objects are split into components Explain the purpose of witness components Explain how vSAN stores large objects View object and component placement on the vSAN datastore Explain how storage policies work with vSAN Define and create a virtual machine storage policy Apply and modify virtual machine storage policies Change virtual machine storage policies dynamically Identify virtual machine storage policy compliance status Introduction to Advanced vSAN Configurations Define and configure compression and deduplication in the vSAN cluster Define and configure encryption in the vSAN cluster Understand the remote vSAN datastore topology Identify the operations involved in managing the remote vSAN datastore Understand the steps involved in creating the vSAN iSCSI target service vSAN Stretched and Two-Node Clusters Describe the architecture and use cases for stretched clusters Detail the deployment and replacement of a vSAN witness node Describe the architecture and uses case for two-node clusters Explain the benefits of vSphere HA and vSphere Site Recovery Manager in a vSAN stretched cluster Explain storage policies for vSAN stretched cluster Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Plan and Deploy [v7] 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 VMware vSAN: Plan and Deploy [v7] 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.

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is as follows: Network Administrators Administrators interested in Automation Individuals interested in devops, specifically for networking Overview This course teaches students to blend Python skillsets with Ansible through the lens of automating networks. Automation techniques for the most popular vendor (incl. Cisco, Juniper, Arista) will be subjects of study, however, students may request examples from vendors within their own environments. Topics begin with a focus on automating networks with Python; this skill set is then folded into a broadening understanding of automating with Ansible. Students will have programmatic experience automating enterprise class networks by the conclusion of this course (includes writing custom Ansible modules with Python). Class is a combination of lecture, demonstration, and hands-on labs. Students are invited to share their own relevant Python and Ansible scripts with the instructor to ensure class subjects are as relevant as possible. All notes and scripts will be made available to students by the end of each day via a cloud-share or email. Lab time will be given reinforce that day's topics and demonstrations. No two networks are the same! Learn to automate your network with a Python and Ansible skillset. Course can be taught across all major (and most minor) network vendors. Course demonstrations can be adapted to best-fit the customer?s network to ensure all lessons have maximum relevance. Day 1 ? Critical Python Catchup & Review Overview of Python and Ansible Python white space rules & best practices Printing and more Printing Date types and Variables Packing and Unpacking Variables f Strings Conditional expressions Relational and Boolean operators Lists, Tuples, Dictionaries Indexing and slicing Built-in functions Iterating with Loops (for and while) Working with files Software Control Management (SCM) (Git, Github, Bitbucket, Cloudshare, etc.) Using Python to access REST interfaces Working with JSON Python, Ansible and Paramiko Using Paramiko to SSH with keys and passwords RESTful API review API keys Paramiko Review Using Paramiko to SFTP with keys and passwords Day 02 ? Python and Network Automation Introduction to Netmiko (automating routers and switches) Using Netmiko to send commands to / from network devices Working with YAML Converting JSON to YAML with Python Ansible keywords YAML and JSON for data exchange Ansible and YAML Ansible Playbook components Tying together Python and Ansible ? Using Python within Ansible Ansible Network Modules What is new in Ansible (most current updates / release notes) Network Agnostic modules Writing network playbooks Reviewing the construction of network playbooks Writing Ansible playbooks that respond to network failures Day 03 ? Blending Python and Ansible Skillsets Review how to use Python within Ansible Calling Python scripts with Ansible Jinja2 Templating Engine for Python (and Ansible) Using Templates in Ansible playbooks Jinja2 filters, looping, and other useful tricks for automating with Ansible Playbook tagging for selective runs When to use Python and when to use Ansible ?Big Picture? options for using Python & Ansible within your Network Ansible Roles Day 04 ? Customizing Ansible with Python Review ? Running Scripts with Ansible Prompting for Ansible user input Ansible Galaxy & Getting at Roles Writing a custom Ansible Module with Python Ansible ?Engine? vs Ansible ?Tower? ? marketing hype, capabilities, costs, etc. Case Study: Automate your Enterprise Network When to use Python and when to use Ansible Writing your own Ansible modules in Python ?Big Picture? options for using Python & Ansible within your Network Overview ? NETCONF / YANG and what they mean for Python and Ansible Molecule ? Testing your roles Additional course details: Nexus Humans Network Automation with Python and Ansible 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 Network Automation with Python and Ansible 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.

As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times. As humanitarians, helping others is both rewarding and challenging as it takes a toll on our wellbeing and mental health. Whether you are providing humanitarian response to current events in Israel and Gaza, the protracted crises in Syria, civil war in Yemen, earthquake in Nepal, or flooding in Dominican Republic (just to name a few), a focus on your wellbeing and mental health is just as important as those you help.  Partnering with The KonTerra Group, an expert in wellbeing and resilience, we created videos in English, Hebrew, Arabic, French, Spanish, Ukrainian, Polish, and Russianon the topics below. They are available on the DisasterReady YouTube channel making them easily available for you and those you are helping.  Coping with Grief and LossCoping with an Insecure EnvironmentUnderstanding and Coping with Vicarious TraumaMaintaining Wellbeing During DisplacementWays to Stay Calm in an EmergencyUnderstanding and Coping with BurnoutWhat Is Counseling and How Can it Help Me?10 Tips for Supporting Staff After a Traumatic EventSupporting Staff During Evacuation, Displacement and Shelter in Place Take a few minutes to invest in your wellbeing by watching one or more of the videos and forward the YouTube link to co-workers, family, and the crisis-affected communities you are walking alongside. Together we can help each other strengthen our wellbeing and mental health during these difficult times.

Learn how to handle medical emergencies at work with our Workplace First Aid Training. This course will teach you essential skills, such as CPR, wound care, and illness identification. This course is ideal for anyone who works in an office, factory, school, or other environment.

Understand the Mental Toughness model and look at how to improve your mental toughness with the 4c’s. Course overview Duration: 1 day (6.5 hours) Mental toughness is the ability to resist, manage and overcome doubts, worries, concerns and circumstances that prevent you from succeeding, or excelling at a task or towards an objective or a performance outcome that you set out to achieve. Our one day programme can help you to achieve this by using tools and techniques to help you perform under pressure and ensure your wellbeing. Objectives  By the end of the course you will to: Identify the causes of stress and how to prevent them Assess your mental toughness using the MTQ48 measure Use tools and techniques to develop your mental toughness Content Understanding Stress, Pressure and Challenge The causes of stress How stress can manifest itself Threat response The Stress performance curve Stress, challenge and pressure Positive stress Mental Toughness, Stress Management and Resilience Defining stress management, resilience and mental toughness How they differ and how they affect each other Mental Toughness Understanding mental toughness The importance of mental toughness The benefits of developing your mental toughness The 4 Cs of Mental Toughness How we approach Challenge Control our emotions Develop Confidence Create Commitment MTQ48 Profile Understanding your MTQ48 profile Looking at your mental toughness Areas for development Developing Mental Toughness Managing physical energy to deal with stress Developing healthy habits for managing stress Multitasking and the ability to focus Identifying unhelpful thought patterns Positive and pragmatic thinking approaches Managing your approach to change and challenge Ways of developing mental toughness

If you've ever phoned a GP surgery or hospital and been greeted by someone who seems to know everything — that’s the work of a Medical Administrator. This course gives you the knowledge to handle medical paperwork, book appointments, manage patient records, and decode the mysterious world of medical jargon — without the need for a white coat or a stethoscope. It’s built for anyone who wants to move confidently into a medical office setting, learning everything from basic office procedures to patient confidentiality and communication techniques — all without leaving your sofa. The UK healthcare sector is one of the busiest in Europe, with over 1.5 million NHS staff and rising demand for admin professionals who keep things running smoothly behind the scenes. With this online course, you'll find out how medical offices stay organised, how records are handled, and how the front desk often runs the show — all while keeping it calm and polite. Whether you're aiming for a role in a hospital, private clinic or GP surgery, this course walks you through the essentials in a way that makes sense. No jargon. No fluff. Just everything you need to know to get moving in the world of medical admin. Learning outcome: After completing this course successfully, you will Learn about clinical and medical administration Understand how to manage a filing system and medical records Understand how to preserve confidentiality in a medical setting Learn the terminology and jargon used in medical Know how to keep up with workplaces safety Acquire an understanding of healthcare information technology Learn about legal considerations and ethics Key Features of the Medical Administrator Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Medical Administrator course is as follows: ***Medical Administrator*** Module 01: Introduction to Medical and Clinical Administration Module 02: Organise Schedules Module 03: Maintaining Medical Records Module 04: Effective Filing Systems in Medical Offices Module 05: Confidentiality in a Medical Environment Module 06: Controlling Stocks and Supplies Module 07: Medical Jargon and Terminology Module 08: Maintaining Workplace Safety Module 09: Information Technology in Health Care Module 10: Medical (Clinical) Coding and Billing Module 11: Legal aspects and Ethics Accreditation All of our courses, including this Medical Administrator course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your courses, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Who is this course for? Anyone can enrol in this Medical Administrator course. This course will provide a wealth of information for: Anyone who enjoys learning new skills Anyone looking to get ready for greater employment opportunities Anyone seeking to enhance their career in order to obtain promotions Anyone who wishes to raise their current abilities to a higher level. Career path You will be able to pursue a number of careers after completing this course, including: Medical Secretary Health records clerk Medical Assistant Medical Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

ᴋᴀᴘ ɪꜱ ᴀ ᴛʀᴀɴꜱᴍɪꜱꜱɪᴏɴ ᴏꜰ ᴋᴜɴᴅᴀʟɪɴɪ ᴇɴᴇʀɢʏ ᴀɴᴅ ɴᴏɴ-ᴅᴜᴀʟ ꜱᴛᴀᴛᴇꜱ ᴏꜰ ᴄᴏɴꜱᴄɪᴏᴜꜱɴᴇꜱꜱ ᴏʀ ᴏɴᴇɴᴇꜱꜱ. It’s stands for Kundalini Activation Process. When the energy is transmitted by the facilitator it activates a person’s life force energy that exists inside every one of us.  It's the path of surrender, there is nothing a person needs to “do” while the facilitator transmits the energy. The energy enters through the crown chakra, and builds up in between the first and second chakra, to then start flowing both ways.  No breathwork or poses are necessary: that's why it's different from kundalini yoga, tantra or chi-gong. In KAP, to receive and feel the energy all you need to do is to surrender.  During the session experiences can be: out of body, bliss states, seeing colours and visions, and having emotional releases. Nevertheless, what happens in the session is not what's most important, what comes after is a profound unblocking of your energy centers and a deeper connection to your intuition and to your true self.  The real changes in your life occur because of these major internal shifts. No experience required! Important to note: - Please wear comfortable clothing - Try not to eat 3 hours before the session (or something light, such as a piece of fruit) - Try to avoid alcohol or substances 24 hours before the session - Bring a yoga mat if you prefer, otherwise one will be provided for you

Leading with Emotional Intelligence

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals 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 PL/SQL Fundamentals 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.

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.