291 Power courses in Sheffield

The package includes the following: Exploring unconscious patterns in couples therapy Healing personal histories in relationships Understanding the influence of the past on the present Enhancing self-awareness in couples therapy Resolving unresolved emotions in relationships Transforming relationship dynamics through psychodynamic approach Foster lasting change with psychodynamic therapy Comprehensive couples therapy program Invest in the future of your relationship today and experience the power of Psychodynamic Couples Therapy. Our compassionate therapists are dedicated to guiding you and your partner towards deep insights, transformation, and lasting fulfillment. Take the first step towards transformative change by scheduling a session with us now. 3 x 1 hour session https://relationshipsmdd.com/product/psychodynamic-couples-therapy/

Can be run as a one day or two day course. Whereas the one day course concentrates on Speaking Skills in delivering a talk and allows time for participants to prepare and deliver a very short talk, the two day course offers the opportunity for participants to deliver a longer (15 minute) talk and includes consideration of other situations where speaking skills are important such as talking in meetings, talking at interviews etc.

Introducing the “Why Do I Always End Up in Situationships?” Package: Your Solution to Avoid Heartbreak, Deception, and Being Used in Relationships Are you tired of constantly finding yourself in confusing and unfulfilling situationships? Do you long for a genuine and committed relationship but seem to attract partners who only want to keep things casual? Miss Date Doctor is here to empower you with the ultimate relationship coaching package designed specifically to break the cycle of situationships and protect your heart from being broken, used, or deceived. With our “Why Do I Always End Up in Situationships?” package, you will gain invaluable insights, practical tools, and personalized guidance to transform your dating life. Our team of experienced relationship coaches understands the complexities of modern dating and will help you navigate the treacherous waters to find genuine love and fulfillment. So, why should you invest in this package? Because it’s time to reclaim your power and create the love life you truly deserve. Here’s what you can expect: Comprehensive Relationship Assessment: Our expert coaches will conduct a thorough assessment to understand your dating history, patterns, and the factors that contribute to your attraction to situationships. By delving deep into your past experiences, we’ll identify any underlying issues that may be hindering your path to a committed relationship. Personalized Strategy Development: Based on the assessment results, we will create a customized action plan tailored to your specific needs and goals. This plan will serve as your roadmap, guiding you through each step of the process to break free from situationships and establish healthier relationship dynamics. Relationship Education and Skills Building: Knowledge is power, especially when it comes to relationships. Our package includes comprehensive educational resources and materials that cover a range of topics, including effective communication, setting boundaries, recognizing red flags, and fostering emotional intimacy. Armed with this knowledge, you’ll be equipped to make informed choices and build strong, lasting connections. Emotional Support and Guidance: Navigating the complexities of relationships can be emotionally challenging. That’s why our coaches are here to provide you with ongoing support and guidance throughout your journey. We’ll be by your side, offering compassionate guidance, helping you overcome setbacks, and celebrating your successes along the way. Role-Playing and Scenario-Based Coaching: To reinforce your newly acquired skills, we’ll engage in role-playing exercises and scenario-based coaching sessions. This hands-on approach will empower you to handle challenging situations confidently and make decisions that align with your relationship goals. Continuous Progress Monitoring: We believe in accountability and progress tracking. Throughout the coaching process, we’ll monitor your progress, provide feedback, and make adjustments to your strategy if needed. This ensures that you stay on track and continue making strides towards breaking the cycle of situationships. Don’t let situationships define your love life any longer. Invest in the “Why Do I Always End Up in Situationships?” package from Miss Date Doctor and take control of your romantic destiny. Say goodbye to heartbreak, deception, and being used in relationships, and say hello to genuine love, connection, and fulfillment. Enroll today and unlock the keys to a healthier and more satisfying love life. Contact Miss Date Doctor now to book your package and embark on a transformative journey towards building meaningful, committed relationships. Your happily ever after is within reach! 3 X 1 HOUR https://relationshipsmdd.com/product/why-do-i-always-end-up-in-situationships-package/

The package includes the following: Positive change in relationships with CBCT Breaking negative patterns in couples therapy Effective communication techniques for couples Problem-solving skills in relationships Enhancing empathy and understanding in partnerships Building trust through Cognitive-Behavioural Therapy Overcoming conflicts in relationships Promoting healthy behaviours in couples Improving relationship satisfaction with CBCT Transformative couples therapy program Invest in the future of your relationship today and experience the power of Cognitive- Behavioural Couples Therapy. Our compassionate therapists are ready to guide you and your partner towards a more fulfilling and harmonious connection. Take the first step towards positive change by scheduling a session with us now. 3 sessions x 1 hour https://relationshipsmdd.com/product/cognitive-behaviourial-couples-therapy-package/

Acceptance and Commitment Therapy (ACT) Package: Embrace Your True Self and Live Authentically Discover the transformative power of Acceptance and Commitment Therapy (ACT) with Miss Date Doctor’s specialized package. ACT is a cutting-edge form of therapy that helps you accept your thoughts and emotions while aligning your actions with your core values. Say goodbye to old patterns of avoidance and self-doubt, and embrace a life of psychological flexibility and authenticity. Our experienced therapists will guide you through targeted exercises and techniques that empower you to embrace discomfort, develop resilience, and make meaningful changes in your life. With the ACT package, you’ll find the courage to face challenges head-on, build stronger relationships, and achieve your personal and relationship goals. This comprehensive program will equip you with the tools needed to navigate life’s uncertainties and build a stronger, happier you. 3 X 1 HOUR SESSION https://relationshipsmdd.com/product/acceptance-and-commitment-therapy-package/

About this Training Course Oil & Gas professionals increasingly need to translate complex findings, analysis and recommendations for effective decision-making. If you face challenges in getting your findings into paper, you will benefit from this training course. The Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals course focuses on the unique needs of technical professionals who write for both technical and non-technical readers. This separately bookable training course will demonstrate how technical professionals can use their technical knowledge and logical edge to write in a reader-friendly style, produce grammatically accurate reports and persuasively communicate for buy-in purposes. An ILM Recognised programme. Training Objectives LEARNING OUTCOMES FOR TECHNICAL REPORT WRITING SKILLS By the end of this course, participants will be able to: Write and turn-around accurate technical documents quickly to meet deadlines and productivity goals Understand how technical reports should be structured by applying a systematic approach to the writing task, involving planning, drafting, revision and production Use clear & powerful language to target and persuade readers for positive results Use tried and tested proof reading techniques to check and review documents more effectively Identify and avoid common pitfalls in technical report writing LEARNING OUTCOMES FOR TECHNICAL PRESENTATION SKILLS By the end of this course, participants will be able to: Present and sell your technical presentation more effectively both internally and externally Plan and structure your meetings and presentations for maximum effect Capture your technical and non-technical audience by delivering your presentation with power and authority Handle questions, interruptions and objections with confidence Target Audience This programme has been researched and developed for all Oil & Gas Engineers and Technical Professionals Course Level Basic or Foundation Trainer Your course leader managed the Business Skills Unit of the British Council programmes as well as oversee all training-related matters from 1997. The trainer considers himself a trainer first and specialises predominantly in high-level writing and technical report writing programmes. In addition to conducting training in Technical Writing, the trainer has also been the chief editor for many large writing projects. These include a year-long project editing the entire Start-Up Manual (including the Black Start Manual) for Nippon Oil's Helang Integrated Platform, a 4-month project rewriting the manuals for the Puteri Dulang FSO off Terengganu, and editing the current revision of the PETRONAS Procedures and Guidelines for Upstream Activities (PPGUA). 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

Are you tired of feeling lost and frustrated in your dating life? Are you ready to take control and find the love you deserve? Look no further than our Personal Dating Coach Package. Designed to provide you with the personalized guidance and support you need, this package is your key to unlocking relationship success. Our team of highly skilled and experienced dating coaches is dedicated to helping individuals like you navigate the complexities of dating and relationships. With our Personal Dating Coach Package, you’ll receive a comprehensive and tailored approach to improving your dating skills and achieving your relationship goals. Personal Dating Coach Package is designed to meet your unique needs and preferences. Through a series of one-on-one coaching sessions, our expert dating coach will delve into your dating history, assess your strengths and areas for improvement, and develop a customized plan of action. Throughout the coaching process, our dating coach will provide invaluable insights, practical advice, and proven strategies to help you overcome obstacles, boost your self-confidence, and enhance your communication skills. We’ll guide you in developing a positive dating mindset, understanding dating etiquette, and navigating various aspects of the dating world, from online dating to first dates and beyond. With our Personal Dating Coach Package, you’ll have a dedicated professional by your side, supporting you every step of the way. We’ll provide ongoing feedback, accountability, and motivation to keep you on track towards your relationship goals. Our goal is to empower you with the tools and knowledge you need to create lasting and meaningful connections. Don’t let another day go by without taking action towards the love life you desire. Invest in our Personal Dating Coach Package and experience the transformative power of personalized coaching. With our expertise and your commitment, you can confidently navigate the dating landscape and find the fulfilling relationship you’ve been searching for. You have something to talk to everyday whenever you need guidance or support 1 month support 7 days a week 40 mins per day https://relationshipsmdd.com/product/personal-dating-coach-package/

About this Training Subsea pipelines play a critical role in the transportation of hydrocarbons (e.g. oil and gas) from offshore production sites to onshore facilities or other platforms. This course will cover design and construction of subsea pipelines with respect to: design for pressure containment, design for collapse, on-bottom stability, freespans, global (lateral and upheaval buckling), corrosion, materials selection, cathodic protection and coatings. Training Objectives Upon completion of this course, participants will be able to understand: Issues and challenges in subsea pipeline design Methods in applying pipeline design codes Techniques in how to specify a pipeline Key considerations in the main methods of pipeline construction Methods and issues surrounding pipeline intervention Target Audience The course is recommended for anyone who wish to gain in-depth knowledge and appreciation of the fundamental principles of the design and construction of subsea pipelines, including: Team Leaders Senior Managers (Line and Function) Project Managers Graduate Engineers Pipeline Engineers Senior Pipeline Engineers Subsea Engineers Integrity Engineers Quality Assurance Engineers Key Contractor's Management Course Level Basic or Foundation Trainer Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc. 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

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led 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.