3795 Engineer courses in Matlock delivered Online

Our new and improved pipe and pump sizing calculator tool. This one hour session will provide an introduction into the following: Justifying the default values (maximum & minimum velocities, pressure loss etc) Preparing a schematic as a reference. Labelling sections and identifying circuits. Picking rooms or radiators for total mass flow rate (kg/s) Selecting flow temperatures and delta temperatures. Selecting pipe sizes for each section. Reviewing the automated velocity checks (m/s) Reviewing the automated maximum pressure drop allowance (Pa/m) Creating circuits Reviewing the index circuit Final results to size your circulation pump. Q & A session after the above is explained and demonstrated.

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Advanced Cyber Security Course is one of our best selling and most popular course. This course gives you the background needed to understand basic cyber security and risk management. This program will provide you with the knowledge and abilities necessary to defend networks, create secure infrastructures, safeguard electronic assets, prevent cyberattacks, and protect your own privacy. The Advanced Cyber Security Course is organised into 3 modules and includes everything you need to become successful in this profession. What Will You Learn? Discover security vulnerabilities across an entire network by using network hacking techniques and vulnerability scanning Understand how we are tracked online by corporations, nation-states, your ISP and others Perform network monitoring to discover and identify potential hackers and malware You will learn how networking affects security systems within an organization What classes are included in this package? Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? The Advanced Cyber Security Course course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. The Diploma in Professional Chef course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. Career Path Training offered by the Advanced Cyber Security Course could potentially benefit a range of roles but would particularly enhance careers in: Software Developer Network Administrator Cybersecurity Engineer Malware Analyst Computer Forensics Analyst Security Architect Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. Certificate of Achievements from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the Advanced Cyber Security Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically, and the results will be given to you immediately.

Kubernetes for engineers training course description This course covers how Kubernetes addresses the challenges of distributed systems. Hands on sessions follow all the major theory chapters. What will you learn Explain what Kubernetes is and how it works. Create and run containers on Kubernetes using the Docker image format and container runtime. Kubernetes for engineers training course details Who will benefit: Anyone working with Docker or Kubernetes. Prerequisites: Definitive Docker for engineers. Duration 2 days Kubernetes for engineers training course contents Introduction Velocity, Scaling your service and your teams, Abstracting your infrastructure. Creating and running containers Container images, Building application images with Docker, Storing images in a remote registry, The Docker container runtime. Deploying a Kubernetes cluster Installing Kubernetes on a public cloud provider, Installing Kubernetes locally using minikube, Running Kubernetes on Raspberry Pi, The Kubernetes client, Cluster components. Common kubectl Commands Namespaces, Contexts, Viewing Kubernetes API objects, Creating, Updating, and Destroying Kubernetes objects, Labelling and annotating objects, Debugging commands. Pods Pods in Kubernetes, Thinking with pods, The pod manifest, Running pods, Accessing your pod, Health checks, Resource management, Persisting data with volumes, Putting It all together. Labels and Annotations Labels, Annotations. Service Discovery What Is Service discovery? The service object, Looking beyond the cluster, Cloud integration, Advanced details. ReplicaSets Reconciliation loops, Relating pods and ReplicaSets, Designing with ReplicaSets, ReplicaSet Spec, Creating a ReplicaSet, Inspecting a ReplicaSet, Scaling ReplicaSets, Deleting ReplicaSets. DaemonSets DaemonSet scheduler, Creating DaemonSets, Limiting DaemonSets to specific nodes, Updating a DaemonSet, Deleting a DaemonSet. Jobs The job object, Job patterns. ConfigMaps and secrets ConfigMaps, Secrets, Naming constraints, Managing ConfigMaps and secrets. Deployments Your first deployment, Creating deployments, Managing deployments, Updating deployments, Deployment strategies, Deleting a deployment. Integrating storage solutions and Kubernetes Importing external services, Running reliable singletons, Kubernetes-native storage with StatefulSets. Deploying real-world applications Parse, Ghost, Redis.

OTT TV for engineers course description This course covers OTT TV by primarily looking at the delivery of video streams using HTTP adaptive streaming. Both MPEG DASH and HLS are investigated. Hands on sessions involve using Wireshark to analyse streams as well as crafting segmented content. What will you learn Explain what OTT TV is, and how it works. Describe the OTT TV architecture. Use Wireshark to analyse and troubleshoot OTT video streams. Explain how HTTP adaptive streaming works. Evaluate and compare MPEG DASH and HLS. Use tools to create OTT TV adaptive streams. OTT TV for engineers course details Who will benefit: Anyone working in the broadcast industry. Prerequisites: TCP/IP foundation for engineers. Duration 2 days OTT TV for engineers course contents What is OTT TV? Brodeo providers vs ISPs. Progressive downloads versus streaming. Why not UDP and RTP for delivery? Adaptive bit rate streaming. Standards. Hands on: Base network setup. Using WireShark for HTTP streams. HTTP protocol stack IP, TCP, IPv6. HTTP. HTTP 1.0, HTTP 1.1, HTTP 2.0, HTTP header fields. HTML 5. Hands on: Analysing HTTP. Adaptive bitrate streaming principles Chunks, fragments, segments. Manifest files. Encoding, resolution, bitrates. Addressing, relative and absolute URLs, redirection. When does the client switch streams? Switch points. Hands on: Walk through of client behaviours on a stream. OTT TV streaming architecture Server components, distribution components, client software. CDN, caching, multiple servers. Hands on: Analysing CDN and Internet delivery. TCP and HTTP streaming interactions TCP ACK, TCP connections, unicast only. TCP flow control, TCP and performance. Hands on: TCP window sizes. MPEG DASH Stakeholders, DASH architecture and model, codec agnostic, XML, Media Presentation Description, Media Presentation, segment formats. Hands on: MPEG DASH analysis. HTTP Live Streaming and others Stakeholders. Media segments, media playlists, master playlists. Adobe HTTP dynamic streaming, Microsoft smooth streaming. Hands on: Analysing HLS. Tools mp4dash, mp4fragment, libdash. Apple developer tools for HLS. Hands on: Creating segmented content. Security HTTPS, encryption, content protection. Hands on: Encryption analysis. Summary Choosing a streaming method. Impact of live versus VoD. Web sockets.

Total MPLS VPN for engineers training course description A hands on course concentrating solely on MPLS VPNs. The course begins with a review of VPN basics before moving onto L3VPNs and MBGP, followed by L2VPNs. What will you learn Compare, contrast and evaluate MPLS L2VPNs versus L3VPNs. Describe, configure and troubleshoot MPLS L3VPNs. Configure and troubleshoot MBGP. Describe, configure and troubleshoot MPLS L2VPNs. Total MPLS VPN for engineers training course details Who will benefit: Anyone working with MPLS VPNs. Prerequisites: Concise MPLS for engineers Duration 2 days Total MPLS VPN for engineers training course contents MPLS VPN basics LSR, PE and P router roles. What is a VPN? MPLS VPN types, MPLS VPN comparison, MPLS L3VPN, L2VPN. VPN architectures. Hands on: Building the base network. L3VPN Separate routing tables, The Virtual Routing Table, VRFs, Route Distinguisher (RD), VNPv4 addresses. Hands on: Minimal VRF configuration, routing between customer and provider (PE-CE). MBGP MP-BGP, IPv4 routing, IPv6 routing, VPNv4 addresses, VPNv6 addresses. Exchanging labels. Exchanging routes. Route targets, communities. Route reflectors. Hands on: MBGP setup. MPLS L3VPN troubleshooting. L2VPN Why L2 not L3? Services: TDM, ATM, Frame Relay, Ethernet. Pseudowires. Hands on: Simple L2VPN configuration. Pseudowires VPWS, AToM, Attachment Circuit, Traffic encapsulation, Ethernet over MPLS. Ethernet MTU considerations. VC types. Hands on: PW configuration and troubleshooting. VPLS Ethernet multipoint connectivity. Virtual Forwarding Instance (VFI), Virtual Switching Instance. Flooding, MAC address management, split horizons. Hierarchical VPLS. Signalling: LDP based. BGP based. Auto discovery. Hands on: VPLS configuration and troubleshooting. Next generation L2VPN E-VPN, PBB-EVPN.

Docker for engineers training course description Docker is the container platform of choice. This course covers how to use Docker to package your applications with all of their dependencies and then test, deploy, scale and support your containers. Hands on sessions follow all the major sessions. What will you learn Work with Docker images, containers and command line tools. Deploy and test Docker containers. Debug Docker containers. Describe Docker networking, deployment tools, orchestration and security. Docker for engineers training course details Who will benefit: Anyone working with Docker. Prerequisites: Introduction to virtualization. Duration 2 days Docker for engineers training course contents Introduction The birth of Docker, the promise of Docker, what Docker isn't. Docker at a glance Process simplification, broad support and adoption, architecture, getting the most from Docker, the Docker workflow. Installing Docker Important terminology, Docker client, Docker server, test the setup. Working with Docker images Anatomy of a Dockerfile, building an image, running your image, custom base images, storing images. Working with Docker containers What are containers? creating a container, starting a container, auto-restarting a container, stopping a container, killing a container, pausing and unpausing a container, cleaning up containers and images, next steps. Exploring Docker Printing the Docker version, server information, downloading image updates, inspecting a container, getting inside a running container, exploring the shell, returning a result, docker logs, monitoring Docker, exploration. The path to production containers Deploying, testing containers. Debugging containers Process output, process inspection, controlling processes, network inspection, image history, inspecting a container, filesystem inspection, moving along. Docker at scale Docker swarm, centurion, amazon EC2 container service. Advanced topics Pluggable backends, containers in detail, security, networking. Designing your production container platform The twelve-factor app, the reactive manifesto. Conclusion The challenges, the Docker workflow, minimizing deployment artifacts, optimizing storage and retrieval, the payoff, the final word.

Learn the essential knowledge and build solid skills in biotechnology with the Biotechnology course. This course will enrich your understanding of biology and present you with job opportunities in the field of business, healthcare, and other industries. Within no time, you will become competent and confident to establish a brilliant career. The Biotechnology course is divided into easy to follow bite-sized modules to help you understand every topic without difficulties. Here, you will learn the core principles and the history of biotechnology. The informative lectures will educate you on molecular and cellular biotechnology. In addition, you will receive the ability to identify the differences between biotechnology and molecular biology. This comprehensive course will also help you grasp the fundamentals of genetic engineering.  Through this Biotechnology course, you will understand the significance of biology in different industries, healthcare sectors and business sectors. At the end of this course, you will receive a valuable certificate, which you'll elevate your resume and boost your employability in the relevant sector. Enrol today! Please note: Our Biotechnology course only gives you theoretical knowledge to excel in this field. This course doesn't entitle you to practise as a professional in this specific field. Learning Objectives Get introduced to the basics of biotechnology Learn about the history of biotechnology Enrich your knowledge of molecular and cellular biology Understand the difference between biotechnology and molecular biology Grasp the principles of genetic engineering Know the fundamental of industrial biotechnology Understand the role of biotechnology in the health and business sector Who is this Course for? This Biotechnology course is ideal for aspiring biotechnologists who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of biotechnology or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Biotechnology course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Biotechnology course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Biomedical Engineer Biochemist Clinical Technician Microbiologist Process Development Scientist Biomanufacturing Specialist Business Development Manager Medical Lab Technologist Microbiologist Clinical Support Specialist Course Curriculum Module 1 - Introduction to Biotechnology Introduction to Biotechnology 00:19:00 Module 2- Biotechnology in the Realm of History Biotechnology in the Realm of History 00:27:00 Module 3- Molecular and Cellular Biology Molecular and Cellular Biology 00:27:00 Module 4 - Biotechnology Versus Molecular Biology Biotechnology Versus Molecular Biology 00:11:00 Module 5- Genetic Engineering Genetic Engineering 00:16:00 Module 6- Biotechnology in Health Sector Biotechnology in Health Sector 00:11:00 Module 7- Industrial Biotechnology Industrial Biotechnology 00:14:00 Module 8- Biotechnology in a Business Perspective Biotechnology in a Business Perspective 00:13:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Advanced DNS training course description This two-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course follows on from our Definitive DNS for engineers course starting with best practices. The majority of the course is spent on securing DNS and in particular DNSSEC. Some parts are specific to BIND. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Implement DNS best practices. Harden DNS servers. Install, configure, maintain and troubleshoot DNSSEC. Advanced DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel. System administrators. Prerequisites: Total DNS for engineers Duration 2 days Advanced DNS training course contents Best practices MX and PTR records, lame delegations, disallowing recursion, TTLs, online testing. Hands on Review of your DNS servers. Split DNS Partitioning internal and external DNS, views. Hands on Implementing split DNS. Hardening DNS ACLs, recursion, queries, trusted sources, chroot jail, secure BIND template. Hands on Securing the DNS server. DNSSEC What is DNSSEC? DNSSEC benefits, DNSSEC RRs. DNSKEY, RRSIG, NSEC, DS. Hands on Creating DNSSEC keys. Securing zone transfers TSIG, shared secret. Securing DDNS. Hands on Secure file transfers. Zone integrity Trusted anchors, Chains of trust, Zone status, Zone signing, Keys. ZSK, KSK, adding keys to a zone file. Secure delegations. Hands on Zone signing Maintaining Signed zones Key rollover, pre publish, double signing, rollover cache.

Advanced TCP/IP training course description An intensive advanced TCP/IP course focusing on the details of the protocols according to the RFCs. This course is designed to go into the technical details of the protocols and is not for those that are new to TCP/IP. A particular focus is on TCP and performance. Those more interested in routing protocols should see our Definitive IP routing for engineers course. It is expected that delegates are totally familiar with configuration addressing. Hands on sessions consist of protocol analysis using Wireshark. What will you learn Analyse packets and protocols in detail. Troubleshoot networks using Wireshark. Find performance problems using Wireshark. Perform network forensics. Advanced TCP/IP training course details Who will benefit: Advanced technical staff. Prerequisites: TCP/IP Foundation for engineers Duration 5 days Advanced TCP/IP training course contents IP Fragmentation and MTU issues, Path MTU discovery, Geolocation, unusual IP addresses, forwarding broadcasts, DiffServ, DSCP, ECN, assured and expedited forwarding. TTL usage in traceroute, Protocol field. Sanitising IP addresses in trace files. Wireshark and checksum errors. IPv6 The header. Extension headers. Traffic class and flow labels. Tunnelling. IPv6 and fragmentation. ARP Requests, responses, gratuitous ARP, Proxy ARP, ARP poisoning. ICMP ping, Round Trip Times, ICMP redirect, ICMP router advertisement and solicitation, Time Exceeded, Destination unreachable. ICMPv6: Similarity to ICMPv4, Neighbor discovery and the replacement of ARP. MLD. First hop redundancy ICMP discovery, HSRP, VRRP, GLBP. IGMP Multicast overview, multicast architecture, multicast addresses, IGMP v1, IGMPv2, IGMPv3. UDP Use in broadcasts and multicasts. Port numbers. TCP Connections, RST, FIN, sequence numbering, packet loss recovery, Fast recovery, RTO timeout, SACK, TCP flow control, receive window, congestion window, van Jacobsen, nagle, delayed ACKs, PSH, URG, TCP options, MSS, Window scaling, TCP timestamps. Congestion notification. Hands on Troubleshooting with sequence numbers, Wireshark IO and TCP graphs to analyse performance. Window size issues. DHCP DHCP header. Relationship to BOOTP. Discover, offer, request, decline, ACK, release. Lease, renewal and rebind times. Relay agents. DHCPv6 DNS Names and addresses, Resource Records, queries, responses, problems. MDNS. HTTP Requests, methods, request modifiers, response codes. HTTPS. SSL, TLS. Proxies. Hands on Redirects, recreating pages from packets. FTP Commands, responses, passive/active mode. Email SMTP, POP3, IMAP, commands responses. Voice and Video RTP, RTCP, SIP. IP PBXs. Traffic flows. Hands on Voice playback. SNMP MIBs, GET, TRAP, polling. Performance Baselining, high latency, Wireshark and timings, packet loss, redirections, small packets, congestion, name resolution. Security Network forensics, scanning and discovery, suspect traffic. IPsec, SSH.