32065 Development courses

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.

About this Training Course Time is money in all industries. For the Oil & Gas industry, this is no exception and the ability to maximise return on investment is all related to where the Oil is and how easily and quickly we can get that product to the customer. Whether in a technical, managerial or supporting role, you are a valuable asset in ensuring that project delivery targets are met and profits are realised. As Petroleum Engineering (PE) activities continue to increase, professionals like you must grasp the language and technology of PE operations in order to maximise expenditures throughout the producing life of a well. Petroleum Engineering equipment and procedures have a unique language that must be conquered for maximum benefit. Clear and understandable explanations of rig equipment, completion equipment, operations procedures, and their complex interactions provide an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. A confident understanding of the technical jargon and a visual appreciation of the various pieces of equipment used provides for an overall 'big picture' of the industry value chain. This serves as an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of this course, the participants will be able to: Define the role of Petroleum Engineering and its interaction between other departments Describe terms used in the Oil & Gas industry such as Surface/Subsurface, Upstream, Midstream and Downstream Describe the Appraisal of Oil & Gas Discoveries, the Cost Estimations, Economics & Reserves Explain what is the Formation, how do we connect to it, and how do we ensure best value Describe how to construct a well, select the equipment & methods, understand the duration that the well is required to perform for Target Audience This course will benefit those in geology, reservoir engineering, equipment and maintenance, and non-petroleum engineering technical professionals as well as forward-looking executives in the following fields who are interested to enhance their knowledge and awareness of the drilling process for increased productivity and contribution to the team that they're supporting: Accounting Administration Business Development Commercial E & P IT Estimation & Proposal Finance & Administration Finance HSE General Management Joint Ventures Legal Logistics Materials Planning Planning & Budgeting Procurement Sourcing Supply Chain Tender Contract Training Drilling Fluids Course Level Basic or Foundation Trainer Your Expert Course Trainer has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. 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

Dive into the realm of Solar PV Systems Modelling and Analysis through EnergyEdge's course. Stay ahead in the field of renewable energy with expert training.

This course bundle is ideal for anyone looking to establish their Cisco networking career. It consists of one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified DevNet Associate (CCDA) certification, and four Cisco Certified Networking Professional (CCNP) certifications. Although there are no formal prerequisites to enrol on the CCNA, CCDA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The newly retooled CCNA covers a breadth of topics, including: Network fundamentals Network access IP connectivity IP services Security fundamentals Automation and programmability Achieving CCNA certification is the first step in preparing for a career in networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified DevNet Associate certification validates your skills and knowledge in understanding and using APIs, Cisco platforms and development, application development and security, and infrastructure and automation. Ideally, DevNet Associates candidates also have one or more years of experience with software development including Python programming. The CCNP is the next level from the CCNA and CCDA. As with the CCNA, there are no formal prerequisites to enrol on the CCNP certification course and sit for the exams. Learners taking a CCNP course generally have an in-depth knowledge of networking, as well as a good understanding of Cisco technologies. The typical certification path for most learners would begin with either the CCDA or CCNA, then progress onto the CCNP. Learners need to pass two exams (one core exam and one concentration exam) in order to gain one CCNP certification. This course bundle includes the core exam and three concentration exams. Once a learner has passed the core exam, they can choose to specialise in one or all three of the CCNP concentration areas listed in this course. The core exam’s focus is based around implementing and operating Cisco enterprise network core technologies.

Enhance your knowledge of economic and financial analysis in renewable energy storage and hydrogen with EnergyEdge's course. Enroll now!

Whether you’re aiming to guide others in their personal or professional growth, or simply sharpen your ability to listen, question and encourage—this Coaching and Mentoring Diploma has been thoughtfully designed to help you do just that, with clarity and confidence. Delivered entirely online, the course suits those with an eye for development—both in themselves and others—without demanding classroom attendance or calendar acrobatics. From understanding the psychology behind effective coaching to grasping the nuances of mentoring relationships, each module is laid out in a logical, digestible manner. You'll explore strategies that foster meaningful dialogue, support others’ decision-making, and nurture lasting change. This course is ideal for those who want to elevate their communication and leadership style, whether in the workplace or personal circles. Professional, accessible, and packed with insight—this is structured learning with purpose, minus the waffle. Our Coaching and Mentoring Diploma course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Coaching and Mentoring Diploma QLS Bundle Includes the following Courses Course 01: Diploma in Coaching and Mentoring at QLS Level 5 Course 02: Personal Development Skills Course 03: Goal Setting, Motivation, and Resilience Course 04: Emotional Intelligence, Mindfulness and Empathy Training Course 05: Maximising Personal Productivity Course Key Features of Coaching and Mentoring Diploma Eligibility for QLS endorsed certificate upon successful completion of the Coaching and Mentoring Diploma course Free CPD Accredited Course Fully online, interactive Coaching and Mentoring Diploma course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Coaching and Mentoring Diplomatraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Coaching and Mentoring Diploma course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Coaching and Mentoring Diploma course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Coaching and Mentoring Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Coaching and Mentoring Diploma course, learners will be able to order an endorsed certificate, titled: Diploma in Coaching and Mentoring at QLS Level 5, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Coaching and Mentoring Diploma basics. Requirements No prior degree or experience is required to enrol in this Coaching and Mentoring Diploma course. Career path This Coaching and Mentoring Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Enhance coal power plant efficiency with EnergyEdge's course on heat rate optimization. Join our classroom training for expert insights!

The Level 5 qualifications in Management and Leadership are aimed at those who are working as middle managers and those who are aspiring to be senior managers. This qualification is mainly focused on the improvement of the student’s capabilities and core management skills such as resource management, recruitment, and information management. The Level 5 Diploma in Management and Leadership has been devised for developing the key skills of middle managers and those who are striving to be senior managers. This diploma is a benchmark qualification for full CMI membership which will take you one step closer to the status of a Chartered Manager. We have a 100% pass rate due to the high levels of support delivered through our online learning platform and individual coaches/assessors are assigned to all students. Our speed of response is second to none and our 5-star rating from our students speaks for itself. We are delighted to have supported students to unleash their potential from a diverse range of organisations both within the UK and internationally from organisations that have most recently included: Michelin Barclays Firstsource Mercedes Benz Shangrila Hotels and Resorts Virgin Money UK Person College London North Norfolk District Council G&L Scientific Coca Cola New Balance PureGym As a CMI accredited Chartered Manager Centre, many of our students go on to achieve recognition as Chartered Managers through our centre. Study method Online, self-paced Duration 6months Access to content Access until course completion Qualification Level 5 Diploma in Management and Leadership (RQF) CPD 370 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students CPD 370 CPD hours / points Accredited by Chartered Management Institute Key Benefits Latest and emerging as well as classical leadership and management concepts, theories and models. Practical guidance and support from our coaches and assessors who are all CMI Chartered Managers or Fellows. An internationally – recognised professional qualification. The credits earned at this course can be transferred to other courses if the students want to pursue MBA or any other Masters. On successful completion of the programme, students will be able to demonstrate their understanding and ability to apply leadership and management good practice which will improve their attractiveness to employers. The programme covers a choice of the following Units to a Total Qualification Time of 540 hours: CMI 502 Developing, Managing and Leading Individuals and Teams to Achieve Success (60 Hours TUT) CMI 504 Managing Performance (50 Hours TUT) CMI 506 Managing Equality, Diversity and Inclusion (50 Hours TUT) CMI 514 Managing Change (50 Hours TUT) CMI 513 Managing Projects to Achieve Results (60 Hours TUT) CMI 515 Creating and Delivering Operational Plans (60 Hours TUT) CMI 517 Principles of innovation (50 Hours TUT) CMI 520 Managing finance (60 Hours TUT) CMI 523 Principles of marketing products and services (60 Hours TUT) CMI 524 Conducting a Management Project (100 Hours TUT) CMI 525 Using Reflective Practice to Inform Personal and Professional Development (50 Hours TUT) We also provide students with access to the full CMI syllabus and support them if they wish to choose alternative Units. What the programme offers Level 5 Diploma in Leadership & Management from Chartered Management Institute (CMI) Student membership of the Chartered Management Institute Full learning support and all course materials All registration and assessment fees (We don't believe in hidden costs) Unrivalled one-to-one tutor support throughout the entire learning journey. A dedicated Chartered Manager as your programme coach/assessor 24-7 access to our extensive online Academy and CMI's Management Direct learning platform. All assessment and support materials are accessible through our online learning platform Assessment feedback within 48 hours to keep students motivated and on track The opportunity to progress to become recognised as a Chartered Manager upon successful completion Who is this course for? Middle Managers, potential middle managers and senior managers/business owners who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None - we offer an inclusive and welcoming learning environment to all our students and there are no barriers to entry. Prospective students should be aware this CMI level 5 qualification is approximately equivalent to an academic degree level. Students will be required to submit assignments to this level. Career path A career in leadership and management. A possible progression route on successful completion of a Level 5 qualification in Strategic Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to Level 6 or 7 Certificate)

The objective of the Level 7 Diploma in Tourism and Hospitality Management qualification (Accredited by Othm, UK) is to provide tourism industry professionals with the specialist knowledge needed to advance their careers. This Level 7 Diploma in Tourism and Hospitality Management is also helpful for graduates who are entering the tourism and hospitality sector for them to gain the skills needed to manage business operations. The qualification provides learners with a contemporary, critical, and international programme that supports their development as managers with a lifelong-learning orientation. The qualification also enables the learners to analyse complex management problems and to apply and adapt specialist skills and technical terminology to propose solutions to these problems informed by best practice and contemporary research. Successful completion of Level 7 Diploma in Tourism and Hospitality Management enable learners to progress into or within employment and/or continue their study towards a relevant Master's programme with advanced standing. Level 7 Diploma in Tourism and Hospitality Management Key Highlights of level 7 Diploma in Tourism and Hospitality Management programme are: Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The Diploma in Tourism and Hospitality Management - Level 7 will teach you to analyse complex management problems and to apply and adapt specialist skills and technical terminology to propose solutions to these problems informed by best practice and contemporary research. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's and MBA degree programme. Mandatory units (Total Credits: 120) The OTHM Level 7 Diploma in Tourism and Hospitality Management qualification consists of 6 mandatory units for a combined total of 120 credits Strategic Management and Marketing (20 credits) Destination Management (20 credits) International Tourism Policy and Development (20 credits) E-Tourism and Social Media (20 credits) Advanced Research Methods (20 credits) Organisational Behaviour in International Contexts (20 credits) Who is this course for? Working Professionals Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal Postgraduate qualification leading to award of degrees in future. Requirements For entry onto the Level 7 Diploma in Tourism and Hospitality Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admissio Counsellors for waiver information. Career path Become eligible to gain direct entry into relevant Master's degree programme after completion of your Level 7 Diploma in Tourism and Hospitality Management Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

About this Course Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources. As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets. BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market. Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes. For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off. During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic benefits when participating with BESS in the electricity market. Training Objectives By the end of this course, the participants will be able to: Discover the different BESS battery technologies and their impact on the grid Understand the role of storage in providing flexibility to the power system Examine the potential revenue streams from BESS models Learn how profit can generated with BESS trading strategies Determine how to optimize the value from BESS projects Find out how to combine BESS with renewable PPAs Target Audience Professionals and executives from Power Utilities, Energy Companies, Financial & Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful. Electricity Marketing and Traders New Venture or Business Development Executives Corporate Finance and Treasury Executives Audit and Risk Management Executives Power or Utility Market Research Analysts Investment Managers for Renewable Power Projects Origination Professionals Regulation, Compliance and Documentation Officers Lawyers and Accountants Power Transmission and Distributions Engineers Trainer Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East. He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and operational risks of the project. 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