Name: Risk Management for IT Projects: In-House Training
Price: 1495 GBP
Availability: InStock

Redhill

<h3><b>Sockets programming training course description</b></h3> <p>A hands on course for programmers using Sockets. It is
important to recognise that the course assumes that
delegates are already familiar with TCP/IP and Python.
Practical exercises follow all the major theory sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Read Python programs which use Sockets.</li>
        <li>Write Python programs which use Sockets.</li>
        <li>Debug Python programs which use Sockets.</li>
      </ul>
       
        <h5>
        <b>Sockets programming training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers working with network applications.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP foundation for engineers<br />
							Python for network engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Sockets programming training course contents</b></h3>
      <ul>
				<li>What is a socket?</li><p>
Review of IP, ICMP, UDP vs TCP, IP addresses,
protocol numbers, ports. API's, UNIX I/O, sockets.
SOCK_STREAM, SOCK_DGRAM. <br /><span>Hands on</span>
Compile and run code.
</p><li>The systems calls</li><p>
Clients and servers, structs, socket(), bind(),
connect(), listen(), accept(), send(), recv(), sendto
(), recvfrom(), close(), shutdown(), getpeername(),
gethostname(). <br /><span>Hands on</span> Walk through of
example client and server code.
</p><li>First code</li><p>
TCP connections, passive opens, active opens.
<br /><span>Hands on</span> Write a simple 'hello world' server and
client.
</p><li>Application protocols</li><p>
User character stream, ASCII turn taking, binary
protocols. <br /><span>Hands on</span> Raw SMTP, Writing a mail
client.
</p><li>Clients</li><p>
Concurrency, polling, threads, event driven
programming. <br /><span>Hands on</span> Conferencing
application.
</p><li>Servers</li><p>
Concurrency, stateful, stateless. Forks and execs.
inetd. <br /><span>Hands on</span> Running servers with and
without inetd, chroot jails, conferencing server
modifications.
		</p><li>Advanced techniques</li><p>
Blocking, select(), partial send(s). Raw sockets,
example sockets using Java, Perl and PHP.
<br /><span>Hands on</span> A broadcast application.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Network programming with sockets

General Admission

<h3><b>Programming in HTML5 with CSS course description</b></h3>
      <p> This course provides an introduction to HTML5, CSS3,
and JavaScript. It is an entry point into both the Web
application and Windows Store apps training paths.
The course focuses on using HTML5 / CSS3 /
JavaScript to implement programming logic, define and
use variables, perform looping and branching, develop
user interfaces, capture and validate user input, store
data, and create well-structured application.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                    <li>Create and style HTML5 pages.</li>
				  	                <li>Use JavaScript.</li>
                       <li>Style HTML5 pages by using CSS3.</li>
                      	<li>Use common HTML5 APLs in interactive Web applications.</li>
                       <li>Create HTML5 Web pages that can adapt to different devices and form factors.</li>
																							<li>Enhance the user experience by adding animations to the HTML5 page.</li>
                  </ul>
        <h5>
        <b>Programming in HTML5 with CSS course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Website developers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>HTML5 development fundamentals.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Programming in HTML5 with CSS course contents</b></h3>
      <ul>
				<li>Overview of HTML and CSS </li><p>
Overview of HTML, Overview of CSS, Creating a Web Application by Using Visual Studio 2012.
<br /><span>Hands on</span> Exploring the Contoso Conference Application.

</p><li>Creating and Styling HTML5 Pages </li><p>
Creating an HTML5 Page, Styling an HTML5 Page.
<br /><span>Hands on</span> Creating and Styling HTML5 Pages.

</p><li>Introduction to JavaScript </li><p>
Overview of JavaScript Syntax, Programming the HTML DOM with JavaScript, Introduction to jQuery.
<br /><span>Hands on</span> Displaying Data and Handling Events by Using JavaScript.

</p><li>Creating Forms to Collect and Validate User Input </li><p>
Overview of Forms and Input Types, Validating User Input by Using HTML5 Attributes, Validating User Input by Using JavaScript.
<br /><span>Hands on</span> Creating a Form and Validating User Input.

		</p><li>Communicating with a Remote Data Source </li><p>
Sending and Receiving Data by Using XMLHTTPRequest, Sending and Receiving Data by Using jQuery AJAX operations.
<br /><span>Hands on</span> Communicating with a Remote Data Source.

</p><li>Styling HTML5 by Using CSS3 </li><p>
Styling Text, Styling Block Elements, CSS3 Selectors, Enhancing Graphical Effects by Using CSS3.
<br /><span>Hands on</span> Styling Text and Block Elements using CSS3.

</p><li>Creating Objects and Methods by Using JavaScript </li><p>
Writing Well-Structured JavaScript, Creating Custom Objects, Extending Objects.
<br /><span>Hands on</span> Refining Code for Maintainability and Extensibility.

</p><li>Creating Interactive Pages using HTML5 APIs </li><p>
Interacting with Files, Incorporating Multimedia, Reacting to Browser Location and Context, Debugging and Profiling a Web Application.
<br /><span>Hands on</span> Creating Interactive Pages by Using HTML5 APIs.

</p><li>Adding Offline Support to Web Applications </li><p>
Reading and Writing Data Locally, Adding Offline Support by Using the Application Cache.
<br /><span>Hands on</span> Adding Offline Support to a Web Application.

</p><li>Implementing an Adaptive User Interface </li><p>
Supporting Multiple Form Factors, Creating an Adaptive User Interface.
<br /><span>Hands on</span> Implementing an Adaptive User Interface.

</p><li>Creating Advanced Graphics </li><p>
Creating Interactive Graphics by Using Scalable Vector Graphics, Programmatically Drawing Graphics by Using a Canvas.
<br /><span>Hands on</span> Creating Advanced Graphics.

</p><li>Animating the User Interface </li><p>
Applying CSS Transitions, Transforming Elements, Applying CSS Key-frame Animations.
<br /><span>Hands on</span> Animating User Interface Elements.

</p><li>Web Sockets for Real-Time Communications </li><p>
Introduction to Web Sockets, Sending and Receiving Data by Using Web Sockets.
<br /><span>Hands on</span> Implementing Real-Time Communications by Using Web Sockets.

</p><li>Creating a Web Worker Process </li><p>
Introduction to Web Workers, Performing Asynchronous Processing by Using a Web Worker.
<br /><span>Hands on</span> Creating a Web Worker Process.</p>
			
      </ul>

Programming in HTML5 with CSS

<h3><b>Essential 5G training course description</b></h3>
      <p>  This course is designed to give delegates an
explanation of the technologies and interworking
requirements of the next generation of cellular
communications.
It is not a definitive set of descriptions but a possibility
of the final deployment. we will investigate the 10 pillars
for 5G which will include various Radio Access
Technologies that are required to interwork smoothly.
We will look at the 4G Pro features and other RATs.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			
                    <li>List the ten pillars of 5G deployment.</li>
                    <li>Describe the 5G Internet.</li>
                    <li>Explain virtualization and RAT virtulization.</li>
                    <li>Describe Software Defined Networks (SDN).</li>
																				<li>Explain carrier aggregation.</li>
                     <li>Describe the mobile cloud.</li>
																				<li>Explain an overall picture of 5G architecture.</li>
                  </ul>
        <h5>
        <b>Essential 5G training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone looking for an understanding of the technologies
and interworking requirements of the next generation of
cellular communications.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Essential 5G training course contents</b></h3>
      <ul>
				<li>Drivers for 5G </li><p>
5G Road Map, 10 Pillars of 5G, evolving RATs, oSON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation.

</p><li>4G LTE Advanced </li><p>
MIMO technology in release 8, Downlink &amp; uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB &amp; remote base station configurations, Downlink CoMP.

</p><li>ICIC &amp; eICIC </li><p>
ICIC, Homogeneous to heterogeneous network evolution, Introduction to eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS).

</p><li>Carrier aggregation </li><p>
Component carriers (CC), CC aggregation deployments, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configs.

</p><li>eIMTA </li><p>
TDD UL-DL reconfig. for traffic adaptation, Reconfig. mechanisms, Interference mitigation schemes, Dynamic &amp; flexible resource allocation.

</p><li>5G architectures </li><p>
5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, 5G in North America, academy research, company R&amp;D, 5G specifications.

</p><li>The 5G internet </li><p>
High-level view of Cloud Services, The Internet of Things &amp; context awareness, Network reconfiguration &amp; virtualization support, server proliferation, how VMs fix underutilised server problem, enter the hypervisor, why are VM such a big deal? SDN, evolution of the data centre network, high availability, low latency, scalability, security, cost model explodes, service-oriented API. OpenFlow switches, OpenFlow controllers, how SDN works. The big picture, pulling it all together, why the network had to change, how SDN &amp; NFV tie together. Evolutionary approach to the internet, architectures for distributed mobility management, MEDIEVAL &amp; MEDIVO projects, a clean slate approach, mobility first architecture. VNet, INM, NetInf, ForMux, MEEM. Generic Path (GP) &amp; anchorless mobility (AM), Quality of Service support, network resource provisioning, resourcing inside a network. IntServ, RSVP, DiffServ, CoS. Emerging approach for resource over- provisioning, example use case architecture for scalable resource control scenarios in the 5G internet. Integrating SDN/NFV for efficient resource over-reservation control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations &amp; operations.

</p><li>Small cells for 5G </li><p>
Average spectral efficiency evolution, WiFi &amp; Femto cells, Capacity limits. Achievable gains with densifications, multi-antenna techniques, small cells. Mobile data demand, approach &amp; methodology, subscriber density and traffic demand projections to 2020. Demand versus capacity, global mobile data traffic increase modelling, country level backhaul traffic projections, Small cell challenges, backhaul, spectrum, automation.

</p><li>Cooperation for next gen wireless networks </li><p>
Diversity &amp; relaying strategies, cooperation &amp; network coding, ARQ &amp; MAC protocols, NCCARQ &amp; PRCSMA packet exchange, Physical layer impact on MAC protocol analysis, NCCARQ overview, PHY layer impact, Case study on NCCARQ.

</p><li>Mobile clouds </li><p>
Mobile cloud, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4 &amp; software stacks, infrared, near field communications (NFC). Network coding, store &amp; forward vs compute &amp; forward, linear network coding, random linear coding.

</p><li>Security for 5G communications </li><p>
Potential 5G communication systems architectures, Security issues &amp; challenges. Mobile malware attacks targeting the UE, 5G mobile botnets, access networks, attacks on 4G networks, C-RNTI &amp; packet sequence number based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, credential attacks, configuration and protocol attacks, attacks on MON, user data &amp; identity attacks, mobile operator's core network, DDoS attacks targeting MON, signalling amplification, HSS saturation, external IP networks.</p>
      </ul>

Essential 5G

<h3><b>D-Link switches training course description</b></h3>
        <p>A hands on course covering the product specifics of D-Link switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
 <li>Install D-Link switches.</li>
					<li>Use the command line interface and the web based interface to manage D-Link switches.</li>
                    <li>Configure and troubleshoot D-Link switches.</li>
                    <li>Perform software upgrades and maintain configurations using TFTP. </li>
                  </ul>
        <h5>
        <b>D-Link switches training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>
        Anyone working with D-Link switches. Particularly aimed at engineers and technicians supporting D-Link switches.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
			
				 <h3><b>D-Link switches training course content</b></h3>
      <ul>
				<li>Introduction </li><p>
How Ethernet works with hubs, How Ethernet works with switches. Installing D-link switches.
<br /><span>Hands on</span> Building a network with a hub, building a network with a D-Link switch.

</p><li>Basic troubleshooting </li><p>
The D-Link switch range, LEDs, cabling issues, factory resets, default settings.
<br /><span>Hands on</span> Building a network with multiple D-link switches.

</p><li>Configuration methods </li><p>
Managed vs. unmanaged switches, Console port access, telnet, web based access, SNMP, saving configurations, NVRAM, switch stacks.
<br /><span>Hands on</span> Accessing the switch using the CLI, IP address configuration, telnet.

</p><li>Command line interface </li><p>
Users, privileges, the CLI, online help.
<br /><span>Hands on</span> Basic commands, user accounts, displaying the switch configuration.

				</p><li>Web based interface </li><p>
Getting started, basic format.
<br /><span>Hands on</span> Configuring the switch using the web interface.

</p><li>Port configuration </li><p>
Common port configuration tasks, link aggregation.
<br /><span>Hands on</span> Configuring ports.

</p><li>STP configuration </li><p>
What is STP? 802.1D vs. 802.1W (RSTP), configuring STP.
<br /><span>Hands on</span> Enabling and disabling STP, changing STP versions, configuring STP.

</p><li>VLAN configuration </li><p>
What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS.
<br /><span>Hands on</span> Setting up VLANS, setting up 802.1Q, Inter VLAN traffic.

</p><li>Housekeeping </li><p>
TFTP, upload download, updating firmware, updating configuration files, BOOTP/DHCP for IP addresses.
<br /><span>Hands on</span> Using TFTP to configure a D-Link switch.

</p><li>SNMP </li><p>
Switch configuration, D-View, other NMS's.
<br /><span>Hands on</span> Using SNMP to manage a D-link switch putting it all together: troubleshooting.
</p>
      </ul>

D-Link switches

<h3><b>Essential IMS training course description</b></h3>
      <p>The IP Multimedia Core Network Subsystem (IMS) is defined by 3GPP as a new mobile infrastructure. This course studies the discreet elements in the IMS.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
				  <li>Describe the IMS.</li>
					<li>Describe the IMS architecture.</li>
                    <li>Explain how charging, security and QoS is handled in the IMS.</li>
                    <li>Explain how the IMS supports service enablers such as Push to talk and Presence.</li>
                  </ul>
        <h5>
        <b>Essential IMS training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Telecommunications staff. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Mobile communications overview</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Essential IMS training course contents</b></h3>
      <ul>
				<li>Mobile communications review </li><p>
The role of IP in telecommunications. GSM to IMS. Enhanced multimedia services, Push To, convergence, conferencing, roaming.

</p><li>What is IMS? </li><p>
What it is, why IMS, standard bodies: 3GPP, IETF, OMA, IMS services. MMD comparison.

</p><li>IMS architecture blocks 	</li><p>
Overview, IMS functions, IMS interfaces, IMS protocols, IMS elements, IMS reference points. Access network, IMS in GSM, CDMA, WiFi &amp; PSTN networks. Core network. Application, Control and Call planes.

</p><li>HSS - User database </li><p>
Identification. The user database, role of HSS, SLF and multiple HSSs. 'Normal' identities, IMPI, IMPU.

</p><li>IMS signalling: SIP </li><p>
What is SIP? SIP URI, contact address, UAs, Proxies, basic SIP call flow, SIP sessions.

</p><li>IMS other protocols </li><p>
Megaco, Diameter, XML, XCAP, COPS, RTP/RTCP, SDP, H.324M, IM and MSRP.

</p><li>Call/Session Control </li><p>
Call Session Control Functions (CSCF). Domains. Home networks, visited networks. CSCF and SIP. P-CSCF, P-CSCF discovery, P-CSCF functions. I-CSCF, DNS and I-CSCF. S-CSCF, S-CSCF functions, ENUM lookups. QoS. Example call flows.

</p><li>IMS services </li><p>
Open service platform, Application Servers, profiles, AS interface with S-CSCF. 'Normal' services (Caller ID, Call waiting, transferâ¦) Push to talk Over Cellular (PoC), IMS conferencing, Group management, IMS Presence, IMS Messaging. Other possible applications. Media servers. (MRFC, MRFP).

</p><li>Gateways </li><p>
IMS PSTN procedures, BGCF, PSTN interface. SGW, MGCF, MGW

</p><li>Charging </li><p>
Architecture, Offline, online and flow based charging, charging reference points, CCF, DIAMETER, ICID, IOI.

</p><li>IMS security </li><p>
IMS security architecture, identities, AAA, public and private user ID, service filters, Cx interface, RADIUS, Diameter protocol, 3GPP AKA, integrity, privacy, NDS, IPSEC, trust, assertion.</p>
      </ul>

Essential IMS

<h3><b>COBOL training course description</b></h3>
      <p> A hands on training course providing an introduction to COBOL.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Write COBOL programs</li>
				  	<li>Debug COBOL programs</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>COBOL training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
            <p>Programmers working with COBOL.
							</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>COBOL training course contents</b></h3>
      <ul>
				<li>Introduction to COBOL </li><p>
Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure.

</p><li>COBOL statement structure </li><p>
COBOL words, format of statements.

</p><li>Divisions </li><p>
Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry.

</p><li>File and Working-Storage Sections </li><p>
Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause.

</p><li>Procedure Division </li><p>
File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification.

</p><li>Perform statement </li><p>
Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement.

</p><li>Program design </li><p>
Design techniques, design considerations, procedure names, program structure.

</p><li>Printing </li><p>
Printed output, Write, advancing option, editing characters; Initialize.

</p><li>Condition testing </li><p>
Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue.

</p><li>Arithmetic </li><p>
Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute.

</p><li>Non-sequential files </li><p>
File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start.

</p><li>Declarative routines </li><p>
Clauses.

</p><li>Subroutines </li><p>
Call, Using clause - calling program/called program, Linkage Section, returning control.

</p><li>Table handling </li><p>
Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing.

</p><li>Data Manipulation </li><p>
Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.</p>
			
      </ul>

Complete COBOL programming

<h3><b>Complete Visual BASIC training course description</b></h3>
      <p>    A hands-on introduction to programming in Visual BASIC V6.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	   <li>Build Visual BASIC applications.</li>
					<li>Build simple components. </li>
                    <li>Debug Visual BASIC programs.</li>
                    <li>Examine existing code and determine its function.</li>
                  </ul>
        <h5>
        <b>Complete Visual BASIC training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to program in Visual BASIC.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Complete Visual BASIC training course contents</b></h3>
      <ul>
				<li>Application development using VB </li><p>

VB features. VB editions, VB terminology. Working in the Development Environment. Event-Driven Programming. Creating a program in VB. Project and executable files. VB reference materials.
</p><li>Visual Basic fundamentals </li><p>
Objects. Controlling objects. Introduction to forms. Introduction to controls. Basic controls.

</p><li>Working with code and forms </li><p>
Modules. Working with code. Interacting with the user. Working with code statements. Managing forms.

</p><li>Variables and procedures </li><p>
Introduction to variables and constants. Working with Procedures and Functions.

</p><li>Controlling program execution </li><p>
Common VB functions. Comparison and relational operators. Conditional structures. Looping structures.

</p><li>Debugging </li><p>
Error types. Debugging logic errors in VB.

</p><li>Working with controls </li><p>
Control types. Standard controls. Advanced standard controls. ActiveX controls. Insertable controls.

</p><li>Data access using the ADO data control </li><p>
Overview of ActiveX Data Objects. VB data access features. Relational database concepts. Using the ADO data Control to access data. SQL. Manipulating data. Using the data form wizard.

</p><li>Input validation </li><p>
Field-Level validation. The masked edit control. Form-Level validation. Form events used when validating data.

</p><li>Error trapping </li><p>
Trapping run time errors. Error handling overview. Enabling an error trap. Errors and the calling chain. In line error handling.

</p><li>Enhancing the User Interface </li><p>
Menus. Status bars. Toolbars.

</p><li>Drag and Drop </li><p>
Overview of Drag and Drop. Mouse events Drag and Drop basics.

</p><li>More about controls </li><p>
Using control arrays. Using the controls collection. Working with object variables. Collections.

</p><li>Finishing touches </li><p>
User Interface design principles. Distributing an application. Creating a default project.</p>
			
      </ul>

Complete Visual BASIC

<h3><b>LTE Airside training course description</b></h3>
      <p> This course provides a concise insight into the LTE
airside. Key parts of the course are detailed looks at the
air interface protocol stack, cell acquisition,
transmission and reception of data and of he layer 1
procedures along with layer 2 procedures.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			
                 <li>Explain the RF optimisation flowchart.</li>
																				<li>Describe the importance of Reference Signal
Received Power (RSRP).</li>
                    <li>List many of the 3GPP recommended KPIs.</li>
                    <li>Describe the concept of APN AMBR and UE AMBR
within LTE.</li> 
                    
                    <li>Describe the use of planning and optimisation
computer tools.</li>
                  </ul>
        <h5>
        <b>LTE Airside training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with LTE.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Essential LTE
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LTE Airside training course contents</b></h3>
      <ul>
				<li>Introduction and review of LTE </li><p>
This section describes the requirements of LTE and key technical features, and reviews the system architecture. LTE Architecture, UE, E-UTRAN and EPC. Specifications.

</p><li>OFDMA, SC-FDMA and MIMO antennas </li><p>
This section describes the techniques used in the LTE air interface, notably orthogonal frequency division multiple access (OFDMA) and multiple input multiple output (MIMO) antennas. Communication techniques for fading multipath channels. OFDMA, FFT processing and cyclic prefix insertion. SC-FDMA in the LTE uplink. Multiple antenna techniques including transmit &amp; receive diversity and spatial multiplexing.

</p><li>Introduction to the air interface </li><p>
This section covers the operation of the air interface, the channels that it uses, and the mapping to the time and frequency domains of OFDMA and SC-FDMA. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and physical signals. LTE spectrum allocation.

</p><li>Cell acquisition </li><p>
This is the first of three sections covering the air interface physical layer. Here, we cover mobile procedures to start low-level communications with the cell, and base station transmission of the corresponding information. Primary/secondary synchronisation signals. Downlink reference signals. The master information block. Physical control format indicator channel. Organisation and transmission of the system information.

</p><li>Data transmission and reception </li><p>
In this section, we cover procedures used for data transmission and reception on the shared channels, and describe in detail the individual steps. Data transmission and reception on the uplink and downlink. Scheduling commands and grants on the PDCCH. DL-SCH and UL-SCH. Physical channel processing of the PDSCH and PUSCH. Hybrid ARQ indicators on the PHICH. Uplink control information on the PUCCH. Uplink demodulation and sounding reference signals.

</p><li>Additional physical layer procedure </li><p>
This section concludes our discussion of the air interface physical layer, by discussing a number of procedures that support its operation. Transmission of the physical random access channel. Contention and non-contention based random access procedures. Discontinuous transmission in idle and connected modes. Uplink power control and timing advance.

</p><li>Air interface layer 2 </li><p>
This section describes the architecture and operation of layer 2 of the air interface protocol stack. MAC protocol, interactions with the physical layer, use for scheduling. RLC protocol, transparent, unacknowledged and acknowledged modes. PDCP, including header compression, security functions and recovery from handover.</p>
      </ul>

LTE airside

<h3><b>MPLS training course description</b></h3>
        <p>A hands-on introduction to MPLS covering the basics of what MPLS is and how to configure it, through to more advanced concepts such as MPLS VPNs and traffic engineering with MPLS.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe MPLS</li>
<li>Explain how MPLS works</li>
<li>Describe the interaction between OSPF/IS-IS/BGP and MPLS</li>
<li>Describe MPLS traffic engineering</li> 
                  </ul>
        <h5>
        <b>MPLS training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with MPLS.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>IP Routing<br />
                 BGP</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MPLS training course contents</b></h3>
      <ul>
        <li>What is MPLS?</li>
        <p>
          What does MPLS stand for? What is MPLS? Core
MPLS, MPLS and the 7 layer model, MPLS is a
protocol, MPLS is a standard, MPLS runs on
routers, MPLS history, Why MPLS? For service
providers, For enterprises. </p>
        <li>MPLS Architecture
</li>
        <p>Label Switch Routers, two types of LSR, PE and
P router roles, FEC, swapping labels, MPLS
packet format, Loops, TTL control. <br /><span>Hands on:</span>
Building the base network. Enabling MPLS.
					Simple testing and troubleshooting of MPLS.</p>
        <li>Label distribution</li>
        <p>Label review, label switch path, label distribution
methods, piggybacking, Label distribution
Protocols, LDP, LDP operation, LDP packets,
discovery messages, session messages,
advertisement messages, notification message,
Label Information Base, routing tables, the LFIB,
MPLS forwarding, penultimate hop popping,
handling labels, LSP control modes, when to
distribute labels, how long to keep labels,
aggregation, label merging.<br /><span>Hands on:</span> LDP traffic
analysis.</p>
        <li>MPLS TE and QoS</li>
        <p> What is MPLS TE? Why TE? TE versus shorted
path, how MPLS TE works, CR-LDP, OSPF-TE,
IS-IS-TE, TE with BGP, RSVP-TE, MPLS Fast
reroute, MPLS QoS.<br /> <span>Hands on:</span> Enabling
MPLS-TE.</p>
        <li>BFD</li>
        <p>BFD, hello the BFD protocol.</p>
				<li>MPLS VPN</li>
				<p>What is a VPN? MPLS VPN types, MPLS VPN
comparison, MPLS L3 VPN, VRFs, MBGP, MPLS
VPN architecture, VRF RD, VRF RT, the label
stack, L2 VPNs, VPWS, AToM, VPLS.<br /> <span>Hands on:</span>
MPLS L3 VPN setup, troubleshooting.
        </p>
      </ul>

Concise MPLS for engineers

London

<h2>Risk Management for IT Projects: In-House Training</h2>
 <p>IT projects may have direct bottom-line impact on the organization, cost millions of dollars, cause organizational change and change the way the organization is perceived by clients. Many IT projects are notoriously hard to predict and are filled with risk. IT Risk Management takes a comprehensive look at IT project risk management using PMI's PMBOK® Guide Risk Management Model in the context of IT Project Life Cycle phases.</p>
 <p>The goal of this course is to arm the practitioner with a rigorous, common-sense approach to addressing uncertainty in projects. This approach includes the ability to influence project outcomes, avoid many potential project risks, and be ready to calmly and efficiently respond to unavoidable challenges.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Describe the risk management process, using the <em>PMBOK® Guide</em>'s standard models and terminology</li>
 <li>Discuss the potential barriers to managing risk effectively in IT project organizations</li>
 <li>Develop an effective risk management plan for IT projects</li>
 <li>Identify project risks using IT-specific, practical tools</li>
 <li>Analyze individual risk events and overall project risk using IT-specific, practical approaches</li>
 <li>Plan effective responses to IT-specific risk based on the results of risk analysis and integrate risk responses into project schedules and cost estimates</li>
 <li>Manage and control risk throughout the IT project life cycle</li>
 <li>Implement selected elements of IT project risk management on your next project</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>Basic concepts and purpose</li> <li>Risk and project constraints</li> <li>Risk and corporate cultures</li> <li>Risk management and IT PLC standards</li> </ul> <h3>Plan Risk Management for IT Projects</h3> <ul> <li>Plan Risk management process</li> <li>Plan Risk management activities</li> </ul> <ul> <li>Design a standard template</li> <li>Assess the project-specific needs</li> <li>Tailor the template</li> <li>Produce a project-specific risk management plan</li> <li>Gain consensus and submit as part of overall project plan</li> <li>A risk management plan of IT projects</li> </ul> <h3>Identify Risks for IT Projects</h3> <ul> <li>Identify risk process overview</li> <li>Risk categories and examples</li> <li>Risk identification tools</li> <li>Risk events by project life-cycle phases</li> </ul> <h3>Perform Risk Analysis for IT Projects</h3> <ul> <li>Perform qualitative risk analysis overview</li> <li>Core qualitative tools for IT projects</li> <li>Auxiliary qualitative tools for cost and schedule estimates</li> <li>When to use quantitative analysis for IT projects</li> </ul> <h3>Plan Risk Response for IT Projects</h3> <ul> <li>Plan risk response overview</li> <li>Active risk response strategies for IT projects (Threat and Opportunity)</li> <li>Acceptance and contingency reserves</li> <li>Contingency planning for IT projects</li> <li>Plan risk responses for IT projects</li> </ul> <h3>Implement Risk Response for IT Projects</h3> <ul> <li>Implement Risk Responses</li> <li>Executing Risk Response Plans</li> <li>Techniques and Tools Used</li> <li>Continuous Risk Management</li> </ul> <h3>Monitor Risks for IT Projects</h3> <ul> <li>Monitor risks overview</li> <li>Monitor risks tips for IT projects</li> <li>Technical performance measurement systems</li> <li>Risk management implementation for IT projects</li> </ul>


                </section>

IIL Europe Ltd

Risk Management for IT Projects: In-House Training

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>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.</p>Overview<p>After completion of the course the participant will be able to: <br />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<br />2. Conduct an internal audit according to ANSI/TIA-942 following ISO-19011 guidelines<br />3. Facilitate and support the external audit to ANSI/TIA-942<br />4. Manage the post-audit process with respect to CAR (Corrective Action Reports), gap closing and _nal certification<br />5. Facilitate surveillance and recertification audits</p><p>This intensive course builds further on the technical understanding of the standard acquired in the CTDCÂ© (Certified TIA-942 Design Consultant) course.</p></div><div id="course-pills-2"><h4>Fundamental concepts and process of an internal audit</h4><ul><li>Terms and de_nitions</li><li>Difference between an internal and external auditor</li><li>Audit principles</li><li>Auditor competency requirements</li></ul><h4>Managing an audit programme</h4><ul><li>Establishing the audit objectives</li><li>Establishing the audit programme</li></ul><h4>Planning the audit</h4><ul><li>Planning the schedule</li><li>Resource planning</li><li>Tools/equipment required</li><li>Document requirements</li><li>- Design documents</li><li>- Process documents</li><li>- Declarations</li></ul><h4>Conducting the audit</h4><ul><li>Conducting an opening meeting</li><li>Conducting the audit</li><li>Interviews</li><li>Document review</li><li>Facility review</li><li>Typical non-conformities</li><li>- Architectura</li><li>- Electrica</li><li>- Mechanical</li><li>- Telecommunications</li><li>Preparing the audit conclusions</li><li>Conducting the closing meeting</li></ul><h4>Preparing and distributing the audit report</h4><ul><li>Audit report requirements</li><li>Classification of non-conformities</li><li>Typical format of an audit report</li></ul><h4>Following up on the audit</h4><ul><li>The CAR ? Corrective Action Report</li><li>Evaluation of the Corrective Action Report</li></ul><h4>Requesting a formal external audit</h4><h4>Issuing a conformity certificate</h4><ul><li>Requirements of the certificate</li><li>Registration of the certificate</li></ul><h4>Surveillance audits</h4><h4>Recertification audits</h4><h4>Exam: Certified TIA-942 Internal Auditor)</h4><ul><li>Actual course outline may vary depending on offering center. Contact your sales representative for more information.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>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.  <p></p>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.<p></p></div>

Nexus Human

Certified Technology Specialist (CTS)

Certified Cryptocurrency Investigator Course (CCI)

Certificate of Completion of Training (CCT)

CompTIA Network+

IT Certifications

SIA Training

Certified TIA-942 Internal Auditor (CTIA)

Bristol

Exeter

Newcastle

Manchester

Liverpool

Birmingham

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live instructor led sessions;&nbsp;</strong></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Why choosing Mindmaps Wellbeing is a good choice for your training.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Instructor led training sessions over two days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Course Manual</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Handy Cue Card</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ MHFAider Certificate upon completion</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Your instructors are <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registered Mental Health Nurses and Healthcare Educators</strong> (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to our online MHFAider peer support groups moderated by the instructor team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">For a little extra:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Organisational MINDWELL Companion tailored for your workplace / organisation.</p>

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>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.</p><p></p><p></p><p>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.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>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.  <p></p>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.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<h3 fr-original-style="" style="box-sizing: border-box;">Data Protection (GDPR) Foundation Certificate</h3>
<div fr-original-style="" fr-original-class="lcb-body" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" fr-original-class="education-description-wrapper" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Data Protection (GDPR) Foundation Certificate is the course for people who need a formal qualification to demonstrate a clear, concise and generic understanding of the General Data Protection Regulation and Data Protection Act 2018, in support of the practical knowledge often acquired in the workplace. It is suitable for the public, private and third sectors and will teach participants essential GDPR skills and sufficient knowledge to assist their organisation toward their data protection implementation and GDPR accountability requirement.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Foundation Certificate is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">As the course covers a lot of ground in a short time we recommend attendees who know nothing about data protection to attend our one-hour live, online Introduction to Data Protection and the GDPR.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Note: This course is delivered live, online, using the Zoom platform. &nbsp;It will be delivered 9.30 - 12.30 and 13.30 - 16.30</p>
</div>
</section>
</div>

Computer Law Training

Legal

Data Protection

Compliance

GDPR

This Foundation Certificate  is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.

Data Protection (GDPR) Foundation Certificate

General admission

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you a stressed, exhausted SEN/EBSA parent or carer, running on empty, with no time to shout <em fr-original-style="" style="box-sizing: border-box;">"HELP!"&nbsp;</em>let alone step off the hamster wheel to rest, recharge and recuperate?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Parenting neurodivergent and/or school avoidant young people comes with a unique set of challenges and, if you&#39;re finding yourself lurching from managing meltdowns to fighting for support or feeling isolated and judged because people don&#39;t understand, it can be really hard and I GET IT!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After finding myself pretty much burnt out I discovered and implemented quick and simple self-help and relaxation tools that have helped strengthen my coping skills to navigate my family&#39;s journey, rebuild my resilience and rediscover&nbsp;my old self!&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I was so blown away by how beneficial simple habits can be that it&#39;s my mission to help others do the same - and so I created&nbsp;The SHARE Project.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ethos of THE SHARE Project is that&nbsp;we need to put our own oxygen mask on first&nbsp;so that we can&nbsp;best support our kids&nbsp;and my aim is that the tools you will learn during our time together will become your oxygen mask, not only for use in case of emergency, but as a sustainable part of your ongoing&nbsp;self-care and wellbeing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During each&nbsp;of four, weekly, live&nbsp;online workshops, delivered over Zoom, you will learn and practise a new tool to implement daily over the coming week (just a&nbsp;few minutes at a time, I promise)!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Then, during the following week&#39;s workshop we will review your progress, make any tweaks and learn and practise the next tool...&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There&#39;ll be no suggestions of long and luxurious spa days and fluffy robes because most of us don&#39;t have the time to do that very often and, frankly, the benefits disappear almost as soon as you&#39;ve driven home... My mission<em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em>is to give you sustainable tools to use anytime and anywhere to help yourself cope better and feel happier, regardless of what&#39;s going on around you!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each group session gives you the opportunity to connect with other SEN parents or carers&nbsp;experiencing similar challenges.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What our clients say:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">"</span></em><span style="color: rgb(32, 33, 36); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">The Share project was a gentle, kind experience which showed understanding for parenting with additional challenges. &nbsp;The refocusing was extremely powerful and I felt nurtured by the sessions."</span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"I gained different techniques to build resilience and overcome overwhelm."&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" fr-original-style="" style="box-sizing: border-box;"><span data-sheets-root="1" style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"has helped me have a more positive outlook day to day, relaxation has helped with my sleep"</span></span><span data-sheets-root="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></span></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you have any questions, please ask and I will be happy to help :)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sue&nbsp;</p>

Discover Calm and Happiness with The SHARE Project: Your Path to Resilience! 🌟
Are you feeling exhausted, overwhelmed and stretched to your limit?  With meetings and meltdowns to manage, battles for support, the frustration of feeling isolated or misunderstood, not to mention the pressure of juggling your job too, it can It can feel like you’re running on empty; hard to find a moment to step off the hamster wheel and just breathe.
I’ve been there, and I get it!💛
After being on the brink of burnout myself, I stumbled upon simple, yet life-changing self-help and relaxation tools. These quick, effective techniques helped me rebuild my resilience, reclaim my sense of self and navigate challenges with renewed strength. The transformation was so profound that I knew I had to share it with others—and that’s how The SHARE Project was born.
What is The SHARE Project?
The SHARE Project is built on a simple principle: you need to put your own oxygen mask on first!  By nurturing yourself, you’re better equipped to support your children. Through our four-week, live online workshop series, delivered via Zoom, you’ll discover practical tools to bring more calm and happiness into your daily life.
Here’s what you can expect:
Weekly Workshops:  Each week, we’ll introduce and practice a new tool designed to fit seamlessly into your life (just a few minutes a day, I promise!). These are not your typical “luxury spa day” suggestions — because let’s face it, who has time for that?  Instead, you’ll learn sustainable, go-to strategies that you can use anytime, anywhere, to boost your wellbeing, even in the midst of chaos.  You will also receive a mid-week email of encouragement between workshops and printables to help record and track your progress.
Ongoing Support:  In each session, we’ll review your progress, fine-tune your approach, and introduce the next tool.  This isn’t just a one-off workshop; it’s a journey of growth and connection.
Community Connection: You’ll be part of a supportive group of fellow SEN parents and carers who understand the unique challenges you face.  Together, we’ll share experiences, uplift each other, and grow stronger.
What our clients say:
“The SHARE Project was a gentle, kind experience which showed understanding for parenting with additional challenges.  The refocusing was extremely powerful and I felt nurtured by the sessions.”
“It has helped me to have a more positive outlook day-to-day, and the relaxation has helped with my sleep.”	
“I looked forward to the sessions each week, they gave me time to focus on myself for a change.”
Ready to Feel More Calm and Happy?
If you’re ready to step off the hamster wheel and start reclaiming your joy, The SHARE Project is here for you. Let’s work together to help you feel more at peace, more resilient, and, most importantly, more you.
Got any questions? Send me a message and I’ll be happy to help! 😊
With love and support,  
Sue

AUsomeMums

Emotional Wellbeing

Emotional Resilience

Autism

Mental Resilience

Special Education Needs (SEN)

Self-help and relaxation skills and exercises for stressed, burned out SEN parents and carers

The SHARE Project - Self-Help & Relaxation Exercises for SEN/EBSA Parent Carers

<p id="isPasted" style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">If you are a parent or carer of a child or young person who may not be able to make decisions about their welfare and finances now or in the future, you will need to consider the best ways to protect them as they move to adulthood.&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">Philip Warford, Lawyer and specialist in planning for the future of disabled &amp; vulnerable people, will talk through the key principles of the Mental Capacity Act 2005, who can make a Powers of Attorney and how the Court of Protection might help.</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">Philip will discuss:</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">MENTAL CAPACITY&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What is mental capacity &amp; who assesses mental capacity&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What affects mental capacity&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">Different levels of capacity for different things&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">How the Mental Capacity Act 2005 affects us</li></ul><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">POWERS OF ATTORNEY&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What is a Power of Attorney</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">Lasting Powers of Attorney explained</li></ul><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURT OF PROTECTION&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What it is and what is does</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">When and how to contact them&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><span lang="EN-US" style="font-family: Arial, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif;">Timescales and their charges<br fr-original-style="" style="box-sizing: border-box;"></span></li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-family: Arial, sans-serif; color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif; color: rgb(0, 0, 0); font-size: 16px;">Philip is the Managing Director of Renaissance Legal. He&nbsp;specialises in helping families and carers of disabled and vulnerable people plan for their future using Wills, Trusts, Powers of Attorney, Court of Protection applications and Inheritance Tax Planning.&nbsp;</span><span style="font-family: Arial, sans-serif; font-size: 16px; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif; font-size: 16px;">Philip&nbsp;regularly speaks at seminars on behalf of many local and national charities including Mencap, NAS and Sense. &nbsp;</span></p>

If you are a parent or carer of a child or young person who may not be able to make decisions about their welfare and finances now or in the future, you will need to consider the best ways to protect them as they move to adulthood. 
 
Philip Warford, Lawyer and specialist in planning for the future of disabled & vulnerable people, will talk through the key principles of the Mental Capacity Act 2005, who can make a Powers of Attorney and how the Court of Protection might help.
 
Philip will discuss:


 MENTAL CAPACITY 
What is mental capacity & who assesses mental capacity
What affects mental capacity
Different levels of capacity for different things
How the Mental Capacity Act 2005 affects us
POWERS OF ATTORNEY 
What is a Power of Attorney
Lasting Powers of Attorney explained
COURT OF PROTECTION 
What it is and what is does
When and how to contact them
Timescales and their charges
Philip is the Managing Director of Renaissance Legal. He specialises in helping families and carers of disabled and vulnerable people plan for their future using Wills, Trusts, Powers of Attorney, Court of Protection applications and Inheritance Tax Planning. Philip regularly speaks at seminars on behalf of many local and national charities including Mencap, NAS and Sense. 

Born at the Right Time

Disability

leading expert Philip Warford will talk about the options available to protect a disabled person using specialist Wills and Trusts

Decision Making for Vulnerable People Webinar 

<p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);">Competition in the communications sector is complex and fast-changing. This presents both risks and opportunities to providers, as well as challenges for public authorities.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Would you like to gain expert insights on the practical applications of competition law in the regulated telecoms industry? <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Then, this training is for you!</strong></p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Presented by experts through practical case examples, this <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">online training</strong> will guide you through the latest competition law developments affecting the telecoms industry and give you a full overview of the role played by competiton law in shaping the telecoms market.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Topics covered include:&nbsp;</strong></p><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li fr-original-style="" style="box-sizing: border-box;">Relationship between competition law and sector-specific telecoms regulation</li><li fr-original-style="" style="box-sizing: border-box;">Market definition</li><li fr-original-style="" style="box-sizing: border-box;">Telecoms mergers</li><li fr-original-style="" style="box-sizing: border-box;">Antitrust aspects of network co-operation</li><li fr-original-style="" style="box-sizing: border-box;">Typical abuses of dominance in the telecoms sector</li><li fr-original-style="" style="box-sizing: border-box;">Broadband state aid&nbsp;</li></ul><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">When:&nbsp;</strong>17-19 September 2024 - <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 hours of interactive sessions spread over 3 days</strong></p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Where:&nbsp;</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Online</strong>, using Microsoft Teams</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cannot make it to one of the sessions?</strong> All sessions will be <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">recorded</strong> and made available to <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">registered participants</strong>.</p>

Cullen International SA

Telecommunications

Competition Law in the telecoms sector

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55265 Microsoft PowerApps 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.  <p></p>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.<p></p></div>

Microsoft Power Apps

Power Apps

Microsoft AZ-900

Microsoft Power Platform

Microsoft AZ-700

Microsoft Power Automate

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How you can communicate your education and modules studied effectively with employers</li><li fr-original-style="" style="box-sizing: border-box;">Tips to make your CV stand out</li><li fr-original-style="" style="box-sizing: border-box;">The industry apprenticeships available</li><li fr-original-style="" style="box-sizing: border-box;">Relevant internships on offer</li><li fr-original-style="" style="box-sizing: border-box;">The university sandwich year placements there are</li><li fr-original-style="" style="box-sizing: border-box;">Courses you can take to get a better understanding of the sector</li></ul>

One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:
 
How you can communicate your education and modules studied effectively with employers
Tips to make your CV stand out
The industry apprenticeships available
Relevant internships on offer
The university sandwich year placements there are
Courses you can take to get a better understanding of the sector

Bayfield Training

One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:

- How you can communicate your education and modules studied effectively with employers
- Tips to make your CV stand out
- The industry apprenticeships available
- Relevant internships on offer
- The university sandwich year placements there are
- Courses you can take to get a better understanding of the sector


Free Webinar | How to sell your CV effectively and secure practical experience in Real Estate

Slough

Portsmouth

Bingley

Cardiff

Milton Keynes 

Nottingham

Bedford

Liverpool 

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">ONLINE STUDY - In your own time (approx. 6 hours study time) +</span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Awarding Body:</strong>&nbsp;Open College Network (OCN) Credit for Learning</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Award Level:</strong>&nbsp;Level 3 (Advanced Level) - Ireland Level 5</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Certified:</strong>&nbsp;Yes (CPD Accreditation)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Minimum Age:&nbsp;</strong>18 (16 with parental consent)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements:&nbsp;</strong>None. (English Level 2 desirable)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Locations:</strong>&nbsp;Study online + Classroom</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">OCN Accredited at UK Level 3 (Ireland Level 5)</span><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - Theory:</strong>&nbsp;Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 2 - Skills and Practical Development:</strong><br fr-original-style="" style="box-sizing: border-box;">Safely and competently set up and maintain a Peripheral IV Infusion.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attend a classroom location to complete your practical training.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Itinerary:</strong></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - THEORY (ONLINE)</strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M1 - Peripheral IV Cannulation - Introduction:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Definitions - understanding terminology relating to PIVC.<br fr-original-style="" style="box-sizing: border-box;">IV Therapy and NMC guidelines.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Legal Obligations and Accountability. Criminal, Civil and<br fr-original-style="" style="box-sizing: border-box;">Contractual law in Healthcare. Vicarious Liability and your<br fr-original-style="" style="box-sizing: border-box;">Duty of Care.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M3 - Anatomy &amp; Physiology:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Sites appropriate to IV cannulation. Hand vs. arm.<br fr-original-style="" style="box-sizing: border-box;">Advantages and disadvantages of relevant veins.<br fr-original-style="" style="box-sizing: border-box;">An overview of Homeostasis and Fluid Balance.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M4 - Hygiene and Infection Prevention &amp; Control (IPC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Reducing healthcare-associated infections. Keeping Safe.<br fr-original-style="" style="box-sizing: border-box;">Bloodborne Pathogens and Work Practice Controls.<br fr-original-style="" style="box-sizing: border-box;">Standard Precautions. Waste Disposal. Needle-stick injuries.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M5 - Indications and Advantages:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When to cannulate, infusion types and benefits over<br fr-original-style="" style="box-sizing: border-box;">alternative infusion routes. Continuous and intermittent infusion.<br fr-original-style="" style="box-sizing: border-box;">Prophylactic use before procedures and in unstable patients.<br fr-original-style="" style="box-sizing: border-box;">Contraindications.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M6 - Equipment:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Cannula types, sizes and colour coding. How to select<br fr-original-style="" style="box-sizing: border-box;">appropriate size. Equipment overview for total procedure.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M7 - Vein Choice for Cannulation:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Correct vein selection. Which veins to avoid.<br fr-original-style="" style="box-sizing: border-box;">How to manage an unsuccessful cannulation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8 - Procedures:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Full procedure for cannulation including correct documentation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Guide to Cannulation - revision</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Video - Recap with full procedure</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M9 - Contraindications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When inappropriate to cannulate including patients with specific health conditions.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M10 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at potential complications during and after<br fr-original-style="" style="box-sizing: border-box;">cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED</strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">BEFORE JOINING US FOR YOUR PRACTICAL TRAINING</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART 2 (CLASSROOM:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 - Welcome, introductions and overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Classroom - registration and introductions.<br fr-original-style="" style="box-sizing: border-box;">Virtual Classroom - audio/visual checks and registration.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Overview and discussion.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 - Anatomy - key points (appropriate to PIVC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Arteries and veins. Selecting an approprate site. Sites to avoid and &ldquo;first choice&rdquo; sites.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4 - Cannulae - selection and types:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Complications of pVAD insertion including examples of<br fr-original-style="" style="box-sizing: border-box;">infiltration, haematoma, extravasation and transfixation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 - VIP Score:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Understanding and using the Visual Infusion Phlebitis score.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7 - Equipment - overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">We take a look at all essential equipment required for PIVC.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 - PRACTICAL SESSIONS:</strong><br fr-original-style="" style="box-sizing: border-box;">Multiple practical sessions throughout the session.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 - Fluids:</strong></span><br fr-original-style="" style="box-sizing: border-box;">The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann&rsquo;s solution, Colloids (and risks), blood products.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 - Infusion Rates:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Calculating infusion rates and drops per minute.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.</em></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)</strong></em></p></div></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Geopace Training

Allied Health Professions (AHP)

Intravenous Cannulation

Aesthetics

Medicine & Nursing

Venepuncture & Cannulation

Learn how to cannulate ...

    Nationally Recognised Qualification

    OCN Accredited - Level 3 (advanced) - Ireland Level 5

    CPD Accredited - The CPD Certification Service

    Classroom or Virtual Classroom options

    Covers all steps for cannulating in arm or hand

    Practise on artificial arms and fake blood!

    Essential qualification for all IV therapies

    Phlebotomy training desirable but not essential

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


1386 Courses in Sheffield

Network programming with sockets

By Systems & Network Training

Programming in HTML5 with CSS

By Systems & Network Training

Essential 5G

By Systems & Network Training

D-Link switches

By Systems & Network Training

Essential IMS

By Systems & Network Training

Complete COBOL programming

By Systems & Network Training

Complete Visual BASIC

By Systems & Network Training

LTE airside

By Systems & Network Training

Concise MPLS for engineers

By Systems & Network Training

Risk Management for IT Projects: In-House Training

By IIL Europe Ltd

Search By Location