Learn how to create a supportive and open environment for mental health and wellbeing at work, helping everyone thrive and perform at their best.
Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.
Netgear switches training course description A hands on course covering the product specifics of Netgear switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. What will you learn Install Netgear switches. Use the command line interface and the web based interface to manage Netgear switches. Configure and troubleshoot Netgear switches. Perform software upgrades. Netgear switches training course details Who will benefit: Anyone working with Netgear switches. Particularly aimed at engineers and technicians supporting Netgear switches. Prerequisites: None. Duration 2 days Netgear switches training course content Introduction How Ethernet works with hubs, How Ethernet works with switches. Installing Netgear switches. Hands on Building a network with a hub, building a network with a Netgear switch. Basic troubleshooting The Netgear switch range, LEDs, cabling issues, factory resets, default settings. Hands on Building a network with multiple Netgear switches. Configuration methods Managed vs. unmanaged switches, Console port access, telnet, web based access, SNMP, saving configurations, NVRAM, switch stacks, stacking ports. Hands on Accessing the switch using the console, IP address configuration, telnet. Console interface Password protection, the menus, menu options. Hands on Setting a password, displaying the switch configuration. Web based interface Getting started, basic format. Hands on Configuring the switch using the web interface. Port configuration Common port configuration tasks, port trunking. Hands on Configuring ports. STP configuration What is STP? Configuring STP. Hands on Enabling and disabling STP, configuring STP VLAN configuration What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Hands on Setting up VLANS, setting up 802.1Q, Inter VLAN traffic. Housekeeping TFTP, upgrades Hands on Boot from net. SNMP SNMP configuration, NMS's. Hands on Using SNMP to manage a Netgear switch, putting it all together: troubleshooting.
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.
Network virtualization training course description This course covers network virtualization. It has been designed to enable network engineers to recognise and handle the requirements of networking Virtual Machines. Both internal and external network virtualization is covered along with the technologies used to map overlay networks on to the physical infrastructure. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer implementations. What will you learn Evaluate network virtualization implementations and technologies. Connect Virtual Machines with virtual switches. Explain how overlay networks operate. Describe the technologies in overlay networks. Network virtualization training course details Who will benefit: Engineers networking virtual machines. Prerequisites: Introduction to virtualization. Duration 2 days Network virtualization training course contents Virtualization review Hypervisors, VMs, containers, migration issues, Data Centre network design. TOR and spine switches. VM IP addressing and MAC addresses. Hands on VM network configuration Network virtualization What is network virtualization, internal virtual networks, external virtual networks. Wireless network virtualization: spectrum, infrastructure, air interface. Implementations: Open vSwitch, NSX, Cisco, others. Hands on VM communication over the network. Single host network virtualization NICs, vNICs, resource allocation, vSwitches, tables, packet walks. vRouters. Hands on vSwitch configuration, MAC and ARP tables. Container networks Single host, network modes: Bridge, host, container, none. Hands on Docker networking. Multi host network virtualization Access control, path isolation, controllers, overlay networks. L2 extensions. NSX manager. OpenStack neutron. Packet walks. Distributed logical firewalls. Load balancing. Hands on Creating, configuring and using a distributed vSwitch. Mapping virtual to physical networks VXLAN, VTEP, VXLAN encapsulation, controllers, multicasts and VXLAN. VRF lite, GRE, MPLS VPN, 802.1x. Hands on VXLAN configuration. Orchestration vCenter, vagrant, OpenStack, Kubernetes, scheduling, service discovery, load balancing, plugins, CNI, Kubernetes architecture. Hands on Kubernetes networking. Summary Performance, NFV, automation. Monitoring in virtual networks.
Data has become the most important resource for every organisation – but the insights gained from data analysis will only ever be truly valuable if they can be clearly expressed to other people. This course is for anybody who works with data, and needs to communicate the meaning that's in the numbers to colleagues, customers, bosses or external stakeholders. It will give you or your team the confidence and skills to translate raw data into compelling visual stories for your key audiences. The principles and skills covered apply to the simplest PowerPoint chart, to more complex interactive visualisations. We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: What makes a great data-driven story The key elements of a successful infographic or presentation. Industry best practice, and discussion of good (and bad) examples. A simple framework for identifying the Audience, Story and Action. Session 2: Data in context How to balance function and aesthetic appeal. Identifying the right graph, chart, infographic or other visual. Framing the data and providing contextual information. Session 3: Designing for the human brain Using colours to add emphasis and meaning. Design and layout principles, and creating hierarchies of information. The principle of ‘self-sufficiency’, and removing clutter. Session 4: Navigation and narrative Tailoring visualisations for different types of communications. Structuring presentations and longer reports. Thinking in layers to create interactive dashboards. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people. Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “I was familiar with Alan’s work as a Guardian Masterclass instructor on data visualisation and digital journalism, which made it easy for me to recommend him for onsite training at the Liverpool School of Tropical Medicine. We had a large group of people interested in honing their abilities to depict their research and stories in engaging ways. Alan’s course provided great insight about common communication pitfalls and how to avoid them, how to become better communicators by understanding the audience diversity, and it showcased some great online tools for creating infographics. This should be mandatory training for all students, academics, report writers and those involved with conveying research to the media as it will help increase the clarity and accessibility of our own research stories.” Dr Lee Haines | Liverpool School of Tropical Medicine
Advanced UNIX shell scripting training course description A follow on hands on course from the Introduction to shell programming course covering the powerful sed and awk tools along with the extra Korn shell programming features. What will you learn Use regular expressions within grep, ed and many other utilities. Use awk and sed. Integrate sed and awk into shell scripts. Recognise the role of shell scripts within the UNIX system. Write shell scripts using new Korn shell features including: The select construct Arrays Arithmetic evaluation Advanced UNIX shell scripting training course details Who will benefit: Programmers developing applications under UNIX. Administrators who need time saving utilities. Technical personnel who wish to make the most out of the Korn Shell. Prerequisites: UNIX shell scripting Duration 3 days Advanced UNIX shell scripting training course contents Regular Expressions What are REs? How can they be used? How to write REs More REs e REs Tagging, matching words, repetitions. The sed editor Basic usage: Saving output, options. sed script files, sed commands, Specifying lines to edit, Hold space and pattern space, advanced commands Awk Basic usage, nawk script files, Patterns, Records and fields, Actions if, while, do, for... System variables NF, NR, RS... Arrays Functions length, printf, cos, user defined... Using nawk in shell scripts Korn shell scripts Review of Bourne shell scripts functions... Variables typeset, manipulating strings Arrays Arithmetic evaluation the let command, (( )), typeset -i The select construct Syntax, workings, REPLY, PS3 Miscellaneous Enhanced I/O, ${10}
24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Boost Your Career By Enrolling On This Newspaper Journalism Course To Get Through Challenging Moments! Get FREE 1 QLS Endorsed Certificate Course with 10 Additional CPD Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of media studies and boost yourself for your desired career, then take a step in the right direction with this industry-standard, comprehensive course designed by professionals. This bundle includes 1 premium, The Quality Licence Scheme-endorsed course, 10 additional CPDQS accredited certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Premium Newspaper Journalism Bundle includes: Course 01: Media Studies: Newspaper Journalism with an at QLS Level 5 10 Additional CPDQS Accredited Courses - Course 01: Journal Therapy Course Course 02: Proofreading & Copy Editing Course (Level 4 Diploma) Course 03: Copywriting Course Level 4 Course 04: Screenwriting & Scriptwriting Course 05: International Relations Course 06: Media and Public Relations Diploma Course 07: English Law Course Course 08: Criminal Law Course 09: Criminal Intelligence Researcher Course 10: Critical Thinking Training Success becomes a lot simpler with this bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium online bundle, supports your professional growth with Quality Licence Scheme endorsement, as well as CPD accreditation. You'll be able to practice on your own time and at your own speed while still gaining an endorsed certificate. You'll get an unrivalled learning experience, as well as a free student ID card, which is included in the course price. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. With this high-quality package, all students have access to dedicated tutor support and 24/7 customer service. Throughout the extensive syllabus of this package, you'll find the required assistance and also the answers to all of your questions. The course materials of this bundle are designed by experts, and you can access these easily from any of your smartphones, laptops, PCs, tablets etc. Master the skills to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer this Bundle Course with Academy for Health and Fitness? Upon successful completion of the bundle, you will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPDQS to expand your knowledge. Innovative and engaging content. Free assessments. 24/7 tutor support. *****Course Curriculum***** Module 01 > Introduction and Principles of Newspaper Journalism Module 02 > History and Development of Newspaper Journalism Module 03 > Interviewing for Newspaper Journalism Module 04 > News Writing Module 05 > News Production Module 06 > News Reporting Module 07 > Writing Skills for Newspaper Journalists Module 08 > Newspaper Journalism law Module 09 > Court Reporting Module 10 > Journalism Ethics Module 11 > Niche Journalism Module 12 > Tips on Writing a Good Feature Story Module 13 > Health and Safety for Journalists How is the Bundle Assessed? We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. Show off Your New Skills With a Certification of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered completely free of charge in this package. For Additional the Quality Licence Scheme Endorsed Certificate, you have to pay the price based on the Level of these Courses: Level 1 - £79 GBP Level 2 - £99 GBP Level 3 - £119 GBP Level 4 - £129 GBP Level 5 - £139 GBP Level 6 - £149 GBP Level 7 - £159 GBP Certification Accredited by CPD Upon finishing the course, you will receive an accredited certification that is recognised all over the UK and also internationally. The pricing schemes are - 10 GBP for Digital Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Bundle Right for You? The Media Studies: Newspaper Journalism package training is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! This package is also ideal for those who want to learn more about this subject in-depth and stay up to date with the latest details. Study the bundle and expand your professional skillset from the comfort of your own home! Requirements The Media Studies: Newspaper Journalism Bundle has no formal entry criteria, and everyone is welcome to enrol! Anyone with a desire to learn is welcome to this course without hesitation. All students must be over the age of 16 and have a passion for learning and literacy. You can learn online using any internet-connected device, such as a computer, tablet, or smartphone. You can study whenever it's convenient for you and finish the bundle at your own speed. Career path Studying the bundle is intended to assist you in obtaining the job of your dreams or even the long-awaited promotion. With the support and guidance of our Media Studies: Newspaper Journalism package, you will learn the important skills and knowledge you need to succeed in your professional life. Certificates CPD Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Newspaper Journalism and Media Studies - CPD Certified Hard copy certificate - Included
About Course Document Management Course: Develop and implement Document Management Strategy for productivity, security, and cost efficiency Are you tired of sifting through stacks of paper documents, losing important files, and dealing with security breaches? Our Document Management Course is here to help! In this course, you'll learn how to digitize paper documents and manage electronic files, and discover the benefits of implementing a Document Management System. We'll cover everything you need to know about protecting sensitive information, including implementing security measures, electronic signatures, access controls, and document destruction. You'll also learn how to create and edit digital documents, collaborate with others, and use version control to track changes.Learning Outcomes The fundamentals of Document Management, including digitizing paper documents and managing electronic files. The components of a Document Management System and how to use it effectively. Best practices for implementing security measures to protect sensitive information. Techniques for document creation and editing, collaboration and version control. Troubleshooting and problem-solving for common document management issues. Emerging trends and developments in the field of document management. The importance of effective document management for organizations. Compliance and regulatory considerations are crucial in Document Management, and we'll cover them in-depth. Additionally, we'll explore Document Workflow Management, including best practices for retrieval, archiving, and audit trails. The course will also cover emerging trends and developments in the field of Document Management, including content management, metadata, workflow automation, and electronic forms. You'll learn about information governance and information lifecycle management, and how these concepts impact Document Management. By the end of this course, you'll be able to troubleshoot and solve common Document Management issues, streamline your processes, and save valuable time and resources. This course is perfect for anyone looking to develop their skills in Document Management, from beginners to professionals. Join us today and revolutionize the way you manage documents! With our comprehensive curriculum and expert instructors, you'll gain the skills and knowledge you need to succeed in today's fast-paced digital world. Don't wait - sign up now and take the first step towards efficient and secure Document Management. What Will You Learn? The fundamentals of Document Management, including digitizing paper documents and managing electronic files. The components of a Document Management System and how to use it effectively. Best practices for implementing security measures to protect sensitive information. Techniques for document creation and editing, collaboration and version control. Troubleshooting and problem-solving for common document management issues. Emerging trends and developments in the field of document management. The importance of effective document management for organizations. Course Content Document Management Course Overview Overview of the Course Introduction to Document Management Introduction Digitizing paper documents and managing electronic files Digitizing paper documents and managing electronic files Document Management System Document Management System Implementing security measures to protect sensitive information Implementing security measures to protect sensitive information Document creation and editing Document creation and editing Collaboration and Version Control Collaboration and Version Control Compliance and regulatory considerations for document management Compliance and regulatory considerations for document management Document Workflow Management Document Workflow Management Troubleshooting and problem-solving for common document management issues Troubleshooting and problem-solving for common document management issues Emerging trends and developments in the field of document management Emerging trends and developments in the field of document management Conclusion Conclusion A course by Xpert Learning Audience Office Administrators and Assistants Project Managers Business Owners and Entrepreneurs Records and Information Managers Information Technology Professionals Human Resources Managers Legal Professionals Anyone looking to improve their document management skills and knowledge
This workshop covers the five main types of payment for exports, from advance payment to open account. It includes the use of Bills of Exchange with and without documents