Duration 2 Days 12 CPD hours This course is intended for This is an Intermediate and beyond-level Tableau course geared for experienced Tableau users who wish to leverage Tableau's more advanced capabilities. Overview This skills-focused course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Understand what data works best with Tableau Desktop and how to shape and clean it appropriately to get Learn how to maximize flexibility from Tableau Desktop. Learn how Tableau Prep folds into the analytic cycle, and when to prep data in Tableau Prep vs. Tableau Desktop. Understand the terminology used in Tableau Prep. Know how Tableau Prep approaches data sampling. Create and understand data prep flows that address common scenarios encountered in data preparation, as applied to common data use cases Know how to view data prepared in Tableau Prep using Tableau Desktop. Understand data exploration and validation in Tableau Prep and Tableau Desktop. Geared for experienced Tableau Users, Tableau Prep Building (Tableau Data Prep) for Experienced Users is a two-day hands-on course designed to provide you with the tools and knowledge of how to prepare and shape data in Tableau Prep. It?s best suited for people who have 3-6 months experience in Tableau Desktop and are somewhat familiar with writing calculations. Throughout the course, our instructors will take you from conceptual data preparation material to creating useful Tableau Prep flows that can be output to Tableau Desktop for analysisNOTE: The Tableau Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Tableau and its most current features, benefits and functionality in a wide array of uses. This is not Official Tableau Training. Course Outline Introduction to the workspace Introduction to the workflow Data literacy concepts Connecting to and configuring data Exploring data Cleaning data Preferred data structures in Tableau Shaping data Combining data Opening a data sample and creating an output file Best practices for data preparation Complex flows Starting with a question Hands-on data preparation Additional course details: Nexus Humans Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) 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. 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.
Duration 0.5 Days 3 CPD hours This course is intended for Security EngineersNetwork Engineers Overview This course is intended to provide a top-level overview of Palo Alto Networks© Traps? Endpoint protection product. Upon completion of the class the student will be able to understand these principles: Explain the core technologies of Traps? and how it differs from traditional signature recognition technologies. Understand the advantages of these technologies over existing solutions. Understand Traps? product architecture and deployment requirements. Installation requirements for Traps? installations. Deploy Exploit Prevention Module defenses to endpoints with Policies. Deploy Malware Protection defenses to endpoints. Provide Application Execution Control in conjunction with WildFire?. Understand deployment strategies and tactics for Workstations, VDI and Server endpoints. Gather and analyze Security Event reports and forensics. Foundation classes are just introductory trainings, NOT a full technical training. Compromise isn?t inevitable, or, at least, it shouldn?t be. Traditional endpoint protection simply cannot keep up with the rapidly evolving threat landscape, leaving organizations vulnerable to advanced attacks. A new approach is needed, one that can rebuild confidence in endpoint security. This new approach needs to prevent advanced attacks originating from executables, data files or network-based exploits ? known and unknown ? before any malicious activity could successfully run. Palo Alto Networks© call this ?advanced endpoint protection.? By focusing on the attacker?s core techniques and putting up barriers to mitigate them, the attacker?s path for exploitation becomes known, even when the attack isn?t. Traps? focuses on the core techniques leveraged by exploits in advanced cyberattacks and renders these techniques ineffective by breaking the exploit sequence and blocking the technique the moment it is attempted. IntroductionThe Traps? technology alternative to endpoint defenseTraps? Exploit and Malware protectionTraps? Product ArchitectureTraps? DeploymentTraps? Exploit Policy ManagementTraps? Malware Protection PoliciesTraps? ForensicsPractical Traps? Implementation considerations Additional course details: Nexus Humans Palo Alto Networks - Foundations of Palo Alto Networks Traps Endpoint protection (EDU-180) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Palo Alto Networks - Foundations of Palo Alto Networks Traps Endpoint protection (EDU-180) 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. 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.
Duration 2 Days 12 CPD hours This course is intended for This in an introductory-level course geared for QA, Test team members and others who want to use the Python testing framework PyTest to implement code testing strategies. Attendees should have prior basic Python scripting experience. Students should have some familiarity with tools to be used in this course: PyCharm, Jupyter Notebook and basic GIT. Overview Working within in a hands-on learning environment students will learn to: Become proficient with pytest from day one by solving real-world testing problems Use pytest to write tests more efficiently Scale from simple to complex and functional testing Write and run simple and complex tests Organize tests in fles and directories Find out how to be more productive on the command line Markers and how to skip, xfail and parametrize tests Explore fxtures and techniques to use them effectively, such as tmpdir, pytestconfg, and monkeypatch Convert unittest suites to pytest using little-known techniques The pytest framework is simple to use but powerful enough to cover complex testing integration scenarios. PyTest is considered by many to be the true Pythonic approach to testing in Python. Geared for QA, Test team members and others who want to use the Python testing framework PyTest to implement code testing strategies, Test Automation with Python is a hands-on, two day Python testing course that provides students with the skills required to get started with PyTest right away. Participnats will learn how to get the most out of it in their daily workflow, exploring powerful mechanisms and plugins to facilitate many common testing tasks. Students will also learn how to use pytest in existing unittestbased test suites and will learn some tricks to make the jump to a pytest-style test suite quickly and easily. Python Refresher Python Overview Python Basics Python Lab Introducing PyTest Why Spend time writing test UnitTest Module Why PyTest? Introductory Lab Writing and Running Test Installing PyTest Writing and Running Tests Organizing files and packages Command Line options Configure pytest.ini Install and Config Lab Markers and Parameters Mark Basics Built-in marks Parameterization Markers and Parameters Lab Fixtures Introduction to Fixtures Sharing fixtures with conftest.py files Scopes Autouse Parameterizing fixtures Using marks from fixtures Built-in fixtures Best Practices Fixtures Lab Fixtures Lab 2 Plugins Finding and installing plugins Overview of plugins Plugin Lab From UnitTest to PyTest Use PyTest as a Test Runner Convert asserts with unitest2pytest Handling setup/teardown Managing test hierarchies Refactoring test utilities Migration strategies Additional course details: Nexus Humans Test Automation with Python (TTPS4832) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Test Automation with Python (TTPS4832) 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. 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.
Duration 3 Days 18 CPD hours PostgreSQL is a powerful, open-source, object-relational database system known for being reliable, secure, and flexible. For administrators, learning PostgreSQL equips you with the skills needed to handle complex and high-performance databases in our data-driven world. Big-name companies like Apple, Cisco, Fujitsu, and IBM trust PostgreSQL for their critical applications, which highlights its significance and broad industry adoption. By getting the hang of PostgreSQL, administrators can boost their career opportunities and play a key role in the success of data-focused businesses. PostgreSQL Server Administration is a three-day hands-on course geared for administrators seeking to sharpen their skills and elevate their database management capabilities. Throughout the course you?ll explore a wide range of essential topics, from server architecture and user accounts to monitoring and routine maintenance. Throughout the course, you'll gain invaluable insights and practical techniques that will empower you to optimize, secure, and manage your PostgreSQL environment effectively. As you navigate through server configuration, database reporting, backup and restore procedures and more, you'll have the opportunity to apply your newfound knowledge to real-world scenarios. By the end of the course, you'll be equipped with the confidence and skillset required to tackle a wide array of administrative challenges and to effectively manage your PostgreSQL databases. Additional course details: Nexus Humans PostgreSQL Server Administration (TTDB7020) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the PostgreSQL Server Administration (TTDB7020) 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. 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.
Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) 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. 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.
To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable: Tuesday 4 June: 9 - 12:30 Friday 7 June: 9 - 12:30 Friday 14 June: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.
To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable: Wednesday 10 April: 9 - 12:30 Wednesday 17 April: 9 - 12:30 Thursday 25 April: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.
To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable: Tuesday 12 March: 9 - 12:30 Friday 15 March: 9 - 12:30 Friday 22 March: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.
For anyone who has to deliver presentations who wants to become more confident and improve their speaking skills.
The emphasis is on competence, fitness to practice and life-long learning. Underpinning this is that clinical specialists and experts take the lead in teaching and training to develop knowledge and skills. However, not everyone has the tools to teach knowing how to is the key to successful learning, this programme is designed to Train the Trainer.