995 Courses in Birmingham delivered Live Online

Duration 1.5 Days 9 CPD hours This course is intended for This course is intended for DBAs and IT Professionals who want to enhance their Postgres administration skill to the next level. Overview This exam is the definitive standard for PostgreSQL professionals. This certification assesses and certifies a database professional?s ability to work in demanding, large-scale, real-world production environments. This course covers enterprise class tools for Postgres administration and prepares the learners to handle real time, production environments. Upon course completion, you will be prepared to manage large, highly available Postgres databases with confidence. PostgreSQL IntroductionSQL TuningPerformance TuningPerformance and BenchmarkingWAL ArchivingStreaming ReplicationConnection PoolingTable PartitioningExtensionsForeign Data WrappersMonitoringDatabase SecurityUpgrading Best Practices Additional course details: Nexus Humans Advanced PostgreSQL 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 Advanced PostgreSQL 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 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 12c SQL Fundamentals 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 Experienced system administrators, system integrators, and consultants responsible for implementing and managing VMware Cloud Foundation Overview By the end of the course, you should be able to meet the following objectives: Describe design implications of VMware Cloud Foundation standard or consolidated architecture List requirements for VMware Cloud Foundation deployment Describe the VMware Cloud Foundation bring-up process and the VMware Cloud Foundation architecture Perform VMware Cloud Foundation bring-up Describe physical and virtual networking considerations Outline VMware Cloud Foundation storage options Use the VMware Imaging Appliance to image ESXi hosts Describe VMware Cloud Foundation multi-instance federation Use VMware Cloud Foundation™ SDDC Manager™ to perform operational tasks Describe user roles in VMware Cloud Foundation and VMware vSphere Manage users and passwords using VMware Cloud Foundation Manage certificate rotation for VMware Cloud Foundation components Use Active Directory integration to automate certificate generation and rotation Describe workload domains Manage workload domains in VMware Cloud Foundation Manage VMware NSX-T™ for VMware Cloud Foundation Describe use cases for Application Virtual Networks (AVNs) Meet vSphere with VMware Tanzu™ requirements Deploy a vSphere with Tanzu enabled workload domain Manage VMware vSAN™ storage in a workload domain Create vSAN storage policies Describe Cloud Native storage Describe the importance of business continuity measures in VMware Cloud Foundation Plan appropriate backup and restore workflows for VMware Cloud Foundation components Implement stretched clusters in VMware Cloud Foundation workload domains This five-day course includes instruction on the capabilities of VMware Cloud Foundation? and how to successfully plan, deploy, manage, and operate hybrid and cloud infrastructures, including customization. The course explains the architecture of VMware Cloud Foundation and explains licensing, certificates, and storage and network management. The course also covers workload domains, availability, life cycle management, and troubleshooting. Course Introduction Introductions and course logistics Course objectives VMware Cloud Foundation Overview Describe the VMware Cloud Foundation solution Describe VMware Cloud Foundation architecture Identify VMware Cloud Foundation components Describe VMware Cloud Foundation topology Define VMware Cloud Foundation terminology Day Zero Tasks Identify the requirements for deploying VMware Cloud Foundation Identify management domain sizing considerations Identify workload domain sizing considerations Detail design considerations for ESXi in management and VI workload domains Detail design considerations for vCenter in management and VI workload domains Detail the VMware Cloud Foundation bring-up process Identify information required for the Planning and Preparation Workbook Identify information required for the Deployment Parameter Workbook Describe how VMware Cloud Builder automates the deployment process Explain how the Deployment Parameter Workbook is imported into VMware Cloud Builder Recognize the configuration validation process performed by VMware Cloud Builder Detail the deployment of the management domain Recognize the options to image a host Identify the key capabilities of VIA Recognize how to use VIA for imaging the ESXi Nodes Post Deployment Operations Understand VMware Cloud Foundation integration with VMware Single Sign-On Configure user access to VMware Cloud Foundation Describe the importance of user roles in vSphere Configure identity sources in vSphere to use with VMware Cloud Foundation Manage passwords in VMware Cloud Foundation Explain the importance of using VMware Cloud Foundation to manage passwords for vSphere components Detail the best practices for password management for VMware Cloud Foundation Retrieve and secure the password list Describe the process for rotating passwords not managed by VMware Cloud Foundation VMware Cloud Foundation License Management Describe how to add license keys to the VMware Cloud Foundation inventory Describe how to view license keys in SDDC Manager Describe how to assign license keys Describe how to remove license keys Describe how to replace expiring licenses VMware Cloud Foundation Networking with NSX-T Describe NSX Management plane and Control planes Detail design considerations for workload domains with shared NSX Manager instances Detail design considerations for workload domains with dedicated NSX Manager instances Describe the spine-and-leaf design Describe the addressing scheme for the underlay Recognize possible variations of the spine-and-leaf design Describe the multi-NIC design Describe NSX Edge node design and BGP peering with the physical network Describe cluster design and rack design Explain dynamic routing with BGP Explain virtual IP addressing Describe logical switching Detail NSX Edge functions Define application virtual networks Describe management domain rack options List NSX Edge cluster requirements for vSphere with Tanzu Discuss NSX Edge cluster placement considerations Describe NSX-T Data Center deployment in VMware Cloud Foundation Explain how logical routing works in NSX-T Data Center Identify NSX Edge functions Describe data plane preparation for NSX-T Data Center Edge nodes in a workload domain Recognize Tier-0 and Tier-1 gateway topologies Recognize features of NSX distributed firewalls Describe the benefits of NSX Federation in VMware Cloud Foundation Identify NSX Federation Use Cases Explain NSX Federation Components and Architecture Discuss NSX Federation configuration basics Managing Workload Domains Define workload domains Detail design considerations for vSphere networking in management and VI workload domains Detail design considerations for storage in management and VI workload domains Recognize design choices for a consolidated design or standard design List the types of workload domains State scale limits for workload domains Identify use cases for multiple clusters in a workload domain List workload domain prerequisites Explain how to create a workload domain Describe how to scale a workload domain Explain how to delete a workload domain Describe host decommissioning vSphere with Tanzu in VMware Could Foundation Discuss the vSphere with Tanzu solution Define the role of Spherelet Describe the supervisor cluster control plane Define vSphere with Tanzu namespaces Describe the role of NSX-T networking components Discuss vSphere with Tanzu networking topology Describe VMware Container Networking with Antrea Describe control plane VM management networking requirements Plan appropriate IP address CIDR ranges for pod, ingress, and egress networking Describe prerequisites for vSphere with Tanzu cluster compatibility Deploy vSphere with Kubernetes Create a vSphere namespace Configure limits and permissions for a vSphere namespace Enabling Harbor Image Registry VMware Cloud Foundation Storage Management Identify vSAN architecture and components Recognize storage options for VMware Cloud Foundation Recognize the connectivity options for supplemental storage Explain why vSAN is the best option for VMware Cloud Foundation storage Recognize vSAN design considerations Identify sizing and performance considerations that impact the storage design Describe vSAN requirements for the management and workload domains Define deduplication and compression Discuss how to scale vSAN clusters in VMware Cloud Foundation Explain how storage policies work with VMware Cloud Foundation vSAN clusters Explain storage policy failure tolerance rules Identify a VM storage policy compliance status Relate storage policies to Kubernetes storage classes Describe persistent volumes Monitor Cloud Native Storage in the vSphere Client Availability and Business Continuity Identify steps in the SDDC Manager backup and restore process Recognize the importance of external service availability Describe native vSphere availability options Identify steps in the NSX backup and restore process Identify stretched cluster use cases Identify stretched cluster components Recognize stretched cluster requirements in VMware Cloud Foundation Prepare and deploy a vSAN stretched cluster using APIs VMware Cloud Foundation Certificate Management Describe public key infrastructure (PKI) Explain the purpose of certificate signing requests (CSRs) List the available CA options in SDDC Manager Describe how to view certificates Explain how to generate a CSR Describe how to replace and install certificates for VMware Cloud Foundation components List the available CA options in SDDC Manager Explain how to configure the Microsoft CA server Describe how to install certificates issued by the Microsoft CA server Explain how to add OpenSSL CA in SDDC Manager Describe how to install certificates issued by OpenSSL CA Explain how to install certificates issued by third-party CAs

This course provides exceptional training on the principles and processes required to successfully operate a warehouse. PARTICIPANTS WILL LEARN HOW TO: • Learn about the characteristics of a warehouse and its function • Understand the basic principles of effective layout design and product storage prioritization • Gain an understanding of modern practices in warehouse operations, such as Kanban and 5S • Understand the importance of packaging and data inputs to improve the performance of pick and pack operations • Understand the role of KPIs in warehouse and supply chain management COURSE TOPICS INCLUDE: Material storage as part of supply chain management Evaluation of outsourcing issues Challenges of codification and traceability Performance management Automated and mechanized systems Different storage methodologies Use of Warehouse management systems Optimum cube utilization and labour productivity Picking and packing management systems Goods receipt and dispatch

This foundational course will help all managers better understand what a procurement function does, including the processes, tools and techniques it employs to reach its goals and how it measures its business performance. PARTICIPANTS WILL LEARN HOW TO: Explain the contribution of procurement to the overall business objectives. Explain the added value that can be obtained by a business when it manages its procurement activities efficiently and effectively. Understand the complex activity of procurement and the challenges it presents for risk management. Develop good quality procurement practices that will manage the expectations of all stakeholders Identify methods by which a procurement function can be measured and performance monitored. Perform contract management activities. Understand ways in which improvements might be identified and implemented. COURSE TOPICS INCLUDE: Procurement and business objectives Stakeholder Management Commercial Specifications Whole Life Costing Targeted procurement Procurement planning Supplier Appraisal and selection RFQ & ITT & Evaluation Contract Management

Service Level Agreements (SLAs) are extensively utilised to define the scope of work and key responsibilities between a customer and a service provider. It is fundamental that all relevant personnel are familiar with the defining characteristics of SLAs and how the design and implementation of these contracts can impact operational efficiency and brand reputation. PARTICIPANTS WILL LEARN HOW TO: Understand why SLAs are so important for good business management Apply a process to develop effective SLAs that define service level expectations and drive desired behaviours Identify methods by which the SLA can be measured and performance monitored Have an understanding of KPI’s and the relevance of critical success factors COURSE TOPICS INCLUDE: Procurement cycle, process structure and tendering Best practice contract management and the 3 C’s Supplier performance measurement and KPIs SLA use, benefits and application The SLA development process The monitoring and control of SLAs

A flexible, modular-based, programme to heighten participants' awareness of ways in which their operations can affect the environment, the principles of environmental management and the practical steps they need to take as individuals and as an organisation to improve environmental performance. Depending on the course modules selected, this programme will give participants: Increased awareness of relevant environmental issues A greater understanding of, and commitment to, the organisation's environmental management programme Preparation for any responsibilities they may have under an Environmental Management System Further benefits according to options chosen 1 Environmental awareness Definition of 'the environment' Key environmental issuesGlobal warmingOzone depletionAcid rainAir qualityWater pollutionContaminated landLand take and green belt shrinkageResource usageHabitat destruction and species extinctions. Option: This module can be used to explain the key environmental issues related to the activities of your own organisation. Diagrams, photos, pictures, examples and statistics relevant to your own organisation are used where possible to illustrate the points being made. 2 Environmental legislation Key elements of environmental legislation affecting the activities of your organisation - including international, European and UK legislation. Legislation of particular relevance to your organisation - how it affects the operations of your organisation Option: Legislation can be dealt with according to which aspect of the environment it protects (eg, air, water, waste) or which part of your organisation's activities it affects Consequences of breaching legislation 3 Environmental management systems Overview of what an environmental management system isHow is an Environmental Management System (EMS) designed and put together?Key elements (emphasising Plan - Do - Check - Review cycle)The need to continually improve Pros and consReasons for having an EMSBenefits of an EMSConsequences of not managing the environmentCosts of installing an EMS Explanation of ISO 14001 and EMAS standards and guidance as applicable to the EMSs of your organisationOverview of your organisation's EMSHow it was set up / is being developed / operatesWho is responsible for itKey parts of system (eg, environmental policy, objectives and targets) identified and discussedEMS documentation - what and where it is. Workshop option: Brainstorm 'Pros and cons' with the participants, come up with all their ideas for good and bad things about EMS and demonstrate that the 'good' list is longer than the 'bad' 4 Environmental consequences Define what an environmental impact is and discuss how they are determined, with reference to the EMS Identify why we want to determine the environmental consequences of operations and activities; how they are used in the EMS for planning, and reducing the impact on the environment Establish key environmental consequences of construction and operational activities on the site; discuss significance ranking and the control measures in place in your organisation. Workshop option: In small groups, participants are asked to identify the impact on the environment of your organisation's activities or a part of their activities. They are then asked to rank these impacts in terms of their significance, using guidelines provided to help them be aware of the contributing factors (eg, frequency, severity). For a selected number of the impacts, the participants are asked to identify what control measures there are and which of these they play a part in. All stages can be discussed with trainers as a whole group at various stages during the workshop. 5 Protected species, nature conservation and invasive weeds Nature conservation, landscape and visual issues in the planning process - overview of key nature UK wildlife legislation, EIA, appropriate timing of surveys, Hedgerow regulations and landscape and visual impact issues Ecological issues - ecological legislation, significant species, hedgerows Archaeology in the development process - why archaeology is important, organisation in the UK, legislation and planning guidance Construction phase issues and consents - major environmental issues during construction, including water resources and land drainage consents, discharges to land or water, water abstraction, public rights of way, tree protection, waste management, Special waste, noise, good practice pollution control and Environmental Audits Identification and management of invasive weeds - including legal position regarding management 6 Chemicals and fuels handling and storage How health and safety management is closely linked to environmental management of materials Planning - what mechanisms are in place for planning materials use; legislation, guidance and policies which define how to manage materials Materials storage - what are the considerations for storing materials, covering:Labels: what are the different types and what do they tell us?Storage facilities: what are the requirements for safe storage of materials (eg, signs, secondary containment, access, segregation, lids/covers)Handling: safe handling for protecting the environment, organisational procedures, high risk situations (eg, decanting, deliveries), how to reduce the risks (eg, use of funnels, proper supervision, training)COSHH and MSDS: brief explanation of legislation and its role in environmental control of hazardous materials, how to use the information provided by COSHH assessments Option: These sessions can be illustrated with photographs/pictures and examples of good and bad storage and handling practices Workshop Options: Labelling Quiz - quick-fire quiz on what different labels tell us; Build a Storage Facility - participants are asked to consider all the environmental requirements for building a safe storage facility for their organisation 7 On-site control measures Overview of the legislation associated with nuisance issues on site and mitigating problems when they arise Examples of bad practice, including fuel storage tanks and mobile equipment - costs involved with prosecution of fuel spills, remediation costs, management costs, legal fees, bad PR coverage Identification and management of contaminated land and relevant legislation Workshop option: Participants are provided with a site plan containing information on site features, environmental conditions and indications of potential issues 8 Waste management Why worry about waste? - a look at how waste disposal can impact on the environment, illustrated by examples of waste-related incidents, statistics on waste production on national, industry-wide and organisational levels, landfill site space, etc Legislation - overview of the relevant legislation, what the main requirements of the regulations are, what penalties there are, and the associated documentation (waste transfer notes) Waste classification - a more in-depth look at how waste is classified under legislation according to hazardous properties, referring to Environment Agency guidance Handling and storage requirements - what are the requirements of the applicable waste legislation and how are they covered by organisational procedures? Examples of good and bad environmental practice associated with handling and storing waste. Workshop option: 'Brown bag' exercise - participants pass round a bag containing tags each with a different waste printed on. They are asked to pick out a tag and identify the classification and the handling, storage and disposal requirements for the waste they select Waste minimisation - overview of the waste minimisation 'ladder' and its different options (elimination, reduction, reuse and recycling), benefits of waste minimisation, examples of waste minimisation techniques Workshop option: Participants are asked to identify opportunities that actually exist within the organisation for minimising production of waste that are not currently being taken advantage of 9 Auditing Requirements for environmental auditing of operations Auditing the EMS Types of internal and external audits Requirements EMS standards (ISO 14001 and EMAS) Carrying out internal audits and being prepared for external audits Workshop options:Mock audit 'Brown Bag' - can be used either for trainers to test participants as if they were in an audit situation, or for the participants to test each other and practice their auditing technique. The bag contains tags each with a different topic printed on (eg, waste skips); participants pass the bag round and select a tag; they are then questioned by the trainer or another participant about that topic as if they were in an audit situation. If the participants are auditing each other, they will be provided with a set of guidelines to keep in mind during the workshop.Virtual auditing - a more practical workshop where participants review photographs of situations/activities relevant to the organisation's operations. They are asked to identify all the good and bad environmental practices that are occurring in the situations. 10 Incident response What should you do when an incident does happen? What should be in a spill kit? When should you call in the experts? When should you inform the Environment Agency or Environmental Health Officer? Workshop option: The participants are provided with some incident scenarios and asked to develop a response to the incident 11 Monitoring and reporting Environmental monitoring programmes and procedures Monitoring and reporting as control measures for environmental consequences Monitoring and environmental 'STOP' card systems - personal and behavioural monitoring and reporting

Success = Value + People + Process With innovation happening more than ever, the new agile project economy requires more and more people across organisations to manage projects successfully, leading to many of us quietly slipping into the role of the unofficial project manager! The problem is very few people receive formal training on how to do it. Stakeholders, scope creep, limited training, and a lack of process all combine to raise the probability of project failure costing organisations time, money, and employee morale Is it any wonder 65% of all projects fail* each year! The good news is—unofficial project managers can build confidence to lead high-value projects and engage teams in a way that inspires them to volunteer their best efforts. Source: *Nieto-Rodriguez, A. (2021). “The Project Economy Has Arrived.” Harvard Business Review; Nov/Dec 21. Outcomes Project Management for the Unofficial Project Manager™ combines best practices from agile and waterfall project management to equip learners with the mindset, skillset, and toolset to engage and inspire team members. Success starts with the core agile principle of value—a project must deliver value to Noble! Once value is established, it is people who make projects successful through a consistent process. Project management isn’t just about managing logistics and hoping the project team is ready to play to win. The skills of “informal authority” are more important than ever before, so team members are inspired to contribute to project success! This course will help learners: Build strong informal authority that inspires project teams to consistently volunteer their best efforts. Utilise a consistent process to start and finish high-value projects on time and with quality. Influence and engage others to define a clear project scope, including clear deliverables and risk strategies. Model openness and agility to apply proactive change management and deliver high-value projects. Project Management Framework The Project Management Framework guides you through five distinct elements in the life of any project. Coupled with the foundational behaviours taught in the programme, this framework can help you deliver highly successful projects again and again. Who Should Attend? This programme is for anyone who finds themselves leading projects at work, regardless of whether or not their job title says, Project Manager! It is NOT a deep dive into project management processes, nor is it a qualification based programme. Whilst it would be helpful to either be involved in or to be leading a project, during the programme, this is clearly not essential. However, it is advisable that the participants have had some experience, whether as a project member or as the person who is leading the project (officially or not)! Project Management Institute (PMI) FranklinCovey is a member of the Project Management Institute (PMI) Authorised Training Partners (ATP) Programme and this course has been designed to satisfy the project management education requirement for PMI Certifications as well as Professional Development Education units (PDUs) needed by PMI credential holders.

Getting Started The MSc in Accounting and Finance is designed to help students become leaders in the financial sector.The programme aims to extend and enhance students' understanding and competence gained through professional qualifications. It seeks to develop their ability to think strategically about management and organisational change within accounting and finance. The programme suits AIA, ACA, ACCA, CIMA, ICAP, or CPA Australia graduates. It provides a means to support accounting practitioners & ongoing professional and personal development needs. Upon completing the programme, students are awarded the prestigious MSc in Accounting and Finance degree from the University of Buckingham. Additionally, students can attend the graduation ceremony held in the UK to celebrate their achievements and join fellow graduates in this momentous event. The programme comprises two phases; the first is the Level 7 Diploma in Accounting and Finance, awarded by OTHM and delivered by the School of Business and Technology London. The second phase is the MSc in Accounting and Finance (Advanced Entry), delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. About Awarding Body Buckingham is unique. It is the only independent University in the UK with a Royal Charter and probably the smallest, with around 2,700 students (approx 1,600 on campus). The University campus is well known for being one of the most attractive locations in the region. The Great Ouse River, home to much wildlife, winds through the heart of campus. Each student mixes with over 100 other different nationalities, so being at Buckingham is just like being in a mini global village. These contacts, acquaintances and friendships carry on long after life at Buckingham is over. Ranked Top 10 for Student Satisfaction Ranked Top 10 for Graduate Prospect Recognised by World Education Services (WES) OTHM Qualifications are approved and regulated by Ofqual (Office of Qualifications and Examinations Regulation) and recognised by Qualifications Wales. OTHM qualifications have achieved a reputation for maintaining significant skills in various job roles and industries like Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. OTHM serves the progression option with several UK universities that acknowledges the ability of learners after studying Level 3-7 qualifications to be considered for advanced entry into corresponding degree year/top-up and Master's/top-up programmes. Regulated by ofqual.gov.uk Recognised by World Education Services (WES) Assessment Assignments and Project No Examinations Entry Requirements A Bachelor's degree or an equivalent or higher qualification. A copy of a valid photo ID. A Statement of Purpose outlines your motivations for joining the course and your career aspirations in accounting and finance. An updated Curriculum Vitae (CV) that highlights at least two years of work experience at the graduate level in either a managerial or professional capacity. English Language Requirements A pass in English at A-level. A bachelor's degree that was studied and assessed in English. An IELTS overall score of 6.5, with a minimum of 6.0 in each component. A TOEFL score of 72 overall, with a minimum of 18 in reading, 17 in listening, 20 in speaking, and 17 in writing. This includes the TOEFL Home Edition. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - OTHM Level 7 Diploma in Accounting and Finance Programme Structure The OTHM Level 7 Diploma in Accounting and Finance qualification consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 600 Guided Learning Hours (GLH) for the completed qualification. Investment Analysis Unit Reference Number : R/615/3236 TQT : 200 Credit : 20 This unit aims to enhance learners' comprehension of investment theories and market equilibrium models. It encompasses tasks such as conducting bond valuations and assessing current investment performance. Upon successful completion, learners will possess the skills to critically analyze the impact of global developments on capital markets and make sound recommendations for future investments. Corporate Reporting Unit Reference Number : D/615/3241 TQT : 200 Credit : 20 This unit aims to develop learners' ability to prepare and interpret financial statements for various business organisations. Learners will be able to apply relevant accounting concepts and principles. The unit allows learners to enhance their quantitative and qualitative analytical skills by interpreting financial data.  Global Finance and Strategy Unit Reference Number : D/615/3238 TQT : 200 Credit : 20 This unit aims to cultivate learners' comprehension of the decisions that are crucial when venturing into global markets. Learners will grasp the significance of autonomy in resolving financial matters within specific timeframes for achieving business success. Strategic Financial Management Unit Reference Number : H/615/3242 TQT : 200 Credit : 20 This unit seeks to enhance learners' grasp of planning and overseeing the allocation of an organization's financial resources. They will appreciate the significance of achieving business objectives and optimizing shareholder returns. Additionally, learners will acquire practical knowledge in designing business strategies and crafting comprehensive business plans. Strategic Audit Unit Reference Number : Y/615/3240 TQT : 200 Credit : 20 The objective of this unit is to foster learners' comprehension of how managers can effectively formulate and implement business strategies. This encompasses thoroughly examining the strategic auditing process and its associated methodologies. Learners will learn to employ appropriate investigative techniques in favourable and challenging environments. Business Research Methods Unit Reference Number : T/508/0626 TQT : 200 Credit : 20 The objective of this unit is to cultivate learners' comprehension of research principles, which encompass crafting research proposals, conducting literature reviews, proper referencing, employing data collection techniques such as interviews and surveys, designing questionnaires, conducting statistical analysis using SPSS, handling qualitative data, and employing methods to draw meaningful conclusions from the analyzed data.   Phase 2 - MSc in Accounting and Finance (Advanced Entry) Programme Structure Research Methods Consultancy Project Report Delivery Methods The programme comprises two phases; the first is the Level 7 Diploma in Accounting and Finance, awarded by OTHM and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MSc in Accounting and Finance (Advanced Entry), delivered by the London Graduate School and awarded by the University of Buckingham through distance learning. You will receive excellent support from academic team of London Graduate School, including your programme manager and your supervisor who will be with you every step of the way. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Getting Started The MBA in Educational Leadership and Management Top Up programme is a dynamic educational offering that aims to equip future educational leaders with essential skills. This programme places a strong emphasis on effective leadership, educational policy, and management within a variety of educational settings. Graduates from this programme emerge well-prepared to take on leadership roles within academic institutions and drive positive changes in the field of education. The MBA in Educational Leadership and Management is designed to empower educators and education professionals with advanced knowledge and skills in leadership and management. This programme presents an excellent opportunity for individuals with a relevant postgraduate diploma or an equivalent qualification to "top up" their credentials to earn a full MBA degree. Throughout this programme, students engage deeply with the intricacies of educational leadership and management, gaining valuable insights into the latest theories, practices, and strategies relevant to the educational sector. The curriculum strongly focuses on critical areas such as leadership theory, organisational management, policy development, and educational change management. The programme provides students with the tools needed to address the complex challenges that educational organisations face today, ultimately enhancing the quality of education. This MBA in Educational Leadership and Management enhances career prospects and actively contributes to improving educational systems. The programme comprises two phases; the first is the Qualifi Level 7 Diploma in Educational Management and Leadership, awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the MBA in Educational Leadership and Management Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements A bachelor's degree Applicant without a bachelor's degree but holding significant relevant experience will be considered for entry on a case-by-case basis. A good command of English (IELTS 6.0 or equivalent). Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase -1 - Qualifi Level 7 Diploma in Educational Management and Leadership The QUALIFI Level 7 Diploma in Educational Management and Leadership is made up of 120 credits, which equates to hours 1200 of TQT. Learners must complete two mandatory units and choose four optional units to achieve a minimum of 120 credits. Mandatory Units Leadership Qualities and Practice in Education Unit Reference -T/618/3135 TQT : 200 Credit : 20 The unit will explore how team performance can be evaluated and optimised to realise strategic business and operational objectives. Contemporary Issues in Education: Theory, Policy and Practice Unit Reference - A/618/3136 TQT : 200 Credit : 20 This unit provides learners with an understanding of the link between educational research, policy and practice.   Optional Units Managing Change in an Educational Context Unit Reference - F/618/3137 TQT : 200 Credit : 20 This unit aims to develop learners' understanding of educational leadership and management in supporting change and developing leadership in their educational context. Pedagogy and Practice in Education Unit Reference - J/618/3138 TQT : 200 Credit : 20 This unit aims to develop learners' theoretical and practical grounding in approaches to teaching and learning related to subject academic knowledge and educational practices. Leading Reflective Practice in Education Unit Reference - L/618/3139 TQT : 200 Credit : 20 This unit aims to develop learners' understanding of reflective practice to apply this to their and other's roles in an educational context, leading to planning for personal development. Research Methods in Education Unit Reference - F/618/3140 TQT : 200 Credit : 20 This unit aims to develop research skills, including different approaches, proposal formulation, planning, data analysis, and exploring research's relationship with evidence-based practice. Postgraduate Study of Childhood, Education and Family Support Unit Reference - A/650/6687 TQT : 200 Credit : 20 The unit will offer a framework for each individual's evaluation of their academic and professional action plans for personal and professional learning. Research Methods for Childhood, Education and Family Support Unit Reference - D/650/6688 TQT : 200 Credit : 20 This unit aims to help learners identify and develop a focus on research and approaches to data analysis, such as phenomenological and hermeneutic approaches and descriptive statistics. Triangulating Theory and Practice Unit Reference - F/650/6689 TQT : 200 Credit : 20 This unit aims to assist educators in comprehending the theories that drive recommendations for best practices and calls for action in a challenging and quickly evolving professional context. Contemporary Issues in Education Unit Reference - K/650/6690 TQT : 200 Credit : 20  This unit aims to introduce learners to various emerging topics from many educational sectors.    Phase 2 - MBA in Educational Leadership and Management Top-Up Programme Structure Developing Effective Management Systems Dissertation (Major Project) Delivery Methods The programme comprises two phases; the first is the Qualifi Level 7 Diploma in Educational Management and Leadership, awarded by Qualifi and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The program is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MBA in Educational Leadership and Management Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.