26227 Courses delivered Online

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.

Discover the fundamentals of effective pain management with our comprehensive course designed to equip you with essential knowledge and skills. Whether you're a healthcare professional, caregiver, or simply interested in understanding pain better, this course provides a structured approach to handling various types of pain. Key Features: CPD Certified Developed by Specialist Lifetime Access In the "Introduction to Pain Management" course, learners will gain a comprehensive understanding of how pain is managed and treated. They will explore various theories and types of pain, from acute to long-term conditions like cancer and neuropathic pain. The course covers the physiological and psychological aspects of pain, helping learners understand its impact on the body and mind. They will also learn practical skills for assessing pain and applying appropriate management techniques. Topics such as primary headaches, back and neck pain, and relaxation methods for pain relief are also included, providing learners with a well-rounded knowledge base to approach pain management effectively. Overall, the course equips learners with essential knowledge and skills to recognize, assess, and address different types of pain in clinical and everyday settings. Course Curriculum Module 01: Introducing Pain Management Module 02: Pain Theories Module 03: Physiology and Psychology of Acute Pain Module 04: Types of Pain Module 05: Assessment of Pain Module 06: Primary Headache Module 07: Back and Neck Pain Module 08: Cancer Pain Module 09: Neuropathic Pain and Its Management Module 10: Pain as a Long-Term Condition Module 11: Relaxation for Pain Management Learning Outcomes: Understand principles of pain management theories and their application. Identify physiological and psychological aspects of acute and chronic pain. Evaluate different types of pain and their clinical presentations. Assess pain using appropriate tools and techniques for effective management. Recognize common types of headache and their management strategies. Apply relaxation techniques to alleviate pain and improve patient comfort. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Healthcare professionals needing foundational pain management knowledge. Medical students exploring pain management as a speciality. Nurses and nurse practitioners seeking to enhance pain assessment skills. Pharmacists aiming to improve pain medication management. Allied health professionals involved in chronic pain care teams. Career path Pain Management Nurse Pain Specialist Doctor Clinical Psychologist (Pain Management) Palliative Care Physician Pain Researcher Physiotherapist Specializing in Pain Management Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

WCNA training course description Wireshark is a free network protocol analyser. This hands-on course provides a comprehensive tour of using Wireshark to troubleshoot networks. The course concentrates on the information needed in order to pass the WCNA exam. Students will gain the most from this course only if they already have a sound knowledge of the TCP/IP protocols. What will you learn Analyse packets and protocols in detail. Troubleshoot networks using Wireshark. Find performance problems using Wireshark. Perform network forensics. WCNA training course details Who will benefit: Technical staff looking after networks. Prerequisites: TCP/IP Foundation for engineers Duration 5 days WCNA training course contents What is Wireshark? Network analysis, troubleshooting, network traffic flows. Hands on Download/install Wireshark. Wireshark introduction Capturing packets, libpcap, winpcap, airpcap. Dissectors and plugins. The menus. Right click. Hands on Using Wireshark. Capturing traffic Wireshark and switches and routers. Remote traffic capture. Hands on Capturing packets. Capture filters Applying, identifiers, qualifiers, protocols, addresses, byte values. File sets, ring buffers. Hands on Capture filters. Preferences Configuration folders. Global and personal configurations. Capture preferences, name resolution, protocol settings. Colouring traffic. Profiles. Hands on Customising Wireshark. Time Packet time, timestamps, packet arrival times, delays, traffic rates, packets sizes, overall bytes. Hands on Measuring high latency. Trace file statistics Protocols and applications, conversations, packet lengths, destinations, protocol usages, strams, flows. Hands on Wireshark statistics. Display filters Applying, clearing, expressions, right click, conversations, endpoints, protocols, combining filters, specific bytes, regex filters. Hands on Display traffic. Streams Traffic reassembly, UDP and TCP conversations, SSL. Hands on Recreating streams. Saving Filtered, marked and ranges. Hands on Export. TCP/IP Analysis The expert system. DNS, ARP, IPv4, IPv6, ICMP, UDP, TCP. Hands on Analysing traffic. IO rates and trends Basic graphs, Advanced IO graphs. Round Trip Time, throughput rates. Hands on Graphs. Application analysis DHCP, HTTP, FTP, SMTP. Hands on Analysing application traffic. WiFi Signal strength and interference, monitor mode and promiscuous mode. Data, management and control frames. Hands on WLAN traffic. VoIP Call flows, Jitter, packet loss. RTP, SIP. Hands on Playing back calls. Performance problems Baselining. High latency, arrival times, delta times. Hands on Identifying poor performance. Network forensics Host vs network forensics, unusual traffic patterns, detecting scans and sweeps, suspect traffic. Hands on Signatures. Command line tools Tshark, capinfos, editcap, mergecap, text2pcap, dumpcap. Hands on Command tools.

QSIG training course description A concise overview of QSIG, covering the development, current use and future of this private network signalling protocol. What will you learn Describe the use of QSIG. Describe the evolution of QSIG. Describe functionality of the QSIGProtocol Stack. Describe functionality and use of the main Supplementary Services and Additional Network Functions within QSIG. QSIG training course details Who will benefit: Network/Systems Engineers Operators/Planners or anyone working within the QSIG Arena. Prerequisites: Telecommunications Introduction Duration 1 day QSIG training course contents Introduction What is QSIG? User benefits, flexible interconnection, public ISDN synergy, feature transparency-end to end intelligence, innovation specialist features - heterogeneous environment. Evolution of QSIG Evolution of QSIG, ISDN PBX Networking, Specification forum (IPNS), QSIG standardisation. The ITU-T reference model extended for corporate networks. QSIG Protocol Q Protocol stack, QSIG basic call layer 3 - SubLayer 1, QSIG Generic Functional layer 3 Sub-Layer 2 (GF), QSIG protocols for supplementary services & ANF's- Layer 3, Sub-Layer 3, Layer 3 Message Overview. Supplementary Services and ANFs QSIG supplementary services standardisation methodology. QSIG Services and additional network features: Advice of charge, Call Completion, (CCBS, CCNR), Call Forwarding and diversion (CFB, CFNR, CFU, CD), Services (CINT, CI, CO, CT, CW, DDI) Services cont. (DND, DNDO), Identification Services - (CLIP, COLP, CLIR, CNIP, CONP, CNIR), Other QSIG services and additional network features (Mobile, Multi Subscriber Number (MSN), Operator Services, Recall (RE), Sub-Addressing (SUB)), User to user signalling, compliance with services. Conclusion - QSIG1 FAQ's, European Computer Manufacturers Association. The Future.

SMPTE 2110 training course description This course studies the new SMPTE ST 2110 suite of standards. The course covers all parts of the standard from SMPTE ST 2110-10 through to SMPTE ST 2110- 50. The course begins with an introduction to all IP studios and separating video and audio streams, then moves on to PTP and synchronisation. Video encapsulation is then followed by audio encapsulation. Handling ancillary data finishes the course. What will you learn Recognise the benefits of SMPTE ST 2110. Describe SMPTE ST 2110. Explain how the SMPTE 2110 standards work. Compare and contrast SMPTE 2110 and SMPTE 2022. SMPTE 2110 training course details Who will benefit: Anyone working in broadcast. Prerequisites: IP broadcast fundamentals Duration 1 day SMPTE 2110 training course contents Introduction The all IP studio. Review of IP and RTP. Role of SMPTE, SMPTE 2022, What is SMPTE 2110, SMPTE 2022 versus 2110, SMPTE 2110 parts, multiplex standards, 2110 separate streams, Video, Audio, ANC. Essences. Separate streams and synchronisation The old way, blackburst, time code, DARS. SMPTE 2110-10, ST2059, PTP, PTP architecture, PTP accuracy, How PTP works, Offset and delay PTP clock types, Hardware time stamping SDP. Hybrids. Uncompressed video SMPTE 2110-20, 2110-21. Image support, raster sizes, bit depth, active video and no blanking, bandwidth and bandwidth savings, pgroups. Timestamps. Packing modes. Packet sizes, pixels per packet. Audio SMPTE 2110-30, 2110-31, PCM, AES3. Allowed versus required. Channels and streams. Ancillary data SMPTE 2110-40, RFC on RTP payloads for ST 291 ancillary data.

TETRA training course description This 2 day training course covers the network architecture required for TETRA. It also looks at the Air Interface, TETRA Functions and Procedures. What will you learn Describe the TETRA Architecture Describe the Air Interface Explain the TETRA Functions Explain the TETRA Procedures TETRA training course details Who will benefit: Anyone working with TETRA. Prerequisites: None. Duration 2 days TETRA training course contents Introduction History of PMR, ETSI development, Tetra function, Tetra markets, Tetra standards, Tetra supplier base, Tetra Release 1, Tetra Release 2. Network Architecture Mobile network Identity, Mobile stations, Base station, Switching & Management, Addresses & Identitie. Air Interface Modulation, TDMA Format, FD, Framin, Burst format, Traffic Channel TCH, Dedicated Channel DCC, Common Control Channel CCC, Signalling Channel SCH, Logical Control mapping LCM, Protocol stack, Voice coded. TETRA Functions Trunked mode operation, User hierarchies, Individual calling, Group calling, Supplementary services, Voice and Data, Data services, Direct mode operation, Tetra WAP, Circuit mode priorities, Circuit mode data, Packet mode data, Discrete and Ambient listening. Automatic vehicle locator. TETRA Procedures MS operational modes, Mobility management, Cell selection, Security & Authentication, Decryption options, Cell setup, Channel assignment, Network management - internal, Network management -external, PSTN Gateway, ISDN Gateway, Control Room Gateway.

The Introduction to Real Estate Course is your first step towards gaining a deeper understanding of the real estate industry. Whether you're looking to broaden your knowledge or exploring this dynamic sector for the first time, this course offers clear, easy-to-follow insights into the key aspects of real estate. From understanding property laws to learning the basics of property valuation, this course will guide you through the foundational elements of the real estate market. As the industry continues to evolve, having a solid understanding of its principles is essential for anyone keen to succeed in this field. Throughout the course, you will gain essential knowledge of the different types of properties, how to assess their value, and the legalities surrounding property transactions. This course is ideal for individuals who wish to start a career in real estate or those looking to enhance their current knowledge. With a focus on practical application, you’ll explore the skills needed to navigate this exciting industry. By the end of the course, you will be well-equipped to pursue opportunities in real estate and gain a competitive edge in this growing sector. So, why wait? Dive into the world of real estate with us today! Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Real Estate Module 02: Basics of Estate Agent Module 03: Different Types of Estate Agents Module 04: Getting Started on the Job Module 05: Listing Property Module 06: Valuation Process Module 07: Negotiating as an Estate Agent Module 08: Selling Property: Finding the Buyers Module 09: Letting Property Module 10: Technology for Estate Agents Learning Outcomes: Navigate the real estate market confidently for a successful career. Master the art of property valuation, a crucial skill for estate agents. Develop effective negotiation strategies for optimal client satisfaction. Demonstrate proficiency in listing and letting processes in the industry. Embrace technology to enhance your efficiency as a modern estate agent. Gain comprehensive knowledge of different types of estate agents and their roles. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring estate agents Individuals keen on a career in real estate Professionals seeking a career change Entrepreneurs interested in property ventures Recent graduates exploring diverse career paths Individuals with an interest in property valuation Those looking to enhance their negotiation skills Anyone fascinated by the intersection of technology and real estate Career path Estate Agent Property Manager Lettings Negotiator Valuation Surveyor Property Consultant Real Estate Analyst Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Gain essential knowledge and practical skills related to tracheostomy care with our comprehensive e-learning course. Designed for healthcare professionals, students, caregivers, and individuals interested in medical care.

Gain essential knowledge and practical skills related to stoma care with our comprehensive e-learning course. Designed for healthcare professionals, students, caregivers, and individuals interested in medical care.

Gain essential knowledge and practical skills related to catheter care with our comprehensive e-learning course. Designed for healthcare professionals, students, caregivers, and individuals interested in medical care.