• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

8503 Opera courses

Marginal Field Development and Planning

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your knowledge in marginal field development and planning with EnergyEdge's course. Enroll now to gain valuable insights.

Marginal Field Development and Planning
Delivered In-PersonFlexible Dates
£3,699 to £3,799

AML Training For Law Firms Not In Scope Course

By DG Legal

In an ever-evolving legal landscape, being a firm outside of the mandatory AML scope doesn't mean being out of the compliance conversation.  This course is your guide to proactively managing risks, staying compliant and ensuring your firm's resilience. Don't miss this opportunity to navigate the unique challenges faced by out-of-scope AML law firms. The course will cover: AML regulations Why are some firms (or departments) in or out of scope? MLROs AML basics CDD (ID elements) Responsibility of doing CDD Source of Funds / Source of Wealth Ongoing monitoring Reporting to the MLRO Target Audience The online course is suitable for staff of all levels, from support staff to senior partners of firms outside of the regulated sector.  Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

AML Training For Law Firms Not In Scope Course
Delivered Online
£90 to £120

Certified Information Systems Auditor (CISA)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The intended audience for this course is information systems security professionals, internal review auditors, and other individuals who have an interest in aspects of information systems audit, controls, and security. Overview Upon successful completion of this course, students will be able to: - implement information systems audit services in accordance with information systems audit standards, guidelines, and best practices. - evaluate an organizations structure, policies, accountability, mechanisms, and monitoring practices. - evaluate information systems acquisition, development, and implementation. - evaluate the information systems operations, maintenance, and support of an organization; and evaluate the business continuity and disaster recovery processes used to provide assurance that in the event of a disruption, IT services are maintained. - define the protection policies used to promote the confidentiality, integrity, and availability of information assets. In this course, students will evaluate organizational policies, procedures, and processes to ensure that an organizations information systems align with its overall business goals and objectives. 1 - The Process of Auditing Information Systems ISACA Information Systems Auditing Standards and Guidelines Fundamental Business Processes Develop and Implement an Information Systems Audit Strategy Plan an Audit Conduct an Audit The Evidence Life Cycle Communicate Issues, Risks, and Audit Results Support the Implementation of Risk Management and Control Practices 2 - IT Governance and Management Evaluate the Effectiveness of IT Governance Evaluate the IT Organizational Structure and HR Management Evaluate the IT Strategy and Direction Evaluate IT Policies, Standards, and Procedures Evaluate the Effectiveness of Quality Management Systems Evaluate IT Management and Monitoring of Controls IT Resource Investment, Use, and Allocation Practices Evaluate IT Contracting Strategies and Policies Evaluate Risk Management Practices Performance Monitoring and Assurance Practices Evaluate the Organizations Business Continuity Plan 3 - Information Systems Acquisition, Development, and Implementation Evaluate the Business Case for Change Evaluate Project Management Frameworks and Governance Practices Development Life Cycle Management Perform Periodic Project Reviews Evaluate Control Mechanisms for Systems Evaluate Development and Testing Processes Evaluate Implementation Readiness Evaluate a System Migration Perform a Post-Implementation System Review 4 - Information Systems Operations, Maintenance, and Support Perform Periodic System Reviews Evaluate Service Level Management Practices Evaluate Third-Party Management Practices Evaluate Operations and End User Management Practices Evaluate the Maintenance Process Evaluate Data Administration Practices Evaluate the Use of Capacity and Performance Monitoring Methods Evaluate Change, Configuration, and Release Management Practices Evaluate Problem and Incident Management Practices Evaluate the Adequacy of Backup and Restore Provisions 5 - Protection of Information Assets Information Security Design Encryption Basics Evaluate the Functionality of the IT Infrastructure Evaluate Network Infrastructure Security Evaluate the Design, Implementation, and Monitoring of Logical Access Controls Risks and Controls of Virtualization Evaluate the Design, Implementation, and Monitoring of Data Classification Process Evaluate the Design, Implementation, and Monitoring of Physical Access Controls Evaluate the Design, Implementation, and Monitoring of Environmental Controls

Certified Information Systems Auditor (CISA)
Delivered OnlineFlexible Dates
£3,250

ALHO – Award in Licensed Hospitality Operations

5.0(43)

By Knight Training (UK) Ltd

Do you want to get some training in the hospitality sector? We are waiting here for you in Knight Training, come to get your Award in Licensed Hospitality Operations now and train with us! This qualification is designed for those new to running or looking to run, licensed retail premises. Don't waste any more time and give us a call on 0330 999 3199 to find more about it!

ALHO – Award in Licensed Hospitality Operations
Delivered In-Person in Birmingham + 3 moreFlexible Dates
£475

Flow Assurance for Offshore Production

By EnergyEdge - Training for a Sustainable Energy Future

About this training course This 5-days comprehensive training not only an introduction into the issue associated with the development of oil and gas fields but also provides an in depth understanding of the issues to be considered in the development of these fields. The theme throughout this training course is Flow Assurance and Innovative Technologies. Each day consists of lectures in the morning and a hands-on workshop in the afternoon. The workshop allows the participants to appreciate the design process associated with field developments. Various software will be available during the workshop to predict Multiphase flows through wells, pipelines and risers, as well as evaluating reservoir production profiles using alternative technologies to develop reservoirs. Further software to assess Surge and environmental safety will also be available. The field design approach will consider an integrated solution through modelling the reservoir decline, wells, flowlines, risers and the host facility. The participants will have a total appreciation of the methodology required to develop offshore oil and gas fields and have an understanding of all of the Flow Assurance issues and technology requirements. Training Objectives After the completion of this training course, participants will be able to: Understand the process required and identify data to analyse Flow Assurance for oil and gas fields. Examine and Identify the Flow Assurance issues required to be evaluated for oil and gas fields design. These include; Wax, Hydrates, Slugging, Corrosion, Sand Erosion, Scaling and Surge. Establish the studies to be undertaken for each area of Flow Assurance including 'Rules of Thumb' and software to be used. Prioritize the need for innovative methods and the technologies to solve Flow Assurance issues and the need for economics considerations. Appreciate the need for an integrated analysis of the oil and fields from the reservoir to the host processing facility. Gain an appreciation of the emerging and enabling technologies for offshore fields application. Dive deeper into the operational strategies requirements to mitigate Flow Assurance issues. Target Audience This training course is suitable and will greatly benefit the following specific groups: Reservoir Engineers Flow Assurance Engineers Thermodynamics Engineers Process and Chemical Engineers Pipeline Engineers Facilities Engineers Control and Subsea Engineers working in the Oil and Gas industries Engineers in other disciplines may attend that require an appreciation of Flow Assurance Course Level Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training Course delivery: This course is limited to a maximum of 20 participants only. A basic understanding of thermo-hydraulics would be advantageous. Morning Lectures and afternoon hands-on practical workshop. Special features: PC-based simulation software demonstration Workshop for hands-on training Course References & Additional resources: 'Flow Assurance for Oil and Gas Fields Production Transport', 1st Edition Handouts Pre & Post Assessment Trainer Your expert course leader is a renowned specialist in flow assurance management for the oil & gas field developments. His expertise enables him to support the operating and contracting companies as well as financial institutions regarding due diligence on offshore development investment decisions and associated operational system risks. Technical assessment of fields for acquisition and production enhancement opportunity. He possesses specialist expertise in evaluating difficult pipeline fluids transport such as Ethylene, Carbon Dioxide and Hydrogen through feasibility studies and technical reviews for clients. He has an exceptional academic background and natural leadership abilities are supported by practical experience of diverse projects worldwide, along with numerous publications at key conferences and publication of four books. Particular interests in developing novel and innovative technologies for subsea applications to solve difficult flow assurance problem areas and improve field development economics. He has worked on major industry projects including; Concorde aircraft fuelling system, the Channel Tunnel aerodynamics and the first deep water oil field development (Foinaven) in the West of Shetland. He is also currently developing a renewable energy solar farm and carbon neutral energy crop (Miscanthus) for domestic and commercial power generation application. He has developed in-house resources including specialist oil & gas field development evaluation software for subsea and onshore field infrastructure development options including; costing and financial analysis, reservoir viability, flow assurance assessment, subsea processing and boosting technologies, flow induced vibrations, surge analysis, heat transfer and chemical injection systems.

Flow Assurance for Offshore Production
Delivered in Internationally or OnlineFlexible Dates
£3,255 to £3,785

The Level 3 NVQ Diploma in Hairdressing (Colchester)

4.8(16)

By Kleek Academy

Complete a full work ready Level 3 NVQ Diploma in Hairdressing and open up fantastic career opportunities with hairdressing skills and Knowledge. Enquire today!

The Level 3 NVQ Diploma in Hairdressing (Colchester)
Delivered In-PersonFlexible Dates
£3,345

The Level 3 NVQ Diploma in Hairdressing (Darlington)

4.8(16)

By Kleek Academy

Complete a full work ready Level 3 NVQ Diploma in Hairdressing and open up fantastic career opportunities with hairdressing skills and Knowledge. Enquire today!

The Level 3 NVQ Diploma in Hairdressing (Darlington)
Delivered In-PersonFlexible Dates
£3,345

The NVQ Level 3 in Beauty Therapy Diploma Massage (Colchester)

4.8(16)

By Kleek Academy

Complete a full work ready NVQ Level 3 Diploma in Beauty Therapy and open up fantastic career opportunities with Spa ready skills and Management Knowledge. Enquire today!

The NVQ Level 3 in Beauty Therapy Diploma Massage (Colchester)
Delivered In-PersonFlexible Dates
£3,345

The NVQ Level 3 in Beauty Therapy Diploma Massage (Darlington)

4.8(16)

By Kleek Academy

Complete a full work ready NVQ Level 3 Diploma in Beauty Therapy and open up fantastic career opportunities with Spa ready skills and Management Knowledge. Enquire today!

The NVQ Level 3 in Beauty Therapy Diploma Massage (Darlington)
Delivered In-PersonFlexible Dates
£3,345

Querying Microsoft SQL Server

5.0(3)

By Systems & Network Training

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Querying Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,797