Name: Nemstar's CISSP Programme
Price: 2754 GBP
Availability: InStock

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need some help with science homework? Or striving for those top grades in class? We&#39;re here to help. At &pound;25 per hour we offer bespoke KS3 Chemistry tuition focused on the topics you want in a way that helps you learn best.&nbsp;</p>

Need some help with science homework? Or striving for those top grades in class? We're here to help. At £25 per hour we offer bespoke KS3 Chemistry tuition focused on the topics you want in a way that helps you learn best. 

Savvy Tutor

Need some help with science homework? Or striving for those top grades in class? Savvytutor is here to help.

KS3 Chemistry Tuition (1 hour)

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need some help with science homework? Or striving for those top grades in class? We&#39;re here to help. At &pound;25 per hour we offer bespoke KS3 biology tuition focused on the topics you want in a way that helps you learn best.&nbsp;</p>

Need some help with science homework? Or striving for those top grades in class? We're here to help. At £25 per hour we offer bespoke KS3 biology tuition focused on the topics you want in a way that helps you learn best. 

KS3 Biology Tuition (1 hour)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need some help with science homework? Or striving for those top grades in class? We&#39;re here to help. At &pound;25 per hour we offer bespoke KS4 Physics tuition focused on the topics you want in a way that helps you learn best.&nbsp;</p>

Need some help with science homework? Or striving for those top grades in class? We're here to help. At £25 per hour we offer bespoke KS4 Physics tuition focused on the topics you want in a way that helps you learn best. 

KS4 Physics Tuition (1 hour)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need some help with science homework? Or striving for those top grades in class? We&#39;re here to help. At &pound;25 per hour we offer bespoke KS3 Physics tuition focused on the topics you want in a way that helps you learn best.&nbsp;</p>

Need some help with science homework? Or striving for those top grades in class? We're here to help. At £25 per hour we offer bespoke KS3 Physics tuition focused on the topics you want in a way that helps you learn best. 

KS3 Physics Tuition (1 hour)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need some help with science homework? Or striving for those top grades in class? We&#39;re here to help. At &pound;25 per hour we offer bespoke KS4 Chemistry tuition focused on the topics you want in a way that helps you learn best.&nbsp;</p>

Need some help with science homework? Or striving for those top grades in class? We're here to help. At £25 per hour we offer bespoke KS4 Chemistry tuition focused on the topics you want in a way that helps you learn best. 

KS4 Chemistry Tuition (1 hour)

<p class="about-class-section__description-paragraph">Fiber art is a craft that deserves to be shared. During these workshops, I will guide you through the process of working with macram&eacute;, to make a do-it-yourself, unique macram&eacute; lobster! Treat yourself (or a friend), take the time, and enjoy the fact that you can quickly visualize the results of your work.</p>
<p class="about-class-section__description-paragraph">More benefits: no mistakes possible (you can always start over during the process), and great for reflexes and memory!</p>
<p class="about-class-section__description-paragraph">Learn to make your own macrame lobster in this beginner macrame class! No prior experience is needed. In this workshop, instructor Rahamatullah will lead as you&hellip;</p>

Fiber art is a craft that deserves to be shared. During these workshops, I will guide you through the process of working with macramé, to make a do-it-yourself, unique macramé lobster! Treat yourself (or a friend), take the time, and enjoy the fact that you can quickly visualize the results of your work.
More benefits: no mistakes possible (you can always start over during the process), and great for reflexes and memory!
Learn to make your own macrame lobster in this beginner macrame class! No prior experience is needed. In this workshop, instructor Rahamatullah will lead as you…

Golden Rope

Arts & Crafts

Macrame

Building & DIY

Learn to make a macrame lobster which is very attractive and beautiful. You can use it a home decor or use it as a hanging flower vase .


Learn to make a macrame lobster

General admission

<p>Delve into the Train the Trainer's principles   Obtain the abilities required to raise your competence in this field   Get a grasp of level 3,5,7 with a certificate of level 7 knowledge   All with this Imperial Academy's all-inclusive course.</p> <p>Enrol now to gain different level knowledge all at one place. Be assured of your knowledge reservoir with Imperial Academy as your learning partner.</p> <p>This detailed training is the perfect place for you if you want to discover crucial tactics, and advice for accelerating both personal and career growth. You will experience this support with our Quality License Scheme endorsed course. By taking advantage of any amenities offered by the course, you can learn about numerous aspects of Train the Trainer. The extensive course was created with a specific goal in mind   to illuminate the route to your desired level of accomplishment in this sector.</p> <p><strong>This skill building </strong><strong>training </strong><strong>includes  </strong></p> <ul> <li>1 QLS Certificate</li><li>CPD Certifications (PDF and Hard Copy)</li><li>24/7 Tutor Support</li></ul><p>This online course's curriculum was designed by experts using their skills and in-depth knowledge. By equipping you with the relevant knowledge and ideas, Imperial Academy's curriculum was created to help you advance in your current position. You will discover the principles of Train the Trainer as you move through the modules of this course and learn about its key ideas, including things like  </p> <p><strong>Level 3 </strong></p> <ul> <li>Train the Trainer - Part 1</li><li>Introduction and Welcome</li><li>Make Them Feel Safe Before Class</li><li>Start with an amazing opener</li><li>Build Credibility and Rapport Qui</li><li>Workbook - Train the Trainer - Part 1</li></ul> <p><strong>Level 5</strong></p> <ul> <li>Training on Facilitating Classroom Activity</li><li>Introduction and Welcome</li><li>Get Buy-In for the Activity</li><li>Find Trainees Who Need Help</li><li>Tutor Effectively During Activities</li><li>Manage the Activity Pace</li><li>Prepare to Lead an Activity</li><li>Workbook - Training on Facilitating Classroom Activity</li><li>Train the Trainer Coach: Complete Guide to Coaching Trainers</li><li>Resources - Train the Trainer Coach: Complete Guide to Coaching Trainers</li></ul> <p><strong>Level 7</strong></p> <ul> <li>Train the Trainer Coliseum: How to Train Very Large Classes</li><li>Hook A Large Class</li><li>Teach A Large Class</li><li>Support A Large Class</li><li>Workbook - Train the Trainer Coliseum: How to Train Very Large Classes</li><li>Train the Trainer Recharge: The Healthy Trainer</li><li>Welcome to Healthy Trainer</li><li>Manage Yourself</li><li>Manage Your Issues</li><li>Manage Your Classroom</li><li>Manage Your Audience</li><li>Manage Your Feedback</li><li>Resources - Train the Trainer Recharge: The Healthy Trainer</li><li>Train the Trainer Serenity Course</li><li>Welcome to Serenity</li><li>Stop Interruptions</li><li>Handle Negativity</li><li>Manage Inattention</li><li>Workbook - Train the Trainer Serenity Course</li></ul> <p><strong>Quality Licence Scheme Endorsed Certificate of Achievement</strong></p> <p>Learners will get a Level 7 QLS endorsed certificate (included with the course) directly at their doorstep after successfully completing this course! It should be noted that international students must pay a £10 shipping cost.</p> <p><strong>Disclaimer</strong></p> <p>This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. One Education will be able to advise you on any further recognition. For further information please visit the Learner FAQs on the Quality Licence Scheme website.</p> <p>Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        180 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>If you want to understand the global influence of Train the Trainer, you should take this course. Anyone working in the sector, whether they are a novice or a pro, would benefit from comprehending the Train the Trainer issues to solve them. This program contains vital topics that will assist you in overcoming obstacles and enhancing your practices.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Anyone can enrol in this course.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>After completing this course, you are to start your career or begin the next phase of your career in this field.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

Delve into the Train the Trainer's principles Obtain the abilities required to raise your competence in this field Get a grasp of level 3,5,7 with a certificate of level 7 knowledge All with this Imperial Academy's all-inclusive course.
Enrol now to gain different level knowledge all at one place. Be assured of your knowledge reservoir with Imperial Academy as your learning partner.
This detailed training is the perfect place for you if you want to discover crucial tactics, and advice for accelerating both personal and career growth. You will experience this support with our Quality License Scheme endorsed course. By taking advantage of any amenities offered by the course, you can learn about numerous aspects of Train the Trainer. The extensive course was created with a specific goal in mind to illuminate the route to your desired level of accomplishment in this sector.
This skill building training includes 
1 QLS Certificate
CPD Certifications (PDF and Hard Copy)
24/7 Tutor Support
This online course's curriculum was designed by experts using their skills and in-depth knowledge. By equipping you with the relevant knowledge and ideas, Imperial Academy's curriculum was created to help you advance in your current position. You will discover the principles of Train the Trainer as you move through the modules of this course and learn about its key ideas, including things like 
Level 3 
Train the Trainer - Part 1
Introduction and Welcome
Make Them Feel Safe Before Class
Start with an amazing opener
Build Credibility and Rapport Qui
Workbook - Train the Trainer - Part 1
Level 5
Training on Facilitating Classroom Activity
Introduction and Welcome
Get Buy-In for the Activity
Find Trainees Who Need Help
Tutor Effectively During Activities
Manage the Activity Pace
Prepare to Lead an Activity
Workbook - Training on Facilitating Classroom Activity
Train the Trainer Coach: Complete Guide to Coaching Trainers
Resources - Train the Trainer Coach: Complete Guide to Coaching Trainers
Level 7
Train the Trainer Coliseum: How to Train Very Large Classes
Hook A Large Class
Teach A Large Class
Support A Large Class
Workbook - Train the Trainer Coliseum: How to Train Very Large Classes
Train the Trainer Recharge: The Healthy Trainer
Welcome to Healthy Trainer
Manage Yourself
Manage Your Issues
Manage Your Classroom
Manage Your Audience
Manage Your Feedback
Resources - Train the Trainer Recharge: The Healthy Trainer
Train the Trainer Serenity Course
Welcome to Serenity
Stop Interruptions
Handle Negativity
Manage Inattention
Workbook - Train the Trainer Serenity Course
Quality Licence Scheme Endorsed Certificate of Achievement
Learners will get a Level 7 QLS endorsed certificate (included with the course) directly at their doorstep after successfully completing this course! It should be noted that international students must pay a £10 shipping cost.
Disclaimer
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. One Education will be able to advise you on any further recognition. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education.
 CPD 
180 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
If you want to understand the global influence of Train the Trainer, you should take this course. Anyone working in the sector, whether they are a novice or a pro, would benefit from comprehending the Train the Trainer issues to solve them. This program contains vital topics that will assist you in overcoming obstacles and enhancing your practices.
 Requirements 
Anyone can enrol in this course.
 Career path 
After completing this course, you are to start your career or begin the next phase of your career in this field.
 Certificates 
Certificate of completion
 Hard copy certificate - Included 

Imperial Academy

Certificate in Education & Training (CET)

Life Coach Training

Teacher Training

Trainers Course

Train the Trainer (TTT)

Teaching & Training

Level 7 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 180 CPD Points | Lifetime Access

Level 3, 5, & 7 Train the Trainer

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">The CISSP is much more than just an exam and our CISSP Programme is much more than an exam bootcamp. 5 Day Consultant led course, 4 weeks of exam cram webinars, 1000&rsquo;s of practice questions, tailored study plans, real-life examples, full post course support, notes from the field. Nothing is left to chance in our totally unique CISSP programme which has been constantly developed and improved over the last 16 years.</span></p><div style="color: rgb(98, 98, 98); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Certified Information Systems Security Professional certification has the respect of the global InfoSec industry because passing the exam demands complete mastery of all areas of Information Security, from cryptology to secure coding, from Pen Testing to Program Management. &nbsp;No area escapes the CISSP exam.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our unique 5 day workshop prepares you for a first time pass of your CISSP exam. &nbsp;Covering each of the famous 8 CBK&#39;s, cram the theory before testing your knowledge during exam simulations. &nbsp;Led by a multi-award winning InfoSec consultant, this workshop delivers everything you need to pass, as 1000&#39;s of successful CISSPs from our programme, which started in 2004, can vouch for!&nbsp;</p></div><div style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><h3 style="color: rgb(126, 121, 125); box-sizing: border-box;" fr-original-style=" color: rgb(126, 121, 125);">Prerequisites</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course requires a min of 3+ years&rsquo; experience working in one of the fields of IS, IT, Networking or software development. A detailed understanding of TCP/IP networking is highly recommended. No other InfoSec experience is required.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note full CISSP membership requires &ldquo;<i fr-original-style="" style="box-sizing: border-box;">a minimum of five years of direct full-time security professional work experience in one or more of the eight domains&nbsp;</i>&rdquo;. Associate membership may be available for those that do not meet the requirements for full membership but have passed the exam.</p></div><div style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><h3 style="color: rgb(126, 121, 125); box-sizing: border-box;" fr-original-style=" color: rgb(126, 121, 125);">Exam</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The CISSP exam contains 100 to 150 multiple-choice questions taken over a 3-hour testing window at one of 1000&rsquo;s of testing locations thoughout Europe. Regarded as one of the toughest exams in the industry, achieving a pass is the career highlight for many InfoSec specialists.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please note that the</strong>&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">exam and exam cost is not included with the course.</strong>&nbsp;3-6 weeks post-course study is recommended before attempting the exam.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></div><div style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><h3 style="color: rgb(126, 121, 125); box-sizing: border-box;" fr-original-style=" color: rgb(126, 121, 125);">Overview</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">CISSP is essential for anyone wishing to progress their career in the rapidly expanding fields of Information Security, Risk and Cyber. &nbsp;From those wishing to change role to those seeking the senior business risk role, CISSP is the global standard of excellence for all IS Professionals</p></div><div style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><h3 style="color: rgb(126, 121, 125); box-sizing: border-box;" fr-original-style=" color: rgb(126, 121, 125);">Outline</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Covering all the 8 Domains of Knowledge required for success, this program guarantees you the best possible First Time Pass chance. You will cover all the following in-depth &amp; in-detail with real-life examples:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Security and Risk Management</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Asset Security</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Security Engineering</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Communication and Network Security</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Identity and Access Management</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Security Assessment and Testing</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Security Operations</b></li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Software Development Security</b></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></div><div style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><h3 style="color: rgb(126, 121, 125); box-sizing: border-box;" fr-original-style=" color: rgb(126, 121, 125);">The Programme</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">5 Day intensive online classroom workshop led by a highly experienced Security Consultant</li><li fr-original-style="" style="box-sizing: border-box;">3 Week post-training study and mentoring programme INCLUDED</li><li fr-original-style="" style="box-sizing: border-box;">Comprehensive, best-in-class, study pack with study material and 1000&rsquo;s of sample questions</li></ul></div>

The CISSP is much more than just an exam and our CISSP Programme is much more than an exam bootcamp. 5 Day Consultant led course, 4 weeks of exam cram webinars, 1000’s of practice questions, tailored study plans, real-life examples, full post course support, notes from the field. Nothing is left to chance in our totally unique CISSP programme which has been constantly developed and improved over the last 16 years.
The Certified Information Systems Security Professional certification has the respect of the global InfoSec industry because passing the exam demands complete mastery of all areas of Information Security, from cryptology to secure coding, from Pen Testing to Program Management. No area escapes the CISSP exam.
Our unique 5 day workshop prepares you for a first time pass of your CISSP exam. Covering each of the famous 8 CBK's, cram the theory before testing your knowledge during exam simulations. Led by a multi-award winning InfoSec consultant, this workshop delivers everything you need to pass, as 1000's of successful CISSPs from our programme, which started in 2004, can vouch for! 
Prerequisites
This course requires a min of 3+ years’ experience working in one of the fields of IS, IT, Networking or software development. A detailed understanding of TCP/IP networking is highly recommended. No other InfoSec experience is required.
Please note full CISSP membership requires “a minimum of five years of direct full-time security professional work experience in one or more of the eight domains ”. Associate membership may be available for those that do not meet the requirements for full membership but have passed the exam.
Exam
The CISSP exam contains 100 to 150 multiple-choice questions taken over a 3-hour testing window at one of 1000’s of testing locations thoughout Europe. Regarded as one of the toughest exams in the industry, achieving a pass is the career highlight for many InfoSec specialists. Please note that the exam and exam cost is not included with the course. 3-6 weeks post-course study is recommended before attempting the exam.
 
Overview
CISSP is essential for anyone wishing to progress their career in the rapidly expanding fields of Information Security, Risk and Cyber. From those wishing to change role to those seeking the senior business risk role, CISSP is the global standard of excellence for all IS Professionals
Outline
Covering all the 8 Domains of Knowledge required for success, this program guarantees you the best possible First Time Pass chance. You will cover all the following in-depth & in-detail with real-life examples:
Security and Risk Management
Asset Security
Security Engineering
Communication and Network Security
Identity and Access Management
Security Assessment and Testing
Security Operations
Software Development Security
 
The Programme
5 Day intensive online classroom workshop led by a highly experienced Security Consultant
3 Week post-training study and mentoring programme INCLUDED
Comprehensive, best-in-class, study pack with study material and 1000’s of sample questions

Nemstar Ltd

Information Security (IS)

Cyber Security

Cissp

Our unique 5 day workshop prepares you for a first time pass of your CISSP exam.  Covering each of the famous 8 CBK's, cram the theory before testing your knowledge during exam simulations.  Led by a multi-award winning InfoSec consultant, this workshop delivers everything you need to pass,

Nemstar's CISSP Programme

Bournemouth

Our Virtual (via Zoom) course provide the same high-quality tuition as our classroom-based sessions. Quarterly meetings will take place at the Academy



Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices.

Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse.


Discover the exciting world of dental nursing and be a part of a growing field that offers endless opportunities for growth and development.
How will you learn?
In addition to our traditional class-based tuition, we also offer Virtual (via Zoom) Learning courses to cater to different learning preferences. Our Virtual Learning courses provide the same high-quality tuition as our classroom-based sessions. To participate, you will need a laptop, PC, smart phone or tablet with a built-in or external camera and microphone. From the comfort of your own home, you will have the opportunity to communicate with your tutor and classmates through video chat, using your phone or computer camera. This allows for seamless interaction, discussions, and collaborative learning.

Quarterly meetings at the Academy
To ensure a well-rounded learning experience, you will be required to attend face-to-face lessons at the Academy on a quarterly basis, which means every three months. These sessions serve several important purposes:

Practical Units: Some aspects of the course require hands-on practical training. The face-to-face lessons will cover these practical units, allowing you to gain valuable experience and apply the knowledge you have acquired during the virtual learning sessions.

Tests and Mock Exams: These assessments are important for evaluating your progress, identifying areas for improvement, and preparing you for the final exams. The Academy will provide a controlled and supervised environment to ensure the integrity and fairness of these assessments.
Attending quarterly face-to-face lessons provides a balanced approach to your learning journey. It combines the convenience and flexibility of virtual learning with the benefits of in-person interactions, practical training, and assessments. By participating in these sessions, you will have the opportunity to reinforce your knowledge, receive personalized feedback, and build a stronger connection with your tutor and classmates.
The Academy is dedicated to supporting your growth and success in dental nursing field, and the face-to-face lessons are an integral part of that commitment.



Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others.


The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry.
Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied.

Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care.

Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field.
No previous experience required – we will teach you from A to Z.
Do you need a job?
Yes, you will have 3 months’ time from the start of your course to find a placement.
The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employee in case you need it.
The course is ideal for you if:
You are looking for a qualification that leads to employment
You intend to participate within dentistry and make a positive contribution to the dental health
You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety
You enjoy interacting with multidisciplinary team and different people


The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations!
Free services– workshops, mock exams, eRoE marking and internal moderation.


Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 14 years and looking to recruit more Trainee Dental Nurses.
Working together – At our Dental Department, we prioritise working together with our learners every step of the way. We firmly believe in providing unwavering support, equipping you with the necessary tools, skills, and assistance to ensure your success. We take immense pride in the achievements of our students, with a long list of graduates boasting remarkable success stories. Our commitment to your success serves as the foundation for our own accomplishments
What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work. Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a.
When are the exams?
There are two exams:
1. Multiple choice theory exam. November and March.
2. Practical exam. January and June. 
Record of Experience (eROE)
To be eligible to sit your first exam, you have to complete your electronic Record of Experience (eROE). The eROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. 
London Waterloo Academy supports Mouth Cancer Research Foundation and encouraging learners to raise the awareness and participate in annual 10k walk.



Study mode – virtual (via Zoom) live stream lessons combined with a quarterly meetings Saturday/Sunday at the Academy
Duration – 1 year (part time)
Virtual (via Zoom) classes – once a week
Quarterly meetings at the Academy – date are discussed with the group in advance
Next Intake/start dates (please choose one for your course to start):
21 September 2024, Saturday classes from 9am to 11am
Registration fee – £300 (includes: administration, workshops, mock exams, RoE marking, internal moderation of RoE)
Tuition Fees – £1,400 (we offer payment plan, and accept instalments)
Exam fee – £510 will be charged at the point of candidate registration with NEBDN
One day introduction course – for those who are considering/not sure whether to step up into the Dental Industry £50.00
Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
Office location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk))

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

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)

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Manchester

Leeds

Bingley

Peterborough

Nottingham

Paisley

Derby

Luton

Hull

Northampton

Swansea

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (Foundation Degree Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.


Attend a classroom location to complete your practical training.


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:
PART 1 - THEORY (ONLINE)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


Advanced Phlebotomy - Skills & Techniques (GPT005)

Reading

<p align="justify" style="color: rgb(125, 125, 125); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(125, 125, 125);">This course has been designed and approved by the ILM (Institute of Leadership and Management). The recognition from the ILM means delegates receive an ILM Recognised Certificate from the ILM upon successful completion of the course.</p><p align="justify" style="color: rgb(125, 125, 125); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);">All of our ILM Programmes are provided in partnership with&nbsp;<a href="https://www.thebcfgroup.co.uk/interpersonal/train-the-trainer.php" style="color: rgb(17, 86, 166); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(17, 86, 166);">The BCF Group</a>, which is the ILM Approved Centre we deliver under.</p><p align="justify" style="color: rgb(125, 125, 125); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(17, 86, 166);">Venue Details</h3><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Nottingham</h5><p style="color: rgb(125, 125, 125); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);">The BCF Group Ltd, 5 Wheatcroft Business Park, Landmere Lane, Edwalton, Nottingham, NG12 4DG</p><img src="https://www.dicksontraining.com/images/wheelchair-icon.jpg" alt="" width="20" height="20" border="0" style="color: rgb(125, 125, 125); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="color: rgb(125, 125, 125);" fr-original-class="fr-draggable"><span style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style="color: rgb(125, 125, 125);">&nbsp;Suitable for Wheelchairs</span><br style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><img src="https://www.dicksontraining.com/images/venue-pics/nottingham.png" alt="" width="150" height="96" border="0" style="color: rgb(125, 125, 125); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="color: rgb(125, 125, 125);" fr-original-class="fr-draggable"><p align="justify" style="color: rgb(125, 125, 125); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);">All Nottingham courses are held at the head office of The BCF Group. The comfortable training suites (which are situated on ground level, as well as the toilet facilities, making them wheelchair-friendly) are fully air conditioned with natural daylight. Plentiful on-site free car parking is also available.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><article style="color: rgb(125, 125, 125); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(125, 125, 125);"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">In-House Courses</h3><section fr-original-style="" style="box-sizing: border-box;"><img src="https://www.dicksontraining.com/images/group1a.png" alt="In-House Training Courses" title="In-House Training Courses" width="327" height="219" border="0" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Train The Trainer course has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry.</p><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course syllabus is flexible and can be tailored to the specific requirements of your organisation and industry.</p><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you would like to discuss how we can tailor this Train The Trainer course for you and/or run it at your premises, please contact us.</p></section></article><br style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><a name="Coursedates" style="color: rgb(17, 86, 166); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(17, 86, 166);"></a><article style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Scheduled Courses</h3><section fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Classroom Course - Nottingham (NG12 4DG)</h5><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.</p><p align="justify" 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: &pound;895 + vat</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strike fr-original-style="" style="box-sizing: border-box;">16-17 April 2024</strike>&nbsp;- COURSE FULL</li><li fr-original-style="" style="box-sizing: border-box;">29-30 April 2024</li><li fr-original-style="" style="box-sizing: border-box;">18-19 June 2024</li><li fr-original-style="" style="box-sizing: border-box;">15-16 August 2024</li><li fr-original-style="" style="box-sizing: border-box;">14-15 October 2024</li><li fr-original-style="" style="box-sizing: border-box;">03-04 December 2024</li></ul><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Classroom Course - Reading (RG41 5QS)</h5><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.</p><p align="justify" 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: &pound;895 + vat</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">05-06 March 2024</li><li fr-original-style="" style="box-sizing: border-box;">25-26 June 2024</li><li fr-original-style="" style="box-sizing: border-box;">26-27 September 2024</li><li fr-original-style="" style="box-sizing: border-box;">05-06 December 2024</li></ul><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Zoom&trade; Course</h5><p align="justify" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same.</p><p align="justify" 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: &pound;795 + vat</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">March 2024</strong>&nbsp;- 25th March (morning), 25th March (afternoon), 26th March (morning), 26th March (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">May 2024</strong>&nbsp;- 21st May (morning), 21st May (afternoon), 22nd May (morning), 22nd May (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">July 2024</strong>&nbsp;- 18th July (morning), 18th July (afternoon), 19th July (morning), 19th July (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">September 2024</strong>&nbsp;- 18th September (morning), 18th September (afternoon), 19th September (morning), 19th September (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">November 2024</strong>&nbsp;- 13th November (morning), 13th November (afternoon), 14th November (morning), 14th November (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">January 2025</strong>&nbsp;- 21st January (morning), 21st January (afternoon), 22nd January (morning), 22nd January (afternoon)</li></ul></section></article><section style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><section style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><article style="color: rgb(125, 125, 125); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(125, 125, 125);"><br fr-original-style="" style="box-sizing: border-box;"></article></section></section>

This course has been designed and approved by the ILM (Institute of Leadership and Management). The recognition from the ILM means delegates receive an ILM Recognised Certificate from the ILM upon successful completion of the course.
All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under.





Venue Details
Nottingham
The BCF Group Ltd, 5 Wheatcroft Business Park, Landmere Lane, Edwalton, Nottingham, NG12 4DG

Suitable for Wheelchairs

All Nottingham courses are held at the head office of The BCF Group. The comfortable training suites (which are situated on ground level, as well as the toilet facilities, making them wheelchair-friendly) are fully air conditioned with natural daylight. Plentiful on-site free car parking is also available.



In-House Courses

Our Train The Trainer course has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry.
The course syllabus is flexible and can be tailored to the specific requirements of your organisation and industry.
If you would like to discuss how we can tailor this Train The Trainer course for you and/or run it at your premises, please contact us.



Scheduled Courses
Classroom Course - Nottingham (NG12 4DG)
Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.
Cost: £895 + vat
16-17 April 2024 - COURSE FULL
29-30 April 2024
18-19 June 2024
15-16 August 2024
14-15 October 2024
03-04 December 2024
Classroom Course - Reading (RG41 5QS)
Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.
Cost: £895 + vat
05-06 March 2024
25-26 June 2024
26-27 September 2024
05-06 December 2024
Zoom™ Course
Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same.
Cost: £795 + vat
March 2024 - 25th March (morning), 25th March (afternoon), 26th March (morning), 26th March (afternoon)
May 2024 - 21st May (morning), 21st May (afternoon), 22nd May (morning), 22nd May (afternoon)
July 2024 - 18th July (morning), 18th July (afternoon), 19th July (morning), 19th July (afternoon)
September 2024 - 18th September (morning), 18th September (afternoon), 19th September (morning), 19th September (afternoon)
November 2024 - 13th November (morning), 13th November (afternoon), 14th November (morning), 14th November (afternoon)
January 2025 - 21st January (morning), 21st January (afternoon), 22nd January (morning), 22nd January (afternoon)

Dickson Training Ltd

Train The Trainer Course

Classroom Course

Online Course

<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;"><img src="https://images.cademy.co.uk/art-by-purnima/1f946b6c-ddfc-4430-8148-ab1d607d7f51/original.jpeg" style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">For all my amazing reviews please click the link below:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a data-fr-linked="true" href="https://www.craftcourses.com/providers/art-by-purnima/reviews" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://www.craftcourses.com/providers/art-by-purnima/reviews</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4-week Online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes and starts at 10.00-10.40 am<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn to prepare your watercolour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, and Loose watercolours see photos.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">*You will be taught live by your tutor online with step-by-step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom and the course is ongoing so you can join at any time.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-class="cancellation-policy">Cancellation and a full refund can be obtained up to 2 weeks before the course starts. Start dates may be amended on request.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">Reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Start Kit Available from Tutor please email for details<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>


For all my amazing reviews please click the link below:
https://www.craftcourses.com/providers/art-by-purnima/reviews


This 4-week Online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.
Each session is 40 minutes and starts at 10.00-10.40 am

* You will learn to prepare your watercolour paints and mix colours.

* You will learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, and Loose watercolours see photos.

*You will be taught live by your tutor online with step-by-step demonstrations and clear explanations of the various stages.

* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.

This is a 4 week course offered live online via zoom and the course is ongoing so you can join at any time.
Cancellation and a full refund can be obtained up to 2 weeks before the course starts. Start dates may be amended on request.
What's included in the price?
Online Tuition
Step by step Demonstrations via Zoom in the live class
Clear explanation from your Tutor
Reference handouts sent via email
What you will need
Start Kit Available from Tutor please email for details

Watercolour paints - tubes or pans
Watercolour paper ( Cold Pressed 300 gsm 140lb)
Round watercolour brushes- size 4 and 6 ( or similar)
HB graphite pencil to draw image
Eraser
Mixing Palette
2 x jars of clean water
Kitchen paper
Hairdryer
Sketchbook
Tracing paper







Art By Purnima

Watercolour Painting

Watercolour for All 4 week Online Course Monday Morning Via Zoom

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.</p>Overview<p>By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.</p><p>ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4.  This course will earn you 21 PDUs. <br /><br /> <b>This class includes an exam voucher. </b></p></div><div id="course-pills-2"><h3>1 - ITIL 4 OVERVIEW</h3> <ul> <li>Introduction to ITIL</li> <li>Key Concepts of ITIL</li> </ul> <h3>2 - The ITIL Framework</h3> <ul> <li>The Four Dimensions of Service Management</li> <li>The ITIL Service Value System</li> </ul> <h3>3 - The ITIL Guiding Principles</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimize and Automate</li> </ul> <h3>4 - THE ITIL SERVICE VALUE SYSTEM (SVS)</h3> <ul> <li>Governance</li> <li>The Service Value Chain</li> <li>Continual Improvement</li> </ul> <h3>5 - Key ITIL Practices</h3> <ul> <li>Continual Improvement</li> <li>Service Level Management</li> <li>Change Control</li> <li>Incident Management</li> <li>Service Request Management</li> <li>Service Desk</li> <li>Problem Management</li> </ul> <h3>6 - Other ITIL Practices</h3> <ul> <li>General Management Practices</li> <li>Service Management Practices</li> <li>Technical Management Practices</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.
Overview
By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.
ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4. This course will earn you 21 PDUs. 

 This class includes an exam voucher. 
1 - ITIL 4 OVERVIEW
Introduction to ITIL
Key Concepts of ITIL
2 - The ITIL Framework
The Four Dimensions of Service Management
The ITIL Service Value System
3 - The ITIL Guiding Principles
Focus on Value
Start Where You Are
Progress Iteratively with Feedback
Collaborate and Promote Visibility
Think and Work Holistically
Keep It Simple and Practical
Optimize and Automate
4 - THE ITIL SERVICE VALUE SYSTEM (SVS)
Governance
The Service Value Chain
Continual Improvement
5 - Key ITIL Practices
Continual Improvement
Service Level Management
Change Control
Incident Management
Service Request Management
Service Desk
Problem Management
6 - Other ITIL Practices
General Management Practices
Service Management Practices
Technical Management Practices

Nexus Human

IT Service Management

ITIL

IT Certifications

IT (Information Technology)

International Trauma Life Support (ITLS)

Institute of Leadership & Management (ILM)

<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

London

<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
  

PCWorkshops

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 

Python EVENINGS Course, Online Instructor-led

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course.



Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are. 
This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to:

Travel the world and be paid for it

Work in a friendly, collaborative atmosphere, 5000 metres above the sea level

Build a global network
This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board. 
98% Employment rate after completion of the course.


How will you learn?
Apart of our traditional class-based tuition, we also offer Virtual Learning courses.
On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification.
We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!!
You will have:

According to the timetable- 1 lesson per week for 18 consecutive weeks.

Exams and final exam based on which the certificate will be issued.

On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.

Individual support on the journey from the course to a job placement

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

Gain an insight into the airline selection process and final one-to-one interview
What is Flight Attendant?
Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. 
Flight Attendant benefits:
Getting paid for travelling the world
Lifestyle
Flexible Work Schedules
Meeting Interesting People
Free Food & Accommodation
Excellent Compensation
The uniforms
Working Environment
How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation.
Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous.
Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round. 
Student – Cabin Crew Flying Support Group
As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. 

Why London Waterloo Academy?
Top Airline Cabin Crew course provider in London
98% Employment rate after completion of the course
With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview.
We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge.
Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more.
The vast global experience of our instructors
This course has been developed in accordance with EASA PART-CC

Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories.
Course Entry Requirements:
English Language at B2 (CEFR) level or above.
There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career. 
Dates (choose one for your course):
14 March 2024 – 11 July 2024, Thursday classes
10 June 2024 – 7 October 2024, Monday classes
17 September 2024 – 14 January 2025, Tuesday classes
18 November 2024 – 17 March 2025, Monday classes
Course duration – 18 weeks
Classes – once a week 
Lesson Time – 6:30pm to 9pm – GMT (London time)
Course fee – £529 (we offer flexible payment plan and accept weekly instalments)
Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)








Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Course Fee

<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

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. 

10213 Courses delivered Online

KS3 Chemistry Tuition (1 hour)

By Savvy Tutor

KS3 Biology Tuition (1 hour)

By Savvy Tutor

KS4 Physics Tuition (1 hour)

By Savvy Tutor

KS3 Physics Tuition (1 hour)

By Savvy Tutor

KS4 Chemistry Tuition (1 hour)

By Savvy Tutor

Learn to make a macrame lobster

By Golden Rope

Learn to make a macrame lobster

By Golden Rope

Learn to make a macrame lobster

By Golden Rope

Level 3, 5, & 7 Train the Trainer

By Imperial Academy

Nemstar's CISSP Programme

By Nemstar Ltd