524 Intelligence courses delivered Live Online

Course Overview: The "FinTech and Big Data Analytics" course provides an in-depth exploration of the dynamic intersection between financial technology (FinTech) and big data. Learners will gain essential knowledge about the innovative solutions disrupting the financial services industry, such as cryptocurrencies, insurtech, and regtech. The course offers insights into the tools, technologies, and trends shaping the future of finance, with a specific focus on how big data analytics is transforming business models and decision-making. By the end of the course, learners will have a comprehensive understanding of FinTech's growth and its applications, enabling them to make informed decisions in this rapidly evolving field. Course Description: This course delves deeper into the core concepts of financial technology and big data, exploring the impact of FinTech innovations on traditional financial systems. Topics covered include the rise of cryptocurrencies, regulatory technology (RegTech), the development of insurance technologies (InsurTech), and the use of big data in reshaping business strategies. Learners will explore the key technologies that drive FinTech, such as blockchain, artificial intelligence (AI), and machine learning, and learn how they enable data-driven decision-making in finance. The course prepares learners for the evolving future of FinTech, equipping them with the necessary skills to understand and navigate this transformative landscape. Course Modules: Module 01: Introduction to Financial Technology – FinTech Module 02: Exploring Cryptocurrencies Module 03: RegTech Module 04: Rise of InsurTechs Module 05: Big Data Basics: Understanding Big Data Module 06: The Future of FinTech (See full curriculum) Who is this course for? Individuals seeking to understand the financial technology landscape. Professionals aiming to advance their careers in the rapidly evolving FinTech sector. Beginners with an interest in emerging financial technologies and data analytics. Entrepreneurs looking to innovate within the financial services industry. Career Path: Financial Analyst FinTech Specialist Data Analyst in Financial Services Blockchain Developer RegTech Consultant InsurTech Specialist Big Data Analyst in Finance

Meditation & Mindfulness Course Overview: The "Meditation & Mindfulness" course provides learners with the tools and techniques needed to manage stress, enhance focus, and cultivate a balanced mental state. Covering key topics such as anxiety management, mindful breathing, and cognitive awareness, this course offers a comprehensive approach to improving emotional well-being. Participants will gain insights into the science of mindfulness, learn how to integrate these practices into daily life, and develop the skills needed to create lasting mental resilience. The course is designed to help individuals not only cope with stress but thrive in their personal and professional lives by cultivating clarity, emotional intelligence, and inner peace. Course Description: This course delves into the core principles of meditation and mindfulness, exploring various methods to reduce stress and improve mental health. Key topics include understanding anxiety and how mindfulness can offer relief, applying specific mindfulness techniques to enhance focus, and developing strategies for maintaining emotional balance. Learners will explore meditation practices, from deep breathing to guided imagery, while also discovering the underlying scientific principles that support these practices. By the end of the course, learners will be able to effectively incorporate mindfulness techniques into their everyday routines, improving their overall mental and emotional resilience. The course is designed for individuals seeking to reduce stress, manage anxiety, and improve their mental well-being. Meditation & Mindfulness Curriculum: Module 01: Introduction & First Concepts Module 02: Understanding & Beating Anxiety Module 03: More Anti-Anxiety Skills & Concepts Module 04: Conclusion (See full curriculum) Who is this course for? Individuals seeking to reduce stress and improve mental well-being. Professionals aiming to enhance focus and emotional resilience. Beginners with an interest in mindfulness and meditation practices. Those looking for practical techniques to manage anxiety. Career Path Mental Health Support Worker Wellness Coach Stress Management Consultant Mindfulness Instructor Health and Wellness Advisor

Master Yourself in Talking with Strangers Course Overview This course, Master Yourself in Talking with Strangers, is designed to empower learners with essential communication skills to confidently initiate and sustain conversations with unfamiliar people. It explores effective techniques to overcome social anxiety, build rapport quickly, and engage meaningfully in diverse social settings. Through structured guidance, learners will develop greater self-awareness and adaptability in interactions, enhancing their personal and professional relationships. By the end of the course, participants will be equipped with the tools to initiate conversations naturally, listen actively, and respond with confidence, making social interactions more rewarding and less daunting. Course Description Master Yourself in Talking with Strangers offers an in-depth exploration of the skills necessary to communicate effectively with new acquaintances. Topics include understanding body language, mastering conversation openers, managing nervousness, and cultivating empathy. Learners will engage with practical strategies for navigating different social contexts and recognising cues that facilitate connection. This course provides a supportive learning environment aimed at increasing social confidence and emotional intelligence. By completing this programme, participants will enhance their interpersonal skills, enabling smoother introductions, more engaging dialogues, and the ability to foster new relationships in both personal and professional spheres. Master Yourself in Talking with Strangers Curriculum Module 01: Course Overview Module 02: The Formula Module 03: Summary Module 04: End (See full curriculum) Who Is This Course For? Individuals seeking to improve their confidence in social interactions. Professionals aiming to enhance networking and communication skills. Beginners with an interest in developing interpersonal abilities. Anyone looking to overcome social anxiety and connect more easily with others. Career Path Customer Service Representative Sales and Marketing Executive Networking and Business Development Specialist Public Relations Officer Community Engagement Coordinator

Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS 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 Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c 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 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.

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

Financial Analysis Course Overview The "Financial Analysis" course provides a comprehensive introduction to financial analysis, equipping learners with the knowledge and skills needed to interpret and evaluate financial statements. Covering key areas such as balance sheets, income statements, and cash flow analysis, this course enables learners to assess financial performance and make informed decisions. Whether you are starting your career in finance or aiming to enhance your existing knowledge, this course offers essential tools for financial analysis. Upon completion, learners will be able to analyse financial data effectively, understand the key financial indicators of businesses, and contribute to strategic financial decision-making. Course Description This course covers the fundamentals of financial analysis, providing in-depth insights into financial statements, including balance sheets, income statements, and cash flow statements. Learners will explore various financial reporting techniques, evaluate profitability, and develop the ability to conduct ratio and equity analysis. The course also delves into the applications and limitations of EBITDA and teaches learners to assess credit risks. By the end of the course, participants will have gained valuable skills in financial data interpretation, enabling them to assess financial health and contribute to strategic financial decisions in organisations. The learning experience combines theoretical knowledge with practical analytical skills to prepare learners for roles in finance and accounting. Financial Analysis Curriculum: Module 01: Introduction to Financial Analysis Module 02: The Balance Sheet Module 03: The Income Statement Module 04: The Cash Flow Statement Module 05: Financial Reporting Module 06: Analysing Profitability Module 07: The Applications and Limitations of EBITDA Module 08: Credit Analysis Module 09: Equity Analysis Module 10: Ratio Analysis (See full curriculum) Who is this course for? Individuals seeking to understand financial analysis Professionals aiming to enhance their financial reporting and decision-making skills Beginners with an interest in finance or accounting Business owners looking to improve their financial literacy Career Path Financial Analyst Accountant Credit Analyst Financial Consultant Corporate Finance Manager Business Intelligence Analyst Investment Analyst

Spiritual Life Coaching Course Overview This course on Spiritual Life Coaching is designed to equip learners with the essential knowledge and skills required to guide others through transformative life changes. Covering the basics of spiritual coaching, it explores the role of a coach, the key qualities required, and how to develop a successful practice. Learners will also gain an understanding of ethical considerations, advanced coaching techniques, and strategies to market and grow their business. Upon completion, participants will be able to confidently offer coaching services while aligning with ethical standards and effectively promoting their practice. This course provides a well-rounded foundation for those interested in becoming spiritual life coaches or enhancing their existing skills. Course Description In this comprehensive course, learners will explore the core principles and methodologies of spiritual life coaching. Beginning with an introduction to coaching basics, the course progresses to more advanced topics such as effective communication techniques, the significance of empathy, and the ethical responsibilities of a coach. Learners will develop key qualities such as emotional intelligence, active listening, and mindfulness, which are essential to guide clients through their spiritual and personal journeys. The course also covers strategies for marketing a coaching business, helping participants reach a wider audience and successfully build their practice. By the end of the course, learners will be equipped with the expertise to offer impactful, ethical spiritual coaching services and expand their professional opportunities. Spiritual Life Coaching Curriculum Module 01: Basics of Spiritual Life Coaching Module 02: Understanding Spiritual Life Coaching Module 03: Fundamental Qualities of a Coach Module 04: Advanced Coaching Module 05: Ethical Guidelines Module 06: Marketing Your Business Module 07: Growing Your Business (See full curriculum) Who is this course for? Individuals seeking to become certified spiritual life coaches. Professionals aiming to develop their coaching skills for career advancement. Beginners with an interest in personal development and coaching. Those looking to build a new career in spiritual coaching. Career Path Spiritual Life Coach Personal Development Coach Wellness Coach Life Coach Entrepreneur in Coaching Business Business Consultant in Personal Development

Course Overview This course, Self-Help Psychology: Mental Freedom, is designed to guide individuals through the process of achieving mental liberation from negative thought patterns and emotional baggage. It combines psychological principles with personal development strategies to help learners cultivate resilience, confidence, and emotional balance. By engaging with the course, participants will explore various techniques and theories to reclaim their mental freedom and transform their mindset, empowering them to lead more fulfilling lives. The course equips learners with the tools necessary for emotional empowerment, self-awareness, and psychological well-being. Course Description Self-Help Psychology: Mental Freedom offers a comprehensive exploration of psychological concepts that foster emotional release and mental clarity. The course covers a range of topics, including cognitive behavioural techniques, emotional regulation, mindfulness practices, and resilience-building exercises. Learners will gain a deeper understanding of how thoughts and emotions affect mental freedom and how to break free from limiting beliefs and self-sabotage. By the end of the course, participants will have developed a set of strategies to enhance mental wellness, cope effectively with stress, and achieve a mindset that is positive and empowered. Course Modules Module 01: Mental Freedom: From PAIN To POWER Module 02: Understanding the Psychology of Self-Empowerment Module 03: Cognitive Behavioural Techniques for Emotional Clarity Module 04: The Role of Mindfulness in Mental Liberation Module 05: Building Resilience and Overcoming Setbacks Module 06: Reprogramming Your Mindset for Success Module 07: Creating a Long-Term Plan for Mental Wellness (See full curriculum) Who is this course for? Individuals seeking to improve mental clarity and emotional well-being Professionals aiming to enhance their personal development and emotional intelligence Beginners with an interest in psychology and self-help techniques Anyone looking to break free from mental barriers and develop a positive mindset Career Path Life Coach Mental Health Support Worker Personal Development Specialist Wellness Consultant Counsellor HR Professional focusing on employee well-being

Course Overview Unlock the transformative power of Neuro-Linguistic Programming (NLP) with this dynamic course designed to equip learners with practical frameworks for personal and professional development. Covering the core principles, models, and techniques of NLP, this training enables individuals to improve communication, enhance self-awareness, and foster behavioural change. Learners will explore how language and thought patterns influence actions, developing strategies to set goals, resolve conflicts, and build better relationships. Whether you are looking to enrich your leadership skills, strengthen your emotional intelligence, or support others through coaching, this course offers valuable tools that can be immediately applied across a variety of settings. By the end of the programme, learners will have a solid foundation in NLP methodologies, with the ability to analyse behaviours, shape outcomes, and inspire transformation in themselves and others. Course Description The NLP Training course offers a comprehensive exploration of the foundational theories and practical applications of Neuro-Linguistic Programming. Learners will delve into key topics such as sensory acuity, representational systems, rapport-building, reframing techniques, and anchoring positive states. Through a structured and engaging learning experience, participants will uncover how internal language patterns affect emotional and behavioural responses, and how these can be influenced for personal advancement or supporting others. Emphasis is placed on building a flexible mindset, enhancing communication skills, and mastering strategies for behavioural change. Suitable for both newcomers and professionals across various fields, the course fosters critical thinking and effective interaction techniques. On completion, learners will have developed a strong command of NLP tools, empowering them to foster positive change, support professional growth, and improve interpersonal dynamics in multiple settings. Course Modules Module 01: Introduction to Neuro-Linguistic Programming Module 02: Understanding Human Communication and Behaviour Module 03: Building Rapport and Enhancing Relationships Module 04: Language Patterns and Persuasion Techniques Module 05: Anchoring and Emotional State Management Module 06: Setting Goals and Achieving Outcomes with NLP (See full curriculum) Who is this course for? Individuals seeking to enhance personal and professional communication. Professionals aiming to improve leadership and coaching skills. Beginners with an interest in behavioural psychology and communication models. Anyone aspiring to build stronger relationships and promote positive change. Career Path Life Coach NLP Practitioner Human Resources Specialist Counselling and Mental Health Support Worker Training and Development Professional Sales and Marketing Executive Leadership and Management Consultant