Name: Nail Technician Level 3
Price: 599 GBP
Availability: InStock

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">We can come to your food business and deliver this course at your premises.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This Level 2 HACCP course is suitable for food and drink manufacturers, caterers, artisans, restaurants and more.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Our customers include noodle, beer, pastry, bread, alcohol, biscuits, meat and canapes manufacturers. We also deliver this course regularly at catering businesses.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This <a href="https://www.kitchentonic.com/level-2-haccp-rsph-course" title="https://www.kitchentonic.com/level-2-haccp-rsph-course" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer" style="color: var(--eds-control,#3659e3); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--eds-control,#3659e3);">RSPH Level 2 in Understanding HACCP course</a> introduces the concept of HACCP which helps the learner to develop an understanding of hazards, controls, monitoring and corrective action procedures for which they may be directly responsible in order to ensure effective food safety.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course is ideal for anyone new to HACCP or has a basic knowledge and understanding of HACCP.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Topics covered include:</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">The importance of HACCP - benefits, origins, legal requirements, due diligence.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">To understand the fundamentals of HACCP - Hazards, Prerequisites, the process of developing HACCP based on CODEX HACCP Principles.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Assessment method: 20 multiple choice questions</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Certificates are issued by the RSPH</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">To book HACCP Training or if you would like a quote, contact us by email.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">We travel to most places to deliver this HACCP course. Trainer travel fees may be applicable.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Prices start from &pound;250pp depending how many candidates attend the course.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Contact us for a quote.&nbsp;</p>

On-Site Level 2 HACCP Training – Nationwide
We offer on-site delivery of the Level 2 HACCP course at your premises, providing convenience and flexibility for your team.
This course is suitable for a wide range of businesses, including food and drink manufacturers, caterers, artisan producers, restaurants, and more.
We have extensive experience delivering  this course to manufacturers of noodles, beer, pastries, pasta, bread, alcohol, biscuits, meat, and canapés, as well as catering businesses. We regularly deliver this course to a variety of sectors, ensuring that your staff are trained in food safety and HACCP principles.
This RSPH Level 2 in Understanding HACCP course introduces the concept of HACCP which helps the learner to develop an understanding of hazards, controls, monitoring and corrective action procedures for which they may be directly responsible in order to ensure effective food safety.
This course is ideal for anyone new to HACCP or has a basic knowledge and understanding of HACCP. 
Topics covered include:
The importance of HACCP - benefits, origins, legal requirements, due diligence.
To understand the fundamentals of HACCP - Hazards, Prerequisites, the process of developing HACCP based on CODEX HACCP Principles.
Assessment method: 20 multiple choice questions
Certificates are issued by the RSPH
If you wish to have this HACCP course delivered on-site at your business location, please get in touch to discuss your specific needs and secure your booking.
Although our base is in London, we deliver training throughout England. Please be aware that trainer travel fees may be applicable, depending on your business location.
Cost: £250 plus £30 per participant, inclusive of exam fees. We can train up to 20 candidates per session.
Autumn discount: Previously £300 plus £30 per participant.
All our courses are VAT exempt.
We have extensive experience delivering this course across diverse sectors, including meat processing, bakery production, ice cream manufacturing, cake and pastry creation, breweries, distilleries, noodle production, and more.
Next steps, call 07837655954 or email info@kitchentonic for a quote or to book training

Kitchen Tonic Training Company and Food Safety Consultants

Food Safety

Catering

Health & Safety

Food Handling

HACCP

HACCP Trainer - Level 2 HACCP Training Course - On-site Nationwide

Nottinghamshire

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course information&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator.</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the machine to be used and be familiar with other types of information sources and relevant legislation.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify steering, driving and braking controls and explain their functions conduct all pre-operational checks in accordance with manufacturers and legislative requirements and check all emergency lowering functions.</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine configure the machine for travel.</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and maneuver it safely on level/rough ground and inclines in open and confined areas.</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area, including overhead and underground hazards maneuver the machine to work the area and correctly configure in readiness to carry out accessing tasks at various points up to full operating height.</li><li fr-original-style="" style="box-sizing: border-box;">Travel with platform raised (where applicable)</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In order to be eligible to undertake NPORS testing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">__________________________________________________________________________________</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment will be to NPORS standards consisting of a theory test and practical test. &nbsp;</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certification</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NPORS Traditional card &ndash;&nbsp;</strong>With the traditional card there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NPORS CSCS &ndash;&nbsp;</strong>To ensure that the operator can receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.&nbsp;</p>

Course information 
It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator.
Have a working knowledge of the manufacturer’s handbook for the machine to be used and be familiar with other types of information sources and relevant legislation.
Be able to locate and identify steering, driving and braking controls and explain their functions conduct all pre-operational checks in accordance with manufacturers and legislative requirements and check all emergency lowering functions.
Safely mount and dismount the machine configure the machine for travel.
Configure the machine for travel and maneuver it safely on level/rough ground and inclines in open and confined areas.
Conduct all necessary safety checks at the work area, including overhead and underground hazards maneuver the machine to work the area and correctly configure in readiness to carry out accessing tasks at various points up to full operating height.
Travel with platform raised (where applicable)
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.
Carry out all end of shift and shut down procedures.
Entry requirements 
In order to be eligible to undertake NPORS testing.
Good understanding of spoken and written English.
__________________________________________________________________________________
Assessment 
Assessment will be to NPORS standards consisting of a theory test and practical test. 
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required. 
NPORS CSCS – To ensure that the operator can receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant. 

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS MEWP Boom (N108)

Kuala Lumpur

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Classroom Training</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In the upcoming digital era, Python stands out as the language of the future for effective AI and data analytics implementation, particularly in the Oil and Gas sector. Its widespread adoption is attributed to extensive libraries, versatility, and a thriving community of developers consistently pushing the boundaries of the field. This training course will tailor a transformative learning experience for professionals in oil and gas.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Commencing with overview in the computer programming, participants delve into programming fundamentals and set up their Python coding environment. Participants will be able to explore flow control tools and functions, unlocking the full potential of Python. Furthermore, participants will gain expertise in various programming paradigms, with a particular focus on Object-Oriented Programming (OOP), a crucial foundation for building sophisticated applications.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants will navigate through file handling, internal modules, and external libraries like NumPy, Pandas, and Matplotlib, providing proficiency in data manipulation and visualization tailored for the challenges of real-life projects. Through a hands-on Data Analytics Project, participants will apply their skills to a real-world dataset, derive insights, and present findings.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This comprehensive workshop equips professionals with the tools for effective automation and data analytics in the Oil and Gas sector. Participants will experience a robust understanding of Python&rsquo;s applications, ready to drive impactful and data-driven initiatives in their professional journey.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be delivered face-to-face over 5-day sessions, comprising of 8 hours per day, 1 hour lunch and 2 breaks of 15 minutes per day. Course Duration: 8 hours in total, 40 CPD points. Maximum number of participants: 30</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING OBJECTIVES</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Acquire a comprehensive understanding of Python syntax, including variables, data types, and fundamental programming constructs.</li><li fr-original-style="" style="box-sizing: border-box;">Apply Python programming skills to analyze industry-specific datasets, extracting meaningful insights that can inform decision-making and operational efficiency.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate the ability to automate routine tasks and streamline workflows within the Oil and Gas sector using Python.</li><li fr-original-style="" style="box-sizing: border-box;">Develop practical solutions and strategies using Python programming for challenges commonly faced in the industry, fostering hands-on experience and problem-solving capabilities.</li><li fr-original-style="" style="box-sizing: border-box;">Gain insights into emerging trends in digital technology within the industry and how Python can be leveraged for continuous adaptation and innovation.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TARGET AUDIENCE</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">All Engineers and Technologists from diverse fields who are interested in utilizing Python programming and data analytics techniques to explore and address challenges within their respective domains.</li><li fr-original-style="" style="box-sizing: border-box;">Data Analysts and Scientists who working with data generated by sensors, monitoring equipment, and other sources within the industry.</li><li fr-original-style="" style="box-sizing: border-box;">IT and Automation Specialists who responsible for designing and implementing IT solutions and automation systems as well as who involve in developing and maintaining software application in the Oil and Gas sector.</li><li fr-original-style="" style="box-sizing: border-box;">Executives and Managers seeking a strategic understanding of how Python and data analytics can impact decision-making and operational efficiency in the industry.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who interest in applying Python programming and data analytics techniques to study and solve challenges in the Oil and Gas field.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals from related industries or backgrounds who are transitioning into roles within the Oil and Gas sector and wish to acquire relevant Python skills.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals from diverse backgrounds who recognize the growing importance of data analytics in the Oil and Gas sector and wish to enhance their skill set.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE LEVEL</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic</li><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING METHODS</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The trainer will employ the &lsquo;learning by doing&rsquo; method by emphasizing practical application. Participants will be introduced to the concepts and theories using techniques that they can easily relate to. The learning experience is then reinforced by implementing the subject through real-life examples. The trainer will provide quizzes and tests for self-assessment and ensuring participants can measure their understanding and apply the knowledge effectively. This hands-on approach not only enhances comprehension but also empowers participants to confidently apply the learned skills in their professional endeavors.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Preparation ahead of the Class:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are required to download the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version software onto their laptops.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The instructions are provided below:</p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Download&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Anaconda</strong>&nbsp;by visiting the Anaconda website (https://www.anaconda.com/products/distribution).</li><li fr-original-style="" style="box-sizing: border-box;">Click on the &ldquo;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Download</strong>&rdquo; button for the version that suits your operating system (Windows, macOS, Linux).</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Select the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version (e.g., Python 3.8) during the installation process.</li><li fr-original-style="" style="box-sizing: border-box;">Install Anaconda follow the instructions to run the installer. Install Just Me (Recommended).</li></ol></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINER</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert trainer is a seasoned multidisciplinary engineer with a 15-year professional journey, driven by an unwavering commitment to innovation and excellence. Armed with a Ph.D. in offshore engineering, he draws extensive insights from diverse industry sectors, notably oil and gas, where he served as a subsea pipeline engineer. His hands-on experience encompasses the entire spectrum, from design and manufacturing to installation and operations of offshore oil and gas facilities.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Previously at Rosen Group, your expert trainer developed digital tools for offshore structural assessments and risk-based inspection. He led research at the ARC Offshore Floating Facilities Hub on enhancing riser design and monitoring using Python and data analytics. He performed design verification for INPEX, Chevron, and Apache on subsea pipelines, risers, umbilicals, and LNG facilities, and was a deputy project manager on verifying the Ichthys gas pipeline. He conducted risk-based inspection and auditing of the Ichthys LNG plant for DNV GL. He also worked as a structural engineer at Advanced Building Engineers designing steel structures, buildings, and other components. Meanwhile, at the University of Western Australia (UWA), your expert trainer developed AI and data solutions for the oil &amp; gas industry focused on condition monitoring and probabilistic assessments and led research on offshore facilities by creating tools for analysis and machine learning.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His academic pursuit culminated in a thesis that underscores his proficiency in employing data science and machine learning, primarily through Python. His research focused on optimising asset integrity management for offshore oil and gas assets, showcasing a seamless integration of engineering and cutting-edge technology. In 2023, he fully unleash AI-driven solutions across diverse sectors. Currently, he actively contributes to mineral resource exploration and assists oil and gas operators in the effective implementation of new AI and digital technologies.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His dedication to knowledge dissemination is evident through his role as a global educator. Over the past five years, he has conducted Python programming lectures at universities and industries, reaching over 1000 novices. His unwavering commitment to lifelong learning, coupled with a growth mindset have positions him as a transformative trainer in the realms of applied AI, data science, and engineering in oil and gas sector</p><section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; 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.<br fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information post training support</a>&nbsp;and fees applicable.</p></div></section>

About this Classroom Training
In the upcoming digital era, Python stands out as the language of the future for effective AI and data analytics implementation, particularly in the Oil and Gas sector. Its widespread adoption is attributed to extensive libraries, versatility, and a thriving community of developers consistently pushing the boundaries of the field. This training course will tailor a transformative learning experience for professionals in oil and gas.
Commencing with overview in the computer programming, participants delve into programming fundamentals and set up their Python coding environment. Participants will be able to explore flow control tools and functions, unlocking the full potential of Python. Furthermore, participants will gain expertise in various programming paradigms, with a particular focus on Object-Oriented Programming (OOP), a crucial foundation for building sophisticated applications.
Participants will navigate through file handling, internal modules, and external libraries like NumPy, Pandas, and Matplotlib, providing proficiency in data manipulation and visualization tailored for the challenges of real-life projects. Through a hands-on Data Analytics Project, participants will apply their skills to a real-world dataset, derive insights, and present findings.
This comprehensive workshop equips professionals with the tools for effective automation and data analytics in the Oil and Gas sector. Participants will experience a robust understanding of Python’s applications, ready to drive impactful and data-driven initiatives in their professional journey.
This course will be delivered face-to-face over 5-day sessions, comprising of 8 hours per day, 1 hour lunch and 2 breaks of 15 minutes per day. Course Duration: 8 hours in total, 40 CPD points. Maximum number of participants: 30
Download your brochure
Email me the brochure
TRAINING OBJECTIVES
Acquire a comprehensive understanding of Python syntax, including variables, data types, and fundamental programming constructs.
Apply Python programming skills to analyze industry-specific datasets, extracting meaningful insights that can inform decision-making and operational efficiency.
Demonstrate the ability to automate routine tasks and streamline workflows within the Oil and Gas sector using Python.
Develop practical solutions and strategies using Python programming for challenges commonly faced in the industry, fostering hands-on experience and problem-solving capabilities.
Gain insights into emerging trends in digital technology within the industry and how Python can be leveraged for continuous adaptation and innovation.
TARGET AUDIENCE
All Engineers and Technologists from diverse fields who are interested in utilizing Python programming and data analytics techniques to explore and address challenges within their respective domains.
Data Analysts and Scientists who working with data generated by sensors, monitoring equipment, and other sources within the industry.
IT and Automation Specialists who responsible for designing and implementing IT solutions and automation systems as well as who involve in developing and maintaining software application in the Oil and Gas sector.
Executives and Managers seeking a strategic understanding of how Python and data analytics can impact decision-making and operational efficiency in the industry.
Professionals who interest in applying Python programming and data analytics techniques to study and solve challenges in the Oil and Gas field.
Individuals from related industries or backgrounds who are transitioning into roles within the Oil and Gas sector and wish to acquire relevant Python skills.
Professionals from diverse backgrounds who recognize the growing importance of data analytics in the Oil and Gas sector and wish to enhance their skill set.
COURSE LEVEL
Basic
Intermediate
TRAINING METHODS
The trainer will employ the ‘learning by doing’ method by emphasizing practical application. Participants will be introduced to the concepts and theories using techniques that they can easily relate to. The learning experience is then reinforced by implementing the subject through real-life examples. The trainer will provide quizzes and tests for self-assessment and ensuring participants can measure their understanding and apply the knowledge effectively. This hands-on approach not only enhances comprehension but also empowers participants to confidently apply the learned skills in their professional endeavors.
Preparation ahead of the Class:
Participants are required to download the Python 3.x version software onto their laptops.
The instructions are provided below:
Download Anaconda by visiting the Anaconda website (https://www.anaconda.com/products/distribution).
Click on the “Download” button for the version that suits your operating system (Windows, macOS, Linux).
Select the Python 3.x version (e.g., Python 3.8) during the installation process.
Install Anaconda follow the instructions to run the installer. Install Just Me (Recommended).
TRAINER
Your expert trainer is a seasoned multidisciplinary engineer with a 15-year professional journey, driven by an unwavering commitment to innovation and excellence. Armed with a Ph.D. in offshore engineering, he draws extensive insights from diverse industry sectors, notably oil and gas, where he served as a subsea pipeline engineer. His hands-on experience encompasses the entire spectrum, from design and manufacturing to installation and operations of offshore oil and gas facilities.
Previously at Rosen Group, your expert trainer developed digital tools for offshore structural assessments and risk-based inspection. He led research at the ARC Offshore Floating Facilities Hub on enhancing riser design and monitoring using Python and data analytics. He performed design verification for INPEX, Chevron, and Apache on subsea pipelines, risers, umbilicals, and LNG facilities, and was a deputy project manager on verifying the Ichthys gas pipeline. He conducted risk-based inspection and auditing of the Ichthys LNG plant for DNV GL. He also worked as a structural engineer at Advanced Building Engineers designing steel structures, buildings, and other components. Meanwhile, at the University of Western Australia (UWA), your expert trainer developed AI and data solutions for the oil & gas industry focused on condition monitoring and probabilistic assessments and led research on offshore facilities by creating tools for analysis and machine learning.
His academic pursuit culminated in a thesis that underscores his proficiency in employing data science and machine learning, primarily through Python. His research focused on optimising asset integrity management for offshore oil and gas assets, showcasing a seamless integration of engineering and cutting-edge technology. In 2023, he fully unleash AI-driven solutions across diverse sectors. Currently, he actively contributes to mineral resource exploration and assists oil and gas operators in the effective implementation of new AI and digital technologies.
His dedication to knowledge dissemination is evident through his role as a global educator. Over the past five years, he has conducted Python programming lectures at universities and industries, reaching over 1000 novices. His unwavering commitment to lifelong learning, coupled with a growth mindset have positions him as a transformative trainer in the realms of applied AI, data science, and engineering in oil and gas sector
Download your brochure
Email me the brochure
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.

EnergyEdge - Training for a Sustainable Energy Future

Machine Learning (ML)

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

Team of 10, pp

Normal Fee, pp

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;This course is aimed at people who require the knowledge and practical skills needed to enable them to safely  operate and maintain a Multi Directional Lift Truck. We will conduct a learner analysis to identify the duration of training required for those with limited or no  experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test  Only).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Course information Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;To provide knowledge and understanding in the following areas:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Have a basic understanding of the industry, the dangers of working in the industry and their &nbsp;responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be &nbsp;used&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;"> Be able to locate and identify driving, steering and braking controls in each travel mode and &nbsp;explain their functions</li><li fr-original-style="" style="box-sizing: border-box;"> Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative &nbsp;requirements&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Start and stop the engine and safely move the machine off and stop it safely in each travel mode</li><li fr-original-style="" style="box-sizing: border-box;"> Configure the machine for travel and maneuver it safely laden and unladen, in open and &nbsp;confined areas in each travel mode</li><li fr-original-style="" style="box-sizing: border-box;"> Conduct all necessary safety checks at the work area&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Maneuver the machine to the work area and correctly configure in readiness to carry out &nbsp;lifting and load handling tasks using each travel mode as appropriate</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;"> Lift and transfer loads accurately and safely at different locations</li><li fr-original-style="" style="box-sizing: border-box;"> Load and unload external transport safely&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Fit, adjust and or remove attachments</li><li fr-original-style="" style="box-sizing: border-box;"> Demonstrate knowledge and understanding of loading and unloading procedures for machine &nbsp;transportation&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For learners applying for the NPORS CSCS Card, or for those requiring the &#39;HS&amp;E TESTED Logo&#39;  displayed on their card they must have passed the CITB Operatives Health, Safety and Environment  Test within the last 2 years. Good understanding of spoken and written English. Assessment NPORS Theory assessment made up of open questions and multiple choice. NPORS Practical assessment.</p>

Who should attend
 This course is aimed at people who require the knowledge and practical skills needed to enable them to safely operate and maintain a Multi Directional Lift Truck. We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).
 Course information Overview
 To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify driving, steering and braking controls in each travel mode and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Safely mount and dismount the machine
Start and stop the engine and safely move the machine off and stop it safely in each travel mode
Configure the machine for travel and maneuver it safely laden and unladen, in open and confined areas in each travel mode
Conduct all necessary safety checks at the work area
Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks using each travel mode as appropriate
Carry out lifting and load handling tasks
Lift and transfer loads accurately and safely at different locations
Load and unload external transport safely
Fit, adjust and or remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements 
For learners applying for the NPORS CSCS Card, or for those requiring the 'HS&E TESTED Logo' displayed on their card they must have passed the CITB Operatives Health, Safety and Environment Test within the last 2 years. Good understanding of spoken and written English. Assessment NPORS Theory assessment made up of open questions and multiple choice. NPORS Practical assessment.

NPORS Multi Directional Lift Truck (N135)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N204 Forward Tipping Dumper</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for forward tipping dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the forward tipping dumper for use and operate safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Attach and set trailers, ready for operation<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Storage and transport of implements and attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N204 Forward Tipping Dumper
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for forward tipping dumper use
➢ Prepare the forward tipping dumper for use and operate safely and efficiently
➢ Conduct all necessary safety checks at the work area
➢ Attach and set trailers, ready for operation
➢ Environmental considerations
➢ Storage and transport of implements and attachments
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Forward Tipping Dumper (N204)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Road Rollers to compact a variety of ground. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category 214 Road Roller</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for roller use<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the roller for use and operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Road Rollers to compact a variety of ground. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category 214 Road Roller
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for roller use
➢ Prepare the roller for use and operate machinery safely and efficiently
➢ Conduct all necessary safety checks at the work area
➢ Operate machinery safely and efficiently
➢ Environmental considerations
➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Road Roller (N214)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Rear Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 4 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N205</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"></p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for rear tipping dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the rear tipping dumper for use &amp; operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Rear Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 4 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N205

It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for rear tipping dumper use
➢ Conduct all necessary safety checks at the work area
➢ Prepare the rear tipping dumper for use & operate machinery safely and efficiently
➢ Environmental considerations
➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Rear Tipping Dumper (N205)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers (mini) to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N139 Forward tipping mini dumper</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for forward tipping mini dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the forward tipping mini dumper for use and operate safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Attachments set correctly ready for operation<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Storage and transport of forward tipping mini dumper / implements / attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers (mini) to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N139 Forward tipping mini dumper
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for forward tipping mini dumper use
➢ Conduct all necessary safety checks at the work area
➢ Prepare the forward tipping mini dumper for use and operate safely and efficiently
➢ Attachments set correctly ready for operation
➢ Environmental considerations
➢ Storage and transport of forward tipping mini dumper / implements / attachments
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Forward Tipping Mini Dumper (N139)

Thetford

<header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This half day or whole day course is designed for those who are new to either working in or with the voluntary and community sector, including staff, councillors and committee members working in statutory agencies.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It will help you understand how the sector works, the various legal forms of organisations, issues of governance and sustainability so that you are able to work more effectively in partnership with the sector and understand its funding needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The half day course covers the basic information; the longer course can include further subjects such as the use of volunteers and typical issues that face trustee boards and management committees.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Areas covered</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understanding the scope of the sector</li><li fr-original-style="" style="box-sizing: border-box;">The different legal structures and types of charities</li><li fr-original-style="" style="box-sizing: border-box;">Governance issues: roles and responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">The policies and procedures that govern the sector</li><li fr-original-style="" style="box-sizing: border-box;">Funding sources for VCS groups</li><li fr-original-style="" style="box-sizing: border-box;">VCS infrastructure groups</li><li fr-original-style="" style="box-sizing: border-box;">Local Compacts.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course could be run as part of a training programme or could be run in house.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">To provide information on VCS structures and the policies that regulate the sector</li><li fr-original-style="" style="box-sizing: border-box;">Understanding issues of governance and management</li><li fr-original-style="" style="box-sizing: border-box;">To further develop relations and understanding across the public and VCS sectors</li><li fr-original-style="" style="box-sizing: border-box;">To alert participants to the opportunities for effective partnerships</li><li fr-original-style="" style="box-sizing: border-box;">To impart an understanding of the additionality that the VCS brings to communities across the county and the different roles that the VCS plays.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target Audience</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">People (either staff, councillors or local representatives) working in statutory agencies or those new to working or volunteering in the voluntary and community sector. It might also be useful for companies who want to develop their corporate social responsibilities. The course can be adapted to suit particular needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cost</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">From &pound;150 + travel costs</p></article></div></header></header></header></header></header><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><br fr-original-style="" style="box-sizing: border-box;"></div>

This half day or whole day course is designed for those who are new to either working in or with the voluntary and community sector, including staff, councillors and committee members working in statutory agencies.
It will help you understand how the sector works, the various legal forms of organisations, issues of governance and sustainability so that you are able to work more effectively in partnership with the sector and understand its funding needs.
The half day course covers the basic information; the longer course can include further subjects such as the use of volunteers and typical issues that face trustee boards and management committees.
Areas covered
Understanding the scope of the sector
The different legal structures and types of charities
Governance issues: roles and responsibilities
The policies and procedures that govern the sector
Funding sources for VCS groups
VCS infrastructure groups
Local Compacts.
This course could be run as part of a training programme or could be run in house.
Objectives
To provide information on VCS structures and the policies that regulate the sector
Understanding issues of governance and management
To further develop relations and understanding across the public and VCS sectors
To alert participants to the opportunities for effective partnerships
To impart an understanding of the additionality that the VCS brings to communities across the county and the different roles that the VCS plays.
Target Audience
People (either staff, councillors or local representatives) working in statutory agencies or those new to working or volunteering in the voluntary and community sector. It might also be useful for companies who want to develop their corporate social responsibilities. The course can be adapted to suit particular needs.
Cost
From £150 + travel costs

SAVO CIC

Organisational Skills

This half day or whole day course is designed for those who are new to either working in or with the voluntary and community sector, including staff, councillors and committee members working in statutory agencies.

It will help you understand how the sector works, the various legal forms of organisations, issues of governance and sustainability so that you are able to work more effectively in partnership with the sector and understand its funding needs.

The half day course covers the basic information; the longer course can include further subjects such as the use of volunteers and typical issues that face trustee boards and management committees.

Introduction to the Voluntary and Community Sector

General Admission

Gloucester

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 day practical course (taken in professional beauty salon) designed to show You how to carry out manicures. This course is designed for complete beginners, who wish to learn from basic to professional most popular nail art techniques to start Your career as nail technicians. It is also good to refresh knowledge and learn new techniques for those of You that are already in business.</p><h1 fr-original-style="" style="box-sizing: border-box;">This nail technician Level 3course includes:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Organizing your work place</li><li fr-original-style="" style="box-sizing: border-box;">Health and safety at the work place</li><li fr-original-style="" style="box-sizing: border-box;">Customer service</li><li fr-original-style="" style="box-sizing: border-box;">Nail anatomy</li><li fr-original-style="" style="box-sizing: border-box;">Skin anatomy and skin care</li><li fr-original-style="" style="box-sizing: border-box;">Nail health</li><li fr-original-style="" style="box-sizing: border-box;">Tools for nails&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Product description used for nail&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension methods using gel and acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Manicure</li><li fr-original-style="" style="box-sizing: border-box;">Electric manicure</li><li fr-original-style="" style="box-sizing: border-box;">Hybrid manicure</li><li fr-original-style="" style="box-sizing: border-box;">Palm massage</li><li fr-original-style="" style="box-sizing: border-box;">Nail and palm care treatment</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using gel</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using gel &ndash; French</li><li fr-original-style="" style="box-sizing: border-box;">Infill&nbsp;gel tips</li><li fr-original-style="" style="box-sizing: border-box;">Nail decoration setting</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Nail extension technique using acrylic templates/forms</li><li fr-original-style="" style="box-sizing: border-box;">Acrylic tips &ndash; French</li><li fr-original-style="" style="box-sizing: border-box;">Infill&nbsp;acrylic nails</li><li fr-original-style="" style="box-sizing: border-box;">Nail decoration setting in acrylic</li><li fr-original-style="" style="box-sizing: border-box;">Gel nail and acrylic nail removal techniques</li><li fr-original-style="" style="box-sizing: border-box;">Natural nail hardening techniques</li></ul>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<h1 fr-original-style="" style="box-sizing: border-box;">Earn your certificate!</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<div data-packed="true" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">After completion of this nail technician course, you will receive a Penelope Academy ABT accredited certificate.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Graduates from this nail training course can begin working as professional nail technicians using their Penelope Academy certificate. Students can develop their skills further by progressing onto our other nail courses.</strong></p></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<div data-appear-animation="fadeInUp" data-appear-animation-delay="300" fr-original-style="" style="box-sizing: border-box;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="https://penelope-academy.co.uk/product/nail-technician-course/#cart" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"></a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</div><div data-vc-full-width="true" data-vc-full-width-init="true" data-vc-parallax="2" data-vc-parallax-image="https://penelope-academy.co.uk/wp-content/uploads/2019/04/penelope-ltd-bg-03..jpg" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><header fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Practical Training!</h2></header><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">90% of the course consists of practical training, as we believe that practice makes perfect!</strong></h2><h1 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h1><h1 fr-original-style="" style="box-sizing: border-box;">Information:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will provide you with all the necessary products and tools for nail training.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Students will receive a manual to keep.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note: all students will be working on models. You will need to bring a model along with you to the training.&nbsp;</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you cannot find anyone to work with, you will need to let us know 1 week before the course so that we can arrange a model.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We provide a friendly, intimate atmosphere for all students to enjoy.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<h1 fr-original-style="" style="box-sizing: border-box;">Requirements:</h1>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The minimum age for entry to this course is 18 years.</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There are no additional requirements to enter this course</p></section></div>

This 3 day practical course (taken in professional beauty salon) designed to show You how to carry out manicures. This course is designed for complete beginners, who wish to learn from basic to professional most popular nail art techniques to start Your career as nail technicians. It is also good to refresh knowledge and learn new techniques for those of You that are already in business.
This nail technician Level 3course includes:
Organizing your work place
Health and safety at the work place
Customer service
Nail anatomy
Skin anatomy and skin care
Nail health
Tools for nails
Product description used for nail
Nail extension methods using gel and acrylic
Manicure
Electric manicure
Hybrid manicure
Palm massage
Nail and palm care treatment
Nail extension technique using gel
Nail extension technique using gel – French
Infill gel tips
Nail decoration setting
Nail extension technique using acrylic
Nail extension technique using acrylic templates/forms
Acrylic tips – French
Infill acrylic nails
Nail decoration setting in acrylic
Gel nail and acrylic nail removal techniques
Natural nail hardening techniques
Earn your certificate!
After completion of this nail technician course, you will receive a Penelope Academy ABT accredited certificate.
Graduates from this nail training course can begin working as professional nail technicians using their Penelope Academy certificate. Students can develop their skills further by progressing onto our other nail courses.
Practical Training!
90% of the course consists of practical training, as we believe that practice makes perfect!


Information:
We will provide you with all the necessary products and tools for nail training.
Students will receive a manual to keep.
Please note: all students will be working on models. You will need to bring a model along with you to the training. 
If you cannot find anyone to work with, you will need to let us know 1 week before the course so that we can arrange a model.
We provide a friendly, intimate atmosphere for all students to enjoy.
Requirements:
The minimum age for entry to this course is 18 years.
There are no additional requirements to enter this course

Penelope Academy

Manicure

Beauty Specialist

Gel Extension

Nail Extension

Acrylic Nail

Nail Technician

Gel Nail Technician

Gel Nail Extension

Beauty Therapy

The ABT Level 3  Diploma in Nail Services is a substantial vocational qualification that will confirm your competence as a nail technician.

Nail Technician Level 3

General admission

Slough

Newport

Milton Keynes 

Birmingham

Bedford

Liverpool 

NATIONALLY RECOGNISED AND ACCREDITED
LEVEL FOUR CERTIFICATE



This course comprises two parts:
 
Part 1 - online (eLearning)

AND

Part 2 - classroom

Part 2 consolidates on Parts 1 and delivers one full day of practical sessions (skill-set development) - PRP Harvesting and Treatment


Award:
Open College Network (OCN Credit4Learning) - Collegen Induction Therapy - PRP Treatment
LEVEL 4 (FDSc)



A modular "hybrid" course - eLearning (online) theory and one full day classroom based course.
 
PART 1 - THEORY ONLINE

Complete this part of your course online (eLearning Course) in the comfort of your own home or workplace.
Please allow 1-2 full days (approx. 12-16 hours in total) to complete this part of your course.
You do not need to complete this part of the course in one "sitting". Do as little or as much as you wish. Each time you log again exactly where you can start where you left off!
 
You must complete Part 1 before attending Part 2 below.
 
PART 2 - CLASSROOM
Attend in the classroom at the training location that you have selected.
Your classroom tutor will recap on the essential parts of your online course after which you will begin your practical sessions learning and developing the skills required to harvest and use Platelet-Rich Plasma in your treatment plan.
Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary


A hybrid modular course awarding:
OCN Accredited Level Three Certificate (Advanced Level) 3 credits AND

GEOPACE Certificate (Collagen Induction Therapy - PRP Treatment)



Parts 1 (A & B) - online (eLearning) +

Part 2 - PRP Harvesting, Preparation & Treatment (one day)


Theory Sessions:


M01 – Course Overview
Learning outcomes, Understanding recommended guidelines (CPSA, HEE, NICE & WHO), Core Competencies (Domains 1, 2 & 3). National Occupational Standards


M02 – Qualifications – Levels & Thresholds
Understanding the range and applications of treatments at Levels 1 to 8. Equivalencies. Looking at each level and specific treatment types. Competencies at Level 4.


M03 – Culture & Diversity
Understanding culture and diversity within the context of a salon, including opportunities and challenges for aesthetic therapists. Diversity and inclusion. Principles of diversity.


M04 – History, Definitions and Roles
The origins of microneedling and development of PRP, evolution of treatments, types of equipment and range of applications. Historical perspective and modern day examples of PRP therapies.


M05 – Health & Safety & IPC
H&S legislation, Standard Precautions (for blood borne pathogens), Pathogen types, Personal Protective Equipment (PPE), Handwashing and Hygiene, Hazardous Waste Disposal (non-specific), Preventing Needlestick Injuries. A detailed look at viruses, bacteria and fungi. Handling clients with infectious conditions and infestations. Transmission modes. Sterilisation processes in the workplace, including autoclaves.


M06 – Regulatory Obligations
Pathways – employed, contracted and self-employed, Management of H&S at work, Local and national government laws and bylaws, DBS types, Record Keeping, Hazardous Waste Disposal (specific), Insurance and insurance types, Accident reporting, The Keogh Review, HEE guidelines, Professional bodies.


M07 – Professionalism & Effective Communication
Presenting a professional image, guidelines and recommendations. How to effectively communicate with your clients and colleagues, communication methods, communicating efficiently in consultation.


M08 – Consent
Understanding consent types and your client’s capacity to consent. The importance of valid consent. Consent frequency. Risk assessment. Storing consent documentation – looking at paper and digital/cloud. Consent and the law. Determining if consent is robust.


M09 – Environmental and Sustainable Work Practices
Sustainability in the workplace. Running an efficient salon (water efficiency, waste reduction, interior fittings). Advancements including digital options (clients and suppliers).


M10 – Anatomy & Physiology
A&P for collagen induction therapy. Veins, arteries and capillaries (phlebotomy overview). The integumentary system – structure and function. Microneedling – depths and penetration. The lymphatic system. The circulatory system. Skin as a defence barrier. Skin – functions and layers. Merkel cells, Langerhans Cells, Keratinocytes and Melanocytes. The epidermal-melanin unit. Fibroblasts and connective tissue. The effects of ageing. Skin changes over time. Skin rejuvenation including optimising cell function and increasing natural collagen. Inducing regenerative healing. The Fitzpatrick Scale. A detailed look at cell function, specifically melanocytes, keratinocytes and fibroblasts. Microneedling the skin, effects and collagen response. Wound healing – stages (haemostasis, inflammatory, proliferative and maturation). Collagen Induction Therapy (CIT). Topical applications to improve keratinocyte function. Topical applications to improve collagen synthesis.


M11 – Patient Management – Consultation & Examination
Pre-treatment and treatment consultations. Client Motives. Educating your client. Developing a consultation plan. Medical Records. Contraindications & Precautions – Relative and Absolute Contraindications in microneedling. Microneedling and anticoagulants. Side effects and treatment failure. Photo-documentation. Looking at and recording a detailed medical history. Client reviews. Health risks. Legalities.


M12 – Record Keeping
Key points and importance. Understanding how to retain records. Claims - Date of Discovery and Date of Knowledge.


M13 – Platelet Rich Plasma (PRP) – Understanding the basics
Whole blood – composition. Platelets and growth factors (types and functions). What are platelets? Understanding platelet modes of action. Platelet Rich Plasma – preparation. PPP and PRP. PRP Activation and collagen response in vivo. Fibrin network formation. Dermal needle puncture - repair pathway. Examples of microneedling applications. Needle depths and facial skin thickness. Types of treatments – a case by case examination.


M14 – Platelet Rich Plasma (PRP) – Harvesting and Preparation
Phlebotomy. Using correct needle size and anticoagulant. Understanding autologous treatment types with PRP. The treatment agent pathway. Whole blood processing. Harvesting good quality PRP - step by step procedure. Using a centrifuge. Centrifuge operation and management. Steps to minimise platelet trauma. First and second centrifuge processes. Understanding how a centrifuge works? Managing breakage and spillage.


M15 – PRP Treatment – putting it all together!
Client arrival, management, documentation, photography, examination, consultation, consent, treatment plan. Patient ID, where necessary. Referrals and when to refer. Seeking expert advice. Employment types – employed (PAYE), contracted, self-employed (freelance) - detailed look at each. Managing equipment and consumables. Compliancy. Pre-treatment guidance. Medications and drug conflicts. Preparing a treatment area. Preparing your client. Disinfecting the face. Applying numbing cream. Phlebotomy procedures.
Blood handling. Dermapen types and accessories. Treatment modes and actions. Selecting the correct needle depth. Applying PRP and microneedling. Managing pen depth and skin areas. Working within facial zones. Post treatment management. Waste management and correct waste disposal. Post treatment client management. Aftercare. Managing adverse effects. Managing post treatment client expectations. Treatment intervals. Post treatment checklists and patient aftercare guidelines.


Classroom Practical Sessions:
Practical Session 1: Equipment familiarisation - hands-on approach
Practical Session 2: Completing medical forms and consent forms
Practical Session 3: Preparing a treatment area
Practical Session 4: Using a centrifuge
Practical Session 5: Performing a microneedling facial treatment with PRP - model 1
Practical Session 6: Performing a microneedling facial treatment with PRP - model 2


Classroom Support Material:
Support material to complement Modules 1 – 15


Online Support Material:
Downloadable pdf files - support material to complement Modules 1 - 15
Demonstration Video



Geopace Training

Medical Aesthetics

Allied Health

Platelet-rich plasma (PRP)

Aesthetics

Aesthetic Practitioner

Facial Aesthetics

Platelet-rich Plasma (PRP) treatments

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    Open College Network Accreditation

    Level 4 (as required for minimally invasive procedures)

    Covers standards set by HEE

    Employed (salon) or Self-Employed opportunities

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


PRP - Collagen Induction Therapy Course (GPT701)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.</p>Overview<p>Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.</p><p>This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.</p>Prerequisites<p></p><li>Basic Windows and Active Directory knowledge.  </li><li>Conceptual knowledge of Configuration Manager objects and how they interact.  </li><li>Basic experience performing configuration tasks in ECM using the graphical console.  </li><li>Experience working from a command prompt.  </li><li>Basic knowledge of the fundamentals of Windows PowerShell.<p></p></li></div><div id="course-pills-2"><h3>1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS</h3> <ul> <li>Architecture of an System Center 2012 Configuration Manager Installation</li> <li>Managing Assets</li> <li>Content Delivery and Management</li> <li>Security, Monitoring, and Remote Management</li> </ul> <h3>2 - MANAGING RESOURCES</h3> <ul> <li>Implementing Discovery</li> <li>Organizing Resources with Collections</li> <li>Working with Boundaries</li> </ul> <h3>3 - WORKING WITH CLIENTS</h3> <ul> <li>Installing the Configuration Manager Client</li> <li>Managing Client Settings</li> <li>Managing Client Operations</li> <li>Monitoring Client Status</li> </ul> <h3>4 - DISTRIBUTING SOFTWARE</h3> <ul> <li>Configure the Software Distribution Components</li> <li>Working with Distribution Points</li> <li>Creating Content for Distribution</li> <li>Deploying Software Applications</li> </ul> <h3>5 - UPDATING SYSTEMS WITH WSUS AND SCCM</h3> <ul> <li>Integrating Configuration Manager and WSUS</li> <li>Managing Updates through Software Update Groups</li> <li>Creating and Deploying Update Packages</li> <li>Working with Automatic Deployment Rules</li> </ul> <h3>6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS</h3> <ul> <li>Creating Compliance Settings Objects</li> <li>Deploying and Monitor the Baseline</li> </ul> <h3>7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS</h3> <ul> <li>Preparing the OSD Environment</li> <li>Working with Task Sequences</li> </ul> <h3>8 - WORKING AT THE SITE LEVEL</h3> <ul> <li>Modify the Site</li> <li>Adding Site System Roles</li> <li>Adding a Secondary Site</li> </ul> <h3>9 - SECURITY AND MONITORING</h3> <ul> <li>Configuring Role Based Administration</li> <li>Implementing Endpoint Protection</li> <li>Configuring Monitoring Options</li> </ul> <h3>10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS</h3> <ul> <li>Review of Scripting Constructs</li> <li>Introduction to the Configuration Manager WMI Classes</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.
Overview
Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.
This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.
Prerequisites

Basic Windows and Active Directory knowledge.
Conceptual knowledge of Configuration Manager objects and how they interact.
Basic experience performing configuration tasks in ECM using the graphical console.
Experience working from a command prompt.
Basic knowledge of the fundamentals of Windows PowerShell.
1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS
Architecture of an System Center 2012 Configuration Manager Installation
Managing Assets
Content Delivery and Management
Security, Monitoring, and Remote Management
2 - MANAGING RESOURCES
Implementing Discovery
Organizing Resources with Collections
Working with Boundaries
3 - WORKING WITH CLIENTS
Installing the Configuration Manager Client
Managing Client Settings
Managing Client Operations
Monitoring Client Status
4 - DISTRIBUTING SOFTWARE
Configure the Software Distribution Components
Working with Distribution Points
Creating Content for Distribution
Deploying Software Applications
5 - UPDATING SYSTEMS WITH WSUS AND SCCM
Integrating Configuration Manager and WSUS
Managing Updates through Software Update Groups
Creating and Deploying Update Packages
Working with Automatic Deployment Rules
6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS
Creating Compliance Settings Objects
Deploying and Monitor the Baseline
7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS
Preparing the OSD Environment
Working with Task Sequences
8 - WORKING AT THE SITE LEVEL
Modify the Site
Adding Site System Roles
Adding a Secondary Site
9 - SECURITY AND MONITORING
Configuring Role Based Administration
Implementing Endpoint Protection
Configuring Monitoring Options
10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS
Review of Scripting Constructs
Introduction to the Configuration Manager WMI Classes

Nexus Human

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Microsoft SC-100

Commercial & Contract Management Certification Program (CCM)

Microsoft SC-200

55133 PowerShell for System Center Configuration Manager Administrators

London

<article id="cincluded">
					<div>
						<h5>SQL Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL course, to leavy you full conversant with queries, DML and DDL statements.
						<br />Hands-on, Practical SQL course. 
						<br />PCWorkshops SQL Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>SQL Course Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment Options</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £750, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Course Certificate on completion.
									</li><li>SQL Course Manual.
									</li><li>Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>Course Details</h5>
					</div>
					<article>
						<div>
							<h5>SQL Intermediate Course summary</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	 <br /><br /><b><li>DAY 1:</li></b>
						    <li><b>Session 1: </b>Database Concepts
							 
							<br />What is a database? 
							<br />Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

							</li>	<li><b>Session 2: </b>Using the SQL client
							SQL Getting started and Logging in, Selecting a database, 
							Client commands, Entering and executing SQL statements, 
							Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, 
							Command line execution of SQL Scripts

							</li><li><b>Session 3: </b>Basic SQL SELECT statement
							<br />The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.  
							<br />Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
							<br />Column aliases.
							<br />Arithmetic expressions.
							<br />Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
							<br />The ORDER BY clause.
							
							
							</li><li><b>Session 4:</b> 
							<br />LIMIT / TOP  and Distinct Queries 
							<br />SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							<br />Group By, 
							<br />Rollup with Group By, 
							<br />Having.
							</li>
							<li><b>Session 5:</b> Joins
							<br />SQL Cartesian products.
							<br />SQL Joins (Inner join, Left join, Right join, Full join).
							<br />Table aliases.
							<br />Natural joins, Multi-table joins.
							<br />Union, Union All queries.
							<br />Except/Minus, Simulating join with Intersect.
							</li>
							<br /><br /><b><li>DAY 2:</li></b>
							<li><b>Session 6:</b>
							<br />SQL Subqueries, Nested Subqueries, 
							<br />Correlated and uncorrelated subqueries. 
							<br />Global and Local Temp Tables.
							</li>
							<li><b>Session 7:</b>
							SQL Built-in Functions: <br />Numeric Functions (ABS, SIGN, MOD, etc.)
							<br />and String Functions (Locate, Left, Right, Concat, etc),
							<br />DATE and TIME functions.
							</li>
							<li><b>Session 8:</b>
							SQL Views (Create, alter and drop), 
							<br />Stored Procedures (Create, alter and drop, Input and Output parameters);
							<br /> Custom Functions (Create, alter and drop).
							</li>
							<br /><br /><b><li>DAY 3:</li></b>
							<li><b>
							Session 9: </b>Managing Data
							<br />Inserting rows, Replacing rows, Updating rows, Deleting rows,
<br />							The truncate statement, 
<br />The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li><b>
							Session 10:</b>
							SQL Indexes (Create, alter and drop).
							</li>
							<li><b>
							Session 11:</b>
							<br />Creating Databases and Tables (Create, alter and drop); <br />Constraints (Add, alter and drop).
							</li>
							<li><b>
							Session 12:</b>
							<br />Import data into SQL and Export from SQL.
							<br />Exporting using SQL, Importing using SQL.
														</li> 
							
							
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>Book the SQL Course</h5>
	                  </div>
							 
							 
<div id="eventbrite-widget-container-12009778571"></div>




					 
							 
							 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About us</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_7KBtchhl8SMxqQ8TquAE3BxAGh2waJl4jxQdXEubLKJcmvn6ak"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Course Intermediate 
 
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. 
Where is the SQL Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Course Materials
SQL Coding Examples
SQL Course Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
Included with SQL Intermediate Course:
SQL Course Certificate on completion.
SQL Course Manual.
Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Course is 4.
SQL Intermediate Course summary
DAY 1:
Session 1: Database Concepts 
What is a database? 
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions. 
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators. 
Column aliases. 
Arithmetic expressions. 
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce'). 
The ORDER BY clause.
Session 4: 
LIMIT / TOP and Distinct Queries 
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), 
Group By, 
Rollup with Group By, 
Having.
Session 5: Joins 
SQL Cartesian products. 
SQL Joins (Inner join, Left join, Right join, Full join). 
Table aliases. 
Natural joins, Multi-table joins. 
Union, Union All queries. 
Except/Minus, Simulating join with Intersect.
DAY 2:
Session 6: 
SQL Subqueries, Nested Subqueries, 
Correlated and uncorrelated subqueries. 
Global and Local Temp Tables.
Session 7: SQL Built-in Functions: 
Numeric Functions (ABS, SIGN, MOD, etc.) 
and String Functions (Locate, Left, Right, Concat, etc), 
DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), 
Stored Procedures (Create, alter and drop, Input and Output parameters); 
 Custom Functions (Create, alter and drop).
DAY 3:
Session 9: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows,

 The truncate statement, 
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 10: SQL Indexes (Create, alter and drop).
Session 11: 
Creating Databases and Tables (Create, alter and drop); 
Constraints (Add, alter and drop).
Session 12: 
Import data into SQL and Export from SQL. 
Exporting using SQL, Importing using SQL.
 
About us

Our SQL Intermediate trainers are experienced award winners.
13 years in business
We keep it practical and customised

PCWorkshops

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

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

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.</p>Overview<p>Upon successful completion of this course, students will be able to:  Learn the fundamental concepts of cloud computing.  Learn the business aspects and impact of cloud computing.  Differentiate the types of cloud solutions and the adoption measures needed for each.  Identify the technical challenges and the mitigation measures involved in cloud computing.  Identify the steps to successfully adopt cloud services.  Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization.  Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.</p><p>Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.</p></div><div id="course-pills-2"><h3>1 - Understanding Cloud Computing Concepts</h3> <ul> <li>Topic A: Understand Basic Cloud Concepts and Terms</li> <li>Topic B: Identify Cloud Network and Cloud Storage Technologies</li> <li>Topic C: Recognize Cloud Design Aspects</li> </ul> <h3>2 - Applying Cloud Business Principles</h3> <ul> <li>Topic A: Relate Cloud Concepts to Business Principles</li> <li>Topic B: Establish Cloud Vendor Relations</li> <li>Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider</li> <li>Topic D: Report Financial Expenditures</li> </ul> <h3>3 - Advising a Cloud Design and Migration</h3> <ul> <li>Topic A: Relate Cloud Concepts to Cloud Design and Migration</li> <li>Topic B: Use Cloud Assessments</li> <li>Topic C: Manage Cloud Design</li> <li>Topic D: Compare Cloud Migration Approaches</li> <li>Topic E: Identify Benefits and Solutions of Cloud Services</li> </ul> <h3>4 - Operating in the Cloud</h3> <ul> <li>Topic A: Relate Cloud Concepts to Technical Operations</li> <li>Topic B: Identify the Technical Aspects of Cloud Operations</li> <li>Topic C: Understand DevOps in the Cloud</li> <li>Topic D: Explain Cloud Security Concerns, Measures, and Concepts</li> </ul> <h3>5 - Managing Cloud Governance</h3> <ul> <li>Topic A: Relate Cloud Concepts to Governance</li> <li>Topic B: Apply Risk Management Concepts</li> <li>Topic C: Understand Compliance and the Cloud</li> <li>Topic D: Manage Policies and Procedures for Cloud Services</li> </ul> <h3>6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)</h3> <h3>7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms</h3> <h3>8 - Glossary</h3> <h3>9 - Index</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Cloud Essentials Plus Certification (Exam CLO-002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.
Overview
Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.
Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.
1 - Understanding Cloud Computing Concepts
Topic A: Understand Basic Cloud Concepts and Terms
Topic B: Identify Cloud Network and Cloud Storage Technologies
Topic C: Recognize Cloud Design Aspects
2 - Applying Cloud Business Principles
Topic A: Relate Cloud Concepts to Business Principles
Topic B: Establish Cloud Vendor Relations
Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider
Topic D: Report Financial Expenditures
3 - Advising a Cloud Design and Migration
Topic A: Relate Cloud Concepts to Cloud Design and Migration
Topic B: Use Cloud Assessments
Topic C: Manage Cloud Design
Topic D: Compare Cloud Migration Approaches
Topic E: Identify Benefits and Solutions of Cloud Services
4 - Operating in the Cloud
Topic A: Relate Cloud Concepts to Technical Operations
Topic B: Identify the Technical Aspects of Cloud Operations
Topic C: Understand DevOps in the Cloud
Topic D: Explain Cloud Security Concerns, Measures, and Concepts
5 - Managing Cloud Governance
Topic A: Relate Cloud Concepts to Governance
Topic B: Apply Risk Management Concepts
Topic C: Understand Compliance and the Cloud
Topic D: Manage Policies and Procedures for Cloud Services
6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)
7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms
8 - Glossary
9 - Index
Additional course details:
Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the CompTIA Cloud Essentials Plus Certification (Exam CLO-002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


CompTIA Network+

IT Certifications

AWS Certified Cloud Practitioner

Cisco Certified Entry Networking Technician (CCENT)

CompTIA A+

CompTIA Security+

CompTIA Cloud Essentials+

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.</p>Overview<p>At course completion, you should be able to<br />describe DAX syntax, data types, and errors<br />use DAX to create calculated columns, measures, and tables<br />explain how DAX calculations are evaluated, along with the differences between row context and filter context<br />configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.<br />create calculated columns and measures that use data from multiple tables in the data model<br />write measures that handle error conditions gracefully<br />use DAX to enhance the Power BI user experience<br />use DAX Studio to connect to a Power BI data model and execute simple queries</p><p>Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</p></div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Duration
2 Days
12 CPD hours
This course is intended for
This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.
Overview
At course completion, you should be able to
describe DAX syntax, data types, and errors
use DAX to create calculated columns, measures, and tables
explain how DAX calculations are evaluated, along with the differences between row context and filter context
configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
create calculated columns and measures that use data from multiple tables in the data model
write measures that handle error conditions gracefully
use DAX to enhance the Power BI user experience
use DAX Studio to connect to a Power BI data model and execute simple queries
Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.
MODULE 1: GETTING STARTED WITH DAX
INTRODUCTION TODAX
CREATING OBJECTS WITHDAX
CONTEXT AND RULES OF EVALUATION
VARIABLES,COMMENTS,AND TESTING
MODULE 2: PERFORMING BASIC CALCULATIONS
GETTING STARTED
IMPLICIT MEASURES
ADDING QUICK MEASURES
WORKING WITH DAX DATA TYPES .
DOING BASIC MATH
USING LOGIC IN YOUR CALCULATIONS
USING THE IF() FUNCTION
NESTED IF()
USING THE SWITCH() FUNCTION
ADVANCED SWITCH()
LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT()
AGGREGATING AND SUMMARIZING DATA
THE SUM() FUNCTION
MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL
CONTEXT DEFINED
DATA MODELING BASICS
INTRODUCTION TO DIMENSIONAL MODELING
RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT
GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE
LOOKING UP DATA WITHOUT USING RELATIONSHIPS
MODIFYING THE CONTEXT USING CALCULATE()
MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS
THE DAX ITERATOR FUNCTIONS
USING TABLE MANIPULATION FUNCTIONS
MODULE 5: WORKING WITH TIME
PERFORMING DATE CALCULATIONS
WORKING WITH DATE TABLES
GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION
DEFINING CUSTOM OPERATING PERIODS
YTD, QTD, AND MTD CALCULATIONS
CUSTOM TO-DATE CALCULATIONS
FINDING YEAR-OVER-YEAR CHANGE
FINDING MOVING AVERAGES
MODULE 6: ENHANCING THE USER EXPERIENCE
CONTROLLING VISIBILITYOF YOUR MEASURES
USING WHAT-IF PARAMETERS
ADDING BANDING
USING DAX TO PROVIDE ROW-LEVEL SECURITY

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
2 Days
12 CPD hours
This course is intended for

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

1 - Introduction to Transact-SQL
Work with schemas
Explore the structure of SQL statements
Examine the SELECT statement
Work with data types
Handle NULLs
2 - Sort and filter results in T-SQL
Sort your results
Limit the sorted results
Page results
Remove duplicates
Filter data with predicates
3 - Combine multiple tables with JOINs in T-SQL
Understand joins concepts and syntax
Use inner joins
Use outer joins
Use cross joins
Use self joins
4 - Write Subqueries in T-SQL
Understand subqueries
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
5 - Use built-in functions and GROUP BY in Transact-SQL
Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING
6 - Modify data with T-SQL
Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables
Additional course details:
Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Learning & Development

Design & Technology Courses (DT)

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIAQQAiADoAMwA3ADIALgAzADgANQA0ADkANAA0ADEANQAyADYANAAxACwAIgBEACIAOgAyADQANwA5AC4AOQA5ADkAOQA5ADkAOQA5ADkAOQA5ADkANQAsACIAQwAiADoANwA2ADcALgA1ADYAOQAwADUANQA1ADgANQA5ADMANwA1ACwAIgBBAD8AIgA6ACIASwAiACwAIgBhACIAOgB7ACIAQQAiADoAWwB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADUAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFcAYQBuAHQAIAB0AG8AIABsAGUAYQByAG4AIABmAHIAbwBtACAAcwBvAG0AZQBvAG4AZQAgAHcAaABvABkgcwAgAGIAZQBlAG4AIABpAG4AIAB5AG8AdQByACAAcwBoAG8AZQBzACAAagB1AHMAdAAgADUAeQByAHMAIABhAGcAbwA/AFwAbgAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAIABJACAAdwBhAHMAIABvAG4AYwBlACAAdwBoAGUAcgBlACAAeQBvAHUAIABhAHIAZQAgAG4AbwB3ACwAIABhAG4AZAAgAEkAJwB2AGUAIABtAGEAZABlACAAZQB4AHAAZQBuAHMAaQB2AGUAIABtAGkAcwB0AGEAawBlAHMAIQAgAFkAbwB1ACAAZwBlAHQAIAB0AG8AIABsAGUAYQByAG4AIABmAHIAbwBtACAAdABoAGUAcwBlACAAYQBuAGQAIABtAHkAIABlAHgAcABlAHIAaQBlAG4AYwBlACAAbwBmACAAYgB1AGkAbABkAGkAbgBnACAAbQB5ACAAdABoAHIAaQB2AGkAbgBnACAAcAByAGEAYwB0AGkAYwBlACAAbwB2AGUAcgAgADUAIAB5AGUAYQByAHMAIQBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiACAASQAgAHcAaQBsAGwAIABkAHIAbwB3AG4AIABvAHUAdAAgAHQAaABlACAAbgBvAGkAcwBlACAAYQBuAGQAIABCAFMALAAgAGwAZQBhAGQAIAB5AG8AdQAgAGIAeQAgAHQAaABlACAAaABhAG4AZAAgAGEAbgBkACAAcwBoAG8AdwAgAHkAbwB1ACAAdwBoAGEAdAAgAHQAbwAgAGQAbwAuACAAIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADUAMQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuACIAfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgAgAEcAZQB0ACAAdABoAGUAIABiAGEAcwBpAGMAcwAgAHIAaQBnAGgAdAAgAGYAcgBvAG0AIAB0AGgAZQAgAHMAdABhAHIAdAAgAHMAbwAgAHkAbwB1ACAAZABvAG4AJwB0ACAAbQBhAGsAZQAgAGUAeABwAGUAbgBzAGkAdgBlACAAbQBpAHMAdABhAGsAZQBzACAAKABsAGUAYQByAG4AIABmAHIAbwBtACAAbQB5ACAAbQBpAHMAdABhAGsAZQBzACEAKQBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiACAAUwBtAGEAbABsACAAaQBuAHYAZQBzAHQAbQBlAG4AdAAgAHQAaABhAHQAIAB3AGkAbABsACAAcwBhAHYAZQAgAHkAbwB1ACAAdABpAG0AZQAgAGEAbgBkACAAbQBvAG4AZQB5ACAAaQBuACAAdABoAGUAIABsAG8AbgBnACAAcgB1AG4AXABuACIAfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFMAbQBhAGwAbAAgAGkAbgB0AGkAbQBhAHQAZQAgAGcAcgBvAHUAcABzACAAbQBlAGEAbgAgAHQAaABlACAAYQBkAHYAaQBjAGUAIABpAHMAIAB0AGEAcgBnAGUAdABlAGQAIAB0AG8AIABpAG4AZABpAHYAaQBkAHUAYQBsAHMALAAgAGEAbgBkACAAZQBhAGMAaAAgAHAAZQByAHMAbwBuACAAaABhAHMAIABkAGkAcgBlAGMAdAAgAGEAYwBjAGUAcwBzACAAdABvACAAbQBlACAAIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIANQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuAEIAZQBnAGkAbgBuAGUAcgAgAHQAbwAgAEIAbwBzAHMAIABpAHMAIABhACAAMQAyACAAdwBlAGUAawAgAG8AbgBsAGkAbgBlACAAcAByAG8AZwByAGEAbQBtAGUAIAB3AGgAaQBjAGgAIABnAGUAbgB0AGwAeQAgAHQAYQBrAGUAcwAgAHkAbwB1ACAAYgB5ACAAdABoAGUAIABoAGEAbgBkACAAYQBuAGQAIABjAHUAdABzACAAdABoAHIAbwB1AGcAaAAgAHQAaABlACAAbgBvAGkAcwBlACAAdABvACAAdABlAGEAYwBoACAAeQBvAHUAIAB0AGgAZQAgAGIAYQBzAGkAYwBzACAAbwBmACAAYgB1AHMAaQBuAGUAcwBzAC4AIABcAG4AIgB9AF0ALAAiAEIAIgA6AFsAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBmAG8AbgB0AC0AcwBpAHoAZQAiADoAewAiAEIAIgA6ACIANQAwAC4AMQA1ADQANgAiAH0ALAAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewAiAEIAIgA6ACIAYgBvAGwAZAAiAH0ALAAiAGQAZQBjAG8AcgBhAHQAaQBvAG4AIgA6AHsAIgBCACIAOgAiAHUAbgBkAGUAcgBsAGkAbgBlACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewAiAEIAIgA6ACIAYwBlAG4AdABlAHIAIgB9ACwAIgBmAG8AbgB0AC0AZgBhAG0AaQBsAHkAIgA6AHsAIgBCACIAOgAiAFkAQQBGAGMAZgByAGcAbABwAFYAQQAsADAAIgB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0ALAAiAGMAbwBsAG8AcgAiADoAewAiAEIAIgA6ACIAIwAwADAAMAAwADAAMAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIAMgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewAiAEIAIgA6ACIAbgBvAHIAbQBhAGwAIgB9ACwAIgBkAGUAYwBvAHIAYQB0AGkAbwBuACIAOgB7AH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAbABpAHMAdAAtAG0AYQByAGsAZQByACIAOgB7ACIAQgAiADoAIgBkAGkAcwBjACIAfQAsACIAbABpAHMAdAAtAGwAZQB2AGUAbAAiADoAewAiAEIAIgA6ACIAMQAuADAAIgB9ACwAIgBoAGUAYQBkAC0AaQBuAGQAZQBuAHQAIgA6AHsAIgBCACIAOgAiADEANwAwADAALgAwACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgA2ADAAMAB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBsAGkAcwB0AC0AbQBhAHIAawBlAHIAIgA6AHsAfQAsACIAbABpAHMAdAAtAGwAZQB2AGUAbAAiADoAewB9ACwAIgBoAGUAYQBkAC0AaQBuAGQAZQBuAHQAIgA6AHsAfQB9AH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA0ADcAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAfQAsACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7AH0ALAAiAGYAbwBuAHQALQBmAGEAbQBpAGwAeQAiADoAewB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9AH0AfQBdAH0ALAAiAGIAIgA6AHsAIgBBACIAOgBbADYANwAsADEAMAAwACwANQA4ACwAOAAzACwAMQAwADAALAA2ADgALAAxACwAMQAwADMALAA0ACwAMQAwADMALAA0ADQAXQB9ACwAIgBkACIAOgAiAEEAIgAsACIAZwAiADoAZgBhAGwAcwBlACwAIgBoACIAOgAiAEEAIgB9AF0ALAAiAEIAIgA6ADIANAA4ADAALAAiAEMAIgA6ADEANwA0ADgAfQA=" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIARAAiADoAMgA0ADgAMAAuADAAMAAwADAAMAAwADAAMAAwADAAMAAwADUALAAiAEMAIgA6ADIANwA3AC4AMAA3ADkANwA4ACwAIgBBAD8AIgA6ACIASwAiACwAIgBhACIAOgB7ACIAQQAiADoAWwB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMwB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAQQByAGUAIAB5AG8AdQAgAGEAIABuAGUAdwBsAHkAIABxAHUAYQBsAGkAZgBpAGUAZAAgAGgAbwBtAGUAbwBwAGEAdABoAC8AdABoAGUAcgBhAHAAaQBzAHQAIABvAHIAIABpAG4AIAB5AG8AdQByACAAMQBzAHQAIAB5AGUAYQByACAAbwBmACAAYgB1AHMAaQBuAGUAcwBzAD8AIABBAHIAZQAgAHkAbwB1ACAAYwBvAG4AZgB1AHMAZQBkACAAYQBuAGQAIABvAHYAZQByAHcAaABlAGwAbQBlAGQALAAgAHQAcgB5AGkAbgBnACAAdABvACAAYgB1AGkAbABkACAAYQAgAHQAaAByAGkAdgBpAG4AZwAgAGIAdQBzAHkAIABwAHIAYQBjAHQAaQBjAGUAPwAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADkAMAB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuACIAfQBdACwAIgBCACIAOgBbAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAIgBCACIAOgAiADYAOQAuADYAMAAxADEAIgB9ACwAIgBmAG8AbgB0AC0AZgBhAG0AaQBsAHkAIgA6AHsAIgBCACIAOgAiAFkAQQBGAGMAZgByAGcAbABwAFYAQQAsADAAIgB9ACwAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAIgBCACIAOgAiAG4AbwByAG0AYQBsACIAfQAsACIAZgBvAG4AdAAtAHMAdAB5AGwAZQAiADoAewAiAEIAIgA6ACIAbgBvAHIAbQBhAGwAIgB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7ACIAQgAiADoAIgBjAGUAbgB0AGUAcgAiAH0ALAAiAGMAbwBsAG8AcgAiADoAewAiAEIAIgA6ACIAIwAwADAAMAAwADAAMAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAMwB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAIgBCACIAOgAiAGIAbwBsAGQAIgB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxADUAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAMwAwAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAHQAZQB4AHQALQBhAGwAaQBnAG4AIgA6AHsAfQB9AH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADgAOQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7ACIAQgAiADoAIgBjAGUAbgB0AGUAcgAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAfQAsACIAZgBvAG4AdAAtAGYAYQBtAGkAbAB5ACIAOgB7AH0ALAAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7AH0AfQB9AF0AfQAsACIAYgAiADoAewAiAEEAIgA6AFsANgA5ACwANwA2ACwAMQAwAF0AfQAsACIAZAAiADoAIgBBACIALAAiAGcAIgA6AGYAYQBsAHMAZQAsACIAaAAiADoAIgBBACIAfQBdACwAIgBCACIAOgAyADQAOAAwACwAIgBDACIAOgAxADcANAA4AH0A" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you a newly qualified homeopath/therapist or in your 1st year of business? Are you confused and overwhelmed, trying to build a thriving busy practice?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Want to learn from someone who&rsquo;s been in your shoes just 5yrs ago? I was once where you are now, and I&#39;ve made expensive mistakes! You get to learn from these and my experience of building my thriving practice over 5 years! I will drown out the noise and BS, lead you by the hand and show you what to do. &nbsp;Get the basics right from the start so you don&#39;t make expensive mistakes (learn from my mistakes!) Small investment that will save you time and money in the long run Small intimate groups mean the advice is targeted to individuals, and each person has direct access to me Beginner to Boss is a 12 week online programme which gently takes you by the hand and cuts through the noise to teach you the basics of business.</p><span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIAQQAiADoAMQAxADcAMQAuADYAOQAwADMANwA5ADYAMgAyADEAOAAxACwAIgBCACIAOgA2ADcAMgAuADgANwAyADIAMQAxADQAOQA1ADQAOAA0ADkALAAiAEQAIgA6ADEAMAA0ADAALgA2ADgAOQA4ADYAOAA1ADYANAAxADEAOAA4ACwAIgBDACIAOgA0ADkAMQAuADkANAA2ADIANgA2ADQAMAAxADgAOQAyADcAMwAsACIAQQA/ACIAOgAiAEsAIgAsACIAYQAiADoAewAiAEEAIgA6AFsAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADkANgA1AH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgBXAGgAYQB0ABkgcwAgAGkAbgBjAGwAdQBkAGUAZAA/AFwAbgAtACAANgAgAHQAZQBhAGMAaABpAG4AZwAgAHMAZQBzAHMAaQBvAG4AcwAgACgAMQBoAHIAKQAgAGMAbwB2AGUAcgBpAG4AZwA6ACAAcwB5AHMAdABlAG0AcwAsACAAbQBhAHIAawBlAHQAaQBuAGcALAAgAGYAaQBuAGEAbgBjAGUAcwAgAGEAbgBkACAAYgBvAHUAbgBkAGEAcgBpAGUAcwBcAG4ALQAgADYAIABpAG0AcABsAGUAbQBlAG4AdABhAHQAaQBvAG4AIABzAGUAcwBzAGkAbwBuAHMAIAAoADEAaAByACkAIAB3AGgAZQByAGUAIAB5AG8AdQAgAGgAYQB2AGUAIABhACAAYwBoAGEAbgBjAGUAIAB0AG8AIABhAHMAawAgAG0AZQAgAHEAdQBlAHMAdABpAG8AbgBzACwAIABsAGUAYQByAG4AIABmAHIAbwBtACAAeQBvAHUAcgAgAHAAZQBlAHIAcwAsACAAZwBlAHQAIABhAGMAYwBvAHUAbgB0AGEAYgBpAGwAaQB0AHkAIABhAG4AZAAgAGMAbwBuAHMAbwBsAGkAZABhAHQAZQAgAHkAbwB1AHIAIABsAGUAYQByAG4AaQBuAGcALgBcAG4ALQAgAEEAbABsACAAcwBlAHMAcwBpAG8AbgBzACAAdABvACAAYgBlACAAcgBlAGMAbwByAGQAZQBkACAAYQBuAGQAIABhAGMAYwBlAHMAcwBpAGIAbABlACAAdABvACAAcABhAHIAdABpAGMAaQBwAGEAbgB0AHMALgBcAG4ALQAgAEEAYwBjAGUAcwBzACAAdABvACAAYQAgAHAAcgBpAHYAYQB0AGUAIABGAEIAIABnAHIAbwB1AHAAIAB3AGgAZQByAGUAIABJACAAdwBpAGwAbAAgAGIAZQAgAGwAaQB2AGUAIABlAGEAYwBoACAAdwBlAGUAawAgAHQAbwAgAGEAbgBzAHcAZQByACAAcQB1AGUAcwB0AGkAbwBuAHMAXABuAC0AIABNAGEAcwB0AGUAcgBtAGkAbgBkACAAdwBoAGkAYwBoACAAdwBpAGwAbAAgAG4AbwB0ACAAYgBlACAAdABoAGkAcwAgAGcAbwBvAGQAIAB2AGEAbAB1AGUAIABlAHYAZQByACAAYQBnAGEAaQBuAFwAbgAtACAAQQBjAGMAZQBzAHMAIAB0AG8AIABkAGkAcwBjAG8AdQBuAHQAZQBkACAAMQAyADEAIABtAGUAbgB0AG8AcgAgAHMAZQBzAHMAaQBvAG4AcwAgAGEAdAAgAGUAbgBkACAAbwBmACAAcAByAG8AZwByAGEAbQBtAGUALgAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMgA1ADkAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFwAbgAiAH0AXQAsACIAQgAiADoAWwB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQBzAGkAegBlACIAOgB7ACIAQgAiADoAIgA0ADAALgAwACIAfQAsACIAZgBvAG4AdAAtAGYAYQBtAGkAbAB5ACIAOgB7ACIAQgAiADoAIgBZAEEARgBjAGYAcgBnAGwAcABWAEEALAAwACIAfQAsACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0ALAAiAGYAbwBuAHQALQBzAHQAeQBsAGUAIgA6AHsAIgBCACIAOgAiAG4AbwByAG0AYQBsACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewAiAEIAIgA6ACIAYwBlAG4AdABlAHIAIgB9ACwAIgBjAG8AbABvAHIAIgA6AHsAIgBCACIAOgAiACMAMAAwADAAMAAwADAAIgB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxADcANAAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQBzAGkAegBlACIAOgB7AH0ALAAiAGYAbwBuAHQALQBmAGEAbQBpAGwAeQAiADoAewB9ACwAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAfQAsACIAZgBvAG4AdAAtAHMAdAB5AGwAZQAiADoAewB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9AH0AfQBdAH0ALAAiAGIAIgA6AHsAIgBBACIAOgBbADEANwAsADcAMQAsADEAMQAsADYAOAAsADYAOQAsADEANQAsADYAMgAsADcAMgAsADEAMAAsADUAOAAsADYANABdAH0ALAAiAGQAIgA6ACIAQQAiACwAIgBlACIAOgAxADIAOAA2AC4AMQA5ADYAMgA0ADMAOQA4ADEANwA5ADkANgAsACIAZgAiADoANgAwADgALAAiAGcAIgA6AGYAYQBsAHMAZQAsACIAaAAiADoAIgBBACIAfQBdACwAIgBCACIAOgAyADQAOAAwACwAIgBDACIAOgAxADcANAA4AH0A" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What&rsquo;s included?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- 6 teaching sessions (1hr) covering: systems, marketing, finances and boundaries&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- 6 implementation sessions (1hr) where you have a chance to ask me questions, learn from your peers, get accountability and consolidate your learning.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- All sessions to be recorded and accessible to participants.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Access to a private FB group where I will be live each week to answer questions&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Mastermind which will not be this good value ever again&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Access to discounted 121 mentor sessions at end of programme.</p>

Are you a newly qualified homeopath/therapist or in your 1st year of business? Are you confused and overwhelmed, trying to build a thriving busy practice?
Want to learn from someone who’s been in your shoes just 5yrs ago? I was once where you are now, and I've made expensive mistakes! You get to learn from these and my experience of building my thriving practice over 5 years! I will drown out the noise and BS, lead you by the hand and show you what to do. Get the basics right from the start so you don't make expensive mistakes (learn from my mistakes!) Small investment that will save you time and money in the long run Small intimate groups mean the advice is targeted to individuals, and each person has direct access to me Beginner to Boss is a 12 week online programme which gently takes you by the hand and cuts through the noise to teach you the basics of business.
What’s included? 
- 6 teaching sessions (1hr) covering: systems, marketing, finances and boundaries 
- 6 implementation sessions (1hr) where you have a chance to ask me questions, learn from your peers, get accountability and consolidate your learning. 
- All sessions to be recorded and accessible to participants. 
- Access to a private FB group where I will be live each week to answer questions 
- Mastermind which will not be this good value ever again 
- Access to discounted 121 mentor sessions at end of programme.

Homeopathic Harmony

As a qualified homeopath of 5yrs, I've put together a brilliant offer for newly-qualified homeopaths who know all about remedies but almost nothing about running a successful, busy homeopathy practice. 

Very limited spaces, and the last time it will be this cheap before prices go up. 

You'll get a mix of group learning and direct access to me (learning from my mistakes so you don't have to waste time and money on making the same!). 

Beginner to Boss

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">One hour webinar aimed at relative newcomers to road rallying, learn the basics of plotting map references, map reading, types of controls and timing.</p>

One hour webinar aimed at relative newcomers to road rallying, learn the basics of plotting map references, map reading, types of controls and timing.

Rally Navigation Training Services

Sports & Fitness

Online webinar aimed at newcomers and beginners to road rallying helping to learn the basics.

Rally Navigation - Road Rallying Introduction

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. &nbsp; At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Programme</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 1: Basic Shapes (1)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 2: Basic Shapes and Use of a Quilling Comb (2)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 3: Flower and Butterfly: Picture 8&rdquo; x 10&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 6: Basket of Flowers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 7: Cherry Blossom Box</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 8: 2 x 5&rdquo; x 7&rdquo; Pictures: Duck and Boat</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 11: Pot of Lavender (1)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 10: Pot of Lavender (2)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will receive all the materials and items of equipment needed to complete the course. These are yours to keep:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Materials and Equipment</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong>Quilling Kit:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: a variety of colours</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: white</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Board</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Needlemaker&#39;s Wheel of Pins</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Formers x 2&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Comb</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 Pair Tweezers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Pokey Tool</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Short</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Long</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Scissors</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Glue Applicator</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Book Binders&rsquo; Glue 30 ml</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Black and white 300 gsm card for box and picture</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(65, 65, 65); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(65, 65, 65); font-size: 14px;">Craft4Smiles C.I.C. is crafting community that&nbsp;</span><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. &nbsp;Anyone who wants to learn new skills can join our programmes. &nbsp;No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays!&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></p>

A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful. 
Programme
Week 1: Basic Shapes (1)
Week 2: Basic Shapes and Use of a Quilling Comb (2) 
Week 3: Flower and Butterfly: Picture 8” x 10”
Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter
Week 6: Basket of Flowers
Week 7: Cherry Blossom Box
Week 8: 2 x 5” x 7” Pictures: Duck and Boat
Week 11: Pot of Lavender (1) 
Week 10: Pot of Lavender (2)
You will receive all the materials and items of equipment needed to complete the course. These are yours to keep: 
Materials and Equipment
 Quilling Kit: 
Quilling Paper Strips: 39 mm: a variety of colours
Quilling Paper Strips: 39 mm: white
Quilling Board
Needlemaker's Wheel of Pins
Quilling Formers x 2 
Quilling Comb
1 Pair Tweezers
Pokey Tool
Quilling Tool: Short
Quilling Tool: Long
Scissors
Glue Applicator
Book Binders’ Glue 30 ml
Black and white 300 gsm card for box and picture
Craft4Smiles C.I.C. is crafting community that provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. 
Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. Anyone who wants to learn new skills can join our programmes. No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. 
Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays! 


Craft4Smiles C.I.C. 

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors.   At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf!  All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.  

Quilling

Craft4Smiles Cademy Launch

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening 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.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening 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. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

509 Basic courses in Leeds

HACCP Trainer - Level 2 HACCP Training Course - On-site Nationwide

By Kitchen Tonic Training Company and Food Safety Consultants

NPORS MEWP Boom (N108)

By Dynamic Training and Assessments Ltd

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

By EnergyEdge - Training for a Sustainable Energy Future

NPORS Multi Directional Lift Truck (N135)

By Dynamic Training and Assessments Ltd

NPORS Forward Tipping Dumper (N204)

By Dynamic Training and Assessments Ltd

NPORS Road Roller (N214)

By Dynamic Training and Assessments Ltd

NPORS Rear Tipping Dumper (N205)

By Dynamic Training and Assessments Ltd

NPORS Forward Tipping Mini Dumper (N139)

By Dynamic Training and Assessments Ltd

Introduction to the Voluntary and Community Sector

By SAVO CIC

Nail Technician Level 3

By Penelope Academy

Search By Location