<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course.</p>Overview<p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom.  Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques.<br />Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level):<br />How to work with Python interactively in web notebooks<br />The essentials of Python scripting<br />Key concepts necessary to enter the world of Data Science via Python</p><p>This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks.  This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice.</p></div><div id="course-pills-2">This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it's often used in Data Science in web notebooks.  This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Data Science

NLP Practitioner

Teacher Training

Professional Skills Course (PSC)

Data Skills

Trainers Course

Python for Data Science Primer: Hands-on Technical Overview (TTPS4872)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is appropriate for advanced users, system administrators and web site administrators who want to use Python to support their server installations, as well as anyone else who wants to automate or simplify common tasks with the use of Python scripts. Students can apply the course skills to use Python in basic web development projects or automate or simplify common tasks with the use of Python scripts.</p>Overview<p>This skills-focused course is about 50% hands-on lab to lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert instructor, you'll learn how to:<br />Create working Python scripts following best practices<br />Use python data types appropriately<br />Read and write files with both text and binary data<br />Search and replace text with regular expressions<br />Work with with the standard library and its work-saving modules<br />Create 'real-world', professional Python applications<br />Know when to use collections such as lists, dictionaries, and sets<br />Work with Pythonic features such as comprehensions and iterators<br />Write robust code using exception handling</p><p>Introduction to Python Programming Basics is a hands-on Python programming course that teaches you the key skills you?ll need to get started with programming in Python to a solid foundational level.  The start of the course will lead you through writing and running basic Python scripts, and then guide you through how to use more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of  Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This course provides you with an excellent kick start for users new to Python and scripting, enabling you to quickly use basic Python skills on the job in a variety of ways.  You?ll be able use Python in basic web development projects, or use it to automate or simplify common tasks with the use of Python scripts. The course also serves as a solid primer course / foundation for continued Python study in support for next level web development with Python, using Python in DevOps, Python for data science / machine learning or Python for systems admin or networking support.</p></div><div id="course-pills-2"><h4>Python Quick View</h4><ul><li>What is Python?</li><li>Python timeline</li><li>Advantages/disadvantages</li><li>Installing Python</li><li>Getting help</li></ul><h4>The Python Environment</h4><ul><li>Starting Python</li><li>Using the interpreter</li><li>Running a Python script</li><li>Editors and IDEs</li></ul><h4>Getting Started with Python</h4><ul><li>Using variables</li><li>Builtin functions</li><li>String data</li><li>Numberic data</li><li>Converting types</li><li>Console input/output</li><li>Command line parameters</li></ul><h4>Flow Control</h4><ul><li>About flow control</li><li>The if statement</li><li>Relational and Boolean operators</li><li>while loops</li><li>Exiting from loops</li></ul><h4>Array Types</h4><ul><li>About array types</li><li>Lists and list methods</li><li>Tuples</li><li>Indexing and slicing</li><li>Iterating through a sequence</li><li>Sequence functions, keywords, and operators</li><li>List comprehensions and generators</li></ul><h4>Working with Files</h4><ul><li>File overview</li><li>Opening a text file</li><li>Reading a text file</li><li>Writing to a text file</li></ul><h4>Dictionaries and Sets</h4><ul><li>About dictionaries</li><li>Creating dictionaries</li><li>Iterating through a dictionary</li><li>About sets</li><li>Creating sets</li><li>Working with sets</li></ul><h4>Functions</h4><ul><li>Defining functions</li><li>Returning values</li><li>Parameters and arguments</li><li>Variable scope</li></ul><h4>Sorting</h4><ul><li>The sorted() function</li><li>Custom sort keys</li><li>Lambda functions</li><li>Sorting in reverse</li><li>Using min() and max()</li></ul><h4>Errors and Exception Handling</h4><ul><li>Exceptions</li><li>Using try/catch/else/finally</li><li>Handling multiple exceptions</li><li>Ignoring exceptions</li></ul><h4>Modules and Packages</h4><ul><li>Creating Modules</li><li>The import statement</li><li>Module search path</li><li>Using packages</li><li>Function and module aliases</li></ul><h4>Getting Started with Object Oriented Programming and Classes</h4><ul><li>About object-oriented programming</li><li>Defining classes</li><li>Constructors</li><li>Understanding self</li><li>Properties</li><li>Instance Methods and data</li><li>Class methods and data</li><li>Inheritance</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to Python Programming Basics (TTPS4800) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Introduction to Python Programming Basics (TTPS4800) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Online Course Creation

Computing Skills

Programming Fundamentals

Computer Programming

Computer Skills

Python Scripting

Introduction to Python Programming Basics (TTPS4800)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Administrators<br />Developers<br />Implementers<br />Systems Administrators</p>Overview<p>Understand the PeopleSoft system architecture, application development methodology, and tool set so you can build and customize PeopleSoft applications efficiently to meet your organizations business requirements. Quickly and efficiently create functionality in PeopleSoft applications to take advantage of the unique capabilities of these applications.<br />Gain Hands-On Experience Using PeopleSoft Application Designer<br />Enrolling in this course will also give you hands-on experience with the Application Designer, the PeopleSoft integrated development environment (IDE). Learn to create and modify PeopleSoft definitions, including fields, records, pages and components. By the end of this course, you'll be able to use Application Designer to create and deploy PeopleSoft classic applications and fluid applications</p><p>This PeopleTools I training introduces the PeopleSoft application development methodology. This 5-day course gives you a general overview of PeopleSoft system architecture, as well as the tool set used to develop new applications or customize existing PeopleSoft applications.</p></div><div id="course-pills-2"><h4>Navigating PeopleSoft Applications</h4><h4>Explaining the PeopleSoft Architecture</h4><h4>Validating Data</h4><h4>Using Application Designer to Develop Applications</h4><h4>Designing the Application</h4><h4>Creating Record Definitions</h4><h4>Building SQL Tables</h4><h4>Creating Page Definitions</h4><h4>Registering Components</h4><h4>Testing Applications</h4><h4>Editing the Portal Registry Structure</h4><h4>Creating Menu Definitions</h4><h4>Understanding the Fluid User Interface</h4><h4>Creating Fluid Pages</h4><h4>Using Delivered CSS</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Peoplesoft PeopleTools I training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Oracle Peoplesoft PeopleTools I course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Learning & Development

Oracle Primavera

Oracle Fusion HCM

Oracle Peoplesoft PeopleTools I

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This Introductory-level course is targeted for aspiring web developers who have software development experience or background. The course can also be adjusted for non-developers upon request.</p>Overview<p>This 'skills-focused' course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our instructors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom.</p><p>Introduction to HTML5/ CSS3 and Responsive Design Basics is a hands-on basic web development course geared for developers who need to understand what the latest in web technologies and responsive design practices that are central to targeting the entire spectrum of user platforms and browsers. This comprehensive course provides a balanced mixture of theory and practical labs designed to take students through HTML5 and CSS3.  Students who attend this course will leave this course armed with the new skills to design, implement, and deploy robust, flexible, and safe web applications.</p></div><div id="course-pills-2"><h4>HTML</h4><ul><li>Define HTML and review its history</li><li>Look at XHTML and its relationship to HTML</li><li>Identify HTML limitations and improvements</li></ul><h4>HTML5</h4><ul><li>HTML5 Overview</li><li>HTML5 Semantic Structure</li><li>HTML5 Forms</li><li>HTML5 Media Delivery</li></ul><h4>CSS</h4><ul><li>Learn the basics of CSS</li><li>Meaning of cascading in CSS</li><li>Declaring CSS within your HTML page</li><li>Creating styles in an external CSS file</li><li>Control how to display and position HTML elements</li><li>Overriding standard tag behavior</li><li>Adding new classes</li><li>Using custom classes in your page</li></ul><h4>CSS3 Overview</h4><ul><li>What is new in CSS3</li><li>The Advantages of CSS3</li><li>Browser Support for CSS3</li></ul><h4>CSS3 Advanced Selectors</h4><ul><li>Selecting Using Attributes</li><li>Selecting Using DOM Structure</li><li>Complex Selecting using Pseudo-Classes</li><li>Selecting Using UI Components and State</li></ul><h4>CSS3 Visual Effects</h4><ul><li>Font Options, Opacity, and Color</li><li>Distributing Content Across Columns</li><li>Working with Borders and Boxes</li><li>Working with Vendor Prefixes</li><li>Functional Techniques</li></ul><h4>HTML5 JavaScript API</h4><ul><li>Cross-Domain Messaging</li><li>Working with Web Storage</li><li>Offline with Application Cache</li><li>Geolocation: What, Why, and How</li></ul><h4>Responsive Web Design (RWD)</h4><ul><li>Adapting to Varying Screen Sizes</li><li>Scaling Page and Text Content</li><li>Scaling and Adapting for Media</li><li>Options for Adjusting Media</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Web Essentials | Introduction to HTML5, CSS3 and Responsive Design (TT4002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Web Essentials | Introduction to HTML5, CSS3 and Responsive Design (TT4002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Design & Technology Courses (DT)

HTML & CSS

Service Design Courses (SDC)

Web Development

Web Essentials | Introduction to HTML5, CSS3 and Responsive Design (TT4002)

Harpenden

<p>Generating new leads and new business can be both time-consuming and frustrating.</p><p>It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate.</p><p>But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful?</p><p>This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline.</p>This course will help participants:<ul><li>Develop a clear and consistent process for new business development and lead-generation</li><li>Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service'</li><li>Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals</li><li>Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach</li><li>Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities</li><li>Develop an engaging telephone voice and manner - and a 'networking personality'</li><li>Qualify potential opportunities with more accuracy on a consistent basis</li><li>Prioritise opportunities and manage their time when sourcing new business</li><li>Discover online sources of leads, contacts and referrals</li><li>Overcome psychological blocks to cold or warm calling - theirs and the client's</li><li>Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy</li><li>Make outbound sales or appointment calls with improved confidence, control and results</li><li>Improve the conversion of calls to appointments by using more effective questions and sales messages</li><li>Get past gatekeepers and assistants more effectively</li><li>Make the most of your CRM software and systems</li></ul><section>
                    <h3>1 Online marketing - what works!</h3><ul><li>Workshop overview and learning objectives</li><li>Choosing your social media channels</li><li>LinkedIn for sales and marketing</li><li>Designing and implementing an effective new business email campaign online</li><li>Creating a lead-generation strategy online - with case studies</li><li>Avoiding common mistakes in social media marketing</li><li>Case study: 'Best practice in social media sales and marketing'</li><li>Using blogs and video-based marketing (eg, YouTube)</li><li>New trends and how to keep your finger on the 'social media' pulse</li><li>Twenty essential websites and online marketing tools</li></ul> <h3>2 Making appointments by telephone</h3><ul><li>Planning the call, telephone techniques, integrating with email and online marketing</li><li>Developing a clear and consistent process to appointment-making</li><li>Setting and achieving the right level of telephone activity to achieve your appointment goals</li><li>Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach</li><li>Overcoming the most common 'put-offs' to seeing or engaging with you</li><li>Overcoming psychological blocks to cold or warm calling - yours and the client's</li><li>Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy</li><li>Making outbound sales or appointment calls with improved confidence, control and results</li><li>Improving conversion of calls to appointments by using more effective questions and sales messages</li><li>The five keys to developing an engaging telephone voice and approaching manner</li></ul> <h3>3 Power networking</h3><ul><li>Strategies for networking and B2B referral-based marketing</li><li>The importance, and different types, of networking</li><li>How to work a room - preparation and strategy</li><li>Communication dynamics in networking - the power of the listening networker</li><li>Assumptions when networking</li><li>Business networking etiquette</li><li>Making connections, asking for cards, contact details and referrals, gaining follow-up commitments</li><li>Building relationships - follow-up and follow-through</li></ul> <h3>4 Developing new leads</h3><ul><li>Strategies for first-time sales calls</li><li>Gaining rapport and opening first-time and new business sales calls effectively</li><li>Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences</li><li>Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal</li><li>Value message - differentiate your solutions clearly and accurately, with tailored value statements</li><li>Presenting the right initial USPs, features and benefits and making them relevant and real to the customer</li><li>Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price</li><li>Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call</li></ul> <h3>5 Organised persistence - CRM and prospect-tracking</h3><ul><li>Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management</li><li>Maintaining a good database for maximising new business ROI</li><li>Developing a contact strategy with different types and levels of contact</li><li>Analysing your contact base using state-of-the-art software and tools</li><li>Making the most of your CRM systems and solutions</li><li>Understanding that your attitude makes a difference when sourcing new business</li><li>Setting SMART objectives for new business development and lead-generation</li><li>Practical exercise - setting personal development and business goals</li><li>Time management tips to improve daily productivity</li><li>New business pipeline management strategies for peak sales performance</li></ul> <h3>6 Workshop summary and close</h3><ul><li>Practical exercise - developing your new business action plan</li><li>Review and feedback</li></ul> 


                </section>

The In House Training Company

Online Course Marketing

Coaching & Consulting Business

Business Development

Business Case Development

Business Development Manager

Lead Generation

New business and lead generation (In-House)

<p>This webinar is part of a&nbsp;series of free, hands-on practical webinars hosted by Cademy on how to get yourself set up to sell spaces, coordinate ticket sales and build online content.&nbsp;</p>
<p>This webinar will focus on:</p>
<ul>
<li><span style="color: var(--text-alt); letter-spacing: -0.05px; font-family: 'SF UI Text', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">How to record and prepare your course content</span></li>
<li><span style="color: var(--text-alt); letter-spacing: -0.05px; font-family: 'SF UI Text', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">How to create an on-demand / self-taught course on Cademy</span></li>
<li>How to sell your course</li>
<li>How to manage student access to your course</li>
</ul>
<p>There&rsquo;s no commitment to sign up to anything, and it&rsquo;s free to join in. So please share with anyone you think might be interested.<br /><br />We're really looking forward to meeting you.</p>

Creative Workshops Scotland

Personal Development

Online Education

How to set up and sell on-demand video courses with Creative Workshops Scotland & Cademy 

General admission

Edinburgh

<p>Join our online get-together for creatives around Scotland who run workshops and courses to earn a living.</p>
<p>After a wee break for personal reasons, I'm back on the case with developing this Scotland-wide network.</p>
<p>Since it's estimated that we spend around 70% of our time on admin, I've invited Adrian from ticketing platform Cademy back to share his top tips for setting up a hassle-free workshop booking system, and getting money in straight away (yes please!).</p>
<p>And we'll be asking what your perfect ticketing platform would look like, and what help and support you'd welcome from a Scotland-wide creative workshops network.</p>
<p>Most of all I'm looking forward to meeting as many other workshop providers and hosts from around Scotland as possible!</p>
<p>Lynn :-)</p>
<p>ZOOM LINK:</p>
<p>https://us02web.zoom.us/j/89504840831?pwd=b2MzQ3REbWl3bkZaUW92NksvS2lHQT09</p>

Get together for creatives in Scotland who run in-person and online workshops to earn a living.

October network get-together

<p>This webinar is part of a&nbsp;series of free, hands-on practical webinars hosted by Cademy on how to get yourself set up to sell spaces, coordinate ticket sales and build online content.&nbsp;</p>
<p>This is webinar will focus on:&nbsp;</p>
<ul>
<li>The ins &amp; outs of running a live online workshop via Zoom, or any other video meeting service.</li>
<li>Setting up an online class on Cademy.</li>
<li>How to sell additional add-ons and kits to complement your online class.</li>
<li>How to deliver a great online workshops.&nbsp;</li>
<li>How to distribute or sell your workshop recordings.&nbsp;</li>
</ul>
<p>There&rsquo;s no commitment to sign up to anything, and it&rsquo;s free to join in. So please share with anyone you think might be interested.<br /><br />We're really looking forward to meeting you.</p>

Running online classes and workshops with Creative Workshops Scotland & Cademy 

Overview<p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);">This two-day Paediatric First Aid course focuses on emergency scenarios that face those looking after young children and infants, including day nurseries, private nursery schools, pre-schools, before and after school clubs for children in the early years age group, childminders, and carers of children at home.</p><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">The Paediatric First Aid course meets the Ofsted Early Years and Childcare Register requirements.</p><h2 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Details</h2><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">What will I learn on this course?</h3><ul style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);"><li fr-original-style="" style="box-sizing: border-box;">The role of the first aider</li><li fr-original-style="" style="box-sizing: border-box;">Resuscitation (child and infant CPR)</li><li fr-original-style="" style="box-sizing: border-box;">Allergic reaction</li><li fr-original-style="" style="box-sizing: border-box;">Unresponsive casualty treatment</li><li fr-original-style="" style="box-sizing: border-box;">Communication and casualty care</li><li fr-original-style="" style="box-sizing: border-box;">Asthma and diabetic emergencies</li><li fr-original-style="" style="box-sizing: border-box;">Choking</li><li fr-original-style="" style="box-sizing: border-box;">Bone, joint and muscle injuries</li><li fr-original-style="" style="box-sizing: border-box;">Managing an emergency</li><li fr-original-style="" style="box-sizing: border-box;">Eye injuries</li><li fr-original-style="" style="box-sizing: border-box;">Bleeding</li><li fr-original-style="" style="box-sizing: border-box;">Seizers</li><li fr-original-style="" style="box-sizing: border-box;">Poisoning, bites and stings</li><li fr-original-style="" style="box-sizing: border-box;">Spinal injuries</li><li fr-original-style="" style="box-sizing: border-box;">Foreign objects</li><li fr-original-style="" style="box-sizing: border-box;">Meningitis and sickle cell</li><li fr-original-style="" style="box-sizing: border-box;">Burns</li><li fr-original-style="" style="box-sizing: border-box;">Heat and cold-extreme</li><li fr-original-style="" style="box-sizing: border-box;">Head injuries</li></ul><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Certification</h3><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Successful candidates will receive a nationally recognised &amp; accredited qualification valid for 3 years.</p>

Prima Cura Training

Childminder

Paediatric First Aid

Child First Aid

The Paediatric First aid course provides the comprehensive set of practical skills needed by first aiders in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies and common childhood illnesses. It meets the standards required to help comply with Ofsted regulations.

2-Day Paediatric & Early Years First Aid (Ofsted Approved)

Overview<p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);">This Paediatric First Aid course focuses on emergency scenarios that face those looking after young children and infants, including day nurseries, private nursery schools, pre-schools, before and after school clubs for children in the early years age group, childminders, and carers of children at home.</p><h2 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Details</h2><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">What will I learn on this course?</h3><ul style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);"><li fr-original-style="" style="box-sizing: border-box;">The role of the first aider</li><li fr-original-style="" style="box-sizing: border-box;">Resuscitation (child and infant CPR)</li><li fr-original-style="" style="box-sizing: border-box;">Allergic reaction</li><li fr-original-style="" style="box-sizing: border-box;">Unresponsive casualty treatment</li><li fr-original-style="" style="box-sizing: border-box;">Communication and casualty care</li><li fr-original-style="" style="box-sizing: border-box;">Asthma and diabetic emergencies</li><li fr-original-style="" style="box-sizing: border-box;">Choking</li><li fr-original-style="" style="box-sizing: border-box;">Managing an emergency</li><li fr-original-style="" style="box-sizing: border-box;">Bleeding</li><li fr-original-style="" style="box-sizing: border-box;">Seizers</li><li fr-original-style="" style="box-sizing: border-box;">Foreign objects</li><li fr-original-style="" style="box-sizing: border-box;">Burns</li><li fr-original-style="" style="box-sizing: border-box;">Head injuries</li></ul><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Certification</h3><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Successful candidates will receive certification of achievement.</p>

Childminding

Baby First Aid

Children First Aid

Nursery Nurse

Infant First Aid

Early Years Foundation Stage (EYFS)

The Paediatric First aid course provides the comprehensive set of practical skills needed by people working in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies.

Paediatric & Early Years First Aid (1-day)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Level 3 Award in Education and Training (RQF)</strong> formerly known as PTLLS, has been designed to introduce teaching for individuals who aspire or currently work in adult education. This includes FE colleges, training providers, workplace training departments and/or Local Authorities. It is a nationally recognised qualification and is also often the preference for employers to source as an accredited train-the-trainer qualification. This qualification includes written assignments and a practical micro-teach session, which can be completed remotely. &nbsp;</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Online Remote Tutor-led Sessions</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This version of the course allows you to attend two days of online sessions led by an experienced tutor. Then come back online 2-3 weeks later to deliver your micro-teach session to your peers. Use this gap in time to prepare your micro-teach and complete the written work for the qualification. This allows you to fully complete in as little as 2-3 weeks. The micro-teach date is flexible and you can also enrol for self-study learning if preferred.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Units:</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learners will achieve 12 credits across 3 units:</span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understanding roles, responsibilities and relationships in education and training</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understanding and using inclusive teaching and learning approaches in education and training</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understanding assessment in education and training</li></ul><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessments:</span></strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This qualification is assessed by a portfolio of evidence which must cover all assessment criteria of the units selected. Assessment methods include:</span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">3 x written assignments.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A micro-teach session</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Self-evaluation</li></ul><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style="color: rgb(58, 58, 58);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should do this course?</strong></span><br fr-original-style="" style="box-sizing: border-box;"></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Level 3 Award in Education and Training (RQF) has been designed to introduce teaching for individuals who would like to work or currently work within FE Colleges, Independent Training Providers and/or Local Authorities.&nbsp;It can meet the needs of a range of trainee teachers, such as:</span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Individuals not currently teaching or training &ndash; achievement of the qualification does not require practice other than microteaching.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Individuals currently teaching and training, including those new to the profession &ndash; although the qualification does not require practice, opportunities may be made available to observe and provide feedback on a trainee teacher&rsquo;s practice; and</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Individuals currently working as assessors, who wish to achieve a qualification that introduces teaching.</li></ul><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style="color: rgb(58, 58, 58);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pre-requisites</strong></span><br fr-original-style="" style="box-sizing: border-box;"></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learners must be aged 19+ years to be enrolled in this course. You do not need to be in a current teaching or training role to complete this qualification.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Please note: course materials are provided in English and the practical assessment must be completed in English.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(58, 58, 58); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(58, 58, 58); font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources</strong></span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">In addition to our extensive online resources, learners will receive our resource pack by post, which includes:</span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learner Handbook</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Printed Training Manual/Workbook</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Printed copies of assignments and session plan templates</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Pen and highlighter</li></ul><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><img src="https://atctraining.net/wp-content/uploads/2022/05/WelcomePack-300x277.png" alt="" width="198" style="color: rgb(0, 0, 0); width: 160px; height: 156.768px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); width: 160px; height: 156.768px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style="color: rgb(58, 58, 58);"></span><span style="color: rgb(58, 58, 58); box-sizing: border-box;" fr-original-style="color: rgb(58, 58, 58);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificate</strong></span><br fr-original-style="" style="box-sizing: border-box;"></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Upon successful completion, learners will receive an externally accredited certificate by Focus Awards, a nationally recognised and Ofqual-regulated awarding organisation.&nbsp;</span></p>

ATC Training Limited

The Level 3 Award in Education and Training (RQF) formerly known as PTLLS, has been designed to introduce teaching for individuals who aspire or currently work in adult education. This includes FE colleges, training providers, workplace training departments and/or Local Authorities. It is a nationally recognised qualification and is also often the preference for employers to source as an accredited train-the-trainer qualification. This qualification includes written assignments and a practical micro-teach session, which can be completed remotely.  

Online Remote Tutor-led Sessions

This version of the course allows you to attend two days of online sessions led by an experienced tutor. Then come back online 2-3 weeks later to deliver your micro-teach session to your peers. Use this gap in time to prepare your micro-teach and complete the written work for the qualification. This allows you to fully complete in as little as 2-3 weeks. The micro-teach date is flexible and you can also enrol for self-study learning if preferred.

Level 3 Award in Education and Training (Remote Online Tutor-led) PTLLS

General Admission

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong>&nbsp;PICTURE BOOKS</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Barry Timms is a children&#39;s picture book editorial consultant with over twenty years&#39; experience. He has also edited preschool books, non-fiction and young fiction works. Barry&#39;s editorial roles include senior and managerial positions at Macmillan Children&#39;s Book, Walker Books and Little Tiger Group, making commercially successful books of the UK, US and international markets.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Barry is also an award winning author of over fifteen picture books. This is NOT a Unicorn!, published by Nosy Crow, won the Stockport Children&#39;s Book Award 2022.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Barry would like you to submit a covering letter and a maximum of two picture book texts to be discussed. These should be for children aged within the 2-6 years age bracket and can be in prose or rhyme. As well as conventional fiction narratives, narrative non-fiction is also acceptable.</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Barry is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the </em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Tuesday 1 October 2024</strong></p>

LOOKING FOR: PICTURE BOOKS
Barry Timms is a children's picture book editorial consultant with over twenty years' experience. He has also edited preschool books, non-fiction and young fiction works. Barry's editorial roles include senior and managerial positions at Macmillan Children's Book, Walker Books and Little Tiger Group, making commercially successful books of the UK, US and international markets.
Barry is also an award winning author of over fifteen picture books. This is NOT a Unicorn!, published by Nosy Crow, won the Stockport Children's Book Award 2022.
Barry would like you to submit a covering letter and a maximum of two picture book texts to be discussed. This should be in one Word document with the cover letter at the top. The texts should be for children aged within the 2-6 years age bracket and can be in prose or rhyme. As well as conventional fiction narratives, narrative non-fiction is also acceptable.
(In addition to the paid sessions, Barry is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.
The submission deadline is: Tuesday 1 October 2024

I Am In Print

Fiction Writing

ONE SPACE LEFT! 9th October Barry Timms #Agent121. Looking for: PICTURE BOOKS

Belfast

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">The purpose&nbsp;of these qualifications is to enable learners to coach clients &ndash; one to one and in small groups &ndash; towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">This qualification is mapped directly to:</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Unit 1: Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Providing a positive customer experience in the exercise environment</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Lifestyle management &amp; health awareness</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Gym-based programme planning and preparation</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Gym-based programme delivery and professional instruction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: Applied anatomy and physiology</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Promoting wellness through client motivation and interaction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: Bespoke exercise programme design</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Customised exercise programme instruction and communication techniques</li><li fr-original-style="" style="box-sizing: border-box;">Unit 10: Nutrition to support physical activity</li><li fr-original-style="" style="box-sizing: border-box;">Unit 11: Business acumen for a successful Personal Training Practice</li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.</span></p><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><div style="color: rgb(105, 105, 105); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(105, 105, 105);"><section fr-original-style="" style="box-sizing: border-box;"><div data-tags="{All} " fr-original-style="" style="box-sizing: border-box;"><div itemprop="text" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Multiple choice test</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Observation of practical skills</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Portfolio of evidence (Learner assessment record)</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><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Add Ons:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">If you choose the <em fr-original-style="" style="box-sizing: border-box;">Gold</em> or <em fr-original-style="" style="box-sizing: border-box;">Platinum</em> Course you will receive the following:</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">NASM Certified Nutrition Coach (CNC) - </span></strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="box-sizing: border-box;">*Platinum Only</em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Behaviour Change Science: Help Clients Stick with their Programme</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Speed Agility and Quickness Training</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Navigating Diets</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Anatomy of a Research paper: How to Read beyond the Abstract</strong></span></p></div><br fr-original-style="" style="box-sizing: border-box;"></div></section></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.
This qualification is mapped directly to:
The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.
Qualification Structure:
Unit 1: Anatomy & physiology for exercise & fitness instructors
Unit 2: Providing a positive customer experience in the exercise environment
Unit 3: Lifestyle management & health awareness
Unit 4: Gym-based programme planning and preparation
Unit 5: Gym-based programme delivery and professional instruction
Unit 6: Applied anatomy and physiology
Unit 7: Promoting wellness through client motivation and interaction
Unit 8: Bespoke exercise programme design
Unit 9: Customised exercise programme instruction and communication techniques
Unit 10: Nutrition to support physical activity
Unit 11: Business acumen for a successful Personal Training Practice
Entry Requirements:
Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.
Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)


Add Ons:
If you choose the Gold or Platinum Course you will receive the following:
NASM Certified Nutrition Coach (CNC) - *Platinum Only
NASM Behaviour Change Science: Help Clients Stick with their Programme
NASM Speed Agility and Quickness Training
NASM Navigating Diets
NASM Anatomy of a Research paper: How to Read beyond the Abstract

Platinum Training Institute

NASM

Personal Trainer

Coaching

Sport

Fitness

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.

PTI Diploma in Personal Training

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The purpose of this&nbsp;qualification&nbsp;is to enable&nbsp;learners to develop the&nbsp;knowledge and skills&nbsp;so they can engage, facilitate, educate and support clients in a gym or health club environment.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Completing this qualification allows learners to access Gym Instructor jobs.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 1 &ndash; Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 2 &ndash; Providing a positive customer experience in the exercise environment</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 3 &ndash; Lifestyle management &amp; health awareness</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 4 &ndash; Gym-based programme planning and preparation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 5 &ndash; Gym-based programme delivery and professional instruction</li><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Multiple choice test</span><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessment workbook</span></p><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Observation of practical skills</span></p><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio of evidence (Learner assessment record)</span></p></ul></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.
Completing this qualification allows learners to access Gym Instructor jobs.
Qualification Structure:
Unit 1 – Anatomy & physiology for exercise & fitness instructors
Unit 2 – Providing a positive customer experience in the exercise environment
Unit 3 – Lifestyle management & health awareness
Unit 4 – Gym-based programme planning and preparation
Unit 5 – Gym-based programme delivery and professional instruction
Entry Requirements:Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.

Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)

Physical Activity

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.

Completing this qualification allows learners to access Gym Instructor jobs.

YMCA Level 2 Certificate in Gym Instructing

<p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(30, 36, 11); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(30, 36, 11);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Stronger body &amp; freedom for the mind from the new Fusion technic class!</strong></span></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Ready for the new term??&nbsp;</span></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We are!!&nbsp;</span></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;Every week we&nbsp;build your technic from floor to the barre and on the center floor. Suits fro all levels. As you can challenge from your own level. Helping us to strengthen our leg alignments, core and upper back support. Enjoy of freeing the mind, finding more confidence for yourself and getting stronger body.&nbsp;</span></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What you will get from Technic classes:&nbsp;</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Strengthen your core and posture.&nbsp;</span></li><li style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Work on leg alignments.&nbsp;</span></li><li style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Improve your balance.&nbsp;</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></li></ul><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is new?&nbsp;</strong></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);">-When you book the live class you get also the recording, so if you miss the class you get to catch up with the recording!!</p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Class levels:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">📣Wednesday 5.45 pm <span style="caret-color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0);">Technic</span>&nbsp;class</p>

Unlock Your Dance Potential with Weekly Dance Technic Class—Online Live and on- demand!
Feeling stuck in your dance journey? Struggling with technique, posture, or confidence? Our Weekly Dance Technic Classes are here to help you break through.
Why Join?
➡️Build Strength & Confidence: Improve core strength, leg alignment, and balance to elevate your dance skills.
➡️Flexible Learning: Choose between online live or on-demand class. Also during the online live class you can choose to keep your camera on or off. 
➡️All Levels Welcome: Pirita will help you move forward from your level, are you then new in dance technic training or have do you have some base. 
Class : 
📣Wednesday 5.45 pm Technic class

Special Offer: Save with our Membership or 5-Class Card—get more, pay less.

Don’t wait—sign up today and transform your dance experience! Book Now!
Click the date and book in, it will take you straight to the payment page where you chan choose the best way for you to keep on dancing. 

If you are wondering what is best for you, contact Pirita and let's see what could be best option for you or come and try, let's chat after that.

Pirita Tuisku

Strength Training

Dance

Flexibility

Build Strength & Confidence: Improve core strength, leg alignment, balance to elevate your dance skills! Join now to Pirita Tuisku´s Dance technic class and keep on dancing!

Dance Technic class Open level  ( Online )

For new students who haven't been in Pirita´s classes

Trial class

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you thinking of booking an e-ALS course or have already booked one? Want to know what to expect? Join us for a live Q&amp;A session online (it&#39;s free!)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will go through the programme and explain what to expect from each session of the day and also give you a chance to ask questions.</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>

Are you thinking of booking an e-ALS course or have already booked one? Want to know what to expect? Join us for a live Q&A session online (it's free!)
We will go through the programme and explain what to expect from each session of the day and also give you a chance to ask questions.



Hunter Clinical Training

E-ALS

ELS (Effective Learning Service)

Teaching Online

e-ALS Q&A Online session

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live instructor led sessions;&nbsp;</strong></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Why choosing Mindmaps Wellbeing is a good choice for your training.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Instructor led training sessions over two days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Course Manual</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Handy Cue Card</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ MHFAider Certificate upon completion</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Your instructors are <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registered Mental Health Nurses and Healthcare Educators</strong> (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to our online MHFAider peer support groups moderated by the instructor team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">For a little extra:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Organisational MINDWELL Companion tailored for your workplace / organisation.</p>

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

<p id="isPasted" 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;" fr-original-style=" color: rgb(0, 0, 0);">This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time <em fr-original-style="" style="box-sizing: border-box;">Essentials in Communication and Co-production with Parents/Carers</em>. We recommend that you have completed the &#39;Essentials&#39; course before booking this course (please see our booking page or contact <span style="color: rgb(209, 72, 65); box-sizing: border-box;" fr-original-style="color: rgb(209, 72, 65);">admin@bornattherighttime.com</span> to find out more).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care.</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Content</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Using lived experience to understand what can lead to conflict and relationship breakdown&nbsp;</span></span></li><li style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Relationship building and avoiding conflict and t</span></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">he factors underpinning challenging situations and difficult conversations&nbsp;</span></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;</span></span></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">System structures which negatively affect effective communication and collaboration&nbsp;</span></span></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The impact of trauma and use of trauma informed practice&nbsp;</span></span></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">BRAVING inventory (Brene Brown) and creating healthy boundaries&nbsp;</span></span></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Ways to create professional, meaningful connection with parents/carers in the current context.<br fr-original-style="" style="box-sizing: border-box;"></span></span></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="caret-color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Delivery</strong></span></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="caret-color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="caret-color: rgb(0, 0, 0);">2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024</span></li></ul>

This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time Essentials in Communication and Co-production with Parents/Carers. We recommend that you have completed the 'Essentials' course before booking this course (please see our booking page or contact admin@bornattherighttime.com to find out more). 
Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care.

Content
Using lived experience to understand what can lead to conflict and relationship breakdown
Relationship building and avoiding conflict and the factors underpinning challenging situations and difficult conversations
System structures which negatively affect effective communication and collaboration
The impact of trauma and use of trauma informed practice
BRAVING inventory (Brene Brown) and creating healthy boundaries
Ways to create professional, meaningful connection with parents/carers in the current context.
Delivery
2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024

Born at the Right Time

Learning Disability Nurse

Allied Health

SENCO

Allied Health Professions (AHP)

Midwifery

Healthcare Workers

Sen Teaching Assistant

Speech & Language Therapist

Social Worker

Occupational Therapist

Disability Awareness

Speech & Language Therapy (SLT)

Social Care

Learning Disability

Physiotherapist

Inspiring, interactive and unique 4-hour CPD certified Communication and Co-production training. 

Difficult Conversations, Conflict and Relationship Building with Parents/Carers (Oct 24)

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><h2 style="color: var(--heading-color-h2); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h2);">What is the course about?</h2></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><h6 style="color: var(--heading-color-h6); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h6);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Main Components</span></strong></h6></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div style="color: var(--text-container-color); box-sizing: border-box;" fr-original-style=" color: var(--text-container-color);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Online CPD TAFL programme is practical and it combines the theory of teaching Arabic as a foreign language with observed and assessed teaching practice with real students of Arabic.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course develops skills and knowledge needed for teaching Arabic at universities, international schools, higher and further education institutes, and language centres.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our TAFL Course is CPD Certified (Certificate No 48801.&nbsp;</p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><h2 style="color: var(--heading-color-h2); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h2);">What will I learn?</h2></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><h6 style="color: var(--heading-color-h6); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h6);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Curriculum</span></strong></h6></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div style="color: var(--text-container-color); box-sizing: border-box;" fr-original-style=" color: var(--text-container-color);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Language Awareness</li><li fr-original-style="" style="box-sizing: border-box;">The learner, the teacher and the teaching/learning context</li><li fr-original-style="" style="box-sizing: border-box;">Planning for effective teaching</li><li fr-original-style="" style="box-sizing: border-box;">Classroom management and teaching skills</li><li fr-original-style="" style="box-sizing: border-box;">Resources and materials for teaching Arabic</li><li fr-original-style="" style="box-sizing: border-box;">Professional development for teachers of Arabic</li></ul><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><h2 style="color: var(--heading-color-h2); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h2);">What is the timetable?</h2></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><h6 style="color: var(--heading-color-h6); box-sizing: border-box;" fr-original-style=" color: var(--heading-color-h6);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Course Schedule</span></strong></h6></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div style="color: var(--text-container-color); box-sizing: border-box;" fr-original-style=" color: var(--text-container-color);"><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;">Part-time Option</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Input Sessions: Week 1-9, Thursday 15:00-18:00 GMT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Teaching Practice: Week 5-9, Tuesday 17.00-19.00 GMT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Full-time Option</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Input Sessions: Week 1-3, Monday, Thursday, and Friday 15:00-18:00 GMT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Teaching Practice: Week 2-4, Tuesday and Wednesday 17.00-19.00 GMT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">teaching practice</strong>&nbsp;is shared amongst participants. If you have your own students, you will be able to record lessons with them during the course.</p></div></div></div></div></div></div>

 International Language Experts

Language Teaching

Initial Teacher Training (ITT)

Online CPD TAFL Course: Master the Art of Teaching Arabic.

Online CPD TAFL: Certificate in Teaching Arabic as a Foreign Language

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

17316 Courses

Python for Data Science Primer: Hands-on Technical Overview (TTPS4872)

By Nexus Human

Introduction to Python Programming Basics (TTPS4800)

By Nexus Human

Oracle Peoplesoft PeopleTools I

By Nexus Human

Web Essentials | Introduction to HTML5, CSS3 and Responsive Design (TT4002)

By Nexus Human

New business and lead generation (In-House)

By The In House Training Company

How to set up and sell on-demand video courses with Creative Workshops Scotland & Cademy

By Creative Workshops Scotland

October network get-together

By Creative Workshops Scotland

Running online classes and workshops with Creative Workshops Scotland & Cademy

By Creative Workshops Scotland

2-Day Paediatric & Early Years First Aid (Ofsted Approved)

By Prima Cura Training

Paediatric & Early Years First Aid (1-day)

By Prima Cura Training

Search By Location