Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.
Better relationships intensive training programme One on one dating coaching Better relationships programme and Relationship assessment overview 5 Day Holiday in mystery 5 star location (Clear mind and relaxation) 2 day therapy in 5 star Luxury London hotel Luxury spa retreat and treatment by celebrity facialist World famous celebrity dentist teeth whitening treatment Free M.D.D Membership for 1 year Assess your love life and enjoy a vacation and bespoke luxury package created by your M.D.D date coach to tailor to your specific needs and problem areas enjoy a first-class experience and let the M.D.D help you embrace a new and bright future and assist you with a beautiful transition to the love life you desire and a happier, confident, enriched mind.Let all your strengths and abilities be harnessed to propel you to great success with this intensive package Price on application https://relationshipsmdd.com/product/m-d-d-premier-vip-coaching-package/
6 Week Qi-Gong Course For Winter When: Tuesday Evenings 6pm and Thursday Mornings (via Zoom) All classes are recorded so you can catch up in your own time. Dates: Tuesdays 6-7pm: January 7th, 14th, 21st, 28th and February 4th and 11th Thursdays 9-9.30am: January 9th, 16th, 23rd, 30th and February 6th and 13th Price: Concessions £60 – Standard £80 – Supporter £110 Suitable for everyone no matter your experience What if you could improve your health, strength and vitality, by simply slowing down? Slow your body Slow your breath Slow your mind When we slow down we give ourselves the opportunity to rejuvenate, to recharge and to harness our own life force energy or “Qi”. As we move towards winter we begin to turn inwards and connect to the power of Yin, the power of Water and the power of finding our own slow flow. In this 6 week course we will explore Qigong movements, meditations and breathwork practices to support this slowing down, giving us the space to connect to our Qi, to our subtle energy, giving us the tools to feel stronger, calmer and full of vitality. In Traditional Chinese Medicine we are entering the water phase of winter. The water element relates to the organs of the bladder and kidneys, our bones, our ears and our sense of hearing. The meridians of Kidney and Bladder run along our spine and the back of the body and when they are flowing well we feel supported by life, grounded and connected to the world around us. We can find our inner flow with ease, without effort or strain, enabling us to let go of our fears and move forward with courage. Qigong teaches us to come back to our bodies, to come back home, to a place of belonging that is inside all of us, a place of stillness in our the centre. Where we can better navigate life’s uncertainties with greater balance, ease, and steadiness. What is included: Six live 60min evening Qigong Classes on zoom Six live 30min morning Slow Flow classes on zoom Access to replays of all classes so you can catch up in your own time. Access to private Whats App group to share experiences and ask questions Weekly supporting material for home practice : – A Weekly video with a guided Qigong Practice or Meditation – PDF – explanations of each practice – Key acupuncture points for self massage Together we will: Learn a simple Slow Flow Qigong Movements to balance your nervous system and release stress. Explore the principal of Wu Wei – Release tension and move with effortless action Connect to your deep internal power – Learn to Standing in Emptiness (Wuchi) Strengthen Kidneys and support adrenal health Exercises to strengthen your spine and reduce back pain Clear the meridian pathways reducing stagnation and stiffness for increased flow and vitality. Learn self-massage techniques for key acupuncture points to release stress and calm our busy minds. Qigong means “To Nourish Life” and for me having a regular practice helps to bring me home to myself. What will i get out of this course? Deeper body awareness Increased strength and emotional stability Relax your mind and Improve mental clarity Enhanced breathing and improved circulation Strengthen your back and build a healthy spine Less physical tension and reduced pain More energy Less stress and anxiety Everyone is welcome to join the course no matter your experience. Please get in touch if you have any questions.
Duration 3 Days 18 CPD hours This course is intended for This course is geared for experienced Scala developers who are new to the world of machine learning and are eager to expand their skillset. Professionals such as data engineers, data scientists, and software engineers who want to harness the power of machine learning in their Scala-based projects will greatly benefit from attending. Additionally, team leads and technical managers who oversee Scala development projects and want to integrate machine learning capabilities into their workflows can gain valuable insights from this course Overview Working in a hands-on learning environment led by our expert instructor you'll: Grasp the fundamentals of machine learning and its various categories, empowering you to make informed decisions about which techniques to apply in different situations. Master the use of Scala-specific tools and libraries, such as Breeze, Saddle, and DeepLearning.scala, allowing you to efficiently process, analyze, and visualize data for machine learning projects. Develop a strong understanding of supervised and unsupervised learning algorithms, enabling you to confidently choose the right approach for your data and effectively build predictive models Gain hands-on experience with neural networks and deep learning, equipping you with the know-how to create advanced applications in areas like natural language processing and image recognition. Explore the world of generative AI and learn how to utilize GPT-Scala for creative text generation tasks, broadening your skill set and making you a more versatile developer. Conquer the realm of scalable machine learning with Scala, learning the secrets to tackling large-scale data processing and analysis challenges with ease. Sharpen your skills in model evaluation, validation, and optimization, ensuring that your machine learning models perform reliably and effectively in any situation. Machine Learning Essentials for Scala Developers is a three-day course designed to provide a solid introduction to the world of machine learning using the Scala language. Throughout the hands-on course, you?ll explore a range of machine learning algorithms and techniques, from supervised and unsupervised learning to neural networks and deep learning, all specifically crafted for Scala developers. Our expert trainer will guide you through real-world, focused hands-on labs designed to help you apply the knowledge you gain in real-world scenarios, giving you the confidence to tackle machine learning challenges in your own projects. You'll dive into innovative tools and libraries such as Breeze, Saddle, DeepLearning.scala, GPT-Scala (and Generative AI with Scala), and TensorFlow-Scala. These cutting-edge resources will enable you to build and deploy machine learning models for a wide range of projects, including data analysis, natural language processing, image recognition and more. Upon completing this course, you'll have the skills required to tackle complex projects and confidently develop intelligent applications. You?ll be able to drive business outcomes, optimize processes, and contribute to innovative projects that leverage the power of data-driven insights and predictions. Introduction to Machine Learning and Scala Learning Outcome: Understand the fundamentals of machine learning and Scala's role in this domain. What is Machine Learning? Machine Learning with Scala: Advantages and Use Cases Supervised Learning in Scala Learn the basics of supervised learning and how to apply it using Scala. Supervised Learning: Regression and Classification Linear Regression in Scala Logistic Regression in Scala Unsupervised Learning in Scala Understand unsupervised learning and how to apply it using Scala. Unsupervised Learning:Clustering and Dimensionality Reduction K-means Clustering in Scala Principal Component Analysis in Scala Neural Networks and Deep Learning in Scala Learning Outcome: Learn the basics of neural networks and deep learning with a focus on implementing them in Scala. Introduction to Neural Networks Feedforward Neural Networks in Scala Deep Learning and Convolutional Neural Networks Introduction to Generative AI and GPT in Scala Gain a basic understanding of generative AI and GPT, and how to utilize GPT-Scala for natural language tasks. Generative AI: Overview and Use Cases Introduction to GPT (Generative Pre-trained Transformer) GPT-Scala: A Library for GPT in Scala Reinforcement Learning in Scala Understand the basics of reinforcement learning and its implementation in Scala. Introduction to Reinforcement Learning Q-learning and Value Iteration Reinforcement Learning with Scala Time Series Analysis using Scala Learn time series analysis techniques and how to apply them in Scala. Introduction to Time Series Analysis Autoregressive Integrated Moving Average (ARIMA) Models Time Series Analysis in Scala Natural Language Processing (NLP) with Scala Gain an understanding of natural language processing techniques and their application in Scala. Introduction to NLP: Techniques and Applications Text Processing and Feature Extraction NLP Libraries and Tools for Scala Image Processing and Computer Vision with Scala Learn image processing techniques and computer vision concepts with a focus on implementing them in Scala. Introduction to Image Processing and Computer Vision Feature Extraction and Image Classification Image Processing Libraries for Scala Model Evaluation and Validation Understand the importance of model evaluation and validation, and how to apply these concepts using Scala. Model Evaluation Metrics Cross-Validation Techniques Model Selection and Tuning in Scala Scalable Machine Learning with Scala Learn how to handle large-scale machine learning problems using Scala. Challenges of Large-Scale Machine Learning Data Partitioning and Parallelization Distributed Machine Learning with Scala Machine Learning Deployment and Production Understand the process of deploying machine learning models into production using Scala. Deployment Challenges and Best Practices Model Serialization and Deserialization Monitoring and Updating Models in Production Ensemble Learning Techniques in Scala Discover ensemble learning techniques and their implementation in Scala. Introduction to Ensemble Learning Bagging and Boosting Techniques Implementing Ensemble Models in Scala Feature Engineering for Machine Learning in Scala Learn advanced feature engineering techniques to improve machine learning model performance in Scala. Importance of Feature Engineering in Machine Learning Feature Scaling and Normalization Techniques Handling Missing Data and Categorical Features Advanced Optimization Techniques for Machine Learning Understand advanced optimization techniques for machine learning models and their application in Scala. Gradient Descent and Variants Regularization Techniques (L1 and L2) Hyperparameter Tuning Strategies
Join the Historical Association and the Royal Geographical Society at this special online twilight forum event specifically for primary teachers of history and geography. The theme this time will be climate education and how primary teachers can develop this through their history and geography lessons. With a keynote speaker and workshop sessions from Ailsa Fidler and Emma Espley, plus an opportunity to network and share ideas, this event will support primary teachers to better understand how history and geography can feed into the responsibility of every curriculum subject to educate our young people about the climate crisis and sustainable futures.
The Alternative Energy Technology Course is a practically based alternative energy course designed to give participants an understanding of alternative energy options and provide them with that practical knowledge and skills to build solar to electric and wind to electric systems at a foundation level. The course is designed to be of benefit to people either working or intending to work as:- Alternative Energy Installers or anyone just wishing to gain practical knowledge of Practical Alternative Energy Systems
About this training course This 3-days training will provide a comprehensive review of integrity of wells exposed to carbon dioxide (CO2) in the context of Carbon Capture Utilization for enhanced oil recovery and Storage (CCUS). CO2 geological storage is a proven technology to reduce greenhouse gas emissions from sources such as coal power plants, cement kilns and steel mills. Wells are widely considered the most critical containment element, especially older wells that are not used to inject CO2 or monitor the plume evolution in the storage reservoir. The main reason for this perceived risk is the high corrosion rate of carbon steel when exposed to wet CO2, and the tendency of Portland cement to react with the gas. The training course advanced contents build on 15 years' experience in carbon storage, both in the development and deployment of technologies. First-hand, in-depth knowledge of the subject will allow us to debunk myths and focus on the real challenges of wells encountering CO2. Training Objectives After the completion of this training course, participants will be able to: Explain the CCUS market drivers Examine the behavior of CO2, on surface and in the reservoir Diagnose cement defects and design repairs Understand the limits of Portland cement Assess the benefits of different technologies and materials Realize why geology is a dominant factor in cement performance Critically choose the most appropriate monitoring techniques Classify aging processes of cement, steel, and rock when exposed to CO2 Assess the risk of existing wells if they encounter the CO2 plume Examine recent advances in real-time approaches to the production monitoring and lift management Target Audience This training course is suitable and will greatly benefit: All surface technical personnel such as process engineers & technologists Facility engineers, production engineers & technologists Drilling engineers and Well engineers Design engineers and Integrity engineers P&A engineers and Cementing engineers Geologists Senior management executives will benefit from this training as covers an overview of the technical and commercial details of CO2 capture technologies and risks involved. 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: 3 days in total (21 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 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is an engineer with a passion for well integrity and possesses 28 years of international experience in field operations, technology development and management in the oil & gas and carbon storage sectors. Since 2018 he is program chair of the Well Integrity Technical Section of the Society of Petroleum Engineers (SPE). He is also author or co-author of 31 technical papers, a book chapter on CO2 geological storage and 7 patent applications. He delivers training on well integrity, plug and abandonment, asset integrity, risk management and QHSE across the Eastern Hemisphere, and carries out active research on harnessing geological barriers, modeling leaks through cement, and quantifying methane emissions from oil & gas wells. He has extensive expertise in: Well integrity, cementing, corrosion, upstream oil & gas (drilling, completion), carbon capture and storage, mathematical modeling, risk management, reliability, HSSE (health/safety/security/environment), asset integrity, management systems, sustainable development, project management, portfolio management, training, and technology development and innovation. He has personally worked on CCS projects in Europe (France, Germany, Netherlands, Norway), Algeria, Japan and USA. Partial list of companies that have benefited from the trainer's expertise: Vermilion Energy Geostock Aker BP Shell Statoil ENI TNO Geogreen Wintershall Archer INA and many more Recent CCS consulting track record: Schlumberger Total Oxand TNO THREE60 Energy and others 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
SAFe® Agile Product Management: Virtual In-House Training Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable. The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent. What you will Learn After completing the class, you should be able to: Use Design Thinking to achieve desirable, feasible, and sustainable outcomes Explore market needs, segmentation, sizing, and competitive landscape Manage value stream economics, including pricing and licensing Use empathy to drive design Apply product strategy and vision Develop and evolve roadmaps Execute and deliver value using SAFe® Explore innovation in the value stream Analyzing your Role as a Product Manager in the Lean Enterprise Continuously Exploring Markets and Users Driving Strategy with Market Segmentation Using Empathy to Drive Design Defining Product Strategy and Vision Creating Roadmaps to Build Solutions Delivering Value Managing Value Stream Economics Creating Innovation in the Value Stream
SAFe® Agile Product Management: In-House Training Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable. The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent. What you will Learn After completing the class, you should be able to: Use Design Thinking to achieve desirable, feasible, and sustainable outcomes Explore market needs, segmentation, sizing, and competitive landscape Manage value stream economics, including pricing and licensing Use empathy to drive design Apply product strategy and vision Develop and evolve roadmaps Execute and deliver value using SAFe® Explore innovation in the value stream Analyzing your Role as a Product Manager in the Lean Enterprise Continuously Exploring Markets and Users Driving Strategy with Market Segmentation Using Empathy to Drive Design Defining Product Strategy and Vision Creating Roadmaps to Build Solutions Delivering Value Managing Value Stream Economics Creating Innovation in the Value Stream
Duration 2 Days 12 CPD hours This course is intended for Leaders and professionals who manage teams or groups and are responsible for their outcomes will benefit from this course. Overview Apply techniques to encourage participation and reach consensus Utilize facilitative questioning techniques Recognize indicators to facilitate each stage of the team process Deal constructively with disruptions and typical problem behavior Implement interventions appropriately Plan and run a focused discussion, meeting or event Students will learn how to develop and apply facilitation techniques to support their team at every stage of the team life cycle. Students will enhance their interpersonal competencies and observational abilities to deal with disruptions and more. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. The Importance of Facilitation Being an Effective Facilitator Harnessing Knowledge, Experience, and Diversity Encouraging Group Motivation and Commitment Observing the Team Process 2. Facilitating Process and Content Identifying Process and Content Elements Managing the Flow Resolving Tensions and Disagreement 3. Setting the Stage for Facilitation Laying the Groundwork, Educating Participants, and Securing Support Selecting the Right Facilitator Planning for a Facilitated Meeting 4. Facilitating Team Development Encouraging Participation Recognizing Stages in the Team Life Cycle Supporting the Team through the Stages 5. Building Consensus and Reaching Decisions Gathering and Presenting Data Synthesizing and Summarizing Identifying Options and Brainstorming Facilitating SWOT Analysis Creating a Short List Using the Multi-Option technique 6. Disruptions, Dysfunctions and Interventions Handling Disruptions and Difficult Behavior Addressing Dysfunction Agreeing on Ground Rules Restating and Reframing