31033 Development courses

Harness the energy is an explorative workshop introducing the notion of utilising and intuitively listening to the energy shared between a group of people. Whether we realise it or not, we all give off certain energies at any time. These energies can affect change, sometimes positively, sometimes negatively. This workshop enhances understanding of the power of our own energy transmissions through the use of complicité-based theatre techniques and exercises. This workshop will help participants become active and aware listeners, able to work better collaboratively to produce strong results. It will demonstrate the power of our own individual energy and the positive impact we can have when we learn to utilise the energy beneficially in different situations.

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers 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. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

Are you ready to explore the depths of your EGO? Join us at Lekdanling - Tibetan Cultural Centre for a FREE course & meditation workshop on 12th of March to learn how to expand your heart and gain insight into the ways of the EGO. Don't miss out - sign up now! #WaysOfTheEGO #Meditation #ExpandYourHeart

Artificial Intelligence (AI) is the most disruptive technology since the internet came onto the scene. AI is transforming every aspect of how we manage projects from developing a business case, to planning the work, managing risk, and tracking performance. Because the technology and market are moving so fast, it can be difficult to know how to start using AI on projects. Generative AI for Project Management will engage you with diverse Generative AI tools to start, plan, and manage either your own project or a generic case study. We will embrace a tool agnostic approach to adopting, integrating, and scaling Generative AI without compromising data or trust. You will have hands-on practice utilizing AI tools to optimize your time and your outcomes. You will be accessing a variety of AI tools requiring you to register for a free account. A computer is required for all traditional classroom deliveries. None At the end of this program, you will be able to: Define essential terms and concepts related to artificial intelligence (AI) Illustrate how prompts facilitate interaction with Generative AI Recognize the capabilities of Large Language Models Craft prompts to develop project origination documents Create prompts to assist in planning a project Develop user stories with Generative AI Analyze project performance using Generative AI Identify the limitations of Generative AI Identify the risks associated with using Generative AI Articulate the need for governance and ethics when establishing an AI program in an organization Course Overview Getting Started Foundation Concepts Understanding essential terms and concepts related to AI Exploring various Generative AI Models Understanding Prompts Creating Prompts for Project Startup Prompts for starting a project Prompts for planning a project Best Practices for prompt engineering Creating Prompts for Managing Projects Creating agile user stories Measuring project performance Analyzing a schedule Using Generative AI Responsibly Limitations of AI Models Establishing an AI governance framework Future trends and next steps Summary and Next Steps

Duration 1 Days 6 CPD hours This course is intended for This course is intended for anyone engaged with teams or looking to live a more fulfilling life. Overview Upon successful completion of this course, participants will gain a new perspective on themselves and their emotions, and increase their value to society. In this course, participants will learn how beneficial becoming more self-aware can be and see how a highly self-aware person becomes more equipped to deal with daily life and its challenges. Getting Started Workshop Objectives Action Plan What is the Self? The Physical Self The Emotional Self The Mental Self The Spiritual Self Practical Illustration Awareness of the Physical Self Scanning Progressive Relaxation Physical Stressors Exercise Practical Illustration Time Management Organization Goal Management Priorities Procrastination Practical Illustration The Emotional Self Validity of Emotions Utility of Emotions Emotional Arousal Emotional Valence Practical Illustration Mood Management Emotional Intelligence Categories of Emotion Increasing Arousal Decreasing Arousal Practical Illustration The Mental Self Thinking Style Learning Style Personality Stinking Thinking Practical Illustration Interpersonal Awareness Addressing Different Thinking Styles Addressing Different Learning Styles Active Listening and Body Language Transactional Analysis Practical Illustration The Spiritual Self Mindfulness Meditation Cultivating Positivity Gratitude Practical Illustration Limitations of Self Awareness Navel Gazing Excessive Self Discipline Developing Humility Developing Empathy Practical Illustration Independence versus Interdependence What is Interdependence? Systems Theory More Than the Sum of All Parts Team Building Practical Illustration Wrapping Up Words from the Wise Additional course details: Nexus Humans Improving Self Awareness 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 Improving Self Awareness 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.

Who would find this course useful? This course excellent for beginners who would like to enter the programmer world via C#. Or for individuals have a particular need for C# Level: A good start for beginners through to intermediate with OOP. Practical confidence will be achieved with a very practical approach to the training. This is normally online, but onsite and classroom courses are also available on request

Free *Understanding Social Anxiety* workshop will teach you: a) What Social Anxiety is; b) 6 main aspects that keep it going.

*Understanding Worry* is a FREE, interactive, hands-on workshop, focused on helping you understand uncontrollable, excessive worrying.

An online mental health awareness training course that is designed to support you to have confident conversations with xxxx,xxxxx & colleagues who have and are showing early signs and symptoms of mental health problems.

Overview   With the ever-increasing demand for Self Esteem in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Self Esteem may be.   Learning about Self Esteem or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Self Esteem. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Self Esteem is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Improving Self Esteem course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Improving Self Esteem course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Improving Self Esteem course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Self Esteem, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Self Esteem, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Self Esteem, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Improving Self Esteem course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Chapter 1 Be Optimistic Be Optimistic 00:00 Chapter 2 It's All in Our Mind It's All in Our Mind 00:00 Chapter 3 Overcoming Negative Thinking Overcoming Negative Thinking 00:00 Chapter 4 Achieving Your Goals Achieving Your Goals 00:00