2625 Courses delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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.

Our Student Visas & Other Routes course is a half-day course dedicated to those who want to develop a better understanding of student routes available in the UK. Course Overview:  Our Student Visas & Other Routes course is a comprehensive half-day training course dedicated to providing you with a better understanding of student routes in the UK. This highly requested course has been meticulously designed to offer invaluable insights into the various student visa options available. During the training, we will cover a range of crucial areas. This includes a comprehensive overview of different routes available for students, such as the Tier 4 visa and the Graduate visa. You will gain a deep understanding of the specific requirements for student visas and the suitability criteria for each route. Additionally, our course will address what happens when a student visa is nearing its end, providing you with valuable insights into the options and procedures available during this crucial phase.   The course will cover: Different routes available for students such as the Tier 4 visa and the Graduate visa Student visa requirements Suitability What happens once a student visa is coming to an end. Any updates to student visas when they are announced.   Course joining links, materials and instructions are sent out 24hours before the course starts.

This workshop equips employees to recognise and respond to signs of suicidal intentions. Participants will learn about the causes of suicidal thoughts and gain tools to help individuals stay safe.

Embodiment workshops

Overcoming Anxiety with NLP is a three hour online workshop with Accredited Trainer of NLP and Clinical Hypnotherapist Paul McGowran of proactivenlp.com. During the workshop Paul will take delegates through understanding how to resolve their own anxiety using NLP thinking and techniques. You can live a life without anxiety, sign up now.

Details This course is aimed at Water and Wastewater managers, field managers, asset managers and others involved in meeting compliance within the Water industry. As Wastewater Treatment compliance now comes under increasing regulatory scrutiny from OFWAT the overall ability of the Water Industry to effectively oversee and manage the Wastewater Treatment process comes under sharper focus. Demonstrating the competence of those responsible will likely become increasingly the focus of public awareness and form a key strand of the regulator’s investigation. Main themes Demonstrate an understanding of the current regulatory framework pertaining to pollution incidents Understand the sources of pollution Understand pollution risks specific to the Water and Wastewater industry Critically analyse the stakeholders’ views of pollution from the Water and Wastewater industry Understand the importance of stakeholder communication, feedback and involvement in the context of pollution incidents Understand the impact of pollution in terms of the environment, customers, cost, H&S and from the regulatory perspective Describe the cumulative effect of point source and diffuse sources of pollution Describe and explain the collective responsibilities and ethical and moral issues as pertaining to pollution incidents Critically evaluate the use of internal systems and mechanisms for delivery of pollution risk reduction strategies Develop a pollution risk reduction strategy appropriate to your organisation. Instructions This online course will be delivered using CISCO Webex. You will need a suitable device with a camera and microphone like a laptop. If you have any questions about what is required, please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.

Learn how to design and customize a perfect fitting sweater using DK or 4ply/fingering weight yarn. From layout and shape to color placement and professional finishing, this 12-week course will guide you through every step with personalized assistance from expert crochet tutor, Merrian. You'll also be part of a small community of crochet students, all making the sweater together over the 12 weeks.

Travel and Parking arrangements: Paid parking is available (attendees are responsible for paying parking fees) From New St Station, follow signs to Moor St station. When you get to Moor St, go down the hill to the side of the station towards the multi-storey car park. At the car park, go left under the railway bridge. Immediately after the railway bridge turn right onto Shaw's passage, which is quite short. We're on the corner at the end of Shaws Passage - walk round the corner onto Allison Street and past the Cafe to the full glass door with the Birmingham Friends of the Earth hanging sign.

Travel and Parking arrangements: Paid parking is available (attendees are responsible for paying parking fees) From New St Station, follow signs to Moor St station. When you get to Moor St, go down the hill to the side of the station towards the multi-storey car park. At the car park, go left under the railway bridge. Immediately after the railway bridge turn right onto Shaw's passage, which is quite short. We're on the corner at the end of Shaws Passage - walk round the corner onto Allison Street and past the Cafe to the full glass door with the Birmingham Friends of the Earth hanging sign.