35412 Courses 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.

The course is a four-hour refresher session for those who have completed the Mental Health First Aid two day course. Just like physical first aid, we recommend you refresh your skills regularly and keep up-to-date.

Manual Handling Manual dealing with is a fundamental piece of pretty much every work all through the UK. Everybody from office laborers to the individuals who work on processing plant floors participate in some type of manual dealing with every single day. It is essential to find out about the dangers implied and how to lift, convey, push, and pull stacks securely. This is the most ideal approach to lessen the pace of working environment wounds, the majority of which are brought about by ill-advised manual taking care of practices. This course gives you a far reaching manual for manual dealing with. It starts by giving you a prologue to the idea of manual taking care of, including models and influenced work environments. It at that point broadly expounds on the commitments bosses and representatives should satisfy to protect their work environment. The particular kinds of dangers and risks, just as instances of how to deal with materials securely are likewise given. You Will Learn: The commitments bosses should satisfy as per the Manual Handling Operations Regulations The commitments representatives should satisfy as indicated by the Manual Handling Operations Regulations The dangers and perils that are implied with inappropriate manual taking care of, including the improvement of musculoskeletal issues and monotonous movement wounds Methods for protected and compelling manual dealing with Pragmatic arrangements and tips to remember with regards to manual taking care of and work environment security Advantages of Taking This Course Finding out about manual dealing with and how predominant it is in the present work environments Understanding the rights and commitments of representatives in the working environment with regards to manual taking care of Finding out about the particular dangers and perils that representatives face when they handle things inappropriately Figuring out how to physically deal with loads appropriately

Course Overview Learn how to master the pillars of business management and inspire greatness in others by taking this insightful course on Organisational Behaviour, HR and Leadership. All businesses are dependent on the way that they treat, support, and direct their Human Resources. Poor management leads directly to substandard operations. You can learn how to excel at these primary people skills by following the guidelines in this training, taking your business skills to new heights of effectiveness. This Business Management tutorial delivers a masterclass on the most important personal aspects of work-related leadership. You can expect expert guidance on how to motivate, manage, measure, and inspire your workforce, alongside the best ways to deal with extreme change and crisis situations. This is the complete learning package for those looking to take responsibility in the workplace and lead their colleagues to deliver exceptional services. This best selling Organizational Behaviour, HR and Leadership has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Organizational Behaviour, HR and Leadership is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Organizational Behaviour, HR and Leadership is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Organizational Behaviour, HR and Leadership is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Organizational Behaviour, HR and Leadership, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Organizational Behaviour, HR and Leadership will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Organizational Behaviour, HR and Leadership to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Linux engineer certification training course description LPIC-2 is the second certification in LPI's multi level professional certification program. This course teaches the skills necessary to pass the LPI 201 exam; the first of two LPIC-2 exams. Specifically, the course covers the administration of Linux systems in small to medium sized mixed networks. What will you learn Perform advanced administration tasks. Perform advanced file system administration. Linux engineer certification training course details Who will benefit: Linux administrators. Prerequisites: Linux system administration (LPIC-1) Duration 5 days Linux engineer certification fundamentals training course contents Part I The LPI 201 Exam Starting a System The Linux Boot Process, Firmware Startup, BIOS Startup, UEFI Startup, Linux Bootloaders, GRUB Legacy, GRUB 2, Alternative Bootloaders, Secure Bootloaders, Process Initialization, SysV Method, systemd Method, Upstart Method, System Recovery, Kernel Failures, Root Drive Failure. Maintaining the System Fluid Messaging, Static Messaging, System backups, Backup Strategies, Performing Backups, Installing Programs from Source, Obtaining and unpacking Installation Files, Compiling Programs, Resource Usage: Managing, measuring, predicting and troubleshooting. Mastering the Kernel What Is the Kernel? Kernel Features, Parts of the Kernel, Kernel Versions, Obtaining Source Code, Creating the Configuration File, Compiling and Installing the Kernel, Compiling and Installing Modules, Creating an Initial RAM Disk, Booting the New Kernel, Creating a Kernel Package, Maintaining the Kernel, Working with Module Files, Module Commands, Working with Hardware, Automatically Detecting Hardware, Troubleshooting the Kernel. Managing the Filesystem The Linux Filesystem, Filesystem Structures, Filesystem Types, Making Filesystems, Attaching Filesystems, Memory-Based Linux Filesystems, the Btrfs Filesystem, Btrfs Subvolumes, Btrfs Snapshots, Optical Filesystems, Swap Filesystems, Network-Based Filesystems, Auto-Mounting, Encrypted Filesystems, Maintaining Linux Filesystems, Adjusting a Filesystem, Checking and Repairing a Filesystem, SMART. Administering Advanced Storage Devices Configuring RAID, Implementing RAID on Linux, Managing a RAID Array, Adjusting Storage Devices, Looking at Drive Interface Concepts, Testing and Tuning Drives, Implementing iSCSI, Managing Logical Volumes, LVM, Creating Logical Volumes, Supporting Logical Volumes, Understanding the Device Mapper. Navigating Network Services Networking Basics, The Physical Layer, The Network Layer, The Transport Layer, The Application Layer, Configuring Network Features, Network Configuration Files, Graphical Tools, Command-Line Tools, Basic Network Troubleshooting, Checking the Log Files, the ARP Cache, Sending Test Packets, Testing Network Routes, Testing Client/Server Connectivity, Finding Host Information, Network Security, Advanced Network Troubleshooting, Viewing Open Network Connections, Viewing Network Statistics, Scanning the Network, Capturing Network Traffic.

CWISA training course description This CWISA course covers wireless technologies with reference to IoT. It examines from an IoT perspective how wireless works, and is an excellent introduction to IoT for the wireless engineer. Topics range from wireless technologies, RF, to mobile networks, IoT, and security. What will you learn Describe wireless networking and IoT technologies. Explain basic RF communications. Plan wireless solutions. Describe how to implement wireless solutions. Use best practices in implementing wireless solutions. CWISA training course details Who will benefit: Anyone working with IoT technologies. Prerequisites: RF fundamentals. Duration 4 days CWISA training course contents Introduction to wireless technologies History of wireless, radio waves and frequencies, wireless technologies and related components, common components of wireless solutions, LAN networking requirements, Network security, Implementing wireless solutions, staging, documentation, security updates, Industry organizations, IEEE, compatibility and certification groups. Wireless network use cases Wireless BANs, Wireless PANs, Wireless LANs, Wireless MANs, Wireless WANs, Wireless sensor networks, New network driver-Internet of Things, IoT for industry (IIoT), IoT for connected vehicles, Residential environments, Retail, Education (K12), Higher education, Agriculture, Smart cities / Public access, Health care, Office buildings, Hospitality, Industry, Stadiums, arenas, and large public venues. Planning wireless solutions Identifying use cases and applications, common wireless requirements and constraints, performing a wireless system design, selecting and evaluating design parameters. RF communications RF wave characteristics, RF propagation behaviours, RF signal metrics, fundamentals of wireless modulation. other wireless carriers, common frequency bands. Radio frequency hardware Hardware levels, basic RF hardware components (circuit board level), RF link types (use category). RF device types. Mobile communications networks Mobile networks, LTE, 5G, Use cases. Short-range, low-rate, and low-power networks RF and speed, RF and range, RF and power, 802.11, 802.15.4, Bluetooth, LoRa (Long range) / LoRaWAN, ZigBee, 6LoWPAN, NB-IoT and LTE-M. Wireless sensor networks What is a Wireless Sensor Network (WSN)? WSN applications, Sensors and actuators, WSN architectures, Planning a WSN. Internet of Things (IoT) Internet of Things (IoT) defined, IoT history and its definition revisited, one more comment on the definition of IoT, IoT verticals, Oil & Gas, IoT structure/ architecture basics, IoT connected objects. Securing wireless networks Confidentiality, integrity and availability, Privacy, non-repudiation, authenticity & safety, Importance of authentication in wireless networks, Key cryptographic technologies & concepts, Authentication methods, Authorisation, OAuth 2.0 authorisation framework, monitoring. Troubleshooting wireless solutions Proper solutions design, designing and implementing wireless solutions, basic installation procedures, general configuration considerations, troubleshooting and remediation, troubleshoot common problems in wireless solutions. Programming, scripting and automation What is an API? categories of APIs, common API communication methods, choosing a language, why are we integrating systems? Application & integration architectures. Data structures & types, XML, YAML, API types.

Windows server 2019 administration course description This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations. What will you learn Administrate Windows Server 2019. Configure file servers and storage. Manage Hyper-V virtualization and containers. Implement HA and disaster recovery solutions. Implement service monitoring and performance monitoring, and apply troubleshooting. Perform upgrades and migration related to AD DS, and storage. Windows server 2019 administration course details Who will benefit: Technical staff working with Windows server 2019. Prerequisites: TCP/IP foundation for engineers. Some Windows experience. Duration 5 days Windows server 2019 administration course contents Windows server administration overview Windows server administration principles and tools, Introducing Windows Server 2019, Windows Server Core Overview. Lab: Deploying and configuring Server Core, Implementing and using remote server administration. Identity Services in Windows server AD DS, Windows Server domain controllers, Azure AD, Group Policy, Active Directory Certificate Services. Lab: Deploying a new domain controller on Server Core, Configuring Group Policy, Deploying and using certificate services. Network Infrastructure services in Windows server DHCP, DNS services, IPAM. Lab: Deploying and configuring DHCP, Deploying and configuring DNS. File Servers and Storage management Volumes and file systems, sharing in Windows Server, Storage Spaces in Windows Server, Data Deduplication, Iscsi, Distributed File System. Lab: Implementing Data Deduplication, Configuring iSCSI storage, Configuring redundant storage spaces, Implementing Storage Spaces Direct. Hyper-V virtualization and containers Hyper-V in Windows Server, Configuring VMs, Securing virtualization in Windows Server, Containers in Windows Server, Overview of Kubernetes. Lab: Creating and configuring VMs, Installing and configuring containers. High Availability in Windows Server Planning for failover clustering implementation, Creating and configuring failover cluster, stretch clusters, High availability and disaster recovery solutions with Hyper-V VMs. Lab: Configuring iSCSI storage, Configuring a failover cluster, Deploying and configuring a highly available file server, Validating the highly available file server deployment. Disaster recovery in Windows Server Hyper-V Replica, Backup and restore infrastructure in Windows Server. Lab: Implementing Hyper-V Replica, Implementing backup and restore with Windows Server Backup. Windows Server security Credentials and privileged access protection, Hardening Windows Server, Just Enough Administration in Windows Server, Securing and analyzing SMB traffic, Windows Server update management. Lab: Configuring Windows Defender Credential Guard, Locating problematic accounts, Implementing LAPS. Remote Desktop Services in Windows Server Remote Desktop Services, session-based desktop deployment, personal and pooled virtual desktops. Lab: Implementing RDS, Configuring RemoteApp collection settings, Configuring a virtual desktop template. Remote access and web services in Windows Server Overview of RAS in Windows Server, Implementing VPNs, Implementing NPS, Implementing Always On VPN, Implementing Web Server in Windows Server. Lab: Implementing Web Application Proxy, Implementing VPN in Windows Server, Deploying and Configuring Web Server. Monitoring, performance, and troubleshooting Windows Server monitoring tools, Performance Monitor, Monitoring event logs for troubleshooting. Lab: Establishing a performance baseline, Identifying the source of a performance problem, Viewing and configuring centralized event logs, Identifying the source of a performance problem, Describe monitoring tools and performance monitoring in Windows Server, Describe event logging and perform event logging monitoring for troubleshooting purposes. Upgrade and migration in Windows Server AD DS migration, Storage Migration Service, Windows Server migration tools. Lab: Selecting a process to migrate server workloads, Planning how to migrate files by using Storage Migration Service.

Level 4 Internal Quality Assurance Qualification with Risk Management Training Level up your career possibilities with quality assurance expertise and develop the ability to in internal quality assessment. Our unique and intensive Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) qualification will open up a vast window for furnishing your career! This in-demand Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) qualification is awarded by Focus, an established Ofqual-regulated Awarding Organisation, ensuring a solid foundation and assisting you to gain in-depth knowledge of the quality assurance sector. You will be learning from the principles of quality assurance to the fundamentals of the assessment process to risk assessment at a workplace and much more! Upon completing this Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) qualification, you will ensure your professional position, progress further to higher levels of professional qualifications, and be able to ascend your career ladder. Not only that!!! Along with this well-organized Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) qualification, you will get a premium CPD accredited Risk Management course completely FREE!!! Enrol now and stand out brightly in this competitive field! Earn a globally recognised certificate and thrive in your life. Qualification Summary Qualification type: Level 4 Award Qualification title: Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) Accreditation status: Accredited Level: 4 Guided Learning Hours (GLH): 90 Total Qualification Time (TQT): 120 Qualification number (QN): 601/6107/3 ****Qualification Curriculum**** **Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF)** Unit 1: Understanding The Principles And Practices Of Internally Assuring The Quality Of Assessment Unit 2: Internally Assure The Quality Of Assessment ***Curriculum of The FREE Course*** **Risk Management** Module 01: Introduction to Risk Management Module 02: Risk and Types of Risk Module 03: Benefits of Risk Management Module 04: Enterprise Risk Management Module 05: Risk Management Process Module 06: Risk Analysis and Assessment Module 07: The Risk Evaluation Process Module 08: Managing Financial Risks Module 09: The Fundamentals of Operational Risk Management Module 10: Managing Technology Risks Module 11: Managing Legal & Political Risk Module 12: Environmental Risk Assessment Module 13: Risk Assessment at Workplace Module 14: Market & Social Risk Assessment Module 15: Preparing Risk Management Plan: Step by Step Course Duration Guided Learning Hours These hours are made up of all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate providers of education or training. Guided Learning Hours for this qualification is 90. Total Qualification Time This is an estimate of the total length of time it is expected that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification i.e. to achieve all learning outcomes. Total Qualification Time is GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. The credit value, where given, for qualification, is determined by TQT, as one credit corresponds to 10 hours of learning. Total Qualification Time for this qualification is 120 hours. Method of Assessment Assessment activities consist of a few short assignments that you have to complete to show evidence of general reading while adding references to your work. All assignments should be submitted via the online portal. Certification Successful candidates will be awarded a Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) from Focus Awards Limited. You will also get a CPD accredited Risk Management certificate from Apex Learning. Progression Level 4 Award in Externally Assuring the Quality of Assessment Processes and Practice Level 4 Diploma in Learning and Development Who is this course for? Our extensive Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) course is suitable for ambitious learners who are already working or considering working in the Quality Assurance sector. The qualification is also suitable for individuals who: Wish to join in an assessor role Beginner this field and wish to acquire in-demand assessing skills wish to gain formal recognition of their skills want to study from home at their own convenience Requirements Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) qualification does not have any specific entry requirements for students. However, you must be at least 19 years old or above to register. Career path Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Internal quality assurer Market developer Marketing executive Quality monitoring officer

Course Overview Amazon affiliate stores work with Amazon to sell Amazon products. When a visitor clicks on a product on the affiliate store's website, they are automatically directed to the Amazon website. The way it works is that if they make a purchase, you will earn a commission on the sale. This complete instructor-guided course will teach you everything you need to know to earn an extra income by building an Amazon affiliate E-commerce store using WordPress, WooCommerce, WooZone, and Elementor. It will guide you through how to register a domain name, set up hosting, navigate the WordPress interface, install WooCommerce, Elementor, and WooZone Plugins, plus much more. By the end of this training, you will have the practical skills to create a customised shop complete with product pages on a WordPress power E-commerce site. This best selling Amazon Affiliate E-Commerce Store from Scratch has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Amazon Affiliate E-Commerce Store from Scratch is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Amazon Affiliate E-Commerce Store from Scratch is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Amazon Affiliate E-Commerce Store from Scratch is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Amazon Affiliate E-Commerce Store from Scratch, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Amazon Affiliate E-Commerce Store from Scratch will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Amazon Affiliate E-Commerce Store from Scratch to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

How to use graphic skills to support your person centred planning