• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

399 Educators providing Operator courses delivered Online

IIL Europe Ltd

iil europe ltd

London

At IIL, our fundamental values of Intelligence, Integrity, and Innovation guide our actions and achievements with each customer, partner, and colleague. Our deepest purpose is to foster the growth and success of individuals, teams, and organizations through enduring relationships and top-notch learning content delivered through various methods. Explore our learning categories: NEW Generative Artificial Intelligence Agile and Scrum Business Analysis Business Relationship Management Cybersecurity IT Management Lean Six Sigma Microsoft Project Project, Program and Portfolio Management INNOVATION IN PROFESSIONAL DEVELOPMENT & TRAINING IIL offers a wide variety of delivery methods to ensure an optimal learning experience. Using its proprietary Many Methods of Learning™, IIL delivers innovative, effective and consistent training solutions through a variety of learning approaches: * In-Person Classroom Courses * Self-Paced On-Demand Training * Live Virtual Classes * Simulations * Free Videos & Webinars * Mobile IIL ACCREDITING BODIES AND PARTNERSHIPS IIL is a PMI® Charter Global Registered Education Provider and member of PMI’s Global Executive Council as well as a Microsoft Partner (with a Microsoft Gold Project and Portfolio Management competency), IIL is also an Accredited Training Partner for: * PRINCE2 * ITIL * Association for Project Management (APM) * PeopleCert on behalf of AXELOS * IASSC Accredited Training Organization® * The American Council on Education (ACE), an APMG International Accredited Training Organization (ATO) * Scrum Alliance REA organization * Authorized CEU Sponsor Member of the International Association for Continuing Education and Training (IACET). * IIBA® Endorsed Education Provider. IIL is the training solution partner of choice for many top global companies.  * Women’s Business Enterprise National Council (WBENC) corporate member.

Oxford Open College

oxford open college

Sheffield

Oxford Open College childcare courses are available “long distance and online” through our virtual campus. We work closely with providers to help successful trainees acquire continued employment. Oxford Open College is accredited by CPD (Continued Professional Development), the specialist awarding body for people working in various fields and want to attain continued development and we have a specialist department working in the early years industry. Achieving a qualification in Early Years is a great way for existing and new childcare practitioners to become qualified or for existing workers to gain further knowledge for use in their jobs. We encourage enquirers to browse through our childcare course to find the perfect support we offer. CONTEXT AND PERSPECTIVE Oxford Open College has a concept that : Children brought up well are most likely to be successful as adults. This is only possible where government, parents and childcare providers work together: At one time whole families with their children used to work long hours to earn the bare minimum to have something to eat in England, “a poor Law Amendment Act 1834” was done; this resulted in governments of the day setting up “clubs of workhouses” in which the paupers were to live…. In a way this was as if guaranteeing them an even more miserable time; here widows and orphans lived. The work reform Act decided that children under nine years old should not work, strangely the Law makers seemed oblivious to the reality that children were not working for fun, but survival due to poverty……..surely Childcare has come a long way. Oxford Open College is Giving new ideas to the learner/practitioner of how best to present material; the Course is implementation of good practice; sharing knowledge and experience: Therefore, this book only offers guidance, ideas; pointers of the best responses to commonly asked topical questions in the UK, NVQ Level 3 Diploma in Childcare. The suggested responses are exhaustive. The selected topics are based on real units and questions or tasks. Oxford Open College have used personal experience in “practicing Childcare settings:” This experience is what has been used to address most of the topics, questions; drawing from real life situations of safeguarding and caring for Children. The Course text book is written in the first person context I or in My setting so that the upgrading or aspiring practitioner can put themselves in the context of what is happening in their own situation or setting in order to draw parallels and learn by inclusion and participation of shared experience and good practice towards safeguarding, playing with and development of; Children. Oxford Open College provides aspiring practitioners with a preamble in form of a model self-evaluation of a childcare setting, to help practitioners evaluate own provisions. Oxford Open College recognises that there are key factors of how to deal with different situations and a summary of headings of usable policies that can be developed by a starting practitioner. Oxford Open College ensures that the course will include “Advice” for practitioners and learners to deal with various situations such as learning differences, bullying and keeping an outstanding setting. Oxford Open College has designed a childcare course so that in its recess the learning offers learners and practitioners an adaptable handbook to be used by any setting. Oxford Open College Gives learners and practitioners an overview of United Kingdom’s based study method of the English Early Years Framework. Why study Early Years with Oxford Open College? You’ll be studying courses designed and created by practitioners and trainers , Childhood, Youth and inclusion play. Oxford Open College offers a ground-breaking curriculum, inspiring and engaging teaching methods, and supports childcare research that looks to influence Childcare practices, policies and debate – both in UK; nationally and internationally. The benefits of studying an early years qualification with Oxford Open college are: Oxford Open College believes that your study will be professionally and vocationally relevant across many contexts. You’ll become equipped with the knowledge and experience to make a real difference in this field. You’ll be studying with a university that has 50 years’ experience as pioneers of social justice and social change. You can fit our flexible study around your work and other commitments. Oxford Open college equips individuals with tools to develop Careers in Early Years. An early years qualification – for example, gives you understanding in childhood and youth studies or early childhood which can open up a range of careers, including: childcare, counselling, early years work, youth and community work, and local, national and international policy development. Oxford Open College courses in early years can help you start or progress your career as a: Self employed business operator of a nursery Teacher Teaching assistant Counsellor Education Welfare Officer Family Support Worker Special education needs coordinator (SENCO).

Online Training Academy

online training academy

About Us Welcome to Training Academy, where learning meets excellence! We are not just a platform; we are your dedicated partner in the knowledge and skill enhancement journey. Our courses are crafted and delivered by industry experts and seasoned educators. You're not just learning; you're gaining insights from the best in the field, ensuring a world-class education at your fingertips. From cutting-edge technologies to timeless skills, we curate content that empowers you to stay ahead in a rapidly evolving world. Join us at Training Academy – where the next generation of learning unfolds. Empower yourself, unlock your potential, and embrace a learning experience like never before. Why Choose Online Training Academy? At Training Academy, we take pride in being the premier destination for online learning, and here's why we stand out from the rest: We understand that life is chaotic, and so is learning. With unlimited access to our courses, students can tailor their learning experience to their own pace and schedule. At Training Academy, education bends to fit your life, not the other way around. Education is dynamic, and so are we. We are committed to continuous improvement, regularly updating our platform with new features, courses, and tools to keep you engaged and motivated. Our Mission Empowering individuals to achieve their full potential through accessible and quality education is our mission's core. Education is the key to personal and professional growth, and we are dedicated to providing the best tools and resources to facilitate that growth. Join Training Academy today and discover the limitless possibilities that education can offer. Your success story starts here!

Charmaine James

charmaine james

London

About Charmayne James  2019 www.charmaynejames.com. All rights reserved Web Design by Frank Turben - Computer HelpCHARMAYNE’S BEGINNINGCharmayne came by her horsemanship talents naturally. Her dad, who always had an eye for good horses, worked as a feedlot cowboy before becoming an owner and operator of cattle feeding, ranching and farming interests in Clayton, New Mexico. Her grandfather was a cowman and steer roper. Her great-grandfather was a Choctaw Indian Light Horseman. Her mother was a rodeo queen who also barrel raced and team roped. Her grandmother was a World War I nurse who returned home and broke horses on the family’s dude ranch.Charmayne grew up at her dad’s feedlot in Clayton. She took ballet and piano lessons, but her favorite activity was riding. Attending schools in Clayton, she was an honor roll student and excelled in art, basketball and track, but was always anxious to get home from school to ride.Charmayne learned to ride bareback on an old cowpony called Redbug, and was always trying to keep up with her older sisters who had begun running barrels. As a member of 4-H, her projects included steers and horses. At age 10 her horse Creamer was named Grand Champion Gelding at the Union County Fair. She had trained Creamer to run barrels and that year won her first All Around Cowgirl title riding Creamer, a borrowed rope horse, and her sister’s pole bending horse.Charmayne and Creamer receiving awards for Grand Champion Gelding at the Union County FairKnowing her horse Creamer was not fast enough to win bigger barrel races, Charmayne wanted another horse. Her sister’s barrel horse, Bardo Deck was for sale, so her Dad bought him and turned the high strung former California race horse over to Charmayne. After a couple months of constant riding alongside the feedlot cowboys working cattle, chasing antelope across the vast grasslands, and many trips around the barrels, Charmayne and Bardo were winning nearly every area barrel race they entered.Late in 1981 Bardo broke his leg in a tragic accident and had to be euthanized. Charmayne was heartbroken. That winter she buried herself in school activities while telling her parents she had to get another horse. In the spring of 1982, after taking Charmayne to look at horses throughout the 5 State area, her dad, partly out of desperation, told Charmayne he liked a little bay horse down in the feedyard horse pens that was for sale. Charmayne countered that she had to have a race horse, but agreed to try the little bay. Before Charmayne got on him, her Dad told her not to kick him out at first because he was known to buck. Charmayne got on and after a few bucks she circled back and put him around the barrels. The two were an instant match. Charmayne paid $1200 for him with the rodeo winnings she had saved while riding Bardo. Her Dad said that was way too much money. They named him “Scamper” because of the way he scampered around the barrels.Scamper had never seen a barrel, but had an excellent handle on him from all the feedyard riding. In the spring of 1982, after two weeks of training on barrels, Charmayne and Scamper won their first barrel race. That summer they won numerous barrel races and amateur rodeos in New Mexico, Colorado, Texas, Oklahoma and Kansas. That fall Scamper was kicked in the hock by another horse. Their vet recommended turning him out for six months with a 50-50 chance he would come back sound.In April of 1983, when Scamper was 7, Charmayne began riding him again. At a vet checkup, after seeing Scamper’s ringbone, splints, and enlarged hock, Charmayne was told she had better get another horse going because Scamper “was not going to last”. By that summer she was winning amateur rodeos, sometimes by a full second. After entering with a WPRA permit, and winning the barrel race at the PRCA Dodge City Roundup Rodeo, Charmayne told her parents she wanted to start going to professional rodeos. They told her that was alright with them, but she would have to pay all her own rodeo expenses. When her dad asked her if she was going to try to make the National Finals Rodeo, she replied “No, I’m going to win the NFR”. She purchased her WPRA card later that year and began her professional rodeo career. This began one of the most amazing rodeo careers in history.In 1994, after winning an unprecedented 10 World Championships, 6 National Finals Rodeo Championships, and over $1,000,000 in arena winnings, Charmayne retired Scamper. Her ability to care for Scamper and keep him running at the top of his game for over 10 years attests to her knowledge and talents. This was a phenomenal feat for the horse that “was not going to last”.After retiring Scamper, Charmayne continued to achieve the eluding and difficult accomplishment of qualifying for the next 6 straight National Finals Rodeos with several different horses. In 2000 she qualified for the National Finals Rodeo and was Reserve World Champion with Cruiser, a former race horse she had purchased for $2,000 at New Mexico’s Clovis Livestock Auction and trained to run barrels. In 2002 she qualified for her 19th consecutive National Finals Rodeo riding Cruiser, winning her 7th National Finals Rodeo and 11th World Championship Title.

Moderntronics

moderntronics

Harrow,

In these terms and conditions (“Conditions”) the following expressions shall have the following meanings: “Business Day” means any day other than Saturday, Sunday or a public holiday. “Business Hours” means the hours detailed in Condition 32 below. “Contact Hours” means Monday to Friday (inclusive) from 07:00 hours to 17:00 hours but excluding bank holidays. “Contract” means any contract between MT and the Customer for the supply of Hardware and/or Software (with the associated Licence) and/or services which is subject to these Conditions. “Customer” means any person, firm or company who enters into a Contract with MT to which these Conditions apply. “Force Majeure” means any event outside the reasonable control of either Party affecting its ability to perform any of its obligations (other than as to payment) under these Conditions. “Goods” means all or any tangible or intangible goods or intellectual property including but not limited to Hardware and Software which are provided to a Customer in accordance with these Conditions. “Hardware” means any hardware provided by MT to the Customer. “MT” means MODERNTRONICS Ltd. or its servants and agents as the case may be. “Insolvency Event” means any one of the following in relation to the Customer: (i) a notice being issued to propose a resolution for winding up or dissolution, or such a resolution being passed; (ii) a petition for a winding up or an administration or bankruptcy order being presented, or such an order made; (iii)any steps being taken with a view to a voluntary arrangement or other assignment, composition or arrangement with all or any creditors or any moratorium, readjustment, rescheduling, forgiveness or deferral of all or any indebtedness; (iv) suspension of payments to all or any creditors and/or ceasing business; (v)an encumbrancer taking possession of all or any assets; (vi) an administrator or receiver being appointed over the Customer or all or any of its assets; (vii)any action anywhere similar or analogous to any of the foregoing; or MT reasonably believing that any of the foregoing is imminent. “Licence” has the meaning attributed to it in Condition 23 below. “Minimum Term” means the term set out in Condition 17 below. “Party” means MT or the Customer and “Parties” means both of them. “Response Time” means two Working Hours from an initial call to the hotline under Condition 26 or 28 below. “Seminar” means any seminar provided by MT. “Service Operator” has the meaning given to that term in Condition 28 below. “Site” means https://www.moderntronics.com and all subdomains including (but without limitation) “Software” means software or software updates or upgrades provided by MT and licensed to the Customer under Condition 23 below. “Training Sessions” means any training session provided by MT. “Working Hours” means the hours between 9:00 to 17:00 on any Business Day 2. Interpretation In these Conditions, the following rules apply: A person includes a natural person, corporate or unincorporated body (whether or not having separate legal personality). A reference to a Party includes its personal representatives, successors or permitted assigns. A reference to a statute or statutory provision is a reference to such statute or provision as amended or re-enacted. A reference to a statute or statutory provision includes any subordinate legislation made under that statute or statutory provision, as amended or re-enacted. Any phrase introduced by the terms including, include, in particular or any similar expression shall be construed as illustrative and shall not limit the sense of the words preceding those terms. A reference to writing or written includes faxes and e-mails. 3. General Information These Conditions apply when MT: sells and delivers Hardware; sells and delivers Licences; sells and delivers Software; or provides repairs or any other services to the Customer. They will also apply to other business transactions unless MT agrees that alternative special conditions apply. These Conditions apply to the exclusion of any other conditions that may be proposed by a Customer or implied by law (insofar as such exclusion is lawful). Part II Specific Provisions for the Use of the Online Shop Customers purchasing Goods from the Site, must read all Parts of these Conditions, which apply to them in full. 4. Consumers The Goods and services provided by MT are designed only for sale to and use by businesses in the course of their business activities. MT does not knowingly sell to any person dealing as a consumer or supply anything for personal use. 5. Customer’s Status By placing an order on the Site, the Customer warrants that he or she is: legally capable of entering into binding contracts and, where the Customer is an individual, that he or she is at least 18 years old; and is dealing in a business capacity and purchasing Goods and/or services for the purpose of his business and not for personal use. Part III General Conditions for the Provision of Goods and Services 6. Formation of Contract Quotations provided by MT to the Customer are not binding on MT. The Customer’s order constitutes an offer to MT to buy the Goods or services. All orders are subject to acceptance by MT. The offer will be deemed accepted, and a Contract formed, when MT sends the Customer confirmation that the Goods have been dispatched (“Dispatch Confirmation”) or, in the absence of a Dispatch Confirmation, when the Goods are delivered. The Contract will only relate to those Goods whose dispatch is confirmed to the Customer by a Dispatch Confirmation or if no Dispatch Confirmation is sent, those Goods which are actually dispatched. MT is not obliged to supply any Goods which may have been part of the Customer’s order until the dispatch of such Goods has been confirmed in a separate Dispatch Confirmation. Subject to Condition 17 below, an order for services will be deemed to have been accepted, and a Contract formed, when MT sends the Customer confirmation that the services ordered will be provided (“Service Confirmation”) or, in the absence of a Service Confirmation, when the services begin to be provided. Oral representations will only be binding upon MT if they are expressly confirmed in writing by MT to the Customer. 7. Price Unless MT expressly specifies prices to the Customer, MT’s current list of prices applicable at the time of the acknowledgement of order will apply. Unless otherwise agreed in writing, all prices are exclusive of value added tax, postage, freight, insurance, forwarding fees, installation and commissioning, travelling expenses and subsistence, which will be added as appropriate. MT will charge overtime for work outside of their normal Business Hours at up to 150% of the hourly rate from time to time applicable during Business Hours. Subject to Condition 16 below, prices are liable to change at any time, but changes will not affect orders in respect of which MT has already sent the Customer a Dispatch Confirmation or a Service Confirmation as the case may be. The Site contains a large number of products and it is always possible that, despite MT’s efforts, some of the products listed may be incorrectly priced. MT will normally verify prices as part of dispatch procedures so that, where a product’s correct price is less than our stated price, MT will charge the lower amount when dispatching the product to you. If a product’s correct price is higher than the price stated on our site, MT will normally, at our discretion, either contact you for instructions before dispatching the product, or reject your order and notify you of such rejection. MT is under no obligation to provide any Goods or services to the Customer at an incorrect (lower) price, even after MT has sent a Dispatch Confirmation or a Service Confirmation in relation to those Goods or services if such incorrect price could reasonably have been expected to be recognised by the Customer as an error. 8. Delivery and Availability The Customer’s order for Goods will be fulfilled by the delivery date in the Dispatch Confirmation or, if no delivery date is specified, then within 30 days of the date the Customer made his order (where such an order leads to a Contract). The period for delivery or performance of the Contract will normally commence on MT’s acknowledgement of the order. However, if the Customer is required to do anything before MT can effect delivery, MT will, as soon as practicable, notify the Customer accordingly. The time within which MT must deliver any Goods will run from the date on which MT receives notice from the Customer that it has duly complied with such notification from MT. Unless otherwise agreed in writing, any periods mentioned in the acknowledgement of order for services and Software development are based on a preliminary estimate of the required workload and therefore are approximate only. Time of delivery and performance is not of the essence. If MT fails to meet any delivery or performance dates set out in the acknowledgement of order and is solely responsible for such failure, the Customer may terminate the Contract but only after MT has been given an opportunity to rectify the situation and subsequently fails to meet the revised set of delivery or performance dates provided by MT to the Customer in writing. Unless MT has been deliberately or grossly negligent, all further claims of the Customer on the basis of the delay in performance are excluded. If MT cannot deliver or perform its obligations under the Contract due to Force Majeure or a failure of the Customer to cooperate or any other act, default or omission of the Customer, then MT will be entitled to perform its obligations under the Contract once the issue has been resolved, provided the issue occurred while MT was still allowed to deliver or perform and MT shall have no liability whatsoever for any delay or its failure to perform its obligations. 9. Agreed Performance Unless specified otherwise in writing, the agreed performance in respect of any repairs provided by MT, at the Customer’s request will be to adjust the relevant unit(s) to MT’s applicable standard specifications for that unit. Where the relevant unit(s) cannot be repaired to MT’s applicable standard specification due to the Customer limiting the repairs required or the time and money to be invested MT may exceed the Customer’s request if MT considers, at its sole discretion, that such additional repairs are reasonable and will ensure the proper functionality of the unit in question. The agreed performance levels for MT’s maintenance and care services are as set out in Conditions 26 and 28 below; for all other services the agreed performance levels will be as set out in the acknowledgement of order. 10. Refunds Where the Customer returns Goods (at the Customer’s cost) because he or she claims that the Goods are defective, MT will examine the returned Goods and will notify the Customer of its findings within a reasonable period of time. If MT (in its sole discretion) deems that the Goods are defective, MT may at its option repair, replace or provide a refund in respect of such defective Goods. MT will process any repair, replacement or refund as soon as practicable and, in the case of any refund, within 30 days of the day MT confirmed to the Customer that the Customer was entitled to the same. Such refunds will be made in full, including a refund of any delivery charges for sending the item to the Customer. 11. Import Duty If the Customer orders Goods for delivery outside the UK, they may be subject to import duties and taxes which are levied when the delivery reaches the specified destination. The Customer will be responsible for payment of any such import duties and taxes. Please note that MT has no control over these charges and cannot predict their amount. Customers should contact their local customs office for further information before placing an order. Customers must comply with all applicable laws and regulations of the country for which the Goods are destined. The Customer will indemnify and keep indemnified MT in respect of all costs, proceedings, losses and liabilities resulting from any breach by the Customer of any such laws. 12. Retention of Title to Property The Goods will be at the Customer’s risk from the time of delivery. Property in and title to all Goods will remain with MT until MT has received payment for the full price of all the Goods (and/or all other goods and/or services supplied by MT to the Customer under any other contract whatsoever).. The Customer may sell or use Goods in which title is retained during the course of their normal business, but may not give such Goods by way of pledge or pledge these Goods as security. Until the property in and title to the Goods passes to the Customer: the Customer shall keep the Goods properly stored, protected and insured and separate from all or any other goods whether belonging to MT, the Customer or any third party; MT shall be entitled at any time forthwith to revoke the Customer’s power to deal with the Goods; and such power shall automatically cease if an Insolvency Event shall occur in respect of the Customer; and the Customer shall not make any modification to the Goods, the Software or their packaging or alter, remove or tamper with any marks, numbers or other means of identification used on or in relation to the Goods. Upon termination of the Customer’s power to deal with the Goods, the Customer shall place the Goods at the disposal of MT and MT are hereby irrevocably authorised without the need for consent of any third party but using only such force as may be necessary, to enter upon any premises of the Customer or any third party for the purpose of removing the Goods. If third parties claim title to Goods with retained title, the Customer will inform MT without delay, will notify the person making the claim of MT’s title and will support MT in enforcing its rights, including taking all the necessary steps required to preserve MT’s rights, including commencing litigation at the Customer’s own expense. If the Customer breaches the Contract, e. g. by delaying payment, the Customer will be obliged to return the Goods with retained title if requested by MT, in return for which MT will not terminate the Contract. 13. Payment Where services, maintenance or care are provided on an ongoing basis, MT will invoice the Customer for these at the beginning of the billing period or as soon as reasonably practicable thereafter. The Customer will pay MT’s invoices in full within 30 days from the date of the relevant invoice. Depending on the scope of an order, payments for such services, maintenance or care are due either upon placement of the order by the Customer or upon partial delivery of the same of between 40 to 50% of their respective order value. BACS or cheque are the only methods of payment accepted. Invoices for Seminars and Training Sessions will be issued at the beginning of the respective session and payment is due immediately and without deduction. 14. Delay of Payment Where a Customer fails to pay an invoice by the due date, MT will be entitled to charge the Customer interest on all monies outstanding from the due date until the actual date of payment (both before and after judgment) at a rate of 8% above the base rate of the Bank of England calculated on a daily basis. 15. Setting-Off and Refusal of Payment The Customer cannot exercise any right of set-off in respect of amounts owed to or by MT. 16. Change of Pricing by MT for Ongoing Maintenance or Care MT may increase its prices for maintenance and services by giving the Customer written notice 2 months prior to the end of the Minimum Term. The Customer has 4 weeks from the date of receipt of the written notice from MT to object to the change. Where the Customer so objects, the Customer will be entitled to give notice to MT to terminate the Contract as of the date of the proposed price increase. 17. Automatic Extension of Contract Where services, maintenance or care are performed on an ongoing basis the Contract will come into effect upon acceptance by MT of the first order from the Customer for Software maintenance. The Contract will initially run until the date specified at “Minimum Service Duration” as set out in the “MT Service Product List” or until the expiry date where an expiry date is stipulated in the Contract (“Minimum Term”). Subject to one of the Parties serving written notice of termination on the other at least three months prior to the expiry of the Minimum Term, the Contract will be extended automatically. In the case of Software Licences supplied without a time limit, the Contract will extend until December 31st of the current year. The subsequent extension periods will begin on January 1st and end on December 31st of the respective year. In the case of Software Licences supplied with limited validity (e.g. a licence for 1-year) the extension is based on the terms and conditions set out in the description of the respective licence (e.g. extension by one further year). Unless otherwise agreed in writing, any extension to a Contract will be on the basis of MT’s current price list as at the date of such extension. 18. Delivery Obligations and Shipping The conditions for EXW (ex works) (MT’s premises or such other place referred to in the relevant order) as set out in the Incoterms 2010 apply to delivery of any Goods. Claims for any transport damages and any replacement of damaged Goods, remain with the Customer who is responsible for adhering to the mode and period for the filing of any claims with carriers, shippers and insurers. 19. Scope of Warranty (Material Deficiencies and Deficiencies in Title) MT warrants that the Hardware is free from defects in workmanship and material as at the time of transfer of risk; and warrants that the Software does not contain any flaws which void or substantially reduce its value or suitability for the usual or contracted purpose. Where MT is not the author of the Software, MT does not warrant that such Software will run without interruptions or errors, nor that MT will be capable of resolving all Software errors, nor that the Customer will be capable of achieving all of the functions included in the Software in all of the combinations chosen by the Customer, nor that these will meet the Customer’s requirements. MT will only warrant the quality and/or durability of Goods if it has expressly agreed in writing with the Customer that it will do so. The warranty period is 1 year. Where MT is the author of the Software such Software is subject to MT’s standard warranty. 20. Obligation to Inspect and Serve Notice of Defects The Customer must inspect the Goods upon delivery or repair and must notify MT in writing of any failure by MT to meet the specification within 7 days of delivery or repair or (where the failure was not apparent on reasonable inspection) within a reasonable time being no more than 1 month after discovery of the failure. Where the Customer fails to provide such notice MT will have no liability under its warranty. 21. Liability Subject only to Condition 21 d), MT shall not be liable to the Customer in contract, tort (including without limitation negligence) and/or breach of statutory duty for any loss or damage which the Customer may suffer by reason of any act, omission, neglect or default (including negligence) in the performance of the Contract by MT, its servants or agents, in a sum which is greater than GBP 200,000 per incident or series of connected incidents. Subject only to Condition 21 d), MT shall not be liable to the Customer whether in contract or tort (including without limitation negligence and/or breach of statutory duty) for indirect loss of any kind resulting from these Conditions, its performance or any breach of its terms. Subject only to Condition 21 d), MT shall not be liable to the Customer whether in contract or tort (including without limitation negligence and/or breach of statutory duty) for indirect economic loss of any kind including (but without limitation) loss of business opportunity, reputation, goodwill resulting from these Conditions, its performance or any breach of its conditions. Notwithstanding any other provision herein, nothing in these Conditions shall operate so as to limit or exclude MT’s non-excludable liability in respect of death or personal injury caused by the negligence of MT to exclude the application of Section 12 of the Sale of Goods Act 1979 and to exclude liability for fraudulent misrepresentation. MT’s liability for loss of data is limited to the effort required to restore the data from proper backups provided by the Customer. 22. Third Party Rights If any third party claims or takes action against the Customer, because Goods delivered by MT, or their use in accordance with the instructions provided by MT, purportedly violate their commercial rights or proprietary rights, then the Customer will inform MT of the same. MT agrees that they will assist the Customer in defending such claims. Where the claim is made to the Customer within 12 months of the date of delivery, MT will indemnify the Customer against claims provided that the Customer: appoints MT to defend the claims or to settle the dispute, and promptly notifies MT of any such claim, keeps the Customer informed of all information received and provides such reasonable assistance to MT as it shall reasonably require, does not defend the action itself without coordinating such defence with MT, and does not at any time admit liability or otherwise settle or compromise or attempt to settle or compromise the said claim or action except upon the express instruction of MT, the alleged breach of rights is not based on alteration of the delivered item used by the Customer, and does not use the item delivered by MT in conjunction with other items and/or in a fashion that breaches any such rights, in a situation where the use of the item as delivered by MT would not have breached the rights of the person who has filed the claim. MT may at any time and at its own expense acquire on behalf of the Customer the right to continue to use the Goods, to replace the Goods or alter them in such a fashion that the rights of others are no longer breached. If this is not possible, the Customer shall return or destroy the Goods if required to do so by MT who will reimburse the purchasing price for the Goods less depreciation. If the Customer refuses to do so, MT will no longer defend the claim or provide the Customer with any further support. The Customer has no further rights in case of disputes over proprietary rights with third parties and MT shall have no liability therefore unless MT could be blamed for acting deliberately or with gross negligence. Part IV Special Conditions for Delivery of Software 23. Conditions of Use for Delivered Software In the case of delivery of Software to the Customer, MT hereby grants the Customer a simple, non exclusive and non-transferable, licence to use the Software (“Licence”) . The validity of the Licence is not time limited, unless otherwise specified to the contrary in the terms and conditions of the Licence. MT, grants the Customer the use of such Software in the form of the object code and the user documentation with the use being restricted to one electronic data processing system at any one time and only for the tasks for which it is intended. Unless permitted by law, the Customer will not decompile the Software or perform reverse engineering. The Customer may duplicate the Software but only to the extent that this is required for the permitted use, and in order to allow it to perform data backup. Upon delivery of any Software, including updates and upgrades, the Customer will immediately produce a backup copy. MT may terminate the Licence granted to the Customer pursuant to this Condition 23 with immediate effect if the Customer is in breach of the conditions for the use of the Software for a period of 30 days from the date of a written notice of such a breach from MT or any third party. On termination of this Contract howsoever arising, the Customer will return to MT within 30 days all Software together with any related materials owned and licensed by MT and shall delete all copies and partial copies of the Software however stored within 7 days of service of the notice. Proof of such deletion must be provided to MT without delay. On receipt of prior written consent from MT, the Customer may retain a copy of the Software for the purposes of archiving. 24. Delivery of Software MT will only install the Software if this has been expressly agreed in writing between the Customer and MT. MT is able to provide telephone consultancy and support concerning questions relating to the application of the respective Software products as well as the solution of problems that may occur as provided for in Condition 26 below. 25. Prerequisites for Running the Delivered Software The proper running of Software systems supplied will only be guaranteed if the Hardware and operating system components used correspond to the reference systems of the respective manufacturer(s), as well as having been approved and certified. Unless otherwise agreed in the Contract, the Customer shall ensure that the provisions in this Condition 25 are complied with. Part VMaintenance and Care Application Software 26. Scope of Performance of MT Services for Application Software For the Software products, unless otherwise expressly agreed in writing, MT will provide the following services, denoted by Service Level “SW-Service STANDARD” and Service Level “SW-Service E-STANDARD”: Right to use Software and documentation updates: MT grants the Customer a non-transferable, non-exclusive Licence to use the Software and any documentation or updates. The right of use is not limited in validity, unless otherwise specified in the terms and conditions of the Licence. Software and documentation updates: MT will supply the Customer with the current version of the Software as specified in the Contract. This will be done as specified by the manufacturer of the Software. The documentation will be supplied in the form determined by the manufacturer of the Software. The installation of Software updates will be performed by suitably qualified personnel of the Customer. Alternatively for an additional charge, MT may install the Software updates on behalf of the Customer. Where the Customer has adapted the Software, the Customer will be liable for the additional cost of performing the same adaptation to the new version of the Software or alternatively the Customer may perform the necessary adaptation himself. Hotline (Service Level “SW-Service STANDARD” only) MT is able to provide consultancy and support by telephone or by e-mail in relation to queries relating to the application of the respective Software products as well as the resolution of any problems (in so far as it is reasonably practicable to do so) which may occur. This service will be provided by MT during the Contact Hours: Wherever possible, qualified consultancy will be provided by MT within the Response Time. E-mail Hotline (Service Level “SW-Service E-STANDARD” only) MT is able to provide e-mail consultancy and support in relation to queries relating to the application of the respective Software products as well as the resolution of any problems (in so far as it is reasonably practicable to do so) which may occur. This service will be provided by MT during the Contact Hours Wherever possible, qualified consultancy will be provided by MT within the Response Time. MT Hotline: E-mail: hotline@MT.com Internet: http://www.MT.com/customersupport Software error messages Where Software problems occur which MT is unable, for whatever reason, to resolve, the Customer may send a written error message to MT. The purpose of such an error message is to identify the error in the Software and enable the manufacturer to resolve the error. MT shall liaise with the manufacturer(s) of the Software products to resolve any Software errors as promptly as possible. Restoration of any data, regardless of the cause of the data loss, is not the responsibility of MT. 27. Obligation of the Customer to Co-operate Pre-conditions for the provision of the services by MT to the Customer are that the Customer has legally acquired the Software and holds a corresponding Licence to use it. In addition, the Software must be in the same condition that it was in when it was delivered. The services exclusively relate to the current release and delivered version of the Software. If earlier Software versions are used, a one-time update service which will be independently invoiced and paid for by the Customer will be provided to update the Software to the latest version. Services will not be performed for Software adaptations made by the Customer (for example including but not limited to macros, programs, variants, user interfaces and database applications). If the operating system for the Hardware is not included in the Contract, the Customer must update the operating system to the most recent version (e. g. by purchasing updates) if this is required in order to use the new versions of the application Software. Hardware and Operating Systems 28. Scope of Performance of MT Maintenance and Care Services for Hardware and Operating System For Hardware products and the operating system, unless otherwise agreed in writing, MT will provide the following services, denoted by Service Level “HW-Service SPECIAL”: The scope of performance is briefly set out in the “Special Description” for each product listed in the attached “MT Service Product List”. The exact scope of performance will be determined in accordance with the attached description of performance issued by the respective MT service operator (“Service Operator” including but not limited to Hewlett-Packard, Fujitsu Siemens and Silicon Graphics). The following shall also apply: Hotline MT is able to provide consultancy and support by telephone or by e-mail in relation to queries relating to the application of the respective Hardware products and operating system, as well as the resolution, (in so far as it is reasonably practicable to do so) of any problems which may occur. This service will be performed by MT during the Contact Hours: Wherever possible, qualified consultancy will be provided by MT within the Response Time. Where queries arise outside of the Contact Hours, the Customer should address such queries directly to MT’s Service Operator Response time for Hardware failures MT will use reasonable endeavours to solve a query within the Response Time. The Response Time shall be deemed to have been initiated either as soon as the customer service personnel arrives on the relevant site, or as soon as remote diagnosis is started, where either is required to resolve the problem. The appropriate Response Time will be determined in accordance with the attached description of performance issued by the respective MT Service Operator. 29. Services Not Included Unless otherwise agreed in writing, the following services will not be provided by MT to the Customer: a) Repair/re-acquisition of devices that have been damaged as a result of: incidents of war of any type civil wars, nuclear energy, deliberate action of the Customer (not of his subcontractors) b) Repair/re-acquisition that is required because of repair work or alterations of devices carried out by the Customer or any third party without the prior written consent of MT. c) Work required due to interface problems between MT’s devices and those of other manufacturers and suppliers. d) Customer service which is required because a product that is not covered under this Contract has caused an error. e) Customer service that has become necessary because devices have been used under adverse conditions (e.g. including contaminations and deviations from recommended room temperature and relative humidity) or in conjunction with accessories or (device-specific) consumables (e.g. including foreign disks, disk stacks, cassettes, printer paper and print heads of any type) (“Device Specific Consumables”) which do not meet the manufacturer’s specifications. f) Replacement of Device-Specific Consumables. g) Data backup. h) Calibration work that is not related to repair. 30. Restoration of Data/Programs The restoration of data and programs upon repair or replacement of a defective hard disk is limited to starting the copying program (Restore) used to restore the last full data backup. 31. Obligation of the Customer to Cooperate a) Hardware service Pre-conditions for the provision of Hardware services by MT are that the Hardware has been acquired legally and has been installed properly at the Customer’s site. In addition the Hardware affected must correspond to the current revision and be in proper condition when including in the Contract. These pre-conditions shall be met immediately after the expiry of the warranty period specified in the Contract. If the Hardware is included in the Contract at a later date, these pre-conditions must first be confirmed by a takeover inspection of the Hardware by MT, which will be independently invoiced and paid for by the Customer, and if required the pre-conditions will be achieved by MT undertaking the required repair work. b) Operating System Service Pre-conditions for the provision of operating system services are that the Customer has legally acquired the Software and has been granted the necessary corresponding Licence to use it. In addition the Software must be in the same condition as when it was delivered to the Customer. The services exclusively relate to the current release and version of the Software. If earlier Software versions are used, a one-time “Update Service” which will be independently invoiced and paid for by the Customer will be provided to update the Software to the latest version. Operating System services will not be provided for Software adaptations made by the Customer (for example including but not limited to macros, programs, variants, user interfaces and database applications). Part VI Generally Applicable Conditions 32. Prices and Fees for Special Services The following items are not included in the payment for services under Conditions 26 and 28 above and will be invoiced separately in accordance with MT’s current price list: Services performed outside Working Hours on the express request of the Customer. Services to correct errors caused negligently by the Customer or by any unauthorised third party as a result of improper treatment, unsuitable operating media, unauthorised manipulations, Software manipulations, non-adherence to operating conditions or otherwise. ices required due to faulty handling, excessive vibration, chemical influence, excessive dust burden or non-adherence to the properties set forth in the unit specifications. Unreasonable wait times and delays in the performance of services which are caused by the Customer. Services to remedy failures caused by Force Majeure. 33. Backup of Customer Data Prior to the commencement of any service work undertaken by MT, the Customer will backup all data in such a way that it may easily be restored by MT in the event that it is lost in the service process. 34. Change of Installation/Application Site Where maintenance and care services are provided on an ongoing basis by MT, the Customer will immediately inform MT in writing of any change to the installation or application address. If such a change results in an increase in MT’s expenses. MT reserves the right to either increase the prices charged to recover the additional expense incurred or alternatively MT may serve notice on the Customer to terminate the Contract where the new address is outside United Kingdom. 35. Miscellaneous Service Conditions and Obligations of the Customer to Co-operate MT may appoint authorised third parties to provide services. The Customer may only transfer title to services to third parties with the prior written consent of MT. Where defective components or devices are replaced by MT, these will become the property of MT. Extension of the products included in the maintenance agreement may be included in this Contract with the consent of the Customer. On request, MT will offer to the Customer a corresponding extension of the Contract, provided maintenance for the respective product is available. Where MT has to perform any services, the Customer shall accurately and without delay provide MT with any/all information that is required to perform such services. The Customer will provide MT with the name of a competent and appropriately qualified contact person and will provide the name of an appropriate substitute in order for the Hardware and Software to be maintained. Any contact(s) will have participated in the respective Seminars and/or Training Sessions held from time to time by MT or alternatively will have acquired comparable knowledge. These contacts will be available to MT’s technicians on site or will have access to the MT’s hotline as applicable. Consumables and Auxiliaries (which shall include documentation, application programs, data, telephone lines for transmission of voice and data) are not included in the scope of performance and shall be provided by the Customer in the vicinity of the system, such consumables and auxiliaries will be provided during Working Hours or, with prior consultation, outside of these hours. Additionally, the Customer will provide to MT computing time and consumables as required. 36. Specifically Ordered Service Days If service days are ordered for call-off within a specified period, such orders are binding. The services will become due for payment once they have been performed or by the end of the defined time period at the latest. Specifically ordered service days to be called off within a defined time period, can still be called off during a time of three months beyond the expiry of such defined time period. Thereafter they are lost. The claim to payment is thereby unaffected. For users that register on our website (if any), we also store the personal information they provide in their user profile. All users can see, edit, or delete their personal information at any time (except they cannot change their username). Website administrators can also see and edit that information.

Musiversity

musiversity

Southampton

Musiversity aims to provide aspiring musicians from all over the world with the very best online video music lessons and courses. By bringing together music students with some of the world’s best music teachers we aim to provide musicians with a single platform for all their music learning needs. In order to use the Musiversity platform, whether for accessing courses, finding teachers, or selling your own courses and services as a teacher, you must agree to the terms of use as set out below. Contents: 1. What is Musiversity? 2. User Accounts 3. Accessing Courses 4. Payments & Refunds 5. Content & Behaviour 6. Copyright and Ownership 7. Becoming a Musiversity Teacher 8. All Access Subscription 9. Musiversity’s Rights 10. Legal Terms & Conditions 1. What is Musiversity? Musiversity is an online music teacher directory and video course platform where music teachers advertise their teaching services, and can upload and compile video courses, and then sell them through our marketplace. Users can browse the courses on our marketplace, or be sent directly to specific music courses on our site through direct links, and then purchase courses to learn from. Purchased courses can be accessed from within the Musiversity platform, so that users can view the video content on any device from any location. Users can also find music teachers, whether for local in-person lessons, or live online video lessons, and contact teachers in order to arrange these. 2. User Accounts Users can browse our website and marketplace without creating an account or logging into the platform, but for all other activities on Musiversity, including purchasing courses, accessing courses, and messaging teachers, users must first create a user account and be logged in to the platform. Creating a Musiversity account is free, and only requires a valid name and email address to be given, along with a password. Musiversity accounts are unique and individual, and must not be shared with other users. Account login details should be kept confidential and not shared with anyone. All accounts on Musiversity must be registered to a person over the age of 18. If acting on behalf of a child, then a parent or guardian must be the one who creates the account. In creating a Musiversity account, you are agreeing to the terms set out in this document. Accounts can be terminated at anytime from within your account profile. You will lose access to any courses you have purchased once your account is terminated. 3. Accessing Courses When a teacher creates and lists a course on the Musiversity platform, they are providing Musiversity with a licence to offer access to their course to our users. When a user accesses a course through our platform (whether it’s a paid or free course) Musiversity is granting that user a licence to access the course, and course materials. The user does not own the course, or course materials, in any way, and has no permission to sell the course materials, or access to them to any other person. Only the account holder may access the courses they have been granted a licence for. Most of the courses on Musiversity require payment to be granted access, but some are offered for free. In either case, once you have been granted access to a course, you will continue to have access to that course for the duration of your account with Musiversity, except in cases where, for legal reasons or otherwise, we are forced to remove a course from our platform for violating our terms. You may not reproduce, copy, re-sell, illegally download, or in any other way provide access to courses to anyone other than the account holder. 4. Payments & Refunds To be granted access to paid courses on Musiversity payments must be made through our online checkout. Musiversity uses Stripe to handle all payments. Payments are made in accordance with the prices set out on the course details page for each course, and must be paid in full before being granted access. We accept payments in the following currencies: USD, CAD, AUD, NZD, EUR, GBP. Once payment had been made you will have lifetime access to the course as long as your account remains active. If you’re not happy with your purchase, you may request a refund within 30 days of purchase, provided you have NOT completed more than 50% of the course in question, by emailing Musiversity directly with your refund request. If a refund request is made within the 30 day refund period AND your student course progress record shows that you have completed less then half of the course, the payment will be refunded in full to the card it was made on. In cases where refunds are given, access to the refunded course will be revoked. If a request is made outside of the 30 day refund period, or your record shows that you've viewed/completed more than 50% of the course, then no refund will given. Payments for our All-Access Subscription are non-refundable (see section 8 below). 5. Content & Behaviour All video content uploaded to Musiversity is the responsibility of the uploader and must adhere to our terms as set out on our Teacher Terms document. Any content that is found to be in breach of those terms will be removed from the platform, and the account may be closed or blocked. All users are responsible for any content that they create on the Musiversity platform, including their profile information, any reviews they leave for courses, messages they send through the platform, and any comments they leave on courses or blog posts. Any user who is found to be posting offensive, illegal, or inappropriate material will have the content removed, and will risk their account being blocked or deleted. 6. Copyright & Ownership All videos, and other content, uploaded to Musiversity remain the intellectual property of the creator of the content, and all copyrights are retained by the creator of the content. Musiversity does not own any of the content uploaded by our teachers. However, by uploading content to our platform you are authorising Musiversity to share this content with anyone, distribute it and promote it on any of our marketing channels, as well as giving us the right to modify and edit content as we see fit, for marketing or promotional purposes. 7. Becoming a Musiversity teacher If you are a music teacher or an experienced musician with knowledge to share, we invite you to join the team of Musiversity teachers, and create, upload, compile, and sell your course, or courses through our platform. You can also just list your teaching services on our directory, without needing to create and/or sell online courses. In order to become a Musiversity teacher you must agree to the terms set out in our Teacher Terms document. 8. All-Access Subscription (pilot scheme) We are currently in the process of setting up and testing a pilot scheme of a new All-Access subscription to Musiversity. This subscription will offer full, unlimited access to all the courses and content on the Musiversity platform for a single monthly subscription fee, including all current and future courses. Subscription payments will be taken monthly, and access to the Musiversity content will be available for the duration of an active subscription. Subscriptions can be cancelled at anytime from within your Musiversity account, and cancelled subscriptions will remain active until the end of the most recent billing period, when they will then be terminated. Once a subscription has been terminated, you will no longer have access to courses on the platform (except any courses you had purchased prior to creating your subscription). As this is a subscription service, and payment is made for the access to our platform, subscription payments are non-refundable. There are no refunds, full or partial, for cancelled subscriptions (expect where required by applicable laws). 9. Musiversity’s Rights Musiversity owns the Musiversity platform and service, including all related web properties and domains, social media accounts, and other accounts associated with the platform. Musiversity owns all content on our website that is created and posted by us, including the general website content, the legal terms and conditions, blog posts and courses which are created by Musiversity, and any other content of which Musiversity is the creator. Musiversity owns the rights to it’s logo, name, and other trademarks. You, as a user with or without an account, may not use our logo without our prior written permission. You may not download, copy, duplicate, or in any other way share our content without prior written permission. 10. Musiversity Legal Terms The term ‘Musiversity, 'Musiversity.co', or ‘us’ or ‘we’ refers to the owners of the Musiversity Platform and website. The term ‘you’ refers to the user or viewer of our platform. The use of this website is subject to the following terms of use: The content of the pages of this website is for your general information and use only. It is subject to change without notice. This website uses cookies to monitor browsing preferences. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law. Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements. This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions. All trademarks reproduced in this website, which are not the property of, or licensed to the operator, are acknowledged on the website. Unauthorised use of this website may give rise to a claim for damages and/or be a criminal offence. From time to time, this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).

Courses matching "Operator"

Show all 875

Oracle SQL Fundamentals, 3 Days

4.6(12)

By PCWorkshops

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Oracle SQL Fundamentals, 3 Days
Delivered Online + more
£750

IPAF Operator - eLearning theory module

By Kingfisher Access

MEWP OPERATOR ELEARNING IPAF’s eLearning for MEWP operators is available for all MEWP categories (1a, 1b, 3a, 3b) and takes around three hours to complete. The eLearning is broken down into manageable sections that you can complete at your own pace and can save and resume your training at any time. IPAF MEWP Operator eLearning training course is available in English, Dutch, French, German, Italian, Portuguese and Spanish.

IPAF Operator - eLearning theory module
Delivered Online On Demand3 hours
£50

Learn SQL Basics, 1-day Course, Online Instructor-Led

4.6(12)

By PCWorkshops

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Learn SQL Basics, 1-day Course, Online Instructor-Led
Delivered Online + more
£185

AUTHORISED ECONOMIC OPERATOR (AEO)

By Export Unlocked Limited

This module aims to develop knowledge and understanding of the status of an authorised economic operator in the export and in import of goods. This includes the advantages of the status, trusted trader, and the process securing the authorised economic operator status.

AUTHORISED ECONOMIC OPERATOR (AEO)
Delivered in Oldham or Online + more
£395

C++ Bootcamp Course, 2-Months

4.6(12)

By PCWorkshops

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

C++ Bootcamp Course, 2-Months
Delivered Online + more
£2,000

55366 Querying Data with Transact-SQL

By Nexus Human

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

55366 Querying Data with Transact-SQL
Delivered Online
£2,976

AZ-040T00 Automating Administration with Powershell

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server. This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches. Prerequisites Before attending this course, students must have: -Experience with Windows networking technologies and implementation. - Experience with Windows Server administration, maintenance, and troubleshooting. 1 - Review Windows PowerShell Learn about Windows PowerShell Get familiar with Windows PowerShell applications Identify factors to install and use Windows PowerShell Configure the Windows PowerShell console Configure the Windows PowerShell Integrated Scripting Environment (ISE) Use Visual Studio Code with PowerShell 2 - Understand the command syntax in Windows PowerShell Discover the structure of PowerShell cmdlets Discover the parameters for using PowerShell cmdlets Review the tab completion feature in PowerShell Display the About files content in PowerShell 3 - Find commands and Get-Help in Windows PowerShell Define modules in PowerShell Find cmdlets in PowerShell Use command aliases in PowerShell Use Show-Command and Get-Help in PowerShell Interpret the help file contents and update the local help content in PowerShell 4 - Manage Active Directory Domain Services using PowerShell cmdlets Manage user accounts in PowerShell Manage groups and group memberships in PowerShell Manage computer accounts in PowerShell Manage organizational units and Active Directory objects in PowerShell 5 - Manage network service settings for Windows devices using PowerShell cmdlets Manage IP addresses in PowerShell Manage IP routing in PowerShell Manage DNS clients in PowerShell Manage Windows Firewall settings in PowerShell 6 - Manage Windows Server settings using PowerShell cmdlets Automate management tasks using the Group Policy management cmdlets Manage server roles and services using PowerShell cmdlets Manage Hyper-V Virtual Machines using PowerShell cmdlets Manage Internet Information Services using PowerShell cmdlets 7 - Manage settings for a local Windows machine using PowerShell cmdlets Manage Windows 10 using PowerShell Manage permissions with PowerShell 8 - Understand the Windows PowerShell pipeline Review Windows PowerShell pipeline and its output Discover object members in PowerShell Control the formatting of pipeline output 9 - Select, sort, and measure objects using the pipeline Sort and group objects by property in the pipeline Measure objects in the pipeline Select a set of objects in the pipeline Select object properties in the pipeline Create and format calculated properties in the pipeline 10 - Filter objects out of the pipeline Learn about the comparison operators in PowerShell Review basic filter syntax in the pipeline Review advanced filter syntax in the pipeline Optimize the filter performance in the pipeline 11 - Enumerate objects in the pipeline Learn about enumerations in the pipeline Review basic syntax to enumerate objects in the pipeline Review advanced syntax to enumerate objects in the pipeline 12 - Send and pass data as output from the pipeline Write pipeline data to a file Convert pipeline objects to other forms of data representation in PowerShell Control additional output options in PowerShell 13 - Pass pipeline objects Pipeline parameter binding Identify ByValue parameters Pass data by using ByValue Pass data by using ByPropertyName Identify ByPropertyName parameters Use manual parameters to override the pipeline Use parenthetical commands Expand property values 14 - Connect with data stores using PowerShell providers Define Windows PowerShell providers Review the built-in providers in PowerShell Access provider help in PowerShell 15 - Use PowerShell drives in PowerShell Explain PowerShell drives in PowerShell Use PowerShell drive cmdlets in PowerShell Manage the file system in PowerShell Manage the registry in PowerShell Work with certificates in PowerShell Work with other PowerShell drives in PowerShell 16 - Review CIM and WMI Review architecture of CIM and WMI Review repositories in CIM and WMI Locate online class documentation by using CIM and WMI cmdlets 17 - Query configuration information by using CIM and WMI List local repository namespaces and classes by using CIM and WMI Query instances by using commands and WMI Query Language Connect to remote computers by using CIM and WMI cmdlets Query repository classes from remote computers by using CIMSession objects 18 - Query and manipulate repository objects by using CIM and WMI methods Discover methods of repository objects by using CIM and WMI Locate class methods and documentation by using CIM and WMI Invoke methods of repository objects by using CIM and WMI 19 - Manage variables in Windows PowerShell scripts Define variables in Windows PowerShell scripts Create variable names in Windows PowerShell scripts Assign values and types to variables in Windows PowerShell scripts Identify the methods and properties of variables in Windows PowerShell scripts Use string variables and methods in Windows PowerShell scripts Use date variables and methods in Windows PowerShell scripts 20 - Work with arrays and hash tables in Windows PowerShell scripts Define an array in Windows PowerShell scripts Work with array lists in Windows PowerShell scripts Define hash tables in Windows PowerShell Scripts Work with hash tables in Windows PowerShell scripts 21 - Create and run scripts by using Windows PowerShell Review Windows PowerShell scripts Modify scripts in the PowerShell Gallery Create scripts using Windows PowerShell Review the PowerShellGet module in Windows PowerShell Run scripts and set the execution policy in Windows PowerShell Review Windows PowerShell and AppLocker Sign the scripts digitally in Windows PowerShell 22 - Work with scripting constructs in Windows PowerShell Review and use the ForEach loop in Windows PowerShell scripts Review and use the If construct in Windows PowerShell scripts Review and use the Switch construct in Windows PowerShell scripts Review the For construct in Windows PowerShell scripts Review other loop constructs in Windows PowerShell scripts Review Break and Continue in Windows PowerShell scripts 23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets Use the Get-Content command in Windows PowerShell scripts Use the Import-Csv cmdlet in Windows PowerShell scripts Use the Import-Clixml cmdlet in Windows PowerShell scripts Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts 24 - Use methods to accept user inputs in Windows PowerShell scripts Identify values that might change in Windows PowerShell scripts Use the Read-Host cmdlet in Windows PowerShell scripts Use the Get-Credential cmdlet in Windows PowerShell scripts Use the Out-GridView cmdlet in Windows PowerShell scripts Pass parameters to a Windows PowerShell script 25 - Troubleshoot scripts and handle errors in Windows PowerShell Interpret error messages generated for Windows PowerShell commands Add output to Windows PowerShell scripts Use breakpoints in Windows PowerShell scripts Interpret error actions for Windows PowerShell commands 26 - Use functions and modules in Windows PowerShell scripts Review functions in Windows PowerShell scripts Use variable scope in Windows PowerShell scripts Create modules in Windows PowerShell scripts Use the dot sourcing feature in Windows PowerShell 27 - Manage single and multiple computers by using Windows PowerShell remoting Review the remoting feature of Windows PowerShell Compare remoting with remote connectivity Review the remoting security feature of Windows PowerShell Enable remoting by using Windows PowerShell Use one-to-one remoting by using Windows PowerShell Use one-to-many remoting by using Windows PowerShell Compare remoting output with local output 28 - Use advanced Windows PowerShell remoting techniques Review common remoting techniques of Windows PowerShell Send parameters to remote computers in Windows PowerShell Set access protection to variables, aliases, and functions by using the scope modifier Enable multi-hop remoting in Windows PowerShell 29 - Manage persistent connections to remote computers by using Windows PowerShell sessions Review persistent connections in Windows PowerShell Create and manage persistent PSSessions by using Windows PowerShell Disconnect PSSessions by using Windows PowerShell Review the feature of implicit remoting in Windows PowerShell 30 - Review Azure PowerShell module Review Azure PowerShell Review the benefits of the Azure PowerShell module Install the Azure PowerShell module Migrate Azure PowerShell from AzureRM to Azure Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules 31 - Review the features and tools for Azure Cloud Shell Review the characteristics of Azure Cloud Shell Review the features and tools of Azure Cloud Shell Configure and experiment with Azure Cloud Shell 32 - Manage Azure resources with Windows PowerShell Create a new Azure virtual machine by using Windows PowerShell commands Manage Azure virtual machines by using Windows PowerShell commands Manage Azure related storage by using Azure PowerShell Manage Azure subscriptions by using Azure PowerShell 33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell Review benefits to manage Microsoft 365 services by using Windows PowerShell Connect to the Microsoft 365 tenant by using Windows PowerShell Manage users in Microsoft 365 by using Windows PowerShell Manage groups in Microsoft 365 by using Windows PowerShell Manage roles in Microsoft 365 by using Windows PowerShell Manage licenses in Microsoft 365 by using Windows PowerShell 34 - Manage Exchange Online by using Windows PowerShell Connect to Exchange Online by using Windows PowerShell Manage mailboxes in Exchange Online by using Windows PowerShell Manage resources in Exchange Online by using Windows PowerShell Manage admin roles in Exchange Online by using Windows PowerShell 35 - Manage SharePoint Online by using Windows PowerShell Install and connect to SharePoint Online Management Shell by using Windows PowerShell Manage SharePoint Online users and groups by using Windows PowerShell Manage SharePoint sites by using Windows PowerShell Manage SharePoint Online external user sharing by using Windows PowerShell 36 - Manage Microsoft Teams by using Windows PowerShell Review Microsoft Teams PowerShell module Install the Microsoft Teams PowerShell module Manage teams with Microsoft Teams PowerShell module 37 - Create and manage background jobs using Windows PowerShell Define the types of background jobs in Windows PowerShell Start remote jobs and CIM/WMI jobs in Windows PowerShell Monitor jobs in Windows PowerShell Retrieve results for running jobs in Windows PowerShell 38 - Create and manage scheduled jobs using Windows PowerShell Create and run Windows PowerShell scripts as scheduled tasks Define scheduled jobs in Windows PowerShell Create job option and job trigger objects in Windows PowerShell Create and register a scheduled job in Windows PowerShell Retrieve the results from a scheduled job in Windows PowerShell

AZ-040T00 Automating Administration with Powershell
Delivered Online
£2,975

SQL Intermediate Course, 3 Days

4.6(12)

By PCWorkshops

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

SQL Intermediate Course, 3 Days
Delivered Online + more
£600

Python Beginners Course, 1-Day

4.6(12)

By PCWorkshops

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

Python Beginners Course, 1-Day
Delivered Online + more
£185

CCTV Operator Course

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

CCTV Operator Course
Delivered Online On Demand6 hours 23 minutes
£25