52876 Courses in Nottingham delivered Online

Super Saver Offer! is Active; Save: £403! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique online training Course might help you get there! Expand your expertise with high-quality training - study the Robotics - Sensors online training and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this Robotics - Sensors training course in around 1 hour. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Robotics - Sensors course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this Robotics - Sensors course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Robotics - Sensors program. Learning Outcomes of Robotics - Sensors: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the Robotics - Sensors course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support ****Course Curriculum**** Here is the curriculum breakdown of Robotics - Sensors course: >> Robotics - Sensors << Section 1: Introduction and Getting Started This course module covers following topics: Unit 1: Introduction Unit 2: Instructor's Introduction Unit 3: Into the Sensors World Section 2: Temperature Sensors This course module covers following topics: Unit 1: Thermocouple Unit 2: Resistance Type Sensor Unit 3: Liquid Expansion and Vapour Pressure Sensors Unit 4: Bimetallic Types Unit 5: Glass Thermometer Section 3: Mechanical Pressure Transducers This course module covers following topics: Unit 1: Pressure Sensors Unit 2: Bourdon Tube Unit 3: Piston Type Unit 4: Capsules and Bellows Unit 5: Diaphragms Section 4: Electrical Pressure Transducers This course module covers following topics: Unit 1: Electrical Pressure Transducers Unit 2: Strain Gauge Types Unit 3: Piezo Electric Types Section 5: Speed Transducers This course module covers following topics: Unit 1: Optical Types Unit 2: Magnetic Pickups and Tachometers Section 6: Flow Meters This course module covers following topics: Unit 1: Positive Displacement Types Unit 2: Inferential Type Meters Unit 3: Tapered Plug Type Unit 4: Variable Area Types Section 7: Force Sensors This course module covers following topics: Unit 1: Force Sensors Section 8: Position Sensors This course module covers following topics: Unit 1: Resistive Type Unit 2: Optical Type Unit 3: Inductive Type Section 9: Depth Gauges This course module covers following topics: Unit 1: Depth Gauges Assessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Robotics - Sensors Course Right for You? Anyone interested in learning more about this subject should take this Robotics - Sensors course. This Course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The Robotics - Sensors program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path After completing this Robotics - Sensors Course, you are to start your career or begin the next phase of your career in this field. Our entire course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Overview This comprehensive course on Library and Information Science Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Library and Information Science Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Library and Information Science Course It is available to all students, of all academic backgrounds. Requirements Our Library and Information Science Courseis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path   Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 8 lectures • 02:27:00 total length •Module 01: Organisation Systems: 00:25:00 •Module 02: Ethics and Values in the Library Professions: 00:21:00 •Module 03: Library Networking: 00:17:00 •Module 04: Library as Infrastructure: 00:25:00 •Module 05: Finance and Budgeting: 00:17:00 •Module 06: Digital and Virtual Libraries: 00:19:00 •Module 07: Library Legislation: 00:23:00 •Assignment - Library and Information Science Course: 00:00:00

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included

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

Do you want to do business with online information items? DO you want to offer services like Udemy or Coursera? This course will guide you the techniques and procedures of making a successful information product. Course Description: Creating your online product does not take a month or year. This course will help you to make your online product quickly. If you want to make your first online product but do not know from where to start, this course will guide you. You can create many information products within 24 hours. The course will show you the paths of making information product quickly with an innovative idea. By the end of the course, you will learn the simple approaches to make eBooks, instructing programs, enrollment programs, video courses, online courses, articles, reports and much more. Course Highlights E-Book Product Creation Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed E-Book Product Creation Course into 8 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 6 hours, 45 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose E-Book Product Creation Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Business people, entrepreneurs who want to do business with the online information product. New online marketers. Individuals who want to do online business. E-Book Product Creation Course is CPD certified and IAO accredited. 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 backgrounds. Requirements Our E-Book Product Creation 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. How To Start To Write An Ebook 01:00:00 Creative Ways To Attract Buyers For Your Product 01:00:00 How To Effectively Draft The Table Of Content Of Your Book 01:00:00 Writing Content Yourself versus Outsourcing 01:00:00 Best Ways To Outsource 01:00:00 Who Should You Hire To Create Your Product 00:30:00 Benefits Of A Long Term Working Relationship With The People You Outsource To 01:00:00 Wrapping Up 00:15:00 Mock Exam Final Exam

Unleash the potential of your mind with this awe-inspiring journey into the realm of psychology. Embark on an exploration of the enigmatic human brain, the epicentre of our thoughts, emotions and behaviours. This comprehensive A-Level Psychology Course is your pathway to understanding the rapidly-evolving science of the mind, and its critical role in the functioning of our society. Discover diverse dimensions of psychology, and their intricate interconnections. Through the course, you will master transferable skills of analysis, evaluation, and critical thinking, arming you with a scientific understanding of the human psyche. Intrigued by the complexity of human behaviour? This course is your gateway to the intriguing world of psychology. A-Levels hold a coveted position in the UK education system, widely recognised by universities and employers as an emblem of significant accomplishment. Securing an A-Level not only demonstrates in-depth understanding of a subject but also enhances your career prospects and unlocks new opportunities. Crafted according to the latest specifications, our A-Level Psychology course ensures you are poised for success. With a well-structured curriculum, guided by clear instructions and engaging assignments, you'll acquire the knowledge and skills required for the examination. Key Features: 💡 Cutting-edge course content, crafted according to the latest specifications 🚀 Fast-track option available (for exams in 2022) 🎯 Access to a network of partner exam centres (guaranteed exam venue) 👩‍🏫 Unlimited tutor support – comprehensive study plan and constant support 🎯 Exam pass guarantee (Get our support until you clear the exam) Delve into the fascinating science of the mind. Unearth the intricate workings of the human brain, the organ that governs our every perception and sensation. Embark on a journey into the realm of […] About the awarding body Awarding body: AQA Our course code: X915 Qualification code: 7182 AQA qualifications are globally recognised and delivered in 30 countries, treasured by employers and universities, empowering learners to advance to the subsequent phase of their journey. The suite of AQA qualifications caters to a wide range of abilities, encompassing GCSEs, IGCSEs, and A-levels. ⏱ Study Hours: Allocate between 250 and 300 hours of study time, with additional time for completing assignments. 👩‍🏫 Study Method: The course is delivered via our dynamic online learning platform. Don't fret if you prefer hard copies, the learning materials can be printed. The resources are available in various formats including videos, quizzes, and interactive activities. 📆 Course Duration: Enjoy unlimited tutor support for up to 24 months from the date of enrolment. You will receive your logins to our MyOxbridge portal where your learning materials are accessible. 📋 Assessment: Enrolments are for exams in Summer 2022.  Complete the standard written exams, each lasting 2 hours and worth 33.3% of marks. We ensure a guaranteed exam space in one of our centres nationwide, eliminating the hassle of finding your own. Check your nearest exam centre. Throughout your course, tutor-marked assignments (TMAs) are required. These do not impact your final grade but provide a chance to receive marking and feedback from your tutor, helping gauge your progress. 👩‍🎓 Course Outcomes: Upon successful completion, you will receive an A-Level in Psychology, issued by AQA, identical to that issued to students at other schools, colleges or universities. This syllabus has been carefully selected as it is best suited to distance learning.  ℹ️ Additional Information: Difficulty - Level 3 Entry Requirements - A science GCSE or equivalent, preferably in biology, is highly recommended. You should also be at ease with dealing with numbers. UCAS Points - 56 Course Content: Immerse yourself in a rich tapestry of subjects, including Social Influence, Memory, Attachment, Psychopathology, Approaches in Psychology, and Biopsychology. You'll delve into topics like conformity, memory models, infant interactions, mental disorders, different learning approaches, and the central nervous system, offering a well-rounded understanding of the human mind and behaviour.

Description Explore the ways of combining various business opportunities to a cohesive successful multiple-business with the International Accredited Business Online Course course. The course teaches you the skills and strategies to put an online multi-business together. You will learn how to amalgamate diverse business opportunities to a successful and achievable 'Multi-business'. The methods of engaging your customers and the procedures of managing combined income streams will be explained in the course. Moreover, the course shows you the process of application and other formalities that you need to follow for running a multi-business without dropping balls and being overwhelmed by stress. Apart from these, the course will help you to find a profitable niche and guides you to set up your goals. The ways of producing multiple products and selling them into multiple platforms, monitoring l changes and progress, and the ways of tying up all the new income streams together into one manageable multi-business will be illustrated in the course. Finally, the system of building and promoting your multi-business using free and low costs tools will be explained. By the end of the course, you will gain a general understanding of the various structures of multiple income streams. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? International Accredited Business Online 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 International Accredited Business Online 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. Introduction Introduction to The Online Multi-Business Master Plan Course 00:03:00 Aims of this course 00:06:00 Course Structure 00:02:00 Online Business Models Online Business Models Overview 00:01:00 Business Models- Udemy 00:04:00 Business Models- Fiverr 00:04:00 Business Models- Amazon KDP 00:04:00 Business Models- Createspace 00:04:00 Business Models- Other Platforms 00:05:00 Your Multi-Business Website Your Multi-Business Website 00:04:00 Getting Started Create, Re-purpose, Repeat 00:04:00 Pick a Niche 00:12:00 Google Keyword Planner Overview 00:02:00 Pick a Platform 00:09:00 Plan, Plan & Test 00:03:00 Earn Your First Dollar 00:06:00 What if you fail- 00:02:00 Build your Systems 00:07:00 Automate and Outsource 00:03:00 Re-purpose and Repeat 00:08:00 Putting it all together 00:04:00 Promoting Your Multi-Business Promoting Your Multi-Business 00:06:00 The Complete Online Multi-Business Master Plan The Complete Online Multi-Business Master Plan 00:11:00 Essential Tools Paypal Overview 00:01:00 Fiverr Overview 00:03:00 MailChimp Overview 00:03:00 Conclusion Finally 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

🔬 Chemistry isn't just in the lab; it's all around us! From the medicines we take, the fuels that power our vehicles, to the food we eat, chemistry is at the heart of everything. Through our A-Level Chemistry Distance Learning Course, we bring this captivating science to your doorstep! Learn about elements on the Periodic Table, the creation of new compounds, and the profound interactions of chemistry with our world. This course equips you not only with a solid grounding in Chemistry but also develops critical skills such as data analysis, problem-solving, and creative thinking, making it an invaluable stepping-stone for careers in health, teaching, research, and beyond.  🎓 Our A-Level Chemistry course, respected in academic circles, aligns with the new AQA A-Level Chemistry syllabus and is structured for optimal online learning. With unlimited tutor support, well-structured assignments, and guaranteed exam centre access for UK students, we ensure a seamless learning experience. This flexible, self-paced course is enriched with dynamic and engaging content, alongside a network of partnership exam centres, and a promise to support you until you pass the exam.  📝 Enrol to reap benefits such as: - Engaging and up-to-date course content - Fast-track option available for 2022 exams - A dedicated study plan with constant support - An exam pass guarantee   About the awarding body Awarding body: AQA Our course code: X909 Qualification code: 7405 📜 The AQA qualifications we offer are internationally recognised, taught in 30+ countries, and highly valued by employers and universities. With an AQA A-Level in Chemistry, you open doors to an array of opportunities worldwide.  ⏱ Study Hours:  Plan for between 250-300 hours of study time, plus time for assignments. 👩‍🏫 Study Method:  Our course is delivered via our engaging online learning platform with a mix of videos, quizzes, and interactive activities. You can also opt to print the learning materials. 📆 Course Duration:  The course spans up to 24 months from enrolment, accessible via our MyOxbridge portal. 📋 Assessment: Enrol now for exams from Summer 2022. There will be three standard A-Level written exams. We provide a guaranteed exam space in one of our UK exam centres, alongside an exam pass guarantee.  Three standard A-Level written exams form the core of the assessment: - Paper 1: 2 hours, 35% of A-Level, 105 marks. - Paper 2: 2 hours, 35% of A-Level, 105 marks. - Paper 3: 2 hours, 30% of A-Level, 90 marks. These exams mix short and long answer questions and extended response questions. We provide a guaranteed exam space in one of our UK centres, and if you don't pass at the first attempt, our exam pass guarantee offers you free support until you succeed. You'll also complete various assignments throughout the course for feedback from your tutor. 🔬 Practical Endorsements: If your university course or career path requires it, you may need to complete a practical endorsement as part of your qualification. We can arrange this through our examination partners, Tutors & Exams. Unravel the magic of Chemistry at your own pace and convenience with Oxbridge. Enrol today to get started on your scientific journey! 🚀 👩‍🎓 Course Outcomes: Upon successful completion, you receive an AQA-issued A-Level in Chemistry, identical to that received by on-campus students. ℹ️ Additional Information: Difficulty: Level 3 Entry requirements: GCSE Science (double award) or GCSE Chemistry (min grade 4) and GCSE Maths (or equivalent) UCAS Points: 56 Course Content includes Atomic Structure, Chemical Reactions, Energy Changes, Equilibria, Electrochemical Cells, Inorganic Chemistry, and more.  🔍 Course Details: Our curriculum is carefully curated to give you a comprehensive understanding of chemistry and its various facets: 1. Structure of the Atom and Bonding: Start your journey by learning about the evolution of atomic structure, supported by evidence from advances in science and technology. 2. Chemical Reactions and Calculations: Understand key terms like relative atomic mass and relative molecular mass and discover the importance of the mole in measuring amounts of substances. 3. Rate of Reaction and Energy Changes in Chemical Reactions: Delve into the collision theory and how changes in conditions can impact the speed of a chemical reaction. 4. Chemical Reactions in Equilibria: Learn about the factors influencing reaction progression, and how Le Chatelier’s principle can be used to predict the effects of changes in conditions. 5. Redox Reactions and Electrochemical Cells: Explore the changes during redox reactions, deduce whether oxidation or reduction has occurred, and construct half-equations for these processes. 6. Inorganic Chemistry: Uncover how elements are classified based on their position in the periodic table and understand trends in atomic radius. 7. Inorganic Chemistry Part One: Familiarise yourself with the IUPAC system for naming organic compounds, their reactions, and different types of isomerism. 8. Inorganic Chemistry Part Two: Finish with a comprehensive look at optical isomerism, aldehydes, ketones, carboxylic acids, aromatic chemistry, amines, polymers, amino acids, organic synthesis, and chromatography.

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

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