5755 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.

Course Information Join our comprehensive three-day programme designed as an invaluable external training opportunity for auditors, audit programme managers, and individuals subject to audits. This course is tailored to foster a deep understanding and cultivate essential skills for auditing the validation of computer systems intended for GxP environments (GLP, GCP, GMP, GDP, GPvP). Commencing with an overview of regulatory prerequisites and the system life cycle, the course swiftly transitions to focus on the pragmatic aspects of auditing computer system validation. Experience a blend of presentations, interactive discussions, and immersive practical workshops throughout the duration of the course. Delegates will benefit from practical examples of how to understand the framework of applicable regulations and guidance. Apply risk management techniques to audit planning Plan and conduct computerised system audits Assess system validation documentation to verify compliance Evaluate data integrity and security issues Prepare for regulatory inspection. The course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Understand the vulnerabilities of computerised systems Learn how to create a compliance checklist Link system development with good business practice. Is this course for you? Auditors Audit programme managers Individuals subject to audits. Tutors Tutors will be comprised of (click the photos for biographies): Nichola Stevens Director and Principal Consultant, Nuncius Compliance Solutions Ltd Barry McManus Consultancy Partner, Empowerment Quality Engineering Ltd Programme Please note timings may be subject to alteration. Day 1 09:00 Welcome and Introductions 09:45 Why We Validate and Regulatory Trends 10:30 Break 10:45 Audit Overview, High Level Process and Scheduling 11:30 System Lifecycle 12:30 Lunch 13:15 Exercise 1 - Audit Scheduling 14:45 Exercise 1 - Feedback 15:15 Break 15:30 Validation Deliverables 16:30 Risk Assessments 17:30 Close of Day 1 Day 2 09:00 Supplier Assessment 10:30 Break 10:45 Exercise 2 - Planning a Supplier Audit 12:00 Exercise 2 - Feedback 12:30 Lunch 13:15 Exercise 3 - Auditing a Computerised System Validation Package 15:30 Break 15:45 Exercise 3 - Feedback 16:30 Change Control 17:15 Close of Day Day 3 09:00 Infrastructure Qualification 09:45 Maintaining a Validated State - Operational Processes 11:00 Break 11:15 Exercise 4 - Auditing Systems in Operational Use 12:45 Lunch 13:30 Exercise 4 - Feedback 14:15 Exercise 5 - Auditing Trail Review 15:30 Break 15:45 Exercise 5 - Feedback 16:15 Course Objectives Summary and Any Additional Questions 16:45 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 19 Points Development Level Develop

Whether you're a seasoned professional or just starting your career journey, our courses offer a strategic blend of theory and practical insights that will set you on a path to professional excellence. The Office Administration Certificate, Performance Management, and Leadership & Management Diploma are your stepping stones to success. These courses empower you with essential skills and knowledge that employers value, making you an asset in any business setting. The Office Administration Certificate equips you with the fundamentals of efficient office management, setting you up for administrative roles in various industries. Performance Management helps you become a team leader who can motivate and drive excellence, while the Leadership & Management Diploma prepares you to excel in leadership roles. These skills are not just assets but necessities in today's competitive job market. By enrolling in our Business Administration courses, you're investing in a brighter, more rewarding future, where you can thrive in the dynamic and ever-evolving world of business. Don't miss out on the chance to advance your career and stand out in your field. Enroll now and watch your professional growth soar. This Business Administration Skills for Success Bundle Consists of the following Premium courses: Course 01: Office Administration Certificate Course 02: Performance Management Course 03: Leadership & Management Diploma Course 04: Compliance Training Level 2 Course 05: Business Development Course 06: Financial Analysis Course 07: Business Management Advanced Diploma Course 08: HR Management Level 3 Course 09: Digital Marketing Course 10: Business Analysis Level 3 Course 11: Decision-Making Learning Outcomes Upon completion of this bundle, you should be able to: Master fundamental office administration skills, including organisation, communication, and time management. Develop expertise in performance management principles and practices. Understand regulatory requirements and compliance standards applicable to your industry. Learn strategies and tactics to identify growth opportunities for your business. Master financial analysis techniques to evaluate an organisation's financial health. Embarking on a journey in Business Administration offers a comprehensive and versatile education that equips learners with the skills and knowledge needed to thrive in the modern business landscape. Our range of courses covers a broad spectrum of essential topics, enabling learners to gain a holistic understanding of the field and its significance in today's competitive world. In our Business Administration programmes, learners will acquire a deep understanding of vital concepts such as leadership, performance management, compliance, financial analysis, and marketing strategies. These courses not only equip learners with practical skills but also foster critical thinking and decision-making abilities. The importance of this education lies in its power to prepare individuals for success across various business sectors. Whether you aim to excel in leadership positions, manage financial aspects effectively, or drive business growth through innovative strategies, our courses provide the foundation to make informed decisions and contribute positively to organisational success. In a rapidly evolving business environment, this comprehensive knowledge is invaluable, offering learners a competitive edge and the potential to advance their careers and achieve their professional aspirations. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is tailored for: Individuals who are just starting their career Managers Team leaders Entrepreneurs and business owners Business analysts Requirements No requirements to enrol this Business Administration Skills for Success course. Career path Upon completion, various career opportunities include: Office Administrator (Average Salary: £18,000 to £25,000 per year) Administrative Assistant (Average Salary: £20,000 to £28,000 per year) Team Leader (Average Salary: £30,000 to £45,000 per year) Business Analyst (Average Salary: £35,000 to £65,000 per year) Office Manager (Average Salary: £25,000 to £40,000 per year) Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Office Administration Certificate) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Become a Certified User Experience Professional Build a career in UX with the world’s only university credit-rated online UX course. Acquire the mindset, the skills and the confidence that make UX designers so valuable. A rewarding and meaningful career awaits. Why become a UX designer? Be in demand UX is a high-growth sector. The demand for UX designers far outstrips the supply of qualified professionals. Get well paid UX designers are highly paid. The average entry-level salary for a UX designer in the United Kingdom is £35,465 (PayScale, 2019) Love your job UX designers make an impact. They solve real-world problems using an exciting mix of research, design, technology and psychology. Study method Online, self-paced Duration 6 months Access to content 12 months Qualification Level 8 Diploma - User Experience Design Awarded by Glasgow Caledonian University Regulated by SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description Duration: 6 months Get certified in six months following a flexible, structured learning path. Delivery: Online The course is delivered entirely online, including video modules, mentor-led webinars and support. Assessment: 2-hour exam Before getting certified, you'll be assessed during a two-hour exam taken online. Outcomes for you Think like a UX designer; adopt the mindset that sets them apart Showcase your knowledge with a portfolio of project work Speak with the confidence that comes from a true, deep understanding of UX Advance your career with job-ready skills Complete a university credit-rated course, valued by employers globally Become a Certified UX Professional Learn with us We’ve worked hard to design the best possible online learning experience for you. As well as an unmatched syllabus, our approach includes: Projects & portfolio Learn by doing with a series of real-world projects ideal for your UX portfolio. Mentors & webinars Be guided by our hand-picked, world-class mentors during monthly webinars. Structure & support Stay motivated with a structured programme supported by fellow students and our customer success team. What you’ll learn We’ve put together a university credit-rated curriculum that’s deep, rigorous and covers everything you need to know to become a certified UX professional and turbocharge your career. Module 01 - Introduction to UX design Module 02 - User research Module 03 - User goals Module 04 - Structure and navigation Module 05 - Interactions Module 06 - Design principles Module 07 - Design patterns Module 08 - Mobile Module 09 - Workflows Module 10 - Prototyping and handover Module 11 - AI and UX Module 12 - Creating your portfolio Module 13 - Career guidance Hub Tutorials for Figma Projects and portfolio - Projects that build into a portfolio Exam - 2-hour final exam Requirements Background You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse array of backgrounds, including project management, development, graphic design, product management, business analysis and so on. Commitment You do need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. Our team will be there to support you along every step of the way but success will come as a result of your own diligence. Career path The average salary for entry level user experience designers is £28,000 The average salary for user experience designers with 1-5 years experience ranges from £29,000 to £50,000 The average salary for user experience managers/leads is £80,000 Information from LinkedIn Salary Reports, based on real jobs listings.

Emotional Intelligence Training

Team Management, Leadership, and Time Management Skills for Admin and Document Control In today's dynamic business world, effective time management and team leadership are essential skills that set outstanding administrators apart. UK companies report that inefficiency costs up to 30% of daily working time, highlighting an urgent need for skilled managers and organised administrators. This Team Management, Leadership, and Time Management Skills Bundle equips you with the tools to enhance productivity, lead teams effectively, and manage key tasks in administrative and document control roles. This bundle delves into essential time management, leadership, and administrative skills, laying a strong foundation for success in any professional setting. You'll cover vital topics such as document control, organisation, and conflict resolution to improve both time management and leadership abilities. With specialised sessions in office administration, remote team management, and productivity enhancement, this program is tailored for individuals eager to elevate their professional skills and make a lasting impact in their organisations. Learning Outcomes for the Time Management Bundle: Master essential time management, team leadership, and document control skills. Build a strong foundation in office management, conflict resolution, and organisational skills. Develop the ability to lead remote teams and manage virtual meetings. Increase productivity with modules on time management, performance optimization, and agile methods. Improve decision-making to support leadership and administrative responsibilities effectively. For those aspiring to excel in roles that demand high-level organisation and time management, this course bundle offers a pathway to success. Gain the skills to handle multiple projects, lead confidently, and add meaningful value to your team and organisation. Courses Are Included In This Team Management, Leadership, and Time Management Skills for Admin and Document Control Bundle: Level 7 Diploma in Leadership & Management Level 4 Time Management Executive Secretary & PA Training Level 5 Office Management and Administration Document Control Level 3 Business Administration Minute Taking Performance Management HR and Payroll Management Level 7 Project Management Special Offers of this Team Management, Leadership, and Time Management Skills for Admin and Document Control Course: This Team Management, Leadership, and Time Management Skills for Admin and Document Control Course includes a FREE PDF Certificate. Lifetime access to this Team Management, Leadership, and Time Management Skills for Admin and Document Control Course Instant access to this Team Management, Leadership, and Time Management Skills for Admin and Document Control Course 24/7 Support Available to this Team Management, Leadership, and Time Management Skills for Admin and Document Control Course [ Note: Free PDF certificate as soon as completing the Team Management, Leadership, and Time Management Skills for Admin and Document Control course] Team Management, Leadership, and Time Management Skills for Admin and Document Control This Team Management, Leadership, and Time Management Skills for Admin and Document Control package comprises more than 10 courses covering vital topics like team management, leadership, conflict resolution, and office administration. This training will help you develop the time management and organisational skills needed to excel in administrative and document control roles. Who is this course for? Team Management, Leadership, and Time Management Skills for Admin and Document Control Aspiring team captains, administrators, and office managers. Professionals aiming to improve their time management, leadership, and document control skills. Individuals interested in positions requiring strong time management and organisational skills. Requirements Team Management, Leadership, and Time Management Skills for Admin and Document Control To enrol in this Team Management, Leadership, and Time Management Skills for Admin and Document Control Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Time Management Course Be energetic and self-motivated to complete our Time Management Course. Basic computer Skill is required to complete our Time Management Course. If you want to enrol in our Time Management Course, you must be at least 15 years old. Career path Team Management, Leadership, and Time Management Skills for Admin and Document Control This time management training provides opportunities for a variety of professional vocations, including: Team Manager salaries range from £30,000 to £50,000 per year Administrative Manager salaries range from £28,000 to £45,000 per year Document Control Specialist salaries range from £25,000 to £42,000 a year

Enhance your dental practice's safety and compliance with our 3-hour CPD accredited Dental Practice Legionella Responsible Person Course. Designed for Practice Owners, Registered Managers, and Senior Infection Control Leads, this online course offers expert guidance on legionella management, aligning with HSE ACOP L8, HSG274 Part 2, HTM 04-01, and HTM01-05 standards. Gain advanced understanding and confidence in legionella prevention in dental settings. Receive a GDC-compliant CPD Certificate upon completion. Join our live sessions led by skilled instructors for a transformative learning experience in dental health and safety management.

The Forensic Analysis Bootcamp is an 8-week deep-dive into forensic equity analysis, featuring a 90-minute Zoom workshop each week. The content includes extensive use of real-life case studies and covers stocks spanning a wide range of sectors and regions. You will learn how companies manipulate expenses and inflate profits, how to spot balance sheet issues, weaknesses of the cash flow statement and issues and more.

2 QLS Endorsed Courses | CPD Certified | Free PDF & Hard Copy QLS Certificates | 180 CPD Points | Lifetime Access

ADVANCED 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! This course theory will help you to understand: We will cover all you need to know in order for you to treat your patients confidently and safely. The Theory will cover; Anatomy and physiology Ageing Characteristic of the ideal skin booster Product Introduction Treatment Method Contraindication Complication management Pre & Post-treatment advices Using Products like Toskani, Skinecos, Jalupro etc. Using Products , PROFHILO, recommended for midd and low part of the face as well as other delicate areas of skin such as the neck, décolletage, hands or knees. Practice will enable you to learn in 1-day ONE-TO-ONE Training We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. A certification of hands-on training will be provided upon completion of the course. You will perform this procedure on live models injecting superficially and administrating the product (skinbooster) into the subcutaneous layer. This will happen under the supervision and guidance of highly experienced aesthetic practitioners. You will practice injectables with needle on; Face, Neck, Decolatege & Hands You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL INTERMEDIATE | Advanced Course