291 Network & Security courses in Bradford

INTRO TO SQL TRAINING COURSE DESCRIPTION A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. WHAT WILL YOU LEARN * Explain the difference between standard SQL and different flavours. * Use SQL statements to query databases. * Use SQL statements to define databases. INTRO TO SQL TRAINING COURSE DETAILS * Who will benefit: Anyone working with databases. * Prerequisites: None. * Duration 2 days INTRO TO SQL TRAINING COURSE CONTENTS * What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. * Database basics RDBMS, Tables. Hands on Investigating a database. * Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. * SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. * More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. * Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. * SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. * SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. * Data control GRANT, REVOKE. Hands on Defining permissions.

WIRESHARK 101 TRAINING COURSE DESCRIPTION Wireshark is a free network protocol analyser. This hands-on course focuses on troubleshooting networks using the Wireshark protocol analyser. The course concentrates on the product and students will gain from the most from this course only if they already have a sound knowledge of the TCP/IP protocols WHAT WILL YOU LEARN * Download and install Wireshark. * Capture and analyse packets with Wireshark. * Configure capture and display filters. * Customise Wireshark. * Troubleshoot networks using Wireshark. WIRESHARK 101 TRAINING COURSE DETAILS * Who will benefit: Technical staff looking after networks. * Prerequisites: TCP/IP Foundation for engineers * Duration 2 days WIRESHARK 101 TRAINING COURSE CONTENTS * What is Wireshark? Protocol analysers, Wireshark features, versions, troubleshooting techniques with Wireshark. * Installing Wireshark Downloading Wireshark, UNIX issues, Microsoft issues, the role of winpcap, promiscuous mode, installing Wireshark. Wireshark documentation and help. Hands on Downloading and installing Wireshark. * Capturing traffic Starting and stopping basic packet captures, the packet list pane, packet details pane, packet bytes pane, interfaces, using Wireshark in a switched architecture. Hands on Capturing packets with Wireshark. * Troubleshooting networks with Wireshark Common packet flows. Hands on Analysing a variety of problems with Wireshark. * Capture filters Capture filter expressions, capture filter examples (host, port, network, protocol), primitives, combining primitives, payload matching. Hands on Configuring capture filters. * Working with captured packets Live packet capture, saving to a file, capture file formats, reading capture files from other analysers, merging capture files, finding packets, going to a specific packet, display filters, display filter expressions. Hands on Saving captured data, configuring display filters. * Analysis and statistics with Wireshark Enabling/disabling protocols, user specified decodes, following TCP streams, protocol statistics, conversation lists, endpoint lists, I/O graphs, protocol specific statistics. Hands on Using the analysis and statistics menus. * Command line tools Tshark, capinfos, editcap, mergecap, text2pcap, idl2eth. Hands on Using tshark. * Advanced issues 802.11 issues, management frames, monitor mode, packet reassembling, name resolution, customising Wireshark. Hands on Customising name resolution.

CONCISE CISCO SWITCHES COURSE DESCRIPTION A hands on course covering the product specifics of Cisco switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. WHAT WILL YOU LEARN * Install Cisco switches. * Use the command line interface and the web based interface to manage Cisco switches. * Configure and troubleshoot Cisco switches. * Perform software upgrades and maintain configurations using TFTP. CONCISE CISCO SWITCHES COURSE DETAILS * Who will benefit: Anyone working with Cisco switches. Particularly aimed at engineers and technicians supporting Cisco switches. * Prerequisites: None. * Duration 2 days CONCISE CISCO SWITCHES COURSE CONTENT * Ethernet review Single segment Ethernet, CSMA/CD, Broadcast domains, collision domains. Hubs, Extending the LAN. Hands on Hub based Ethernet. * Cisco switches What are switches, frame forwarding and filtering, the forwarding database. Hands on Switched based Ethernet. * Configuring Cisco switches Accessing the switch, installing the switch, The CLI, connecting PCs using the switch. Hands on Configuring Cisco switches. * The command line interface User and privilege modes, online help, show, basic troubleshooting. The configuration editor, Global, major and sub commands, enable, secret and other passwords. Hands on Simple troubleshooting using the CLI. * Port configuration Speed, duplex, security, trunking. Hands on Port trunking. * Spanning Tree Protocol Spanning Tree, Loops, effect, root bridges, bridge port states, STP reconfiguration. RSTP and variants. Hands on STP. * VLANS What are VLANs, configuring VLANs, access ports and trunks, 802.1Q, inter VLAN routing. Hands on Access ports, trunks, layer 3 switching. * Housekeeping Configuration management, software management, password recovery. Hands on TFTP. * Managing interconnection devices SNMP, RMON, RMON II. * Troubleshooting LEDs, CDP, logging, Layer 1, layer 2, layer 3. Hands on Fixing things.

MOBILE COMMS TRAINING COURSE DESCRIPTION A complete overview of mobile communications covering all the major technologies in a 2-day format. WHAT WILL YOU LEARN * GSM * GPRS * UMTS * LTE * Alternative mobile strategies MOBILE COMMS TRAINING COURSE DETAILS * Who will benefit: Anyone involved in mobile communications. * Prerequisites: None. * Duration 2 days MOBILE COMMS TRAINING COURSE CONTENTS * Introduction Telephony, RF, mobile and wireless technologies, distances, mobile phone generations, base stations, cells, frequencies, cell types, MSC, handoffs, channels, internetworking, the Internet, wireless Internet access. UK operators, worldwide operators. * GSM What is it? Timeline, digitising voice, channels, GSM architecture, Abis, A, Um, MS, BTS, BSC, MSC, HLR, VLR, EIR, AuC. Radio link aspects, GSM signalling overview, signalling protocols, roaming, GSM call flows, authentication. IMEI. SIM cards. * GPRS What it is, 2G to 3G, GPRS user features, GPRS network features, GPRS elements, GPRS architecture, overlay, SGSN, GGSN, GPRS ATTACH, GPRS protocol stack, GPRS timeslots, EDGE, GPRS classes, GPRS routing, GPRS packet format. * UMTS and 3G What is 3G? IMT-2000, 3G proposals, what is UMTS? Speed comparison, evolution to 3G, CDMA, CDMA 2000, W-CDMA, UMTS components, UMTS infrastructure, RNC, Node B, network architecture, packet switched attach, mobility in 3G, HSDPA. * LTE and 4G LTE architecture and principles, Physical layer, Air interface, E-UTRAN, Evolved packet core, service provision. * Other wireless solutions Integration of services, Bluetooth, Blackberry, VoIP, Mobile IP, 802.11, WiFi, 802.16, WiMax, What is 5G?

HP PROCURVE TRAINING COURSE DESCRIPTION A hands on course covering the product specifics of HP switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. WHAT WILL YOU LEARN * Install HP ProCurve switches. * Use the command line interface and the web based interface to manage HP ProCurve switches. * Configure and troubleshoot HP ProCurve switches. * Perform software upgrades and maintain configurations using TFTP. HP PROCURVE TRAINING COURSE DETAILS * Who will benefit: Anyone working with HP switches. Particularly aimed at engineers and technicians supporting HP switches. * Prerequisites: None. * Duration 2 days HP PROCURVE TRAINING COURSE CONTENT * Introduction Traditional Ethernet, Hubs, Frames, MAC addresses. Hands on Building a network with a hub * What is a switch? Switches versus hubs, the MAC address table, handling unknown addresses. Hands on Building a network with HP switches. * Configuration methods How to configure a HP switch using: Console port access menus, CLI, telnet, web based access. Hands on Console access, show commands, using the menus, IP address configuration, telnet. * Command Line Interface Operator mode, Manager mode, configuration mode, passwords, online help, CLI commands, basic troubleshooting. Hands on More show commands, basic troubleshooting, setting a password, displaying status and counters. * Web based interface Web access, basic format, Getting started. SSL. Hands on Web based configuration. * Port configuration Common port configuration tasks, port security, port aggregation. Hands on Configuring ports. Trunking and failover. * STP configuration Broadcast storms. What is STP? RSTP. Configuring STP. Hands on Enabling and disabling STP, investigation failover. * VLAN configuration What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Addressing and VLANs, Layer 3 switches and VLANs. Hands on Setting up VLANS, setting up tagged ports, Inter VLAN traffic. * Housekeeping TFTP, software upgrades, downloading configurations. Hands on Software upgrade, downloading a configuration. * SNMP SNMP configuration, HP OpenView. Hands on Using SNMP to manage a HP ProCurve switch. * Basic troubleshooting Putting it all together. Layer 1 troubleshooting, Layer 2 troubleshooting. * Miscellaneous exercises CDP. Logging

HP SWITCHES TRAINING COURSE DESCRIPTION A hands on course covering the product specifics of HP switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. WHAT WILL YOU LEARN * Install HP switches. * Use the command line interface and the web based interface to manage HP switches. * Configure and troubleshoot HP switches. * Perform software upgrades and maintain configurations using TFTP. HP SWITCHES TRAINING COURSE DETAILS * Who will benefit: Anyone working with HP switches. Particularly aimed at engineers and technicians supporting HP switches. * Prerequisites: None. * Duration 2 days HP SWITCHES TRAINING COURSE CONTENT * Introduction Traditional Ethernet, Hubs, Frames, MAC addresses. Hands on Building a network with a hub. * What is a switch? Switches versus hubs, the MAC address table, handling unknown addresses. Hands on Building a network with HP switches. * Configuration methods How to configure a HP switch using: Console port access menus, CLI, telnet, web based access. Hands on Console access, show commands, using the menus, IP address configuration, telnet. * Command Line Interface Operator mode, Manager mode, configuration mode, passwords, online help, CLI commands, basic troubleshooting. Hands on More show commands, basic troubleshooting, setting a password, displaying status and counters. * Web based interface Web access, basic format, Getting started. SSL. Hands on Web based configuration. * Port configuration Common port configuration tasks, port security, port aggregation, Hands on Configuring ports. Trunking and failover. * STP configuration Broadcast storms. What is STP? RSTP. Configuring STP. Hands on Enabling and disabling STP, investigation failover. * VLANs What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Addressing and VLANs, Layer 3 switches and VLANs. Hands on Setting up VLANS, setting up tagged ports, Inter VLAN traffic. * Housekeeping TFTP, software upgrades, downloading configurations. Hands on Software upgrade, downloading a configuration. * SNMP SNMP configuration, HP OpenView NNM. Hands on Using SNMP to manage a HP switch. * Basic troubleshooting Putting it all together. Layer 1 troubleshooting, Layer 2 troubleshooting. * Miscellaneous exercises CDP. Logging

ADVANCED KIBANA TRAINING COURSE DESCRIPTION This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. WHAT WILL YOU LEARN * Lens * Timelion * Maps * Custom Visualisations with Vega * Canvas * Filters and Controls * Drilldown and Dashboards * KQSL and ElasticQueries * Scripted and RunTime Fields * Alerts and Alarms ADVANCED KIBANA TRAINING COURSE DETAILS * Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. * Prerequisites: None * Duration 1 day ADVANCED KIBANA TRAINING COURSE CONTENTS Topics * Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations * Visualise Library Timeseries, Metrics Different types of aggregations * Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips * Custom Visualisations with Vega Introduction to vega scripting * Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions * Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters * Drilldown Dashboards Linking one dashboard to another * KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search * Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues * Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)

LINUX SHELL SCRIPTING TRAINING COURSE DESCRIPTION A practical introduction to writing scripts using the Bourne shell under any Linux operating system. Applicable for those using the Korn shell as well. WHAT WILL YOU LEARN * Read shell scripts. * Write shell scripts. * Use different types of quotes. * Recognise the role of shell scripts within the Linux system. LINUX SHELL SCRIPTING TRAINING COURSE DETAILS * Who will benefit: Programmers developing programs under UNIX. Administrators / support personnel who wish to find out more about the workings of Linux or write simple utility programs. * Prerequisites: Linux Fundamentals * Duration 2 days LINUX SHELL SCRIPTING TRAINING COURSE CONTENTS * Review of Linux fundamentals * Basic shell scripts What does the shell do? How are commands executed? Different shells. what is a shell script? Comments, creating shell scripts. * Variables Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. * Positional parameters $0 to $9, $#, $* and others. shift parameter substitution. * Control statements The test command The if statement while loops for loops The case statement. * Special characters Redirection of errors, here documents, quoting. * Arithmetic in shell scripts The expr command. * System shell scripts * Screen handling The terminfo database, The tput command. * Advanced issues (optional session) Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell. * Optimising shell scripts The time command, performance tips.

ESSENTIAL SD-WAN TRAINING COURSE DESCRIPTION SD-WAN is rapidly growing in use. This vendor neutral course starts with an introduction to what SD-WAN is and when it is useful. Each main area of SD-WAN is then studied in more detail to enable delegates to recognise the technologies used in SD-WAN and then use this information to evaluate SD-WAN products. WHAT WILL YOU LEARN * Describe what SD-WAN is (and isn't). * Explain how SD-WAN works. * Evaluate SD-WAN products. * Compare and contrast SD-WAN with other technologies such as MPLS, Ethernet, SDN, NFV and WAN optimisation. ESSENTIAL SD-WAN TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to learn about SD-WAN. * Prerequisites: Network fundamentals. * Duration 1 day ESSENTIAL SD-WAN TRAINING COURSE CONTENTS * What is SD-WAN? What is SD and SDN? What is WAN? Branch/ Office. MPLS, MPLS vs Internet, Ethernet, Broadband, LTE/4G, Cable, Satellite. The impact of the cloud. Single console, Dynamic path selection, automation. Why SD-WAN? * Single console Network management, orchestration, administration. Example GUI interfaces. Northbound and southbound APIs. * Dynamic path selection SD-WAN transports, Overlay networks, security. VPNs, IPsec. QoS and prioritization. Policies, traffic path rules. Application specific routing, bonding, optimisation. * Automation Time saving, removing errors. Zero touch, ZOOM, ZTP. The role of the orchestrator. Real time monitoring of the network. APIs. * Architecture and products Hardware solutions, software solutions, virtual appliances. Clouds. SD-WAN edge devices, SDWAN controllers, Orchestrators. HA and SD-WAN. Riverbed, Cisco, Juniper, others. * Summary SD-WAN doesn't replace MPLS, virtualisation and SD-WAN. Relationship with SDN and NFV. SDWAN versus WAN optimisation.

STREAMING TELEMETRY TRAINING COURSE DESCRIPTION An introduction to streaming telemetry. The course progresses from a brief look at the weaknesses of SNMP onto what streaming telemetry is, how it differs from the xflow technologies, the data formats available and how to configure it. WHAT WILL YOU LEARN * Describe streaming telemetry. * Explain how streaming telemetry works. * Describe the data presentation formats available. * Configure streaming telemetry. STREAMING TELEMETRY TRAINING COURSE DETAILS * Who will benefit: Network engineers. * Prerequisites: TCP/IP foundation for engineers. * Duration 1 day STREAMING TELEMETRY TRAINING COURSE CONTENT * What is streaming telemetry? SNMP weaknesses, Netflow, sflow, polling and the old models, push vs pull, What is streaming telemetry? * Telemetry streaming architecture Model driven versus event driven telemetry, subscriptions, publications. Periodic versus on change, model selection and scalability. Telemetry streaming protocols TCP, UDP, SSH, HTTP, HTTP2, NETCONF, RESTCONF, gRPC, gNMI. * Models and Encoding The role of YANG. YANG models and tools. XML/ NETCONF, JSON/RESTCONF, JSON over UDP. Protocol buffers/gRPC. * Google Protocol Buffers Decoder ring, protocol definition file. GPB-KV, GPB-Compact. Keys. * Streaming telemetry configuration Router: Destination, Sensor, subscription. Collector: YANG models, .proto file. Pipeline. ELK: Consume, store, visualise streaming data. * Collection tools APIs, YANG development Kit, Downstream consumers, influxdata, Grafana, Kafka, Prometheus, others.