39375 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for Delegates attending this course must have successfully achieved the ITIL 4 Foundation Qualification; your certificate must be presented as documentary evidence to gain admission to this course. Ideally candidates should have at least two years professional experience working in IT Service Management. The ITIL 4 HVIT Qualification would most likely suit the following delegates: Individuals continuing of their journey in service management ITSM managers and aspiring ITSM managers IT managers and practitioners involved in digital services or working in digital transformation projects, working within or towards high velocity environments Existing ITIL qualification holders wishing to develop their knowledge The above list is a suggestion only. Delegates may take as few or as many Intermediate qualifications as they require, and to suit their needs. Overview This course has been created to help IT service management practitioners working in organizations that are becoming more digitally enabled. The practitioners are familiar with traditional IT service management concepts, and now want to be able to discuss ?digital? with more confidence, to develop practical competences, and to be valued contributors in the digital domain. They want to improve how they and their co-workers: Help get customers? jobs done ? helping customers become who they seek to become Keep raising the bar ? taking things to a significantly higher level Trust and are trusted ? as professional knowledge workers in a healthy workplace Accept ambiguity and uncertainty - not scared of not knowing an answer Commit to continual learning ? all as part of their daily work The scope of the course is the primary activities in the digital value chain. In other words, what the practitioner does and which resources they use across the lifecycle of digital products, in order to: Make the right digital investments Realize and deliver digital products and services quickly Provide digital products and services that are highly resilient to disruption Ensure that the service consumer realizes value from the digital products and services Assure conformance of activities with governance, risk and compliance requirements. Understand and know how to use the key principles and methods of Organizational Change Management to direction, planning and improvement Understand and know how to use the key principles and methods of measurement and reporting in directing, planning and improvement Understand and know how to direct, plan and improve value streams and practices ITIL 4 is a framework for quality IT service management (ITSM) through proven best practice, providing practical and flexible guidance to support your organization on its journey to digital transformation while empowering your IT teams to continue to play a crucial role in the wider business strategy. This course highlights the ways in which digital organizations and digital operating models function in high-velocity environments, including the use of working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing. This class includes an exam voucher. Prerequisites ITIL© 4 Foundation 1 - THE NATURE OF HIGH-VELOCITY IN A DIGITAL WORLD Overview of the key ITIL 4 high-velocity terminology Understand when the transformation to high velocity IT is desirable and feasible Understand the five objectives associated with digital products ? to achieve: Valuable investments ? strategically innovative and effective application of IT Fast development - quick realization and delivery of IT services and IT-related products Resilient operations - highly resilient IT services and IT-related products Co-created value - effective interaction between service provider and consumer Assured conformance - to governance, risk and compliance (GRC) requirements. 2 - ITIL OPERATING MODEL ? DIGITAL PRODUCT LIFECYCLE Understand how high velocity IT relates to: The four dimensions of service management The ITIL service value system The service value chain The digital product lifecycle 3 - FUNDAMENTAL CONCEPTS FOR DELIVERING HVIT Understand the following concepts: Ethics Safety culture Toyota Kata Lean / Agile / Resilient / Continuous Service-dominant logic Design thinking Complexity thinking Use the principles, models and concepts to contribute to: Help get customers? jobs done Trust and be trusted Commit to performance Deal with uncertainty Improve by being inquisitive 4 - ACHIEVING VALUE WITH DIGITAL PRODUCTS Know how the service provider ensures valuable investments are achieved. Know how to use the following practices to contribute to achieving valuable investments: Portfolio management Relationship management Know how the service provider ensures fast deployment is achieved Know how to use the following practices to contribute to achieving fast deployment: Architecture management Business analysis Deployment management Service validation and testing Software development and management Know how the service provider ensures resilient operations are achieved Know how to use the following practices to contribute to achieving resilient operations: Availability management Capacity and performance management Monitoring and event management Problem management Service continuity management Infrastructure and platform management Know how the service provider ensures co-created value is achieved Know how to use the following practices to contribute to achieving co-created value with the service consumer: Relationship management Service design Service desk Know how the service provider ensures assured conformance is achieved Know how to use the following practices to contribute to achieving assured conformance: Information security management Risk management

Jamf Training, Jamf 300 course,

About this Training Course This 5 full-day training course looks at the setup of economic analysis cases, including the estimation of recoverable reserves, production profiles, commodity prices, and project costs - CAPEX, OPEX, taxes, royalties, transportation, depreciation, before-tax (BTAX) cash-flow, after-tax (ATAX) cash-flow and international fiscal regimes (production sharing agreement and concessionary system). The course begins from the basic required parameters of inflation, interest and time value of money. These concepts are then transformed into profitability indicators. Last but not the least, the profitability indicators are then used to make investment decisions. The emphasis of this course is to bridge the gap between theoretical concepts and their practical limitations. The participants will be able to appreciate the amount of information that they never thought of. Another emphasis of this course is also on the use of Excel's financial functions. This understanding is very critical when it comes to building economic cash-flow models. Over the years, we have seen that participants really struggle with using the Excel functions correctly and this leads to mistakes that can be easily avoided. In each session, multiple choice problems are provided to participants to reinforce their understanding of the concepts covered in the course. Many quick or tips not widely known, are also shared with the participants. The concepts covered in this course are not restricted to downstream, upstream or petrochemical projects. These concepts can be used to evaluate any type of investment under consideration. Participants will require access to computers/laptops with Excel to solve problems during the course. Training Objectives Upon completion of this course, participants will be able to fully understand the gas market dynamics and Investment Evaluation. They will be able to: Learn how to reduce exposure and mitigate risks in projects by handling uncertainty Clarify concepts such as time value of money, cash-flow models, capital budgeting, IRR, NPV, income producing investments Maximise the return on investments through good decision-making processes based on the commercial viability of projects Improve their decision process, investment and opportunity analysis Acquire the hands-on experience in building their own economic evaluation models and solving case study-based examples   Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: Facilities and Planning engineers Project and procurement personnel Oil & gas engineers Geologists Financial Analysts Commercial managers Economists Government officials Business advisors Asset managers E&P managers Product and business development personnel   Course Level Basic or Foundation Training Methods     Organisational Impact     Trainer Your expert course leader is a globally recognised subject matter expert in petroleum/project economics and international gas market analysis. He is a recipient of the 2021 Society of Petroleum Engineers (SPE) International Management Award, an award that recognises individuals who make significant technical and professional contributions to the petroleum engineering profession and to the worldwide oil and gas industry. He has 40 years of diversified experience in petroleum engineering, reservoir engineering, project economics and decision analysis. He had been involved in evaluating multi-billion-dollar oil and gas field development, NGL, LNG, GTL, Aluminum smelter, refinery, petrochemical, power and production sharing projects. He has worked with major oil companies such as Saudi Aramco, ZADCO, Qatar Petroleum and companies in USA. He is a registered professional Engineer in the state of Colorado, USA. He is the author of six books: Petroleum Engineering Handbook for the Practicing Engineer, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. Project Economics and Decision Analysis, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. These books are used as textbooks in universities worldwide to teach petroleum economics to undergraduates and graduate students. Tip & Tricks in Excel based Financial Modeling, Vol. 1 & 2, published by Business Expert Press, New York, USA. He has also authored several papers in the Oil & Gas Journal, The Log Analyst, World Oil, SPE Journals, and Oil & Gas Financial Journal. He has delivered lectures in more than 25 countries around the globe. He has always received excellent feedback, as an expert presenter, from the participants of his courses. Daily daily_agenda     POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

About this training course This 5-day intensive training course is designed to improve the skills of those involved in the financial and contractual auditing of upstream Oil & Gas Exploration and Production activities. The objective of this course is to enhance your understanding of the various audit principles and practices being applied in this industry today and to equip you with the knowledge and tools to deal with complex audit cases. The course concentrates on aspects of auditing unique to the E&P business. Training Objectives After the completion of this training course, participants will be able to: Apply a structured methodology for conducting oil industry internal, production sharing and joint venture audits Implement the benefits of a multi-discipline team audit approach Adopt a model of best practice for conducting audits Analyse, interpret and decide complex cases using the contracts and documents, the principles and auditor's judgement Target Audience This training course is suitable and will greatly benefit the following specific groups: Personnel with an Internal audit background who are totally new to the discipline of Joint Venture (JV) or Production Sharing Contract (PSC) audit Experienced audit practitioners who wish to update their auditing techniques Personnel from Finance or any discipline who intend to take part in internal or joint venture audits Personnel with a background in statutory audit in the accountancy profession who require an insight into the internal and joint venture audit areas 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 The maximum number of participants allowed for this training course is 25. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Duration 4 Days 24 CPD hours This course is intended for This course is designed for data scientists with existing knowledge of Python and machine learning frameworks like Scikit-Learn, PyTorch, and Tensorflow, who want to build and operate machine learning solutions in the cloud. Overview Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure. Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow. Prerequisites Creating cloud resources in Microsoft Azure. Using Python to explore and visualize data. Training and validating machine learning models using common frameworks like Scikit-Learn, PyTorch, and TensorFlow. Working with containers AI-900T00: Microsoft Azure AI Fundamentals is recommended, or the equivalent experience. 1 - Design a data ingestion strategy for machine learning projects Identify your data source and format Choose how to serve data to machine learning workflows Design a data ingestion solution 2 - Design a machine learning model training solution Identify machine learning tasks Choose a service to train a machine learning model Decide between compute options 3 - Design a model deployment solution Understand how model will be consumed Decide on real-time or batch deployment 4 - Design a machine learning operations solution Explore an MLOps architecture Design for monitoring Design for retraining 5 - Explore Azure Machine Learning workspace resources and assets Create an Azure Machine Learning workspace Identify Azure Machine Learning resources Identify Azure Machine Learning assets Train models in the workspace 6 - Explore developer tools for workspace interaction Explore the studio Explore the Python SDK Explore the CLI 7 - Make data available in Azure Machine Learning Understand URIs Create a datastore Create a data asset 8 - Work with compute targets in Azure Machine Learning Choose the appropriate compute target Create and use a compute instance Create and use a compute cluster 9 - Work with environments in Azure Machine Learning Understand environments Explore and use curated environments Create and use custom environments 10 - Find the best classification model with Automated Machine Learning Preprocess data and configure featurization Run an Automated Machine Learning experiment Evaluate and compare models 11 - Track model training in Jupyter notebooks with MLflow Configure MLflow for model tracking in notebooks Train and track models in notebooks 12 - Run a training script as a command job in Azure Machine Learning Convert a notebook to a script Run a script as a command job Use parameters in a command job 13 - Track model training with MLflow in jobs Track metrics with MLflow View metrics and evaluate models 14 - Perform hyperparameter tuning with Azure Machine Learning Define a search space Configure a sampling method Configure early termination Use a sweep job for hyperparameter tuning 15 - Run pipelines in Azure Machine Learning Create components Create a pipeline Run a pipeline job 16 - Register an MLflow model in Azure Machine Learning Log models with MLflow Understand the MLflow model format Register an MLflow model 17 - Create and explore the Responsible AI dashboard for a model in Azure Machine Learning Understand Responsible AI Create the Responsible AI dashboard Evaluate the Responsible AI dashboard 18 - Deploy a model to a managed online endpoint Explore managed online endpoints Deploy your MLflow model to a managed online endpoint Deploy a model to a managed online endpoint Test managed online endpoints 19 - Deploy a model to a batch endpoint Understand and create batch endpoints Deploy your MLflow model to a batch endpoint Deploy a custom model to a batch endpoint Invoke and troubleshoot batch endpoints

Duration 3 Days 18 CPD hours This course is intended for This course is intended for solutions architects, solution-design engineers, developers seeking an understanding of AWS architecting and individuals seeking the AWS Solutions Architect-Associate certification. Overview Identify AWS architecting basic practices. Explore using the AWS management tools: The AWS Console, Command Line Interface (CLI), and CloudFormation in a lab environment. Examine the enforcement of accounts security using policies. Identify the elements that build an elastic, secure, virtual network that includes private and public subnets. Practice building an AWS core networking infrastructure. Determine strategies for a layered security approach to Virtual Private Cloud (VPC) subnets. Identify strategies to select the appropriate compute resources based on business use-cases. Practice building a VPC and adding an Elastic Cloud Compute (EC2) instance in a lab environment. Practice installing an Amazon Relational Database Service (RDS) instance and an Application Load Balancer (ALB) in the VPC you created. Compare and contrast AWS storage products and services, based on business scenarios. Compare and contrast the different types of AWS database services based on business needs. Practice building a highly available, auto-scaling database layer in a lab. Explore the business value of AWS monitoring solutions. Identify the role of monitoring, event driven load balancing, and auto scaling responses, based on usage and needs. Identify and discuss AWS automation tools that will help you build, maintain and evolve your infrastructure. Discuss network peering, VPC endpoints, gateway and routing solutions based on use-cases. Discuss hybrid networking configurations to extend and secure your infrastructure. Discuss the benefits of microservices as an effective decoupling strategy to power highly available applications at scale. Explore AWS container services for the rapid implementation of an infrastructure-agnostic, portable application environment. Identify the business and security benefits of AWS serverless services based on business examples. Practice building a serverless infrastructure in a lab environment. Discuss the ways in which AWS edge services address latency and security. Practice building a CloudFront deployment with an S3 backend in a lab environment. Explore AWS backup, recovery solutions, and best practices to ensure resiliency and business continuity. Build a highly available and secure cloud architecture based on a business problem, in a project-based facilitator-guided lab. Architecting on AWS is for solutions architects, solution-design engineers, and developers seeking an understanding of AWS architecting. In this course, you will learn to identify services and features to build resilient, secure and highly available IT solutions on the AWS Cloud. Architectural solutions differ depending on industry, types of applications, and business size. AWS Authorized Instructors emphasize best practices using the AWS Well-Architected Framework, and guide you through the process of designing optimal IT solutions, based on real-life scenarios. The modules focus on account security, networking, compute, storage, databases, monitoring, automation, containers, serverless architecture, edge services, and backup and recovery. At the end of the course, you will practice building a solution and apply what you have learned with confidence. Prerequisites AWS Cloud Practitioner Essentials classroom or digital training, or Working knowledge of distributed systems Familiarity with general networking concepts Familiarity with IP addressing Working knowledge of multi-tier architectures Familiarity with cloud computing concepts 0 - Introductions & Course Map review Welcome and course outcomes 1 - Architecting Fundamentals Review AWS Services and Infrastructure Infrastructure Models AWS API Tools Securing your infrastructure The Well-Architected Framework Hands-on lab: Explore Using the AWS API Tools to Deploy an EC2 Instance 2 - Account Security Security Principals Identity and Resource-Based Policies Account Federation Introduction to Managing Multiple Accounts 3 - Networking, Part 1 IP Addressing Amazon Virtual Private Cloud (VPC), Patterns and Quotas Routing Internet Access Network Access Control Lists (NACLs) Security Groups 4 - Compute Amazon Elastic Cloud Compute (EC2) EC2 Instances and Instance Selection High Performance Computing on AWS Lambda and EC2, When to Use Which Hands-On Lab: Build Your Amazon VPC Infrastructure 5 - Storage Amazon S3, Security, Versioning and Storage Classes Shared File Systems Data Migration Tools 6 - Database Services AWS Database Solutions Amazon Relational Database Services (RDS) DynamoDB, Features and Use Cases Redshift, Features, Use Cases and Comparison with RDS Caching and Migrating Data Hands-on Lab: Create a Database Layer in Your Amazon VPC Infrastructure 7 - Monitoring and Scaling Monitoring: CloudWatch, CloudTrail, and VPC Flow Logs Invoking Events 8 - Automation CloudFormation AWS Systems Manager 9 - Containers Microservices Monitoring Microservices with X-Ray Containers 10 - Networking Part 2 VPC Peering & Endpoints Transit Gateway Hybrid Networking Route 53 11 - Serverless Architecture Amazon API Gateway Amazon SQS, Amazon SNS Amazon Kinesis Data Streams & Kinesis Firehose Step Functions Hands-on Lab: Build a Serverless Architecture 12 - Edge Services Edge Fundamentals Amazon CloudFront AWS Global Accelerator AWS Web Application Firewall (WAF), DDoS and Firewall Manager AWS Outposts Hands-On Lab: Configure an Amazon CloudFront Distribution with an Amazon S3 Origin 13 - Backup and Recovery Planning for Disaster Recovery AWS Backup Recovery Strategie Additional course details: Nexus Humans Architecting on AWS 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 Architecting on AWS 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.

Level 4 Endorsed Diploma - International Trade Qualification Complete all 15 modules and 3 assessments, from a choice of 7 to earn a Level 4 Diploma in International Trade.

Duration 2 Days 12 CPD hours Overview This program is designed to provide you with the knowledge and skills necessary to: Build a solid foundation in human resource management. Discuss key pieces of federal legislation that impact HR. Understand the role of the EEOC and its investigatory process. Improve your employee recruitment and selection process to help avoid legal pitfalls. Understand the importance of effectively communicating base pay, incentive compensation, and benefits information to staff at all levels. Gain knowledge of employee orientation, onboarding, and training and development. Learn the process, methods and purpose of performance appraisals. Gain the critical knowledge necessary to help reduce costs, avoid potential lawsuits, and improve your ability to handle challenging HR issues. This program is ideal if you are just starting out in the HR profession. 1 - HUMAN RESOURCE MANAGEMENT The HR profession Strategic and human resource planning 2 - EMPLOYMENT LAW Federal CEO legislation The EEOC and affirmative action Compensation legislation Other federal 3 - RECRUITMENT AND SELECTION Recruiting The selection process Evaluating applicants 4 - COMPENSATION AND BENEFITS Total compensation Pay increases and incentives Compensation system design Benefits overview 5 - EMPLOYEE DEVELOPMENT Orientation, training, and development Training program design Training evaluation 6 - PERFORMANCE MANAGEMENT Performance management systems Performance appraisal process Disciplinary action Termination Additional course details: Nexus Humans SHRM Essentials of HR Management 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 SHRM Essentials of HR Management 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 This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

About this Training Course The 3-day hands-on petroleum economics training course provides a comprehensive overview of the practices of exploration and development petroleum economics and its application in valuing oil and gas assets to aid corporate decisions. Participants will gain a thorough understanding of the principles of economic analysis as well as practical instruction in analytical techniques used in the industry. The participants will learn how to construct economic models, to include basic fiscal terms, production and cost profiles and project timing. The resulting model will provide insights of how the various inputs affect value. Example exercises will be used throughout the course. Training Objectives Upon completion of this course, participants will be able to: Understand and construct petroleum industry cash flow projections Calculate, understand and know how to apply economic indicators Learn and apply risk analysis to exploration and production investments Evaluate and model fiscal/PSC terms of countries worldwide Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: Geologists Explorationists Reservoir Engineers Project Accountants Contract Negotiators Financial Analysts New Venture Planners Economists Course Level Basic or Foundation Intermediate Trainer Your expert trainer has over 40 years' experience as a petroleum economist in the upstream oil and gas industry. He has presented over 230 oil and gas industry short courses worldwide on petroleum economics, risk, production sharing contracts (PSC) and fiscal analysis. In over 120 international oil industry consulting assignments, he has advised companies and governments in the Asia Pacific region on petroleum PSC and fiscal terms. He has prepared many independent valuations of petroleum properties and companies for acquisition and sale, as well as economics research reports on the oil and gas industry and including commercial support for oil field operations and investments worldwide. He has been involved in projects on petroleum royalties, design of petroleum fiscal terms, divestment of petroleum assets, and economic evaluation of assets and discoveries since the early 1990s to date. He has been working on training, consultancy, research and also advisory works in many countries including USA, UK, Denmark, Switzerland, Australia, New Zealand, Indonesia, India, Iran, Malaysia, Thailand, Vietnam, Brunei, Egypt, Libya, and South Africa. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations