1637 Courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

This complete training program comprising levels 1 and 2 is divided into multi-sequential sections to let you gain comprehensive knowledge and understanding of SQL and data analysis. This two-level course is designed to kickstart your SQL knowledge and perform various data analysis tasks and implement SQL in projects independently and efficiently.

Unlock the world of web development with our comprehensive course! Whether you are a beginner or looking to enhance your coding skills, our masterclass will take you on an exciting journey. A project-based course that will help you learn and implement HTML, CSS, and JavaScript. With hands-on experience, you will design web pages, add interactive elements, and create a polished final project. Gain practical skills, optimize your coding workflow, and create professional web applications.

Learn how to work with data using Python (the coding language) as a tool. Learn how data is structured and how to manipulate it into a usable, clean form ready for analysis. Work on a small real-life project from conception to solution, in a team or on your own.

In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Course Category Inclusion Description In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Testimonials ‘Inclusive practice has become more daring, more radical, more inspirational, more inclusive. How exciting and encouraging!’ ‘What a moving and energising day – there is so much we can do together’ Learning Objectives Increased confidence regarding developing leadership for inclusive practice in mainstream schools Access to a wider range of practical strategies to impact on team building Deeper understanding of developing vision and consensus Opportunity to reflect on professional attitudes and behaviour towards staff, parents and pupils New skills and processes to make inclusion successful Who Is It For? Heads and Deputies Leaders Managers of Chidren’s Centres Managers of Early Years settings Local Authority Support Services Course Content The course answers the questions: How to get a team thinking and working more inclusively? How to create and share my vision? Where do I start to think about developing a more inclusive setting? How can I get the best out of my team? We will cover a range of areas including: Establishing a welcoming team Building Vision and values Developing Trust Creating inclusive staff teams and communities of acceptance Creative Team problem solving Organisational models Curriculum access and curriculum design for inclusion Work with parents Consensus building If you liked this course you may well like: LEADERSHIP: CREATING AND SHARING YOUR VISION

Unlock the power of coding with our all-inclusive Ruby course. Whether you're starting from scratch or elevating your programming skills, this course is tailored for a seamless learning curve in Ruby 3.2.

https://www.valuex2.com/agile-hr-certification/ https://www.linkedin.com/company/80563537/

Description The evolution of our minds over the last hundred thousand years was to ensure we survived in a world of danger. Our four essential needs were food, water, shelter and sex to continue the species. Now we worry about losing our jobs, being rejected, getting a speeding ticket, embarrassing ourselves in public, and so many weird reasons. Now Happiness can be described as feeling good. In this How to Be Happy in the Modern World you will learn to follow your heart, work out what your values are, what you stand for, and live by those values, set goals guided by your values, and more. you will be able to reduce your stress and will learn to keep satisfied what you have at the moment. What Will I Learn? Reduce stress through meditation Find joy in their everyday lives Apply techniques to increase long term happiness Reduce general anxiety about the future Reduce anxiety about money Increase happiness for themselves and those around them Requirements Students simply need to be open to knew ways of thinking   Who is the target audience? Anyone who wants to be happier and less stressed in their lives Introduction Why We Need to Re-Evaluate Our Lives FREE 00:05:00 How to Reduce Stress Why Is Everyone So Stressed? FREE 00:11:00 Anti-stress Visualization Exercise 00:05:00 How Can We Reduce Our Anxiety About Money? 00:17:00 The Problem with Modern Culture and What to do About It 00:15:00 Culture Focused Visualization Exercise 00:05:00 How to Increase Happiness Why Are People Often Happier in Poor Countries? 00:18:00 Gratitude Visualization 00:04:00 Why is the Present Moment the Most Important Moment? 00:07:00 Present Moment Visualization Exercise 00:04:00 The Attitude Adjustment that will Change Your LIfe 00:07:00 Attitude Visualization Exercise 00:02:00 How to Optimize Your Life Priorities for Maximum Happiness 00:08:00 Happiness Visualization Exercise 00:03:00 The True Power of Exercise 00:07:00 Increase Motivation Visualization Exercise 00:02:00 How to Live with Purpose A Secret to Start Living Life with Purpose Right Now 00:14:00 Living with Purpose Exercise 00:04:00 Conclusion and BONUS MATERIAL Conclusion and BONUS Material 00:05:00

Protect your community and workplace from radicalisation with our comprehensive course - Effective Responses to Radicalisation Threats. Learn how to prevent, promote and respond to radicalisation with our 7 modules, including engaging with families and tackling criticism of the Prevent Act. Get equipped with specific skills to ensure a safer society today! Learning Outcomes: Develop a deep understanding of preventing radicalisation in childcare and childcare providers. Gain knowledge and strategies for promoting British values effectively. Acquire a comprehensive understanding of prevent responsibilities and their implementation. Learn how to fulfill the prevent duty for local authorities and partner agencies. Develop the skills to respond appropriately to concerns related to radicalisation. Gain insights into engaging and working with families confronted with radicalisation challenges. Equip yourself with the knowledge and skills to effectively respond to radicalisation threats with our comprehensive Effective Responses to Radicalisation Threats course. Designed to provide a theoretical understanding of the topic, this course offers a practical approach to tackling radicalisation. With seven modules covering various aspects, including prevention strategies in childcare, promoting British values, and responding to concerns, this course is an essential resource for anyone concerned about the safety and security of their community. Gain insights into engaging with families confronted with radicalisation challenges and address criticisms of the Prevent Act. Join our course today and contribute to a safer society. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Effective Responses to Radicalisation Threats course is perfect for: Childcare providers and professionals working in childcare settings. Individuals responsible for promoting British values. Professionals in local authorities and partner agencies. Anyone concerned about radicalisation threats and wanting to respond effectively. Career path This Effective Responses to Radicalisation Threats course will be helpful for anyone looking to pursue a career as: Prevent Officer: £26,000 - £40,000 per annum. Community Engagement Officer: £22,000 - £30,000 per annum. Policy Advisor: £30,000 - £45,000 per annum. Youth Worker: £18,000 - £30,000 per annum. Education Consultant: £30,000 - £50,000 per annum.

Students who complete PVOL203 will be able to: Recognize demand and PV production curves Identify the common types of PV systems and their major components Describe DC and AC coupled systems Discuss load profiles and modes of operation, including: peak load shaving, time-of-use, zero-sell, self-consumption prioritization, demand-side management Introduce utility-scale storage and microgrids Explain the relationship between real power, apparent power, and reactive power Complete a load estimate for different system types and for seasonal loads; evaluate electrical requirements of loads Identify phantom loads and efficiency upgrades Estimate starting surge and power factor requirements Describe the differences when sizing battery-based systems compared to grid-direct systems Choose a peak sun hour value based on design criteria for various systems Review battery basics and terminology Describe and compare different battery chemistries and technologies Find the capacity and voltage of different batteries; determine state of charge List safety precautions and hazards to be aware of when working with batteries; list appropriate personal protective equipment (PPE) Identify appropriate battery enclosures Calculate values for current, voltage, and energy for different battery bank configurations Review battery bank design parameters Complete a lithium-ion battery bank design example Review and compare different design example costs List features, options, and metering available for different types of battery chargers Explain basics of lithium battery charging Compare generator types and duty cycle ratings, including fuel options Identify specifications critical for choosing appropriate battery-based inverters Discuss different overcurrent protection devices and equipment disconnects and when/where they are required Define the maximum voltage drop slowed for the proper functioning of a battery-based PV system Identify safe installation procedures List basic commissioning tests which should be completed before and after a system is operating