2666 Code courses in Leicester delivered Online

English Proficiency Adventure (Intermediate Level)

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

Step into innovation and technology with our groundbreaking course, 'Arduino Interfacing with Sensors in Your Smartphone.' Embark on a journey where creativity meets functionality as you harness the power of Arduino to connect sensors to your smartphone seamlessly. From the thrill of setting up your hardware and software to crafting custom Android apps without coding, this course promises to unlock endless possibilities in mobile technology. Discover the essential components needed to kickstart your Arduino adventure, from hardware requirements to navigating the intricacies of MIT App Inventor. Dive deep into the realms of mobile app development as you explore the Designer and Blocks Editor, laying the foundation for your foray into creating intuitive mobile apps. With our guidance, even those with zero coding experience can craft innovative applications that effortlessly bridge the gap between Arduino and smartphones. Unlock the potential of sensors as you delve into the world of proximity, accelerometer, gyroscope, and magnetometer sensors. Learn how to read analogue sensor data with Arduino and translate it into interactive mobile experiences. Whether you're a budding technologist, a hobbyist seeking to expand your skills, or an entrepreneur with a vision for innovative mobile solutions, this course equips you with the tools and knowledge to turn your ideas into reality. Learning Outcomes: Understand the hardware and software requirements for interfacing Arduino with smartphones. Master MIT App Inventor to design and develop custom Android apps for Arduino projects. Explore various sensors, including proximity, accelerometer, gyroscope, and magnetometer. Learn to create mobile apps without coding, integrating Arduino seamlessly. Gain proficiency in reading analogue sensor data and controlling Arduino remotely via smartphones. Highlights of the Arduino Interfacing with Sensors in Your Smartphone : Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Arduino Interfacing with Sensors in Your Smartphone Course for? Tech enthusiasts eager to explore Arduino and smartphone integration. Hobbyists looking to expand their knowledge in mobile app development. Entrepreneurs seeking to develop innovative mobile solutions. Students interested in learning about sensor interfacing and mobile technology. Engineers and developers aiming to enhance their skills in IoT and mobile connectivity. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Requirements The Arduino Interfacing with Sensors in Your Smartphone is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Mobile App Developer: £25,000 - £70,000 per annum IoT Engineer: £30,000 - £65,000 per annum Software Engineer: £25,000 - £70,000 per annum Electronics Engineer: £25,000 - £55,000 per annum Embedded Systems Developer: £30,000 - £70,000 per annum Technology Consultant: £35,000 - £80,000 per annum Course Curriculum Introduction and Getting Started Introduction 00:03:00 Hardware and Software Requirements Hardware and Software Requirements 00:02:00 Download and Install MIT App Inventor 00:10:00 Download and Install Arduino Pro IDE 00:09:00 Setting Up App Inventor What is App Inventor 00:02:00 Designer and Blocks Editor MIT App Inventor User Interface Explained 00:04:00 First Mobile App to Control Arduino Make your first Mobile App - Blink LED 00:15:00 Code your Arduino - Blink LED 00:05:00 Proximity Sensor Proximity Sensor Mobile App 00:14:00 Light Sensor Mobile App and Arduino Code 00:13:00 Practical Testing 00:03:00 Accelerometer Sensor Accelerometer Sensor Mobile App 00:14:00 Coding Accelerometer Sensor 00:05:00 Gyroscope Sensor Gyroscope Sensor Mobile App and Arduino Code 00:06:00 Magnetometer Sensor Magnetometer Sensor Mobile App and Arduino Code 00:05:00 Make Android App With Zero Experience MIT App Inventor Introduction uuuu 00:03:00 What can you do and system requirements 00:03:00 What is app inventor in More Details 00:02:00 Java Vs App Inventor 00:03:00 Why using App Inventor 00:01:00 App Architecture 00:05:00 Let's Start Making Apps 00:05:00 First App Add Items and Start Programming with Blocks 00:10:00 First App Testing and Running the App using Emulator 00:13:00 Resources you need to visit to Create Better Apps 00:02:00 How to Create a website for your app for free and take credit for it 00:05:00 Android Apps for Arduino with MIT App Inventor without Coding Introduction 00:03:00 App Inventor Overview 00:04:00 An App Challenge 00:01:00 System Requirements 00:01:00 AppInventor Vs Java and C 00:03:00 Why App Inventor Works 00:02:00 App Architecture 00:05:00 Download and Install App Inventor on Your Device 00:09:00 AppInventor UserInterface With Example 00:14:00 Arduino Coding for Led On Off Practical Example 00:09:00 Making an Android App for Led On Off Practical Example 00:12:00 Testing On Off App with Arduino 00:07:00 Make a Login Protected Led Control App 00:14:00 Slider Application to Control Led Brightness 00:15:00 Slider Practical 00:09:00 Practical Connect Bluetooth Module 00:05:00 RGB Led Controller Android Application 00:14:00 RGB LED Arduino Coding 00:12:00 Sensor Readings Arduino Coding 00:09:00 Sensor Readings Android Application 00:17:00 LCD Text Arduino Coding 00:09:00 LCD Text Android Application 00:06:00 Remote Controlled Robot Android Application 00:09:00 Remote Controlled Robot Arduino Coding 00:15:00 Make Money with MIT App Inventor Apps 00:05:00 Reading Analog Sensor with Arduino Introduction 00:02:00 How to read analogue sensors using Arduino 00:02:00 Software Requirements 00:04:00 Wiring Analog Sensors to Arduino 00:09:00 Writing code to collect reading from analogue sensors 00:07:00 Practical Analogue Sensor Testing 00:03:00 Analyse and convert Sensor Reading 00:03:00 Manipulating Sensors Reading 00:06:00 ADC in Arduino Explained 00:14:00

Embark on a literary adventure with the A-Level English Literature distance learning programme, crafted to nurture you as a discerning, self-reliant reader. Delve into an extensive assortment of literary works spanning various centuries, cultivating an ability to scrutinise closely and assess diverse critical perspectives. You'll acquire the knack of articulating well-informed, independent views based on robust evidence. Furthermore, you'll master weaving critical standpoints into your essays to bolster and cultivate your arguments. An A-Level in English Literature lays a solid foundation for any field demanding superior written communication, research, and analytical prowess. This qualification can pave your way into various careers including Journalism, Teaching, Law, Academia, Media, Advertising, Marketing, Politics, and the Performing Arts. A-Levels, the educational hallmark of the UK, are esteemed by universities and employers alike as an emblem of substantial accomplishment. Harness the power of the English Language to inspire, motivate, and challenge yourself in a myriad of ways. Possessing an A-Level symbolises an in-depth comprehension of a subject, enhancing your career prospects and presenting new opportunities. Designed in line with the latest specifications, this A-Level English Literature course is poised to provide you the best shot at success. With our comprehensive resources at your disposal, including a clear induction and well-structured assignments, you'll be adeptly prepared for the exam. Benefits you'll enjoy: An innovative course, devised according to the latest specification featuring captivating and interactive content Option for fast track available for this course (exams in 2022) A complimentary e-textbook to facilitate your learning Access to a network of partner exam centres (guaranteed exam venue) Unlimited tutor support – aiding in crafting a study plan and offering unwavering support throughout Exam pass assurance (In case of initial failure, we’ll support you until your subsequent exam) A-level English Literature will stimulate your reading habits, promoting a critical approach and fostering an understanding of analysing a variety of critical viewpoints. Awarding Body Details: Awarding body: AQA Our course code: X902 Qualification code: 7712A AQA qualifications, recognised and taught across 30 countries globally, are esteemed by employers and universities, enabling learners to progress to their subsequent life stage. AQA qualifications cater to a variety of abilities, encompassing GCSEs, IGCSEs, and A-levels. ⏰ Estimated Study Time Allocate between 200 and 300 hours for studying, plus extra time for assignment completion. 🌐 Learning Methodology Our innovative online learning platform delivers this course, offering an interactive and engaging experience. For those inclined, printable learning materials are available. Learning resources incorporate diverse media, including videos, quizzes, and interactive activities. 🗓️ Course Duration Commence your learning journey by enrolling today, and enjoy unlimited tutor support for up to 24 months from enrolment. 📝 Assessment Method All current enrolments are for Summer 2022 exams. Official Exams: Complete two standard written exams: 3-hour exam, 40% of marks 2-hour 30-minute exam, 40% of marks One coursework task, 20% of marks (See NEA below) We offer a guaranteed exam spot in one of our nationwide exam centres, eliminating the need for you to find one. Assignments: Throughout your course, you'll need to complete: - One introductory assignment - Ten assignments Though not contributing to your final grade, these provide an opportunity to submit work to your tutor for marking and feedback, helping gauge your progress. Non-Exam Assessment (NEA): - One coursework task, 20% of marks The A-Level assessment for the new specification includes a non-exam assessment (NEA). This coursework is completed during your learning and sent to your exam centre for marking. Further details provided upon enrolment. 🎓 Course Outcomes Upon successful completion, receive an A-Level in English Literature, issued by AQA. This syllabus (7712A) is specifically chosen for its suitability to distance learning. Your certificate is indistinguishable from those issued to students in any other academic setting. ℹ️ Additional Information Difficulty Level - 3 Entry Requirements - We strongly recommend prior study of English literature to GCSE or equivalent level. UCAS Points - 56 _________ Course Content 1. Love through the ages: Shakespeare's Othello 2. Love through the ages: Poetry - Anthology (Pre 1900) 3. Love through the ages: Prose - The Great Gatsby 4. Love through the ages: Unseen poems 5. Texts in shared contexts: Drama - A Streetcar Named Desire 6. Texts in shared contexts: Prose - The Handmaid's Tale 7. Texts in shared contexts: Poem - Skirrid Hill (Post-2000) 8. Texts in shared contexts: Unseen prose extract 9. Independent critical study The course covers various themes and literary works, exploring 'Love through the ages' with works like 'Othello' and 'The Great Gatsby', and 'Texts in shared contexts' like 'A Streetcar Named Desire' and 'The Handmaid's Tale'. The course also includes an 'Independent critical study' unit to develop research skills and analytical thinking. Course Content Methods of language analysisPhonetics, phonology and prosodicsGraphologyLexis and semanticsGrammar, including morphologyPragmaticsDiscourse Textual variations and representationsThe textual range (various subjects, writers, audiences)Functions of the textsIdentity and representationsHow audiences are addressed and positionedStructure and organisation of the texts Children’s language developmentPhonological, pragmatic, lexical, semantic and grammatical developmentThe development of written languageThe functions of children’s languageTheories and research about language development Diversity and changeLanguage in its wider social, geographical and temporal contextsProcesses of language changeSocial attitudes to language diversity and change Language discoursesStudying texts that convey attitudes to language diversity and changeMethods of conveying views and opinions about language issues: representations, identities and positioning.Connecting to discourses about languageThe directed writing task Language Investigation (NEA)Choosing an investigation focusCarrying out the investigation (including ethics, record keeping and referencing)Organising and analysing the data and interpretation of findingsConcluding your investigation Original writing (NEA)An overview of the assessment and marking criteria, including organising and referencing workChoosing your area of original writing (Power of persuasion, storytelling & power of information)Choosing and analysing style modelsProducing a reflective commentary Preparing for the A Level examinationsRevision TipsExam TechniquesPreparing for Paper 1Preparing for Paper 2

About this Training Course In turbulent times for the entire Energy Sector, Oil & Gas E & P segments are coming under tremendous pressure to reinvigorate. Oil Majors like Shell Plc are no longer termed as Oil & Gas Company but also branded as SHELL Energy, with technology at its forefront. The Risks, Scope and Context of Engineering, Procurement, Construction, Installation and Commissioning (EPCIC) Projects is evolving rapidly. Thus, the success of a project is dependent on the practical 'know how' in scoping, contract drafting, negotiation and execution competencies. Understanding the essential ingredients of contracts and mastering the international contracting principles will equip the participants to identify vague and ambiguous clauses, avoid dangerous and often hidden terms, and better understand the controlling position in a project. In this 3 full-day course, the participants will find out how to negotiate legacy contracts where parties are not allowed to edit any clauses during the bidding process. The participants will learn from the Case Law Reports and analysis to take home lessons learned from bitter experiences of their peers in the industry. It is designed to help those who need a solution to manage current contractual issues or those who execute contracts regularly and want to be more proficient in managing their contracts and projects, with changing contexts. The course is developed with the underlying objectives for the participants to: Enhance their current knowledge of the legal principles governing international Contracts from formation, execution to breaches, redresses and dispute resolution either as a party or as a consortium member or as a coverture. Manage Consortium and Joint Venture Partners inter-relationship and contractual responsibilities. Identify dangerous exposures due to joint and severally liable requirements of consortium-based contracts. Effectively Manage Risks of Projects, with Enforceable Contract Documents, by learning the purpose and potential benefits of maintaining evidence in compliance to the contract clauses. Learn the Contract Enforcement Nuggets of Owners and the Variation Claims Strategies of the Contractors. Allocation of contract management related roles / assignments and WBS within consortium partners for effective project management and profitable results. Use of Contract Terms & Conditions for enhancing project performance, monitoring, reporting, and achieving timely completion, thereby avoiding delays and disputes. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completion of the course, the participants will have learnt: Project management strictly in accordance with the contract and the corporate strategies. How to ensure that Variations Order claims are appropriately managed in turnkey and lump-sum contracts. Manage contemporary challenges and market factors with direct or indirect impact on the contracts. Managing all members of the Supply Chain from vendors to logistics services providers. Cost Engineering and Performance Management. How to manage Consortium Partners, Contractors, and Owner's representatives. When and how to obtain / grant extension of time (EOT) and costs. Ability to identify rights and obligations of each party to a contract instead of making subjective decisions. Ability to be firm in negotiations without violating terms of the agreements. Ability to spot different legal systems, contract laws and arbitration rules. Ability to negotiate and avoidance of disputes and resolution in amicable manner, in accordance with the provisions of the contract. Competency in developing and maintaining documentary evidence and traceability for all works executed during the project. Target Audience This course is specially curated for professionals from International Oil & Gas Industries including Offshore & Marine Sectors. They include the heads of strategic business units, contracts managers, project directors, project managers, general managers, corporate legal counsels, procurements and supply chain managers, lawyers and legal professionals engaged in the EPCIC Segments of the Oil & Gas Industry.   Course Level Intermediate Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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

About this training course This 5 full-day course will cover all aspects of steam turbines including design and features of modern turbines, material, rotor balancing, features enhancing the reliability and maintainability of steam turbines, rotor dynamic analysis, Campbell, Goodman and SAFE diagrams, Blade failures: causes and solutions, maintenance and overhaul of steam turbines, and modeling of steam turbines. This course will also cover in detail all the components of these turbines, instrumentation, control systems, governing systems, and selection criteria. The main focus of this course will be on the failure modes of steam turbine components, causes and solutions for component failure, maintenance, refurbishment and overhaul, rotor dynamic analysis of steam turbines, and computer simulation of steam turbine rotor dynamics. All possible failure modes of steam turbine components and the maintenance required to prevent them will be discussed in detail. Examples of rotor dynamic analysis, and stability criteria will be covered thoroughly. This course will also provide up-dated information in respect to all the methods used to enhance the availability, reliability, and maintainability of steam turbines, increase the efficiency and longevity of steam turbines, and improve the rotor dynamic stability. This course will also cover in detail all steam turbine valves, jacking oil system, turning gear, turbine supervisory system, steam turbine monitoring technology, validation, and verification tests, performance testing of steam turbines and steam turbine codes especially ASME PTC6. Training Objectives Steam Turbine Components and Systems: Learn about all components and systems of the various types of steam turbines such as: stationary and rotating blades, casings, rotor, seals, bearings, and lubrication systems Steam Turbine Failure Modes, Inspection, Diagnostic Testing, and Maintenance: Understand all the failure modes of steam turbine components, causes and solutions of steam turbine component failure, inspection, diagnostic testing, and all maintenance activities required for steam turbines to minimize their operating cost and maximize their efficiency, reliability, and longevity. Steam Turbine Instrumentation and Control Systems: Learn about the latest instrumentation, control systems, and governing systems of steam turbines Steam Turbine Reliability and Maintainability: Increase your knowledge about all the methods used to enhance the reliability and maintainability of steam turbines as well as the predictive and preventive maintenance required for steam turbines Steam Turbine Selection and Applications: Gain a detailed understanding of the selection considerations and applications of steam turbines in steam power plants, co-generation, combined-cycle plants, and drivers for compressors pumps, etc Steam Turbine Valves, Load-Frequency Control, Turbine Bypass Systems, and Steam Turbine Superheater Attemperators: Gain a thorough understanding of all steam turbine valves, load-frequency control, turbine bypass systems, and steam turbine superheater attemperators Jacking Oil System and Turning Gear: Learn about the turbine jacking oil system and turning gear operation Turbine Supervisory System: Gain a thorough understanding of the turbine supervisory system Steam Turbine Monitoring Technology, Validation, and Verification Tests for Power Plants: Learn about steam turbine monitoring technology, validation, and verification tests for power plants Steam Turbine Codes: Learn about steam turbine codes including ASME PTC6, DIN Test Code, and International Electrotechnical Commission (IEC) Doc 1, IEC Doc B Steam Turbine Rotor Dynamic Analysis, Campbell, Goodman, and SAFE Diagrams: Gain a thorough understanding of steam turbine rotor dynamic analysis, Campbell, Goodman, and SAFE diagrams Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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 to their own organization. Each delegate will receive a copy of the following materials written by the instructor: Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) STEAM TURBINE TECHNOLOGY MANUAL (includes practical information about steam turbines maintenance, testing, and refurbishment - 500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

This training is aimed at developing Person Centred Planning – for Local Authority, School or Multi Academy Trust professional teams. Parents and carers can also participate in this training. One day introduction to underlying values and practicalities of approach in schools – 100 people 2 Day skill training for 30 participants to learn PATH planning skills 1 day follow up after 3 months to problem solve issues and celebrate what achieved. Person Centred Planning (PCP) is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most commonly used person centred tool with children is a PATH – and it shows these values in action. Why now? The Children and Families Act 2014 sets out clear principles for supporting and involving children and young people in all aspects of the support and planning of their special educational need. The Special Educational Needs and Disability Code of Practice: 0 – 25 years provides the statutory guidance relating to part 3 of the Children and Families Act 2014. Embedded in its principles is the need for a stronger focus on the participation of children, young people and their parents/carers in decision making at both individual and strategic levels. The use of Person Centred Approaches provides the opportunity to fulfil those principles. Working in this way ensures the CYP and their parents/carers are at the centre of all decision making and future planning. It provides an opportunity to engage directly with children and young people to discuss their needs, and plan how they can achieve the best possible outcomes. This should be integral to all planning for children and young people with Special Educational Need and Disability (SEND) throughout their lives. Education Health Care Planning processes are required to be truly person centred at every stage, including annual reviews, so understanding this way of working has never been more essential. Is this different to what we do already? This person-centred way of working offers a radical new approach to visualising planning, empowering and directly involving children and those that care about them throughout planning meetings and allowing for inclusive, creative methodology which builds on and challenges existing practice in schools. Core principles The focus of inclusive, person-centred working is first and foremost on ordinary needs and not solely on special needs. – Being somebody – Contributing by sharing gifts and capacities – Knowing people and having relationships – Having choice and control – Sharing ordinary places – being present in local spaces and having a valued role there The training is delivered by Inclusive Solutions who are Educational Psychologists with a national reputation for training and person centred planning with schools over the last 16 years. In this training, you will learn how to facilitate with a child, family, team or an organisation to think together around their preferred future or about a challenge or issue. Here is an opportunity to experience first-hand the person centred, futures planning tool – PATH (Pearpoint, Forest et. al. 1989). This course will provide participants with a practical introduction to person centred planning and approaches, including examples of best practice in using person centred approaches in schools. The course will explore the underlying values of person centred approaches, provide an introduction to the person centred planning tools and link this to national policy and guidance. Participants will gain: 1 Knowledge of person centred planning and approaches 2 An understanding of how person centred approaches can be used in schools 3 A basic knowledge of the person centred review process and where to find out more information 4 The skills to gather information about what is important to and for the children and young people they support 5 An understanding of PATH and situations in which this process could be used in school The course answers these questions: • What are person centred approaches? • How can we use person centred approaches in our school? • What is person centred thinking and how can it be used in schools? • How can we learn about what is important to and for the child or young person and share this information? • How can we make sure that the child is at the centre of their annual/transition review?

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

QLS endorsed Qualification | Fully Online Course | Tutor Support | Well Planed Study Materials

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing