Duration 3 Days 18 CPD hours This course is intended for This class is intended for the following participants: Cloud architects, administrators, and SysOps/DevOps personnel Individuals using Google Cloud Platform to create new solutions or to integrate existing systems, application environments, and infrastructure with the Google Cloud Platform. Overview This course teaches participants the following skills: Understand how software containers work Understand the architecture of Kubernetes Understand the architecture of Google Cloud Platform Understand how pod networking works in Kubernetes Engine Create and manage Kubernetes Engine clusters using the GCP Console and gcloud/ kubectl commands Launch, roll back and expose jobs in Kubernetes Manage access control using Kubernetes RBAC and Google Cloud IAM Managing pod security policies and network policies Using Secrets and ConfigMaps to isolate security credentials and configuration artifacts Understand GCP choices for managed storage services Monitor applications running in Kubernetes Engine This class introduces participants to deploying and managing containerized applications on Google Kubernetes Engine (GKE) and the other services provided by Google Cloud Platform. Through a combination of presentations, demos, and hands-on labs, participants explore and deploy solution elements, including infrastructure components such as pods, containers, deployments, and services; as well as networks and application services. This course also covers deploying practical solutions including security and access management, resource management, and resource monitoring. Introduction to Google Cloud Platform Use the Google Cloud Platform Console Use Cloud Shell Define cloud computing Identify GCPs compute services Understand regions and zones Understand the cloud resource hierarchy Administer your GCP resources Containers and Kubernetes in GCP Create a container using Cloud Build Store a container in Container Registry Understand the relationship between Kubernetes and Google Kubernetes Engine (GKE) Understand how to choose among GCP compute platforms Kubernetes Architecture Understand the architecture of Kubernetes: pods, namespaces Understand the control-plane components of Kubernetes Create container images using Google Cloud Build Store container images in Google Container Registry Create a Kubernetes Engine cluster Kubernetes Operations Work with the kubectl command Inspect the cluster and Pods View a Pods console output Sign in to a Pod interactively Deployments, Jobs, and Scaling Create and use Deployments Create and run Jobs and CronJobs Scale clusters manually and automatically Configure Node and Pod affinity Get software into your cluster with Helm charts and Kubernetes Marketplace GKE Networking Create Services to expose applications that are running within Pods Use load balancers to expose Services to external clients Create Ingress resources for HTTP(S) load balancing Leverage container-native load balancing to improve Pod load balancing Define Kubernetes network policies to allow and block traffic to pods Persistent Data and Storage Use Secrets to isolate security credentials Use ConfigMaps to isolate configuration artifacts Push out and roll back updates to Secrets and ConfigMaps Configure Persistent Storage Volumes for Kubernetes Pods Use StatefulSets to ensure that claims on persistent storage volumes persist across restarts Access Control and Security in Kubernetes and Kubernetes Engine Understand Kubernetes authentication and authorization Define Kubernetes RBAC roles and role bindings for accessing resources in namespaces Define Kubernetes RBAC cluster roles and cluster role bindings for accessing cluster-scoped resources Define Kubernetes pod security policies Understand the structure of GCP IAM Define IAM roles and policies for Kubernetes Engine cluster administration Logging and Monitoring Use Stackdriver to monitor and manage availability and performance Locate and inspect Kubernetes logs Create probes for wellness checks on live applications Using GCP Managed Storage Services from Kubernetes Applications Understand pros and cons for using a managed storage service versus self-managed containerized storage Enable applications running in GKE to access GCP storage services Understand use cases for Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Bigtable, Cloud Firestore, and Bigquery from within a Kubernetes application
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.
Looking to step into the criminal justice field with confidence? This Prison Officer: 20-in-1 Premium Online Courses Bundle is tailored for those who want to stand out in custodial services, public safety, and correctional institutions. Build credibility, broaden your skill set, and show you're prepared for a high-responsibility career path. Description From prison services to immigration detention and forensic operations, employers expect more than physical readiness—they want adaptable, emotionally intelligent professionals. This all-in-one training bundle gives you the confidence to apply for frontline roles across correctional services, youth offending teams, rehabilitation programs, and security agencies. With critical training in law, psychology, communication, data handling, and conflict management, this bundle reflects the blend of soft and technical skills hiring managers are actively screening for. If you’re aiming for job security in a sector that never slows down, this is your move. Don’t let your next opportunity go to someone else. Secure your place at the front of the hiring line—before the roles close. FAQ Q: Who should enrol in this bundle? A: Ideal for aspiring prison officers, correctional staff, youth workers, and custody support personnel. Q: What job roles does this bundle support? A: Prison Officer, Custody Support Officer, Probation Assistant, Detention Centre Operative, Youth Justice Worker, and Court Liaison Officer. Q: Is this bundle suitable for beginners? A: Yes, it’s designed to benefit both entry-level candidates and professionals seeking advancement. Q: Do I receive certificates for the courses? A: Yes, each course includes certification for your records and CV. Q: How long do I have to complete the courses? A: You’ll have lifetime access—study flexibly at your own pace.
Equip yourself for a career in financial crime prevention, compliance, and regulatory investigations with this AML Analyst 20-in-1 bundle. Built to impress employers across financial services and legal sectors, this training suite marks you as hireable, trustworthy, and analysis-ready. Description AML analysts don’t just check boxes—they uncover risks, flag anomalies, and protect institutions from fraud and penalties. With the rise of digital finance, demand for trained AML professionals has surged. But roles aren’t going to candidates without the right blend of legal, analytical, and reporting skills. This bundle reflects exactly what AML recruiters want: legal knowledge, software familiarity, communication skills, and analytical precision. Whether you’re aiming for a new role or building on existing admin or finance experience, this bundle offers undeniable value. If you want to break into compliance or enhance your credibility in financial operations, now’s the time to certify. The job market rewards those who are already prepared. FAQ Is this bundle suited for a future in AML or risk analysis? Yes, it’s perfect for aspiring AML analysts, compliance assistants, and financial risk staff. Do I need prior compliance knowledge? No—this is designed for beginners and early-career professionals. Are certificates included? Yes. Each of the 20 courses provides a digital certificate upon completion. Which industries recognise this training? Banking, legal services, insurance, fintech, corporate finance, and regulatory consultancy. Can I access the content anytime? Yes. You’ll have lifetime access, so you can pace your learning flexibly. What’s the urgency? AML enforcement is growing stricter—and skilled analysts are in short supply. Get certified before the next recruitment wave hits.
If your goal is to build a career around people—how they work, communicate, and thrive—then the People Practice: 20-in-1 Premium Online Courses Bundle is your launchpad. Built for jobseekers, HR assistants, junior team leads, and workplace wellbeing advocates, this bundle positions you for roles that require both empathy and structure. 20 in-demand certifications. One simple route to a more employable you. Description People-centric roles are rising fast—and so is the competition. This bundle helps you stand out with a well-rounded, job-targeted portfolio that includes coaching, public speaking, problem-solving, and HR functions. Perfect for entry-to-mid-level professionals looking to work in HR, operations, or organisational wellbeing, these courses signal your ability to handle people processes with clarity and confidence. Employers need team players who know how to listen, guide, and lead—and this bundle demonstrates all three. The best part? You're not paying for 20 separate courses—you're getting a bundled advantage at a fraction of the cost. But act quickly: limited-time bundles like this disappear just as fast as they open. FAQ What types of roles does this bundle support? HR assistant, team leader, people coordinator, junior project lead, and learning & development. Is it suitable for new professionals? Yes. It’s ideal for those starting out or transitioning into people-focused roles. Are the courses accredited? Each course includes a certificate of completion to strengthen your job applications. Can I learn at my own pace? Absolutely. Study online, anytime, from anywhere. How long is this offer available? It’s a short-term promotion. Once the enrolment period ends, it may not return.
Elevate your leadership profile with a 20-in-1 course bundle tailored to help you manage teams, navigate crises, and communicate with impact. Built for those who aim to lead — not just participate. Description Stakeholder management is no longer optional — it’s a top skill for anyone in leadership, project coordination, HR, or operations. Whether you're managing clients, team dynamics, or cross-department collaboration, employers want professionals who can lead with logic and communicate with confidence. This high-impact bundle strengthens your job-readiness across compliance, negotiation, reporting, and digital productivity. Whether you're climbing the corporate ladder or making a lateral move into leadership, this comprehensive training makes your CV a hiring manager’s shortlist favourite. Remember, opportunities don’t wait — and neither does enrolment. Seats are limited, and the most career-conscious professionals are already securing theirs. Don’t miss your chance to become the person businesses rely on. FAQ Q: Who is this bundle ideal for? A: Team leaders, project managers, client-facing professionals, and anyone stepping into stakeholder roles. Q: Does it help me become more employable? A: Absolutely — it shows you’re capable of managing both people and performance under pressure. Q: Is it suitable for those new to leadership? A: Yes. It's a great starting point for professionals seeking their first management role. Q: Can I complete the courses flexibly? A: Yes — all content is online and designed for self-paced learning. Q: Is this worth the investment? A: You're getting 20 industry-relevant skills for less than the price of a single leadership course. Q: Will I receive something I can add to my CV? A: Yes — each completed course boosts your credentials and job appeal.
Looking to break into insurance, compliance, or financial services? This all-in-one 20-course bundle is engineered to help you do exactly that — with credibility. From payroll to contracts, AML to compliance, it’s a job-market toolkit built for real hiring trends. Don’t just hope to get shortlisted — be the candidate that employers must consider. Description The insurance sector isn’t just about policies — it’s about precision, regulation, and a strong grasp of financial and legal frameworks. This Insurance bundle prepares you to align with what hiring managers want across roles in underwriting, claims, compliance, data handling, and financial analysis. With skills that speak directly to the needs of insurance firms, law offices, brokerages, and corporate risk departments, this bundle can elevate your CV from “average” to “interview-worthy.” Employers are increasingly looking for candidates who come prepared. You’ll come overprepared — without overpaying. In a field that values documentation, regulation, and detail, this bundle lets you stand out from the crowd. Spots in insurance-adjacent careers are competitive — don’t wait until the job posting closes. FAQ Q: What industries does this bundle relate to? A: Insurance, compliance, payroll, legal services, finance, underwriting, and corporate governance. Q: Do I need prior experience? A: No — this is beginner-friendly and ideal for career switchers or upskillers. Q: Will this help me apply for insurance-related jobs? A: Yes — the course bundle reflects common employer expectations in entry-level and support roles. Q: What if I’m already in finance or admin? A: Great — this can help you pivot into specialised areas like compliance or insurance operations. Q: How soon can I start? A: Enrol instantly and start learning today.
Commercial plumbing is more than just pipework—it’s about project support, site safety, and compliance in large-scale environments. This 20-in-1 Commercial Plumber bundle was built for those ready to prove they can handle the pressure of high-volume installations and workplace expectations. Commercial contracts are competitive. Don’t let a skills gap cost you the role. 🔍 Description Whether you're applying to contractors, facilities firms, or major construction outfits, commercial plumbers are expected to bring more than just tools. They need to know the protocols, communicate with teams, and manage tasks in line with project goals. This bundle gives you a clear edge. With a rich mix of safety, communication, site operations, and purchasing knowledge, you'll walk into interviews with confidence—and proof that you're a reliable fit for commercial-scale environments. Get 20 in-demand certifications in one go, at a cost far lower than trying to piece it together one course at a time. The market won’t wait—act now and make your profile interview-ready. ❓ FAQ Q: Is this bundle suitable for new commercial plumbers? A: Yes. It’s designed to prepare both aspiring and current plumbers for commercial environments. Q: What industries does it align with? A: Construction, commercial property services, contract maintenance, and project-based plumbing work. Q: Will employers value these certificates? A: Absolutely—they show initiative, responsibility, and site-readiness across multiple disciplines. Q: Can this help with moving from domestic to commercial plumbing? A: Definitely—it introduces core non-technical skills often required in commercial settings. Q: How long do I have to complete the courses? A: There’s no time limit—study at your own pace with lifetime access.
Want to step into the fast-paced world of procurement? This 20-in-1 Procurement Assistant bundle is your gateway into one of the most critical functions across industries—from retail and construction to public sector supply chains. Smart jobseekers know: procurement is hiring. The question is—are you ready? 🔍 Description Procurement assistants are the unsung heroes who keep business operations on track. But the role demands more than just processing paperwork—it calls for critical thinking, system knowledge, and interdepartmental awareness. That’s exactly what this bundle delivers. With topics spanning finance, compliance, negotiation, and logistics, it gives you the career versatility today’s employers are looking for. You'll be building a skillset that transfers across industries—perfect for those seeking entry-level roles with real advancement potential. And with 20 practical courses bundled into one cost-effective package, the only thing you’ll be cutting is wasted opportunity. Enrol now—before someone else claims the job you’ve been eyeing. ❓ FAQ Q: What kind of roles is this bundle good for? A: Procurement Assistant, Junior Buyer, Purchasing Coordinator, Logistics Admin, or Finance Support Officer. Q: Is it relevant for remote and hybrid work? A: Yes—it covers both onsite and remote-friendly tasks that many employers need filled. Q: Do I need a finance background? A: Not at all. It’s beginner-friendly and useful for those transitioning from any admin or retail position. Q: Will this bundle support progression to buyer or procurement manager roles? A: It builds foundational knowledge essential for long-term growth in procurement careers. Q: What sectors is this useful for? A: Retail, manufacturing, healthcare, education, public services, construction, and distribution.