824 Courses

Duration 2 Days 12 CPD hours This course is intended for This course is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL or EDB Postgres Advanced Server. It teaches the essential skills required by Postgres DBAs to be successful. Overview This certification exam assesses and certifies a database professional to demonstrate the fundamental skills necessary to maintain and manage a PostgreSQL server and applications in a production environment. This course presents the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data. It also introduces learners to enterprise class tools for Postgres administration and prepares them to handle real time, production environments. Upon course completion, the learners will be prepared to manage large, highly available Postgres databases with confidence. Introduction and Architectural OverviewSystem ArchitecturePostgreSQL InstallationEDB Postgres Advanced Server InstallationDatabase ClustersConfigurationCreating and Managing DatabasesCommand Line User ToolsGUI ToolsSecurity BasicsSQL PrimerBackup, Recovery, and PITRRoutine MaintenanceData DictionaryMoving Data Additional course details: Nexus Humans Foundations of Postgres Administration 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 Foundations of Postgres Administration 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 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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 5 Days 30 CPD hours This course is intended for Networking and security professionals involved in the management, configuration, administration, and monitoring of FortiGate devices used to secure their organizations' networks. Overview In interactive labs, you will explore firewall policies, user authentication, basic VPNs, explicit proxy, virus detection, web filtering, application control and more. These administrative fundamentals will provide you with a solid understanding of how to integrate and maintain basic network security. In the last three days you will review topics including features commonly used in complex or larger enterprise/MSSP networks, such as advanced routing, transparent mode, redundant infrastructure, security-as-a-service (SaaS), advanced IPsec VPN, IPS, SSO, certificates, data leak prevention, diagnostics, and fine-tuning performance. The Fortinet NSE 4 Bundle is a 5-day event that provides the basic configuration and administration of the most commonly used features of FortiGate appliances and a selection of advanced FortiGate networking and security features. The Fortinet NSE 4 Bundle is a 5-day event that provides the basic configuration and administration of the most commonly used features of FortiGate appliances and a selection of advanced FortiGate networking and security features. Additional course details: Nexus Humans NSE 4 Bundle 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 NSE 4 Bundle 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 This course is intended for Anyone who wants to qualify as a professional tester. The certification also offers good qualifications for builders, designers, programmers and project managers Overview This three-day training provides a general introduction to information systems testing. The objective of the training is to prepare the students for the ISTQB Foundation exam. Some important topics that will certainly be discussed here are the importance of testing, testing in relation to system development and the fundamentals of a structured testing process. The different phases in a test project are explained, after which some test techniques (both black box and white box) are also discussed. This foundation training therefore contains the basis in testing for both test managers and testers. In addition to theory, the training also includes a number of mock exams, so that the topics covered are placed even better in the exam context. Course Outline test principles life cycle testing static techniques test specification techniques blackbox techniques whitebox techniques and experienced based techniques Additional course details: Nexus Humans Certified Tester Foundation Level (CTFL) 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 Certified Tester Foundation Level (CTFL) 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 4 Days 24 CPD hours This course is intended for Architect Database Administrators Overview Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle Multitenant Architecture Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster Leaf Nodes Implement Oracle Database In-Memory on an existing Oracle RAC database Configure an Oracle RAC database to use Application Continuity Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard Upgrade an existing database to use Oracle ASM Filter Driver Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Additional course details: Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 5 Days 30 CPD hours This course is intended for Application Consultants, Developers, Solutions Architects, and System Administrators. Overview Work with SAP Fiori ApplicationsUnderstand and leverage the architectures and principles of SAP Fiori and SAP UX DesignConfigure and customize SAP FioriConnect SAP Fiori with other technologies This course provides participants with an overview of Fiori Design Principles. End-User Perspective Explore the Design of SAP Fiori Explore the SAP Fiori Launchpad Explore SAP Fiori Data Handling Personalize SAP Fiori Foundation Explain User Interfaces Explain Data Services Explain Application Types Architecture Examine SAP Fiori for Suite on Any DB Examine SAP Fiori for Suite on HANA Examine SAP Fiori for S/4HANA Examine SAP Fiori Mobile Configuration Create SAP Fiori Groups Create SAP Fiori Catalogs Create LPD_CUST Target Mappings Create SAPUI5 Fiori Target Mappings Create Web Dynpro Target Mappings Create Transaction Target Mappings Configure Analytical Applications Theming Use the UI Theme Designer Use SAP Screen Personas Integration Integrate SAP Workflow Operate SAP Fiori Standalone Explore SAP HANA Cloud Platform Additional course details: Nexus Humans UX100 SAP Fiori - Foundation 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 UX100 SAP Fiori - Foundation 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 1 Days 6 CPD hours Overview Please refer to Overview This course provides an overview of IoT and Blockchain, and how Blockchain holds the potential to securely unlock business and operational value of IoT to support common tasks, such as sensing, processing, storing information, and communicating. What is IoT? Internet of Things Overview IoT History How does IoT work? Components of an IoT device Current IoT Landscape Growth areas Privacy concerns IoT Design Standards Zigbee networking protocol Thread Group AllSeen Alliance/AllJoyn Open Interconnect Consortium/IoTivity Industrial Internet Consortium ITU-T SG20 IEEE P2413 Apple HomeKit IoT Design Questions Questions to help you design an IoT solution IoT Architecture Stage 1 - Data Generation (Sensors / Actuators) Stage 2 - Data Acquisition Systems Stage 3 - Edge Processing Stage 4 - Long-Term Data Storage / Blockchain What is Blockchain? History of Blockchain How does Blockchain work? Benefits of Blockchain Blockchain vs. conventional technology IoT / Blockchain Benefits of adding Blockchain to IoT Trust Building Cost Reduction Accelerate Data Exchanges Scaled Security for IoT Additional course details: Nexus Humans IoT and Blockchain Training 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 IoT and Blockchain Training 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 In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline 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 Intermediate SQL Custom 3-Day Private Class Outline 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.

We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards. WHEN: Thursday 31st October and Friday 1st November 2024 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Stephen M Goldsmith ABOUT STEPHEN: Stephen M Goldsmith started out at Rochester Art college, now known as University for the Creative Arts and was apprenticed at C.J Vander’s in 1971 and indentured with The Worshipful Company of Goldsmiths’. Now a Master Polisher of over 50 years’ experience, originally working for the Crown Jewellers Asprey & Garrards and well-known society jeweller Theo Fennell. Many of the pieces polished are now seen in Palaces, Museums and the rich and famous across the world. Stephen is one the most respected jewellery & silver polishers and is currently is teaching polishing across Europe and is known affectionately as “The Gold polishing Guru”. He has polished and restored many famous silverware pieces including the Americas Cup; Cricket World cup, Wimbledon Cup, Dubai Gold Cup, Premier League Cup. He has also been privileged to work in the jewel house at the Tower of London restoring The Grand Punch bowl made in 1830 and used by the Royal family on many occasions. Also known for polishing the largest pure gold coins made by the Royal Mint the largest being the James Bond 7kg pure gold coin. He is a fellow of the Institute of Professional Goldsmiths (IPG) and their official ambassador and a Master of The Dutch Guild of Goldsmiths. He shares his trade skills by teaching nationally and internationally including at Goldsmiths Centre, School of Master Jeweller’s Birmingham and VanTol & Breet Academy (Netherlands), The School of Jewellery Dublin & The Design & Craft Irish Craft Council in Kilkenny, Vannilla Ink, Aka_bespoke Manchester, Sheila Fleet in Orkney, Patrick Mavros in Zimbabwe and Mauritius. Stephen is a Freeman of The Worshipful Company of Goldsmiths’ and was granted the Freedom of the City of London in 1975. He has also had the very rare honour of winning The Goldsmith’s Company Award twice, plus many other prestigious awards and served as a council member for The Goldsmiths’ Craft and Design Council and a published authority on polishing precious metals “Polishing and Finishing for Jewellers and Silversmiths by the Crowood Press. WHAT DOES THE DAY INVOLVE? We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards.You can get a glimpse of what he does on his instagramWHAT HAPPENS DURING THE MASTERCLASS?First, Stephen will talk about his career giving you an insight into the makings of a master craftsman. Then he will demonstrate just why he is known as master polisher. After this demonstration you will be guided by Stephen to try and replicate what you have been shown in the demonstration.After working through a few more exercises you will set to work on your own jewellery, receiving guidance on not just how to achieve the finish you would like for your jewellery but to reach a standard of finish you didn’t know you could.These Masterclasses are a great opportunity to learn from someone who is:a) A true master in our tradeb) Not a grump or condescending because you don’t know somethingc) Happy to chat and share his knowledge!All you need to bring is some of your own jewellery (around 6 items) at the point where it’s ready for polishing.You will have a spindle that is yours for the duration of the masterclass, mops, materials etc will be provided. It can be a messy business so make sure your clothing is workshop friendly!You will also have full access to our workshop, benches, tools and equipment if needed.This Masterclass will leave you with the knowledge and skills to take your polishing to a highly professional standard.EXPERIENCE REQUIRED: This class will benefit jewellers with some experience who are looking to learn to polish their work to a professional level. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. We have a microwave, kettle and fridge to store or cook your lunch choices. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

Duration 4 Days 24 CPD hours This course is intended for Database Administrators Administrator Overview Describe the Oracle Clusterware architecture Describe how Grid Plug and Play affects Clusterware Describe the benefits of Oracle RAC Explain the necessity of global resources Describe global cache coordination Install the Oracle database software Create a cluster database Perform post-database-creation tasks Convert a single-instance Oracle database to RACs Explain the principles and purposes of clusters Define redo log files in a RAC environment Define undo tablespaces in a RAC environment Start and stop RAC databases and instances Modify initialization parameters in a RAC environment Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Configure RMAN for the RAC environment This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. Additional course details: Nexus Humans Oracle Database 12c - RAC Administration 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 Oracle Database 12c - RAC Administration 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.