26728 Courses

leadership management training course mentoring coaching

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, 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 practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.

The model adds an easily understandable engaging communication tool that delegates begin to use immediately and effectively when they leave the training room. The model adds an easily understandable engaging communication tool that delegates begin to use immediately and effectively when they leave the training room. Insights Discovery - How it Works: Through Insights Discovery® and our own, in-house Insights Discovery® licenced practitioner, we use the Insights Discovery model to understand an individual’s unique preferences. Our Insights Discovery-based people development programmes are simple and deeply insightful. They provide immediate impact and enable positive, lasting change. Insights Discovery® is: Simple: easy to understand so everyone can apply what they learn. Universal: it speaks to everyone at all levels. Deeply Insightful: take you places you never expected. Positive: the supportive language is so engaging it empowers people to change. Fun! The memorable colour energy system that really sticks Using Insights Discovery® as part of a wider programme: Insights Discovery® is at the heart of everything that we do. This simple framework of four colour energies can be used to develop highly-tailored solutions to meet your unique business needs. Example solutions: Increasing communication and collaboration: learn how your team, department or organisation can work together more effectively in a series of Insights Discovery® Workshops. Improving personal effectiveness: as part of a programme of coaching, Insights Discovery can be used to identify areas of strength and help create a development plan tailored to each individual. Developing leaders and sales people: use an understanding of preferences to assess individual and collective strengths and enhance crucial business skills. Explore the concept of change and gain an understanding of the process Understand how different personality types respond to change Engage the wider organisation by building relationships with staff Motivate teams through change

The aim of this course is to provide an overview of Agile approaches to product development. It explains what Agile is and when and why to use it. The scope of the programme includes: The course emphasises the collaborative nature of Agile and the flexibility it offers to customers. The principal training objectives for this programme are to help participants understand: Why and when to use Agile How to use Agile The roles involved in Agile development The cultural factors to take into account How to manage Agile developments 1 Introduction (Course sponsor and trainer) Why this programme has been developed Review of participants' needs and objectives 2 Background to Agile Issues with traditional approaches to product development How Agile helps Roots of Agile Agile lifecycles Product v project 3 How Agile works The Agile Manifesto Agile principles Process control: defined v empirical Different Agile methods The Scrum framework DSDM Atern 4 Managing Agile When to use Agile Managing Agile projects Team organisation 5 Agile techniques Daily stand-ups User stories Estimating MoSCoW prioritisation 6 Course review and action planning (Course sponsor present) Are there opportunities to use Agile? What actions should be implemented to adopt Agile? Conclusion

Agility has become a prized business attribute. Although Agile methods were once most associated with software development, they are now applied in a host of different areas. Agile continues to find new applications because it is primarily an attitude. This programme delivers a solid grounding in both the Agile mindset and Agile methods. It covers three methods, illustrates the benefits of each and shows how they can be integrated. It includes practical techniques as well as background knowledge. By the end of the session, participants will be able to: Apply Agile concepts to self-manage their work Understand the roles people take on in Agile teams Use a variety of techniques to help deliver customer satisfaction Focus on delivering against priorities Employ a range of estimating techniques 1 Introduction Overview of the programme Review of participants' needs and objectives 2 The basics of Agile What makes Agile different Agile Manifesto and Principles Using feedback to deliver what is needed 3 Agile teams Multi-disciplinary teams Team size and empowerment Agile values 4 Agile at the team level - Scrum Scrum roles Scrum 'events' Scrum 'artifacts' 5 Agile for teams juggling multiple demands - Kanban Taking control of the work Improving throughput Dealing with bottlenecks 6 Agile in projects - AgilePM The phases of an Agile project Managing change requests Delivering on time 7 Estimating T-shirt / Pebble sizing Yesterday's weather Planning poker 8 Pick 'n' mix - some useful techniques The daily stand-up User stories Retrospectives Work-in-process limits Burndown charts Minimum viable product A / B testing 9 Review and action planning Identify actions to be implemented individually Conclusion

Duration 2 Days 12 CPD hours Overview Create heightened self-awareness and personal discovery Establish a space of mutual respect by adapting your communication Work with resistance to gain commitment and buy-in Recognize and enhance trust by leading from any position Distinguish among varying attitudes and behaviors to make your teams work as a stronger unit One of DISC?s most intriguing applications is leveraging behavioral identification and adaptability. This workshop will guide you on the path of heightened self-awareness and personal discovery. You can make this your cornerstone seminar, revealing your unique behavioral style blend and how to apply that knowledge prescriptively to others, based on their style blend; thus boosting communication effectiveness. Studies indicate that 92% of workplace conflict is the result of misunderstanding and communication breakdowns. Your entire organization can apply DISC?s prescriptive lessons of behavioral adaptability to reduce employee conflict and turnover, increase productivity, and optimize team performance. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Understanding The World Of Disc What is DISC? Breaking down the four main styles: Dominant Influencing Steady Conscientious Determining behaviors to read styles: Indirect vs. Direct Open vs. Guarded 2. Building Stronger Self-Awareness Rating your own style Understanding the Platinum Rule Grid Breaking down your profile Natural Style Adapted Style 3. Reading And Adapting To Others? Behaviors Applying the Platinum Rule Identifying characteristics in others Communication strategies with others Adapting your approaches 4. Getting Buy-In From Others Selling yourself to others Getting buy-in from each profile Understanding the cycle of getting buy-in Assessing Solving Confirming agreement Assuring satisfaction 5. Trust-Based Leadership High performance leadership characteristics The key to listening to build trust Motivating strategies with each profile 6. Making Teams Work Understanding how we each make decisions Seeing the power in each style as a role Blending team styles for teamwork Reviewing the team needs to optimize effectiveness

An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. They may be hired on a full-time basis and carry a full CFO workload or can be recruited on a part-time or interim basis to focus on a specific merger or acquisition. This flexibility is ideal for start-ups and SMEs who don’t have the budget to recruit a full external team to oversee an M&A or to hire a full-time CFO. The CFO is a link between both companies engaged in the M&A, acting as the eyes and ears for both the board and CEO. Their financial skills enable them to identify potential M&A opportunities and incorporate risk management into their strategy to get the most value out of their deal. Most companies evolve their approach to mergers and acquisitions organically, especially those who rely on an M&A specialist instead of having a dedicated team that works solely on M&A. The CFO is responsible for considering any potential acquisitions, crunching the numbers involved, and ensuring due diligence. They’ll be responsible for determining the value of a potential M&A and presenting it to the company’s board and leadership team to determine whether to make the purchase. An M&A specialist is responsible for gathering the data – including both positive and negative factors – to present an objective look at the other organisation and the potential value the acquisition could bring. CFOs will spend most of their time getting to grips with the numbers involved, long before presenting the M&A proposal to the board. This exercise also requires them to have real-time insight into their own company’s performance, value, and finances to paint a wider picture. An M&A specialist will take the critical steps of ensuring that the numbers presented to them are correct. CFOs who don’t specialise in M&As will still have the skill set required to oversee the process but may lack the efficiency and unique insight of an M&A specialist. Companies that are exploring the option of a merger or being acquired by another company may also decide to recruit an M&A specialist to prepare their accounting. The organisation will want to ensure they present the correct numbers to get the correct valuation and prevent any delays further in the process if incorrect numbers pop up. Getting on top of the data early can enable CFOs to plan accordingly. Most will want to provide extra time within their strategy for any potential hiccups along the way. Spending more time on the data early on can speed up the process while still ensuring due diligence is met. Visit our website to learn more https://www.fdcapital.co.uk/mergers-and-acquistions-specialist/ Tags Online Events Things To Do Online Online Networking Online Business Networking #finance #insights #cfo #mergers #acquisitions

This 2-day workshop is offered with an internal and external focus. Day 1 will focus on building your internal network and relationships by focusing on your personal network, your brand, influencing skills and perceptions. Day 2 focuses on your external relationships with suppliers, patient groups etc. This will focus on assertiveness, outcome rather than relationship focus, and influencing and negotiating skills. DAY ONE 1 Can you succeed by yourself? 2 Relationship awareness theory 3 The Strengths Deployment Inventory / Your FACET5 profile 4 Building rapport 5 Influencing power bases 6 Active listening 7 Building your personal internal network 8 Perceptions 9 Your brand DAY TWO 3 Preparing for conflict 2 The negotiation conversation 1 Your stakeholders and what they want from you 4 Influencing others 5 Your communication approaches for success 6 Emotional Intelligence 7 The trust model 8 Knowing your outcomes

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning