20440 Courses

This UI (User Interface) course is for designers, front-end developers and everyone who would like to start a career in UI design. During the course you will learn how to design mobile and web applications, as well as how to work with colours, fonts, and imagery. Every week each student will get personal feedback.

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 The primary audiences for this course are quality directors and quality assurance managers, managers responsible for the governance of an enterprise and management of its risks, technical experts, project managers and consultants, internal auditors, compliance officers and virtually anybody involved in ANSI/TIA-942 compliance certification related projects either from an end-user or vendor perspective. Participants must hold a valid CTDC certificate in order to be able to register for the CTIA class. Overview After completion of the course the participant will be able to: 1. Prepare the organisation for an audit according to ANSI/TIA-942 including preparation of the required documents, resource planning and management of the audit process itself 2. Conduct an internal audit according to ANSI/TIA-942 following ISO-19011 guidelines 3. Facilitate and support the external audit to ANSI/TIA-942 4. Manage the post-audit process with respect to CAR (Corrective Action Reports), gap closing and _nal certification 5. Facilitate surveillance and recertification audits This intensive course builds further on the technical understanding of the standard acquired in the CTDC© (Certified TIA-942 Design Consultant) course. Fundamental concepts and process of an internal audit Terms and de_nitions Difference between an internal and external auditor Audit principles Auditor competency requirements Managing an audit programme Establishing the audit objectives Establishing the audit programme Planning the audit Planning the schedule Resource planning Tools/equipment required Document requirements - Design documents - Process documents - Declarations Conducting the audit Conducting an opening meeting Conducting the audit Interviews Document review Facility review Typical non-conformities - Architectura - Electrica - Mechanical - Telecommunications Preparing the audit conclusions Conducting the closing meeting Preparing and distributing the audit report Audit report requirements Classification of non-conformities Typical format of an audit report Following up on the audit The CAR ? Corrective Action Report Evaluation of the Corrective Action Report Requesting a formal external auditIssuing a conformity certificate Requirements of the certificate Registration of the certificate Surveillance auditsRecertification auditsExam: Certified TIA-942 Internal Auditor) Actual course outline may vary depending on offering center. Contact your sales representative for more information. Additional course details: Nexus Humans Certified TIA-942 Internal Auditor (CTIA) 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 Certified TIA-942 Internal Auditor (CTIA) 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.

The objective of the OTHM Level 3 Diploma in Education and Training qualification is to develop learners' understanding of theory and practice in education. It provides learners with an opportunity to engage with the issues and challenges facing professionals and in their own country. The units will provide knowledge that underpins the ability to work as an effective practitioner in the education sector. They combine both theoretical and practical knowledge in the education profession and will develop and enhance knowledge and skills in the areas of approaches to teaching and learning, developing resources and reflective practice. Program Overview Key Highlights Program Duration: 9 Months (Can be fast-tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn Develop learners' understanding of theory and practice in education. Will train you to work as an effective practitioner in the education sector. It further develop and enhance knowledge and skills in the areas of teaching and learning, developing resources and reflective practice. Who is this course for? Working Professionals, O-Level holders, professionals working in Education and Training Institutions, Human resource consultants

Our regionally-based associate AutoCAD trainers come to your organisation to deliver small-group training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams. One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs. Course Outlines AutoCAD 2D Beginners - 2 days AutoCAD 2D Intermediate - 2 days AutoCAD 3D Beginners - 1 day Advance Steel Beginners - 2 days Pricing £800.00 plus VAT per day for up to 6 learners and £125.00 plus VAT per day to cover travel and accommodation within mainland UK. Just add £50.00 plus VAT per additional learner up to the 8delegate maximum.

QLS Level 5 Endorsed Diploma | QLS Hard Copy Certificates Included | Plus 5 CPD Courses | Lifetime Access

***24 Hour Limited Time Flash Sale*** Property Management, Building Surveying, Conveyancing Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter 'Property Management, Building Surveying, and Conveyancing' Embark on an immersive journey into the world of Property Management, Building Surveying, and Conveyancing with our comprehensive course bundle! This bundle is a treasure trove of theoretical knowledge for anyone seeking to delve into these disciplines. The Property Management, Building Surveying, and Conveyancing course bundle encompasses eight courses, with three Quality License Scheme (QLS) endorsed courses - Conveyancing, Building Surveying, and Property Management. Upon completion of these QLS-endorsed courses, you'll be presented with a hardcopy certificate, a commendable testament to your dedication. To further your theoretical understanding, we've also included five CPD Quality Standard (QS) accredited modules. These courses are UK Property Development, Property Management Diploma, Property Law and Taxation, Real Estate Agent, and Contracts Law UK 2021. CPD QS accreditation assures you that these courses meet the professional competence and ongoing learning requirements. Key Features of the Property Management, Building Surveying, Conveyancing Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Property Management, Building Surveying, Conveyancing bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Conveyancing QLS Course 02: Building Surveying QLS Course 03: Property Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: UK Property Development Course 02: Property Management Diploma Course 03: Property Law and Taxation Course 04: Real Estate Agent Course 05: Contracts Law UK 2021 In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Property Management, Building Surveying, Conveyancing courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: By the end of this Property Management, Building Surveying, and Conveyancing course, learners will be able to: Gain a comprehensive understanding of Property Management, Building Surveying, and Conveyancing. Learn about UK Property Development and the factors affecting it. Enhance your understanding with a diploma in Property Management. Get a grasp of the intricacies of Property Law and Taxation. Understand the role and responsibilities of a Real Estate Agent. Develop an understanding of Contracts Law UK 2021. Learn how to handle different aspects of property transactions and contracts. The Property Management, Building Surveying, and Conveyancing course bundle offers an extensive exploration into these specialised areas. The bundle features three QLS-endorsed courses and five CPD QS accredited courses, providing a range of perspectives on the topics. From Conveyancing to Contracts Law UK 2021, each course delves into the specifics of its subject, equipping learners with a broad and detailed theoretical understanding. You will explore the mechanisms of property management, the nuances of building surveying, the details of property law and taxation, and the workings of property development. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in embarking on a career in Property Management, Building Surveying, or Conveyancing. Current professionals in the property sector seeking to broaden their theoretical knowledge. Law students or professionals wanting to understand Property Law and Conveyancing. Entrepreneurs interested in property development or real estate. Career path Property Manager: £22,000 - £40,000 Building Surveyor: £28,000 - £48,000 Conveyancer: £20,000 - £35,000 Real Estate Agent: £20,000 - £60,000 (with commission) Property Law Consultant: £40,000 - £80,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Data has become the most important resource for every organisation – but the insights gained from data analysis will only ever be truly valuable if they can be clearly expressed to other people.  This course is for anybody who works with data, and needs to communicate the meaning that's in the numbers to colleagues, customers, bosses or external stakeholders.  It will give you or your team the confidence and skills to translate raw data into compelling visual stories for your key audiences. The principles and skills covered apply to the simplest PowerPoint chart, to more complex interactive visualisations.  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: What makes a great data-driven story The key elements of a successful infographic or presentation. Industry best practice, and discussion of good (and bad) examples. A simple framework for identifying the Audience, Story and Action. Session 2: Data in context How to balance function and aesthetic appeal. Identifying the right graph, chart, infographic or other visual. Framing the data and providing contextual information. Session 3: Designing for the human brain Using colours to add emphasis and meaning. Design and layout principles, and creating hierarchies of information. The principle of ‘self-sufficiency’, and removing clutter. Session 4: Navigation and narrative Tailoring visualisations for different types of communications. Structuring presentations and longer reports. Thinking in layers to create interactive dashboards. 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 “I was familiar with Alan’s work as a Guardian Masterclass instructor on data visualisation and digital journalism, which made it easy for me to recommend him for onsite training at the Liverpool School of Tropical Medicine. We had a large group of people interested in honing their abilities to depict their research and stories in engaging ways. Alan’s course provided great insight about common communication pitfalls and how to avoid them, how to become better communicators by understanding the audience diversity, and it showcased some great online tools for creating infographics. This should be mandatory training for all students, academics, report writers and those involved with conveying research to the media as it will help increase the clarity and accessibility of our own research stories.”
 Dr Lee Haines | Liverpool School of Tropical Medicine

Enhance your career with the Electrician: Electrical & PAT Testing Complete Bundle! Gain essential skills in electrical systems, safety regulations, and testing procedures to excel as an electrician in the UK. Enroll now!

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of Level 6 Diploma in Accounting and Business qualification (accredited by Othm) is to provide learners with the knowledge and skills required by a middle or senior manager in an organisation, and who may be involved in managing organisational finances, investment and risk, audit and assurance, or research. Many accountants occupy key managerial positions in business, yet few are qualified managers. In the increasingly complex modern business environment, there is a high demand for skilled professionals who can work flexibly in teams across business boundaries. Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.