26305 Courses in Manchester delivered Online

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Delve into the fascinating world of nutrition and its profound impact on human health with the 'Introduction to the Role of Nutrition in Human Health' course. This comprehensive exploration is divided into six modules, starting with the fundamentals of nutrition and health, progressing to a deep dive into macronutrients and micronutrients, and concluding with the application of nutrition principles across the lifespan. By the end of this course, you'll have a solid understanding of the vital connection between nutrition and overall well-being. Learning Outcomes: Grasp the foundational concepts of nutrition and its significance in maintaining health. Analyze macronutrients and their pivotal roles in the human body. Explore the benefits of vitamins and their impact on various bodily functions. Understand the essential role of minerals in human nutrition. Apply nutrition principles to enhance fitness and overall health. Investigate nutrition requirements and recommendations across different life stages. Gain insight into dietary planning for specific health goals. Evaluate the role of nutrition in preventing and managing chronic health conditions. Why buy this Introduction to the Role of Nutrition in Human Health?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Introduction to the Role of Nutrition in Human Health you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Introduction to the Role of Nutrition in Human Health course is ideal for Individuals interested in understanding the connection between nutrition and health. Health enthusiasts looking to optimize their nutrition choices. Students pursuing studies in nutrition and dietetics. Healthcare professionals seeking to expand their knowledge of nutrition. Prerequisites This Introduction to the Role of Nutrition in Human Health was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Registered Dietitian: £25,000 - £40,000 per year. Nutrition Consultant: £30,000 - £50,000 per year. Nutrition Educator: £25,000 - £45,000 per year. Clinical Nutritionist: £30,000 - £55,000 per year. Health and Wellness Coach: £20,000 - £40,000 per year. Course Curriculum Module 1: Introduction to Nutrition and Health Introduction to Nutrition and Health 00:12:00 Module 2: Macronutrients - Nutrients in Food and Their Role in Health Macronutrients - Nutrients in Food and Their Role in Health 00:14:00 Module 3: Micronutrients - Benefits of Vitamins Micronutrients - Benefits of Vitamins 00:14:00 Module 4: Micronutrients - Introduction to Minerals Micronutrients - Introduction to Minerals 00:18:00 Module 5: Nutrition in Fitness and Health Nutrition in Fitness and Health 00:17:00 Module 6: Nutrition through Life Nutrition through Life 00:12:00

Mobile IP training course description A detailed examination of the protocols and architecture of Mobile IP. What will you learn Recognise the benefits of ADSL. Configure and troubleshoot IS-IS. Explain how IS-IS works. Describe the use of Level 1 and Level 2. Design IS-IS networks. Mobile IP course details Who will benefit: Technical staff wanting to learn DNS.Network Administrators. Support personnel. Prerequisites: TCP/IP Foundation Duration 2 days Mobile IP course contents Introduction Quick review of IP, What is Mobile IP? What Mobile IP provides, Mobility requirements, Where Mobile IP is required, where mobile IP is not required, DHCP as an alternative, Proxy ARP as an alternative. Architecture Mobile node, home network, home agent, Foreign agent, Fixed home address, Care of address, Correspondent node, Tunnelling. How Mobile IP works Using two addresses, issues with TCP, discovering the care of address, registering care of address, tunnelling the care of address. The protocols involved. Issues with Mobile IP Routing inefficiencies, Security and firewalls, ingress filtering, QoS. MIP and IPv6 Stateless address configuration, Neighbour discovery, miscellaneous.

STP alternatives training course description The Spanning Tree Protocol (STP) dates from 1985. This course explores the technologies that can be used as an alternative to STP, including FabricPath, SPB and TRILL. What will you learn Explain how STP and RSTP work. Explain how TRILL works. Explain how SPB works. Explain how FabricPath works. STP alternatives training course details Who will benefit: Technical network staff. Prerequisites: Definitive Ethernet switching for engineers Duration 1 day STP alternatives training course contents Introduction Layer 2 versus Layer 3, STP problems: One path, convergence, MAC explosion, STP alternatives. STP 802.1D, how STP works, root bridge, convergence times, single path. RSTP 802.1w, Improvements, convergence times. Link aggregation 802.3ad, Multi system Link aggregation. IS-IS Concepts, Discovery, topology exchange, flooding. Changes for TRILL, FabricPath and SPB. FabricPath Overview, architecture, control plane protocols, DRAP, STP interactions, packet forwarding, configuration. TRILL Concepts, RBridge, TRILL frames, control plane, data plane, learning MAC addresses. SPB 802.1aq, Node ID, Backbone Edge Bridges, Backbone MAC address, customer MACs, I-SID, forwarding database.

Test-Driven Development - A Stunningly Quick Introduction "The job of QA is not just to do testing it's to build quality in.How often have you heard that sentence? And how often has it been followed up with solid practices for actually building quality in? Test-Driven Development (TDD) is one of the foundational practices of high-quality product development. Popularized nearly 20 years ago, TDD is an important skill for high-quality software development. If you want it to be easier to build high-quality code, then you need to understand TDD. In this hands-on session, we'll learn by doing. Richard will facilitate a coding dojo, a safe place to learn and practice the skills of test-driven development. We'll mob-program together on a coding kata - an easy programming problem - to learn TDD, refactoring, clean code, code smells, and more - all in the pursuit of technical agility, business agility, and a great product that people love. To follow along, bring your laptop and development environment. You'll leave with an introduction to solid new skills, including: Test-driven development (TDD) Extreme Programming (XP) Refactoring and refactoring patterns Code smells Mob programming

Definitive 802.1X training course description A hands-on training course concentrating solely on 802.1X. Hands on sessions follow major chapters to reinforce the theory. What will you learn Describe 802.1X. Explain how 802.1X works Configure 802.1X Troubleshoot 802.1X. Definitive 802.1X training course details Who will benefit: Technical network staff. Technical security staff. Prerequisites: SIP for engineers Duration 2 days Definitive 802.1X training course contents Introduction What is 802.1X? Authentication access, 802.3, 802.11. IEEE, 802, 802.1X-2001, 802.1X-2010. Architecture Supplicant, Authenticator, Authentication server, EAP, EAPOL, RADIUS, Diameter. Port configuration 802.1X in a switch environment. Hands on Configuring 802.1X. How it works Controlled ports, uncontrolled ports. Authentication flow chart, Initialisation, initiation, negotiation, authentication. Hands on 802.1X packet analysis. 802.1X and 802.11 WiFi, WiFi security. Hands on 802.1X WiFi port access. EAP Extensible Authentication Protocol, RFC 3748, RFC 5247. EAP methods: Weak, MD5, LEAP, Strong: TTLS, TLS, FAST. Encapsulation: 802.1X, PEAP, RADIUS, Diameter, PPP. 802.1X accounting RADIUS, accounting messages, 802.1X accounting AV pairs. 8021.X and VLANS VLANs, Guest VLAN, restricted VLAN, voice VLAN. Hands on VLAN assignments with 802.1X.

The Introduction to the UK Health System for Health Care Managers is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Introduction to the UK Health System for Health Care Managers consists of several modules that take around 2 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Introduction to the UK Health System for Health Care Managers Introduction to the UK Health Systems 00:20:00 Changes Since Devolution 00:45:00 Lessons and Opportunities 01:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

This course provides an in-depth exploration of digital marketing's evolution, illuminating the significance of performance marketing in today's competitive landscape. Participants will gain insights into key metrics and KPIs crucial for optimizing marketing efforts and driving tangible outcomes. After the successful completion of the course, you will be able to learn about the following:⦁ Overview of digital marketing and its evolution.⦁ Understanding performance marketing and its importance.⦁ Key performance marketing metrics and KPIs. Dive into the world of performance marketing, unraveling the intricacies of targeted advertising, conversion tracking, and campaign optimization. Learn to harness data-driven insights to maximize ROI and elevate brand performance across digital platforms. Introduction to Performance Marketing equips learners with essential tools and techniques to navigate the dynamic realm of digital marketing. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Performance Marketing Self-paced pre-recorded learning content on this topic. Introduction to Performance Marketing Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Performance Marketing Analyst Digital Advertising Specialist Conversion Rate Optimization Manager Marketing Data Scientist Campaign Performance Strategist Digital Marketing Metrics Manager ROI Optimization Consultant Performance Marketing Manager Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

This course provides a comprehensive introduction to foodborne viruses, focusing on their properties, transmission, and impact on food safety. Designed for professionals at all levels, it covers detection methods, contamination risks, and prevention strategies to help businesses mitigate viral threats in food supply chains. Delivered by an industry expert, the course includes an interactive Q&A session for deeper insights. No prior knowledge is required.

🌟 Unlock the Power of Online Transactions with 'Introduction to PayPal Basics' Course! 🌟   Are you ready to harness the convenience and potential of secure online payments? Dive into the world of digital transactions and elevate your financial prowess with our comprehensive 'Introduction to PayPal Basics' course!   🚀 Transform Your Payment Experience: Learn the ins and outs of PayPal, the globally trusted platform for seamless online transactions. Whether you're a budding entrepreneur, an established business owner, or simply looking to navigate the digital landscape effortlessly, this course is your gateway to mastering PayPal's essential features and functionalities.   💡 What You'll Gain: 🔹 Understanding PayPal's Interface: Navigate with ease and confidence through PayPal's user-friendly interface. 🔹 Setting Up Your Account: From personal to business accounts, discover step-by-step guidance on establishing your presence on PayPal. 🔹 Sending and Receiving Payments: Learn the art of sending invoices, requesting funds, and accepting payments hassle-free. 🔹 Security Measures: Safeguard your transactions with best practices in PayPal's security protocols. 🔹 Exploring Additional Features: Uncover advanced functionalities like currency conversion, refunds, and managing disputes.   👨‍🏫 Expert Guidance, Anytime, Anywhere: Led by industry experts, this course offers engaging video tutorials, practical demonstrations, and insightful resources. Access the materials at your convenience, fitting your learning into your busy schedule.   🎓 Who Can Benefit? 🌐 Entrepreneurs venturing into the online marketplace 🏢 Small business owners seeking efficient payment solutions 👩‍💻 Freelancers and professionals navigating digital transactions 💼 Individuals aiming to streamline personal online payments   🌈 Embrace the Future of Transactions: Join us on this enlightening journey and unlock the potential of PayPal. Say goodbye to transactional hassles and embrace the future of seamless online payments! Enroll now in the 'Introduction to PayPal Basics' course and embark on your journey towards financial efficiency and confidence in the digital realm! Sign up today to start your PayPal mastery! 💳💻✨ Course Curriculum Basic Overview 00:00 Account Fees and Account Types 00:00 Terms of Service 00:00 Account Opening 00:00 Profile Account Settings - Part 1 00:00 Proifle Account Settings - Part 2 00:00 Profile Account Settings - Part 3 00:00 Funding Account Set Up 00:00 Profle Account Settings - Part 5 - Setting Up Payment Preferences 00:00 Adding Funds To Your Paypal Account 00:00 Requesting Funds Through PayPal 00:00 Transferring Funds Through PayPal 00:00 Sending Funds With PayPal 00:00 Mobile App Set Up 00:00 Making Payments With PayPal 00:00 Business Set Up - Sending Invoices 00:00 Business Set Up - Selling on a Marketplace 00:00 Business Set Up - Selling On Your Website 00:00 Getting Help From PayPal 00:00 Conclusion 00:00 Advanced Overview 00:00 Set Up Paypal Here 00:00 Set Up PayPal Buttton - Part 1 00:00 Set Up Paypal Button - Part 2 00:00 Set Up PayPal Button - Part 3 00:00 Setting Up Funnels With PayPal 00:00 PayPal and Autoresponder Integration 00:00 PayPal and Other Autoresponders 00:00 Direct Connection to Webinars - Zoom 00:00 Direct Connection to WordPress 00:00 Direct Connection to Membership Platforms - Part 1 00:00 Direct Connection to Membership Platform - Amember 00:00 Integration with Zapier 00:00 Integration To Autoresponder Through Zapier 00:00 Integration To GoToWebinar Through Zapier 00:00 Live Example - Create A Subcription Product 00:00 Live Example - Integrate wtih WordPress 00:00 Live Example - Integrate with Autoresponder 00:00 Live Example - Integrate with Webinars 00:00 Conclusion 00:00