11077 Courses in Liverpool 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 Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Functional Skills English Level 2 course is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Functional Skills English Level 2 Course for? This Functional Skills English Level 2 course is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Functional Skills English Level 2 Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result The UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Functional Skills English Level 2 Module 01: Linguistics 00:42:00 Module 02: Teaching Grammar and Vocabulary 00:34:00 Module 03: The Basics of Sentence 00:08:00 Module 04: Structure of Sentence 00:16:00 Module 05: Question 00:11:00 Module 06: Punctuation & Capitalisation 00:21:00 Module 07: Spelling 00:24:00 Module 08: English Pronunciation 00:29:00 Module 09: Teaching Receptive Skills: Reading 00:17:00 Module 10: Teaching Productive Skills: Writing 00:15:00 Module 11: Teaching Receptive Skills: Listening 00:16:00 Module 12: Teaching Productive Skills: Speaking 00:14:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Learn how to scan content for grammatical errors and check readability, with this professional proofreading and copy editing training course. In the Diploma in Proofreading & Copy Editing at QLS Level 5, you will learn how to check content on paper and on-screen for errors before it is published, taking you through the professional guidelines and techniques. You'll also get tips on how to find work and develop your career. The Diploma in Proofreading & Copy Editing at QLS Level 5 has been designed by experts in the industry to provide learners with the best learning experience. You will gain valuable insight into the role and responsibilities of the role of proofreader and copyeditor, with skills that are essential for content creation. Why buy this Diploma in Proofreading & Copy Editing at QLS Level 5? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this course for? This Diploma in Proofreading & Copy Editing at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Diploma in Proofreading & Copy Editing at QLS Level 5 is a great way for you to gain multiple skills from the comfort of your home. Prerequisites This Diploma in Proofreading & Copy Editing at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 1: Proofreading Basics Proofreading Basics 00:25:00 Module 2: Applying the Style Guide Applying the Style Guide 00:20:00 Module 3: Spelling and Grammar Spelling and Grammar 00:15:00 Module 4: Proofreading on Paper Proofreading on Paper 00:25:00 Module 5: Proofreading On-Screen Proofreading On-Screen 01:00:00 Module 6: Copy-Editing Basics Copy-Editing Basics 01:00:00 Module 7: Copy-Editing - The Use of Language Copy-Editing - the Use of Language 00:45:00 Module 8: Copy-Editing - Checking Accuracy and Facts Copy-Editing - Checking Accuracy and Facts 00:15:00 Module 9: Copy-Editing - The Beginning and The End Copy-Editing - the Beginning and the End 00:15:00 Module 10: Copy-Editing - Legal Checks Copy-Editing - Legal Checks 00:30:00 Module 11: Finding Work and Developing Your Career Finding Work and Developing Your Career 00:20:00 Mock Exam Mock Exam - Diploma in Proofreading & Copy Editing at QLS Level 5 00:20:00 Final Exam Final Exam - Diploma in Proofreading & Copy Editing at QLS Level 5 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

The Diversity and Inclusion Accelerator is designed for accelerating your D&I program and enhancing your skills on this topic. This one-day course takes a deeper look at the state of diversity and inclusion (D&I) in today's organizations, where it can be improved, and the attitudes required for success.

For anyone who has to deliver presentations who wants to become more confident and improve their speaking skills.

Learn to use cutting-edge language models ChatGPT, Dalle-2, and Midjourney to create high-quality written content and generative art in this course. Discover how to fine-tune these models for specific tasks and explore the ethical implications and future-proofing strategies for using AI in your work.

Body Language Masterclass Communication Through Movement Course Overview This "Body Language Masterclass: Communication Through Movement" provides an in-depth exploration of non-verbal communication, offering insights into how body language influences interactions and relationships. Learners will understand the importance of body movements, facial expressions, posture, and gestures in communication. The course is designed to enhance communication effectiveness in personal and professional settings, focusing on recognising and using non-verbal cues to convey messages more clearly. By the end of the course, participants will be equipped with the skills to interpret and utilise body language to improve their interpersonal interactions, boosting confidence and enhancing professional communication. Course Description In this course, participants will delve into the key elements of non-verbal communication, learning how body language affects our daily interactions. Topics include understanding the nuances of gestures, posture, and facial expressions, as well as their role in business settings. The course covers the importance of non-verbal communication in forming impressions, creating rapport, and enhancing leadership skills. Additionally, learners will examine how to use body language effectively in the digital world. Through engaging lessons, participants will develop essential skills in recognising non-verbal cues and improving their communication style. This course is suitable for individuals seeking to elevate their communication abilities and build stronger, more authentic connections in both personal and professional contexts. Body Language Masterclass Communication Through Movement Curriculum Module 01: How You Communicate Nonverbally Through Your Body Module 02: Reading and Understanding Non-Verbal Communication Module 03: The Importance of Non-Verbal Communication in Business Module 04: Improving Your Non-Verbal Communication Skills Module 05: Branding Yourself Non-Verbal Communication Module 06: Branding Yourself in the Digital World Through Non-Verbal Communication Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their communication skills. Professionals aiming to enhance their interpersonal interactions in the workplace. Beginners with an interest in understanding body language. Those who want to build stronger personal and professional relationships. Career Path Corporate Communication Specialist HR and Recruitment Professional Marketing and Branding Specialist Leadership and Management Roles Customer Service Manager Media and Public Relations Expert

Overview All leading companies that produce content of any kind need experienced Proofreaders and Copy Editors. Become trained in this profession and secure rewarding roles. This Level 3 Proofreading and Copy Editing Course is designed to train you quickly in all the abilities needed to perform quality control and amendments ahead of publishing. No manual, book, magazine, website, brochure, or business letter is sent out to an audience without Proofreading. This course will prepare you for a lucrative and satisfying career in this fascinating area of business. You will be expertly trained to check, edit, and adapt the text to the highest of standards and earn yourself a substantial reputation. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Level 3 Proofreading and Copy Editing Course. It is available to all students, of all academic backgrounds. Requirements Our Level 3 Proofreading and Copy Editing Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 12 lectures • 05:30:00 total length •Proofreading Basics: 00:25:00 •Applying the Style Guide: 00:20:00 •Spelling and Grammar: 00:15:00 •Proofreading on Paper: 00:25:00 •Proofreading On-Screen: 01:00:00 •Copy-Editing Basics: 01:00:00 •Copy-Editing - the Use of Language: 00:45:00 •Copy-Editing - Checking Accuracy and Facts: 00:15:00 •Copy-Editing - the Beginning and the End: 00:15:00 •Copy-Editing - Legal Checks: 00:30:00 •Finding Work and Developing Your Career: 00:20:00 •Assignment - Level 3 Proofreading and Copy Editing Course: 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course is designed for all project managers and project team leaders. This class is intended for PMP?s looking to earn PDU's, or for Project Managers looking to learn more about Project Team Leadership techniques. Project success depends on choosing, motivating, and leading the project team. This course focuses on improving the project manager?s human resource expertise, from initial planning through project closure. Participants will apply all course principles to a work-related case study taken directly from their work environment. At course completion, students will be able to develop a human resource plan, acquire optimal team members, develop and motivate team members, and manage team members to accomplish project goals. NOTE: This course will earn you 14 PDUs. 1 - Project Teams Overview Project Human Resource Management Project Human Resources Management Processes Case Study Selection 2 - Develop Human Resource Plan Plan Human Resource Management Roles and Responsibilities Project Organizational Chart Staffing Management Plan Resource Histogram 3 - Acquire Project Team Acquire Project Team Overview Multi-Criteria Decision Analysis Acquire Contract Resources Optimize Virtual Teams Best Practices Social Identity Theory Virtual Teams and Social Identity Theory Team Building Activities for Virtual Teams Cultural Diversity Individualism and Communitarianism Perspectives of Time and Space Fate and Personal Responsibility Face and Saving Face Body Language Create Resource Calendars 4 - Develop Project Team Develop Project Team Overview Ground Rules Form, Storm, Norm, Perform, Adjourn Team Building Team Building ? Personality Profiles Collaborative, Delphi, Majority and Plurality Decision Making Recognition and Rewards Expectancy Theory Maslow?s Hierarchy Of Needs Operant Conditioning Team Performance Assessment 5 - Manage Project Team Manage Project Team Overview Performance Problems Challenging Stakeholders Stress Management Conflict Management and Resolution Views of Conflict Sources of Project Management Conflict Conflict Resolution Survey Conflict Resolution Techniques Additional course details: Nexus Humans Project Team Leadership 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 Project Team Leadership 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.