10594 Courses in Manchester delivered Online

Enrol in our Perfect Your English Writing and Grammar course to master grammar, punctuation, and business proposal writing. Suitable for students, job seekers, entrepreneurs, and lifelong learners, this course provides comprehensive training to enhance your writing skills and advance your career.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

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.

Higher Intermediate Communication Training in all 4 Integrated Skills: Listening, Speaking, Reading and Writing. Learn REAL language, not "textbook English".

Successful communications are all about making the message as simple as possible – but this can be difficult when the subjects we're talking about are inherently complicated.  Academic institutions, tech companies, health organisations, charities and many others have complex ideas, processes and systems at the heart of what they do.  This course is for anybody who needs to distill information down into key messages for important stakeholders, funders and investors, decision makers and members of the public.  You’ll learn proven techniques for grabbing attention and changing minds through presentations and public speaking, infographics and data visualisations, and written reports and online posts.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: Understanding your audience Matching your objectives to your audience's motivations. Identifying the right tone and language. Understanding how, where and when your audience wants to be spoken to. Session 2: Refining your objectives  Breaking down strategic aims into tactical steps Metrics and milestones: defining and measuring progress and success. Rapidly building a brief for your communications. Session 3: Telling the story  Using metaphors, visuals, comparisons to frame your narrative. From slide decks to online campaigns - choosing the right formats for delivering your message. Selecting communications channels to maximise reach and impact. Session 4: Keeping it going  Processes and systems for launching and maintaining communications campaigns. Building social proof – creating and curating content. Troubleshooting and preparing for common challenges. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “We’ve now worked with Alan for almost 3 years, and during that time he has continued to deliver the highest quality training for our clients and delegates. Alan’s passionate delivery style has continued to deliver innovative training solutions to over 1500 delegates across the public, private and voluntary sector. Each of our courses with him has always delivered exceptional feedback and satisfaction levels.” Joe Barlow | Head of Programme, Understanding ModernGov

Lower Intermediate Communication Training in all 4 Integrated Skills: Listening, Speaking, Reading and Writing. Learn the REAL language, not "textbook English".

In this practical and engaging workshop there is input on building an effective team around a child, problem solving as a team, improving communication and handling conflict. Communication with parents, problem solving and collaborating is explored. Empathy with parents who are ‘labelled’ is encouraged. Course Category Parents and Carers Description In this practical and engaging workshop there is input on building an effective team around a child, problem solving as a team, improving communication and handling conflict. Communication with parents, problem solving and collaborating is explored. Empathy with parents who are ‘labelled’ is encouraged. A key aspect of this day is ‘reframing’ how we think about the most difficult, hard to work with parents who attract many labels. Participants soon discover that they are more similar than they realise to those labelled ‘others’. The day gives those present opportunities to reflect on their attitudes and practice in relation to parents who are different. Practical ideas for joint problem solving and active engagement are fully explored. Testimonials “Made me more aware of how to approach parents and carers” “It (the conference) couldn’t have been improved. All the speakers were good” “I’ll have a more positive approach to welcoming people” “It will encourage us as practitioners to listen and think a little more. Learning Objectives Increased confidence in working with parents Access to a wider range of practical and thoughtful strategies when collaborating with parents and carers Deeper understanding of core values surrounding inclusion of disabled children in collaboration with parents and carers Opportunity to reflect on professional attitudes and behaviour towards parents with a focus on labelling and stigmatisation New skills and processes to make joint work successful Who Is It For ? Early Years and School based Practitioners Children Centre Staff Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Social Workers Health Workers Course Content The course answers the questions: Why is this parent impossible to work with? Where do I begin to communicate with some parents? How can I collaborate with parents and carers to include high profile children or young people? Best delivered over the course of a full day we will cover: The importance of WELCOME Labelling and reframing: Setting the tone: Reframing language to describe parents Providing parents with insights about children’s behaviour using stories Circle of Courage as applied to parents Circles of Support The Intentional Building of Relationships Not doing it alone – The Importance of Teams in developing inclusive practice Problem solving: Circles of Adults/Solution Circles Community Guides If you liked this you may like: COMMUNITY CIRCLES

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

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

Developing a solid foundation in Greek grammar will help you create your own sentences correctly and will also make it easier to improve your communication skills in both spoken and written Greek. So this course has been designed to help you steadily advance with the Greek language. Here, on the Greek Online School Learning Management System (LMS) you will find all the grammar phenomena that you need to know for the A2 Level (basic knowledge) in Greek, the language that influenced all European languages.