50593 Courses delivered Online

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 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

Are you captivated by the celestial tapestry of the night sky? Do you marvel at the cosmic dance of the stars or yearn to decode the enigma of the Big Bang? Our Astronomy GCSE course, tailored for self-paced learning, could be your perfect stargazing companion. Under the steadfast guidance of a dedicated tutor, this course will take you on a virtual space voyage, studying the cosmic choreography of our galaxy's celestial bodies - from our home planet, the moon and the sun, to neighbouring planets, comets, and distant stars. Discover the dynamics that govern our planetary systems, leading to day-night and seasonal transitions. Journey through the annals of time to learn how historical observations of celestial patterns shaped our understanding of our cosmic address. Lastly, delve into current theories about the universe's evolution and their implications for humankind's future. The course not only cultivates scientific reasoning and problem-solving skills - valued by universities and employers - but also lays a solid foundation for a potential career in various scientific fields, including meteorology, and professions in planetariums, museums, and engineering. This course isn't just an introduction to astronomy; it's a launching pad to your future. This Edexcel GCSE Astronomy course has been crafted for convenient online study, providing unlimited access to your personal tutor via email and telephone. We ensure a clear course induction and meticulously structured assignments to help you excel in your exams. Our GCSE in Astronomy features: Freshly minted course, devised according to the latest specifications with dynamic, engaging content. A fast track option for exams in 2022. Access to our partnered exam centres for a guaranteed exam venue. Unlimited tutor support. Exam pass guarantee: if you don't succeed the first time, we'll assist you until the next exam. This course is a magnificent initiation into the awe-inspiring world of astronomy for stargazers and those mesmerised by the cosmic ballet.  About the awarding body Awarding body: Edexcel Our course code: X815 Qualification code: 1AS0 Official Qualification Title: Astronomy GCSE Edexcel, the UK's leading awarding organisation, provides academic and vocational qualifications in schools, colleges, and workplaces both domestically and internationally. For nearly two decades, Edexcel has empowered learners to achieve success through education. ⏱ Study Hours: Allocate between 120 and 150 hours for study, plus additional time for assignment completion. 👩‍🏫 Study Method: Our interactive online platform delivers the course, offering a variety of media including videos, quizzes, and interactive activities. If you prefer, you can print the learning materials. 📆 Course Duration: Post-enrolment, you have up to two years to study and take your exams, with continuous unlimited tutor support. 📋 Assessment: Enrolments are open now for exams from Summer 2022. You will need to complete two standard GCSE written exams, each of 1 hour 45 minutes, contributing 50% of the marks. We provide a guaranteed exam space in one of our country-wide exam centres. Throughout the course, you'll complete assignments for tutor feedback, helping you to monitor your progress. You will also complete two observational tasks: one unaided and one using a telescope. 👩‍🎓 Course Outcomes: Successful completion of this course will award you with a GCSE in Astronomy, issued by Edexcel. This syllabus is chosen for its compatibility with distance learning. ℹ️ Additional Information: Official Qualification Title - Astronomy GCSE Difficulty - Level 2 Entry requirements - No formal entry requirements. Ability to observe the night sky and a good grasp of maths are needed. Course Content: The course covers essential math skills for astronomy, celestial observations, exploration of planetary systems, the solar system, the moon, the Earth-moon-sun system, stellar evolution, cosmology, and our place in the galaxy, among others.

Dive into the enthralling world of life sciences with our online Biology IGCSE course. Engage with the intriguing elements of life, from the origins of the universe, the human psyche, to the vibrancy of animal species. This course invites you to comprehend the complex mechanisms of cellular functions, cellular division, and how various human body systems collaboratively enable life. Broaden your understanding of biodiversity, deforestation, genetics, and evolution. This comprehensive IGCSE Biology course serves as a stepping stone to a plethora of captivating careers like medicine, zoology, pharmacology, and more. This course is specifically designed for online study, based on the latest Edexcel GCSE Biology syllabus. Indulge in self-paced learning, with the guidance of structured assignments, to build your proficiency and knowledge for the examination. Key Highlights: Fresh, dynamic, and engaging course content, aligned with the latest specifications Fast track option available for 2022 exams Access to partnership exam centres ensuring guaranteed exam venue Unlimited tutor support, offering a study plan and continuous support Exam pass guarantee (additional support provided for resit exams) GCSE Biology is an intellectually stimulating course that fosters the necessary skills for a successful career path. About the awarding body Awarding body: Edexcel Our course code: X805 Qualification code: 4BI1 Official Qualification Title: IGCSE Biology  Edexcel is a globally recognized education and examination body, providing academic and vocational qualifications in the UK and worldwide. For almost two decades, Edexcel has been paving the path to success through learning. ⏱ Study Hours Allocate between 120 and 150 hours for study, in addition to the time required for assignments. 👩‍🏫 Study Method Our interactive online learning platform offers a vibrant learning experience with various media resources such as videos, quizzes, and engaging activities. If preferred, the learning materials can also be printed.  📆 Course Duration Enrolment is open now, with the course officially commencing on 01/09/21. Access to learning materials will be available from the course start date, and you will benefit from unlimited tutor support for a duration of two years. 📋 Assessment Enrol now for Summer 2022 examinations. You will be required to sit two standard IGCSE written exams: Written exam: 2 hours, 61.1% of IGCSE, 110 marks. Written exam: 1 hour 15 minutes, 38.9% of IGCSE, 70 marks. Exams include a variety of question formats such as multiple-choice, short answer, calculations, and extended open-response questions. We guarantee an exam space in one of our UK exam centres. Assignments form a crucial part of your course but do not contribute to your final grade. They prepare you for your final examinations. All exams must be taken in the same session.  👩‍🎓 Course Outcomes Upon successful completion of this distance learning course, you will be awarded an IGCSE in Biology by Edexcel. This syllabus is carefully selected as it is most suitable for distance learning. ℹ️ Additional Information Official Qualification Title - IGCSE Biology Difficulty - Level 2 Entry requirements - No formal prerequisites are required for this course, however, a good command of English language skills is recommended. Course Content: Living Organisms: Explore diverse living organisms, their common characteristics and unique traits. Structure and function in living organisms: Comprehend cellular structure, functions, and processes like diffusion, osmosis and active transport. Reproduction and inheritance: Understand the preservation and transmission of genetic information through sexual and asexual reproduction. Ecology and the environment: Discover the interconnectedness of organisms and their environments and human impacts like global warming and water pollution. Use of biological resources: Understand biological resources, impacts of deforestation, food production processes, and the role of genetic modification in agriculture.

Unlock Your Potential as a Learning & Skills Mentor with Our Level 4 Course This qualification is designed to equip candidates with the essential skills and knowledge needed for effective employment and career progression in the field of Learning. As a Learning & Skills Mentor, you will play a pivotal role in supporting individuals and groups to achieve their learning and development goals. Through this course, you will master the art of working within ethical and legal frameworks, ensuring the highest standards of mentoring practice while meeting the diverse needs of mentees in a collaborative and inclusive manner. Commit to your professional growth and embrace reflective practice within your sector, setting a new benchmark for excellence in mentoring. Learn about the Cavity Training Learning & Skills Mentor Course The purpose of the learning and skills mentor occupation is to support individuals and groups with their learning and development towards agreed goals. They will do this by working within ethical and legal frameworks to ensure a high standard of mentoring practice. They will work collaboratively with stakeholders to inclusively meet the individual needs of the mentee. They will be committed to their own professional development and reflective practice as a mentor and within their sector. Fees This course can be completed as an government funded apprenticeship, through Cavity Training, or as a privately funded course for £3500. You can either pay as a lump sum or alternatively, you can split into 12 instalments.   Entry requirements Whilst any entry requirements will be a matter for individual employers, a minimum of English & Maths GCSE are required. Structure Our candidates are trained to the highest standards and are fully supported to develop all of the knowledge, skills and behaviours required to be an outstanding Learning & Skills Mentor. Knowledge Our course is delivered via live training webinars with specialist tutors. Skills and Behaviours You will be appointed a designated Learning & Skills Tutor, who will coach you through your qualification and complete regular assessments with you to support you to complete your qualification. You will have weekly contact from your Tutor. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

To provide the knowledge and skills required to perform an internal audit of part of a Energy management system based on ISO 50001 and report on the effective implementation and maintenance of the management system in accordance with ISO 19011.

Psychology, the science of the mind, unveils how thought processes function, the reasons for our behaviours, and our learning methodologies. This GCSE Psychology course empowers you to comprehend yourself and others more effectively, providing a stellar kick-start for anyone intrigued by psychology at a higher level or simply keen on understanding how our minds function. 💡 GCSEs are esteemed qualifications across the UK, considered as the educational standard for school-leavers at 16. Discover different psychological schools and theories, explanations for diverse behaviours, and research techniques used in the discipline. Comprehensive course specifics can be found below.  This GCSE Psychology course, aligned with the most recent specifications, is designed to set you up for success. It provides a clear induction and structured assignments, aiding in the development of the necessary skills and knowledge for the exam. For UK students, a guaranteed exam centre access is included. GCSEs - qualifications that truly count. 🎖️ You will benefit from: A fresh, engaging course, aligned with the latest specification 📘 Fast track option for 2022 exams ⏭️ Access to our partnership exam centres, ensuring a guaranteed exam venue 🏢 Unlimited tutor support - we assist you in drafting a study plan and provide continuous support 🤝 Exam pass guarantee (we offer support until you clear the exam) 🎯 About the awarding body Awarding body: AQA Our course code: X808 Qualification code: 8182 AQA qualifications are globally recognised, highly esteemed by employers and universities, and a pathway for young people to advance to their future stages. AQA offers a range of qualifications including GCSEs, IGCSEs, and A-levels to cater to diverse abilities.  ⏱ Study Hours: Allocate between 120 to 150 hours for study, in addition to time for completing assignments. 👩‍🏫 Study Method: Our course is delivered via an online learning platform, engaging learners with dynamic resources. The materials can be printed if preferred. Learning resources span different media including videos, quizzes, and interactive activities. 🎥📝🧩 📆 Course Duration: Post-enrolment, up to two years are granted to study and sit your exams, with ongoing unlimited tutor support.  📋 Assessment: Enrol now for Summer 2022 exams. Completion of two GCSE standard written exams is required. A guaranteed exam space is provided in our exam centres across the UK. During your course, nine assignments and one introductory assignment are also to be completed. These provide a chance to submit work to your tutor for marking and feedback, helping gauge your progress. 👩‍🎓 Course Outcomes: Successful completion of this home learning course awards you a GCSE in Psychology, issued by AQA. The syllabus has been handpicked due to its suitability for distance learning. ℹ️ Additional Information: Difficulty - Level 2. There are no formal entry requirements; however, effective English reading and writing skills are recommended. Course Content: The course encompasses various fascinating modules including Memory, Perception, Development, Research Methods, Social Influence, Language, Thought & Communication, Brain and Neuropsychology, and Psychological Problems. 🧠🔬📚

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Solar Energy, Foresty and Agricultural Science bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Solar Energy, Foresty and Agricultural Science related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Solar Energy, Foresty and Agricultural Science bundle will help you build a solid foundation to become a proficient worker in the sector. This Solar Energy, Foresty and Agricultural Science Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : Solar Energy Course 02 : Sustainable Energy, Development and Environmental Impacts Course 03 : Oil and Gas Industry Course 04 : Petroleum Refining Demystified Course 05 : Online Course in Conservation Course 06 : Environment Management Course 07 : Environmental Health Course 08 : Environmental Law 2021 Course 09 : Meteorology Course 10 : Land Management Course 11 : Diploma in Water Treatment Course 12 : Forestry Course 13 : Agricultural Science Course 14 : Botany Course 15 : Wildlife Rescue and Rehabilitation Course 16 : Architectural Studies Course 17 : Cleaning: Disinfection, Waste Management and Chemical Safety Course 18 : COSHH (Control of Substances Hazardous to Health) - Awareness Course 19 : Spill Management Training Course 20 : Horticulture & Organic Gardening Course 21 : Homesteading Diploma Course 22 : Floristry Academy Diploma Course 23 : Arboriculture Course 24 : Marine Biology Course - Online Diploma Course 25: Garden Design Course 26: Reproduction in Flowering Plants Course 27: Kitchen Gardening Course 28: Mushroom Growing Course Course 29: Carbon Literacy Knowledge Course 30: Animal Science 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Learning Outcome This tailor-made Solar Energy, Foresty and Agricultural Science bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Solar Energy, Foresty and Agricultural Science Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Solar Energy, Foresty and Agricultural Science bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Solar Energy, Foresty and Agricultural Science Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Description: Skype for Business is a service by Microsoft that helps you to collaborate with anyone, anywhere at any time. This instant messaging collaborative tool is cost-effective and user-friendly. The Skype for Business Course will familiarise you with all the features of the tool. In the course, you will learn how to use Skype for business, the ways of setting location, managing contacts, setting alerts and alert sounds, the process of sending and receiving the instant message, etc. Finally, the course helps you to create audio and video calls, preparing business meetings, and creating the presentation for the conference, and the use of Skype notification area. Learning Outcomes: Discover how to open and close Skype for Business, also ways to sign in and out of your account Set your status on log in or while logged in, add personal notes and set location Manage your contacts by adding internal and external contacts, creating groups, move contacts within groups, add them to favourite groups, block certain contacts, use status and relationship view, and much more Manage alerts by disabling or changing alert sounds, setting up status change alerts, and configuring Do Not Disturb Utilize the instant messages (IM) services by sending and responding to them, using spellchecker, adding emoticons, changing the font and viewing conversation history Examine how to make an audio and video call, record audio or video calls, and change device settings Conduct business meetings using Skype meeting opting through Outlook, joining meetings, setting up impromptu meetings in Skype, and taking notes during a meeting with OneNote Show stakeholders your presentation by learning how to display a PowerPoint presentation, a whiteboard, share screens and programs, post polls and Q&A, send files to participants and share note through Microsoft OneNote Manage advanced settings by turning off all profile pictures, displaying Skype for Business window on top, using Microsoft Skype for Business Recording Manager, and stop Skype for Business from starting up automatically View Skype Notification Area icon, change presence status, sing in and out, and open and close the program Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Skype for Business Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Skype for Business Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Skype for Business Course The Basics 00:30:00 Setting Your Presence and Location 00:45:00 Managing Contacts, Part One 00:45:00 Managing Contacts, Part Two 00:30:00 Alerts and Alert Sounds 00:30:00 Sending and Receiving Instant Messages (IM) 00:30:00 Audio & Video Calls 00:45:00 Skype Meetings 00:30:00 Presenting with Skype for Business, Part One 00:45:00 Presenting with Skype for Business, Part Two 00:45:00 Advanced Settings 00:30:00 Using Skype for Business in the Notification Area 00:30:00 Mock Exam Mock Exam- Skype for Business Course 00:20:00 Final Exam Final Exam- Skype for Business Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00