8340 Insights courses

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.

Mindfulness: Mindfulness Course Online Discover how Mindfulness: Mindfulness can positively impact various aspects of your life, including your mental, emotional, and physical well-being. Through this Mindfulness: Mindfulness learn how to cultivate meaningful connections with others through mindful communication and active listening. Gain valuable insights on creating and maintaining a consistent Mindfulness: Mindfulness routine that aligns with your lifestyle and goals. Develop the discipline and motivation needed to make mindfulness a lifelong habit. If you are seeking a transformative experience that will enhance your overall well-being, then our course "Mindfulness" is the perfect solution for you. The Mindfulness: Mindfulness course can help you regain control and find tranquility amidst the storm. Our comprehensive Mindfulness: Mindfulness course offers a deep dive into the art of mindfulness, providing you with the knowledge, techniques, and tools necessary to bring about positive change in your life. Don't let stress and distractions rule your life. Take control, find serenity, and unlock your full potential through the art of Mindfulness: Mindfulness. Sign up now and experience the profound benefits that await you! Main Course: Mindfulness Diploma Course Special Offers Of this Mindfulness: Mindfulness Course This Mindfulness: Mindfulness Course includes a FREE PDF Certificate. Lifetime access to this Mindfulness: Mindfulness Course Instant access to this Mindfulness: Mindfulness Course 24/7 Support Available to this Mindfulness: Mindfulness Course Mindfulness: Mindfulness Course Online This Mindfulness Diploma Course has six modules to describes mindfulness and how to become a mindfulness instructor. The role, method and elements related to mindfulness are describes in this Mindfulness Diploma Course. Moreover, you will know about mindfulness meditation and empirical evidence in this Mindfulness Diploma Course. With the help of Mindfulness Diploma Course you can explore mindfulness meditation. Who is this course for? Mindfulness: Mindfulness Course Online This Mindfulness: Mindfulness Course is open to everyone. Requirements Mindfulness: Mindfulness Course Online To enrol in this Mindfulness: Mindfulness Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Mindfulness: Mindfulness Course. Be energetic and self-motivated to complete our Mindfulness: Mindfulness Course. Basic computer Skill is required to complete our Mindfulness: Mindfulness Course. If you want to enrol in our Mindfulness: Mindfulness Course, you must be at least 15 years old.

Teaching English Training: Teaching English Course As an individual in teaching English do you want to gain proficiency in English language teaching methodologies and techniques? If so, then you must try our teaching English course. This teaching English course helps to gain the ability to design engaging lesson plans and effectively manage classroom dynamics. Graduates of this teaching English course possess knowledge of language assessment principles. Moreover, the teaching English course can assess learners' language proficiency accurately. The teaching English course also demonstrates intercultural competence and sensitivity to learners' diverse backgrounds and needs. Additionally, the teaching English course is capable of integrating technology into language instruction to enhance learning outcomes. Enrol in our teaching English course to get confident and competent to inspire and empower students! [ Note: Free PDF certificate as soon as completing the Teaching English Training: Teaching English course] Teaching English Training: Teaching English Course This Project Manager course consists of 12 modules. Unlock your potential with our Teaching English course! Perfect for anyone passionate about teaching English, this course offers expert insights into effective Teaching English techniques. Enhance your skills, explore advanced Teaching English strategies, and start your journey today. Our Teaching English program is designed for dedicated educators. Embrace Teaching English excellence now! Who is this course for? Teaching English Training: Teaching English Course Our teaching English course is appropriate for people who require a lot of knowledge and practical help to advance their academic abilities. Requirements Teaching English Training: Teaching English Course To enrol in this Teaching English Course, students must fulfil the following requirements: Teaching English: Good Command over English language is mandatory to enrol in our Teaching English Course. Teaching English: Be energetic and self-motivated to complete our Teaching English Course. Teaching English: Basic computer Skill is required to complete our Teaching English Course. Teaching English: If you want to enrol in our Teaching English Course, you must be at least 15 years old. Career path Teaching English Training: Teaching English Course After completing this teaching English course successfully, students will have a wealth of useful skills and the chance to seize.

The Fintech Frontier: Why FDs Need to Know About Fintech,” the podcast where we delve into the world of financial technology There are numerous areas where fintech can make a significant impact. For example, payment processing and reconciliation can be streamlined through digital payment solutions and automated tools. Data analytics and artificial intelligence can enhance financial forecasting, risk management, and fraud detection. Blockchain technology can revolutionize supply chain finance and streamline processes involving multiple parties. By understanding the capabilities of these fintech solutions, FDs can identify areas for improvement and select the right technologies to optimise their financial operations. Additionally, fintech can greatly enhance financial reporting and analysis. Advanced data analytics tools can extract meaningful insights from vast amounts of financial data, enabling FDs to make data-driven decisions and identify trends and patterns. Automation of repetitive tasks, such as data entry and reconciliation, reduces the risk of errors and frees up valuable time for FDs to focus on strategic initiatives. The adoption of cloud-based financial management systems also provides flexibility, scalability, and real-time access to financial data, empowering FDs to make informed decisions on the go. With the rapid pace of fintech advancements, how can FDs stay up to date and navigate the evolving fintech landscape? Continuous learning and engagement with the fintech community are key. Attend industry conferences, participate in webinars and workshops, and engage with fintech startups and established players. Networking with professionals in the field, joining fintech-focused associations, and following relevant publications and blogs can help FDs stay abreast of the latest fintech developments. Embracing a mindset of curiosity and adaptability is crucial in navigating the ever-changing fintech landscape. I would also encourage FDs to foster partnerships and collaborations with fintech companies. Engage in conversations with fintech providers to understand their solutions and explore potential synergies. By forging strategic partnerships, FDs can gain access to cutting-edge technologies and co-create innovative solutions tailored to their organisation’s unique needs. As we conclude, do you have any final thoughts or advice for our FD audience regarding fintech? Embrace fintech as an opportunity, not a threat. Seek to understand its potential and how it can align with your organisation’s goals and strategies. Be open to experimentation and pilot projects to test the viability of fintech solutions. Remember that fintech is a tool to enhance and optimize financial processes, and as FDs, we have a crucial role in driving its effective implementation. https://www.fdcapital.co.uk/podcast/the-fintech-frontier-why-fds-need-to-know-about-fintech/ Tags Online Events Things To Do Online Online Conferences Online Business Conferences #event #fintech #knowledge #fds #frontier

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.

In this informative session, a distinguished panel of speakers from the National Hospital for Neurology and Neurosurgery at UCLH NHS Foundation Trust, Queen Square London, together with a patient representative from the Brain Tumour Charity, offered valuable insights into the diagnosis, treatment, and management of meningiomas. The discussion included an exploration of Gamma Knife radiosurgery techniques, detailed planning and implementation processes, and perspectives from the patient experience.

Enhance your AML expertise with this CPD-accredited Level 5 course. Master fraud detection, compliance, risk management & financial crime prevention.

When mistakes happen in a care setting, honesty isn't optional – it’s a duty. Our Duty of Candour online course walks learners through the essentials of openness and accountability in health and social care environments. From understanding what the duty involves to recognising when and how to apply it, this training provides clarity on expectations for professionals who deal directly with patients, clients, or their families. Designed for those in health, social care, or related roles, this course covers key responsibilities, legal requirements, and the importance of transparency when things don’t go to plan. Whether you're looking to refresh your knowledge or build confidence in handling sensitive disclosures, this course offers structured, accessible content you can follow at your own pace, from wherever you are. No drama, just clear and practical insight to help you stay informed and do the right thing when it matters most. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to Duty of Candour Module 02 : Duty of the Candour Process Module 03 : Legal Framework Module 04 : Communication Skills for Duty of Candour Module 05 : Understanding and Managing Adverse Events Module 06 : Apology and Compensation Module 07 : Learning from Incidents Module 08 : ccountability and Oversight Module 09 : Cultural Change Module 10 : Future Directions and Challenges Learning Outcomes: Understand the fundamental principles of Duty of Candour. Navigate the Duty of Candour process with confidence. Comprehend the legal framework surrounding healthcare communication. Develop effective communication skills for Duty of Candour situations. Manage adverse events and incidents with a patient-centered approach. Contribute to a culture of accountability and oversight in healthcare. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Healthcare professionals Medical administrators Legal professionals in healthcare Quality assurance specialists Patient advocates Healthcare policymakers Compliance officers Risk management personnel Career path Healthcare Compliance Officer Medical Legal Advisor Patient Experience Coordinator Quality Assurance Specialist Risk Manager in Healthcare Healthcare Policy Analyst Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Coffee artistry is more than just brewing a cup; it's about mastering the craft to create stunning coffee experiences. In this Mastering Coffee Artistry course, you will explore the finer aspects of coffee making, from the basics of bean selection to the techniques used to create beautiful latte art. Whether you’re looking to refine your current skills or dive deeper into the world of coffee, this course offers everything you need to gain a deeper appreciation for the art behind every cup. Throughout the course, you'll learn the secrets of perfecting your brew and how to elevate your coffee-making skills to a whole new level. From understanding the intricacies of espresso to designing intricate latte art, this course covers it all. With easy-to-follow guidance, you’ll master the tools and techniques needed to create visually impressive and delicious drinks that captivate both the eye and the taste buds. Whether for personal enjoyment or to enhance your coffee expertise, this course will transform the way you see and make coffee. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Coffee Module 02: Coffee Beans Module 03: Coffee Roasting Module 04: Brewing Methods Module 05: Barista Skills and Techniques Module 06: The Classic Coffees Module 07: Mastering Latte Art Module 08: Coffee Menu Design and Trends Module 09: Working as a Professional Barista Learning Outcomes: Understand the coffee industry's rich history and origins. Gain in-depth knowledge of coffee bean varieties and their characteristics. Master the coffee roasting process, achieving optimal flavor profiles. Acquire expertise in various coffee brewing methods. Develop advanced barista skills and techniques for precision coffee preparation. Explore the world of classic and contemporary coffee offerings. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring baristas Coffee enthusiasts and connoisseurs Café owners and staff Hospitality professionals Individuals seeking a career in the coffee industry Those looking to enhance their coffee-related skills Career path Barista Café Manager Coffee Roaster Coffee Shop Owner Coffee Educator Hospitality Professional Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.