1174 Courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.

Social Media Marketing Level 5 Course Overview: This Social Media Marketing Level 5 course offers a comprehensive exploration of key digital marketing strategies tailored to social media platforms. It covers essential topics like SEO, content marketing, email marketing, and growth hacking, enabling learners to understand the full spectrum of social media marketing techniques. By completing the course, learners will gain valuable insights into how to build and implement effective strategies across different platforms such as Facebook, Instagram, Twitter, and YouTube. The course prepares learners for practical application in real-world marketing scenarios, giving them the skills needed to increase engagement and drive conversions in the ever-evolving social media landscape. Course Description: The Social Media Marketing Level 5 course dives deep into the various facets of digital marketing, focusing on techniques that have the potential to scale businesses. It explores the fundamentals of digital marketing, growth hacking strategies, and the importance of the customer journey in creating successful campaigns. Key topics include SEO, content marketing, email marketing, and platform-specific marketing strategies such as those for Facebook, Instagram, Twitter, and YouTube. By the end of the course, learners will be proficient in building cohesive marketing strategies that align with business objectives and drive results. The course provides a structured learning experience that integrates theory with applicable skills for future marketing success. Social Media Marketing Level 5 Curriculum: Module 01: Fundamentals of Digital Marketing Module 02: Growth Hacking Module 03: Customer Journey Module 04: Content Marketing Module 05: SEO Module 06: E-Mail Marketing Module 07: Facebook Marketing Module 08: Instagram Marketing Module 09: Twitter Marketing Module 10: Youtube Marketing Module 11: Mobile Marketing (See full curriculum) Who is this course for? Individuals seeking to develop a solid understanding of social media marketing. Professionals aiming to enhance their digital marketing skills for career progression. Beginners with an interest in pursuing a career in social media marketing. Marketing enthusiasts who want to deepen their knowledge of platform-specific strategies. Career Path: Social Media Manager Digital Marketing Specialist Content Strategist SEO/SEM Expert Social Media Analyst Email Marketing Specialist Brand Manager Marketing Consultant

Are your sales people too stressed, running on adrenalin, perhaps driving towards burnout, struggling to reach targets? Wouldn't you rather they delivered consistently good performance, sustainable over longer periods of time, with less stress (for both them and you)? This uniquely empowering workshop will help your team develop naturally high levels of focus, energy and motivation. They will attain a sense of grounded euphoria, giving them a very distinct and ethical edge in selling. A one-day programme, it gives salespeople an introduction to the 'Natural Superheroes' concepts and resources, tools and techniques, to help them improve their sales performance - realising greater sales potential, developing deeper and more profitable client relationships, winning more business. Through this experience, sales teams gain: Information about profiling clients to instantly understand more about their deepest drives and true needs so they can be genuinely met and, where possible, exceeded Insights into deep, honest and very 'real' reasons for sales procrastination - participants are given specific workable strategies they can easily apply to overcome sales resistance, by tapping their natural motivational styles An understanding of communicating at the very highest levels with different people so they truly understand your sales message and have a significantly more positive sales experience A realisation of their very specific natural sales talents as individuals and as a team A deeper level of experience and understanding of what specifically drives their own behaviour and the behaviour of their clients - these unique insights explain not only how but exactly why people behave the way they do An experience of what it takes to be unshakeable under pressure and manage the sales processes and relationships to a positive outcome for all Brand-new insights into working with and handling difficult people across all levels of authority An understanding of the pitfalls and the psychological traps we set ourselves which cause unnecessary stress, anxiety and frustration on a daily basis and, in turn, limit our sales performance Access to very simple and practical tools that massively increase self-awareness, engender accountability and responsibility and develop emotional sales mastery 1 Introducing 'Natural Superheroes' for sales What is a 'Natural Superhero'? Defining emotional intelligence in the context of sales and why it is so important Knowing yourself - why most people don't know themselves at all and how we can understand exactly what drives our behaviour for the purpose of improving sales performance specifically Knowing exactly why others, and specifically clients and team members, behave the way they do - understanding the real motives behind people's good and bad behaviour in a sales meeting Simple steps to freeing yourself of any anxiety, pressure and false sense of limitation when selling Being yourself in sales - why this is not as easy as it sounds but how you can make it effortless How to take control of achieving the sales performance you really need and want for yourself and others Strategies that raise your self-awareness, increase an authentic and sustainable sense of self-confidence, in difficult situations and in moments of crisis 2 Understanding yourself, your team members and your customers - using the Enneagram Introducing the Enneagram and why it is so valuable to sales people and their clients Exploring the 9 types of motivational drives and why people have different reasons for buying from you Core types and wings - understanding the influence of other motivations either side of the core Enneagram type How to confirm the profile of your client - using celebrities from the world of politics, cinema, sports - we explore how to identify each type - what are their core drives, why have they arisen and how can we use these insights to help you in improving your sales performance The 3 levels of behaviour within your personal profile and that of your clients Lookalike Enneagram types - mistaken identities - how to avoid these traps when profiling your clients and your team How to communicate effectively in a sales environment with each of the different Enneagram types - communication strategies for positive impact on morale, performance and, ultimately, sales results How to interpret and make use of the results of your online personal profile - participants complete an online profile before the event and have the opportunity to analyse their results with a view to improving their sales performance How sales teams sabotage their own performance and that of other people within the team - and how to stop it Uncovering your particular edge in a sales role - what unconsciously trips you up as a sales person? How the Enneagram helps us in sustaining a truly great sales performance over time 3 Why positive thinking alone doesn't work in sales Why 'PMA' does not stand for positive mental attitude when selling - learn its alternative meaning that can serve you even more effectively in a sales role 3 steps and exercises that naturally increase PMA The value of making unconscious thinking conscious and how to do this without any pain or discomfort in a sales meeting Why each Enneagram type has a different experience of PMA in terms of their outward behaviour and how to know when you are maximising your sales performance 4 Measuring success How to measure the development of your individual profile as a sales person Development planning and review Into the future - how to continue your Natural Superhero development

Duration 1 Days 6 CPD hours This course is intended for Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. Overview In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will: Share data across applications. Use action, unmatched, and duplicate queries to manage data. Create complex reports and forms. Use macros to improve user interface design. Use VBA to extend database capabilities. Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting. Implement security strategies and distribute a database to multiple users. You've covered many of the basic functions of Microsoft© Access©, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Lesson 2: Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Lesson 3: Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Lesson 4: Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Lesson 5: Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Use VBA with Form Controls Lesson 6: Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Lesson 7: Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Marketing Secrets for High Sales Course Overview "Marketing Secrets for High Sales" is a dynamic course designed to equip learners with advanced strategies for driving sales success. Throughout the course, participants will explore cutting-edge marketing techniques, tools, and insights that have proven effective in boosting sales across various industries. By the end of the course, learners will understand how to craft compelling marketing strategies, leverage customer psychology, and implement tactics that consistently lead to high sales conversions. The course is structured to provide learners with both the theoretical knowledge and actionable skills needed to excel in a competitive market. Course Description This course delves into a wide range of topics including sales funnel optimisation, creating persuasive marketing messages, targeting the right audience, and leveraging digital platforms for maximum impact. Learners will explore the intricacies of consumer behaviour, the role of brand positioning, and the importance of data-driven decision-making. By engaging with the course materials, participants will gain in-depth insights into the strategies that fuel high sales numbers and discover how to adapt these methods to suit their unique business goals. The course is designed to offer a structured learning experience, ensuring that all essential concepts are covered and applicable to real-world scenarios. Marketing Secrets for High Sales Curriculum Module 01: Understanding Sales Psychology Module 02: Crafting Compelling Marketing Campaigns Module 03: Leveraging Social Media for High Sales Module 04: Data-Driven Marketing Techniques Module 05: Email Marketing for Conversion Optimisation Module 06: Building Brand Loyalty to Drive Long-Term Sales Module 07: Advanced Sales Funnel Strategies (See full curriculum) Who is this course for? Individuals seeking to enhance their marketing knowledge and skills. Professionals aiming to boost their sales strategies and performance. Beginners with an interest in learning the principles of high sales. Entrepreneurs and business owners looking to optimise their marketing efforts. Career Path Marketing Manager Sales Director Digital Marketing Specialist Brand Strategist Sales Consultant

Building the Case for Data Governance Masterclass with Nicola Askham (The Data Governance Coach) and Alex Leigh

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants and Business Process Owners/Team Leads/Power Users. Overview This course is organized in a fashion that mimics the step by step process planners will undergo in executing production planning tasks on a daily basis. We start with setup up alert profiles to manage the day to day exceptions. Participants will walk through a detailed analysis of the net requirements calculation process that is executed during product heuristics. Gain an understanding of how scheduling is performed as new orders are created. This will include analyzing source determination rules as well as scheduling strategies. Participants will analyze the pegging functionality and the master data parameters that can control the outcome of pegging. Additionally, we will perform an analysis of process, service and REM heuristics. Lastly, perform an overview of the detailed scheduling activities involved in developing an execution schedule. In this course, students gain an in-depth understanding of the advanced topics required to implement production planning in SAP SCM APO. Introduction to Production Planning in SAP Advanced Planning and Optimization (SAP APO) Planning Demand in the Supply Chain Using Production Planning and Detailed Scheduling (PP/DS) Production Planning Results Evaluation Evaluating the Planning Run Results with Alerts Evaluating the Planning Results Evaluating the Planning Run with Advanced Tools Planning Procedure Configuring Basic Parameters for Planning Executing the Production Planning Run Planning a Product Using the Planning Procedure Order Creation with Product Heuristics Using Demand Management in PP/DS Planning Make-to-Order Production Using PP/DS Using Firming in PP/DS Configuring Product Heuristics Managing the Reuse of Procurement Proposals Using the Lot-Size Calculation In Production Planning Scheduling in Production Planning Determining the Source of Supply of the Order Scheduling Operations with the Strategy Profile Scheduling a Planned Order for Production Pegging in Production Planning Configuring Dynamic and Fixed Pegging Additional Heuristics in Production Planning Planning Production Using Process Heuristics Planning Production Using Service Heuristics Configuring Bottom-Up Heuristics Planning Production Using Repetitive Manufacturing (REM) Heuristics Outlining the Integration of Supply Network Planning (SNP) in PP/DS Detailed Scheduling Scheduling Operations with the Detailed Scheduling Planning Board Planning Production with Detailed Scheduling Strategies and Heuristics Managing Setup Times with the Setup Matrix Managing Scheduling with the PP/DS Optimizer Using MRP-Based Detailed Scheduling Additional course details: Nexus Humans SCM250 SAP Production Planning in SAP APO 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 SCM250 SAP Production Planning in SAP APO 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.

Advanced Parenting Skills Course Overview The "Advanced Parenting Skills" course provides learners with a deep understanding of effective parenting techniques, focusing on the development of advanced strategies and skills to manage complex parenting situations. It explores key elements such as communication, relationships, and leadership, helping parents and professionals enhance their approach to nurturing children's growth and well-being. Learners will gain valuable insights into building strong family dynamics, addressing behavioural challenges, and fostering positive parent-child relationships. The course is designed to equip learners with the expertise needed to face parenting challenges confidently, improve family interactions, and support children's emotional and social development. Course Description This course delves into essential aspects of advanced parenting, offering a comprehensive exploration of the skills required for effective parenting. Topics include the tools and strategies for managing various parenting challenges, as well as understanding and improving relationships between parents and children. It also covers leadership development in children, the communication dynamics that influence family relationships, and ways to establish mutual understanding. By the end of this course, learners will be well-prepared to apply these skills in real-world parenting contexts, creating a harmonious and supportive family environment. The learning experience is structured to offer both theoretical insights and actionable strategies, empowering individuals to make informed decisions and nurture their children's growth more effectively. Advanced Parenting Skills Curriculum Module 01: Introduction to Advanced Parenting Skills Module 02: Skills Required for Parenting Module 03: The Tools for Parenting Module 04: Strategies for Parenting Module 05: Relationships Between Children and Parents Module 06: Understanding Between Children and Parents Module 07: Developing Effective Relationships Module 08: Behaviour Is The Heart Of Communication Module 09: The Challenge of Parenting Module 10: Asserting Leadership Abilities in Children (See full curriculum) Who is this course for? Individuals seeking to improve their parenting skills. Professionals aiming to enhance their knowledge of family dynamics. Beginners with an interest in child development and parenting strategies. Caregivers and family support workers looking to deepen their understanding of parenting. Career Path Parenting Coach Family Support Worker Childcare Specialist Behavioural Therapist Family Counsellor

Financial Wellness: Managing Personal Cash Flow Course Overview This course provides a comprehensive guide to managing personal cash flow effectively, empowering learners to take control of their finances with confidence. Covering essential concepts such as budgeting, borrowing, credit management, and tax strategies, it equips participants with the knowledge to plan and optimise their financial wellbeing. Learners will develop a clear understanding of personal money management, insurance, and the relationship between mental health and finances. By the end of this course, individuals will be able to create and maintain a realistic budget, manage debts responsibly, and make informed financial decisions to enhance their overall financial stability and security. Course Description Delving deeper into the foundations of personal finance, this course explores key topics including cash flow planning, accounting principles for personal use, and effective money management strategies. Learners will gain insight into borrowing options, credit systems, and how to manage debt wisely. The course also covers personal insurance, tax considerations, and the design of tailored financial strategies. Emphasising the connection between financial health and mental wellbeing, it offers a well-rounded approach to managing money. Throughout the learning experience, participants will build critical skills to plan budgets, evaluate financial choices, and implement strategies that support long-term financial security in a clear and structured manner. Financial Wellness: Managing Personal Cash Flow Curriculum: Module 01: Introduction To Personal Cash Flow Module 02: Understanding The Importance Of Personal Finance Module 03: Accounting And Personal Finances Module 04: Cash Flow Planning Module 05: Understanding Personal Money Management Module 06: Borrowing, Credit And Debt Module 07: Managing Personal Insurance Module 08: Understanding Tax And Financial Strategies Module 09: Designing A Personal Budget Module 10: Money And Mental Health (See full curriculum) Who is this course for? Individuals seeking to improve their personal financial management skills. Professionals aiming to enhance their understanding of personal cash flow. Beginners with an interest in personal finance and budgeting. Anyone wishing to gain confidence in managing debt and credit. Career Path Financial Planning Assistant Personal Finance Advisor Budget Analyst Credit Management Officer Insurance Consultant Tax Support Specialist

Motivation Skills Course Overview: This course on Motivation Skills provides learners with a comprehensive understanding of the key principles and strategies behind effective motivation. It covers essential techniques that can be applied in various personal and professional settings to enhance performance, engagement, and productivity. By exploring core motivational theories and practical methods, the course equips learners with the tools to inspire and energise individuals or teams, making it invaluable for anyone looking to create a motivating environment. Learners will finish the course with a strong grasp of motivational skills, ready to apply them in their everyday interactions. Course Description: In this course, learners will dive into the fundamentals of motivation, including the psychological theories that underpin human drive and behaviour. Topics such as motivational techniques, strategies for sustained engagement, and ways to effectively influence others will be explored. The course provides learners with a structured approach to boosting motivation in themselves and others, enhancing productivity and morale. Learners will gain a strong understanding of how to adapt motivational strategies to different contexts and individuals, offering them the ability to drive results in diverse professional and personal environments. Motivation Skills Curriculum: Module 01: Introduction Module 02: Motivational Skills Module 03: Motivational Strategies Module 04: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their leadership skills. Professionals aiming to enhance team engagement and performance. Beginners with an interest in psychology or human behaviour. Managers looking to foster a positive work culture. Career Path: Motivational Speaker Team Leader or Manager HR Specialist Coaching and Mentoring Roles Workplace Wellness Coordinator