328 Courses

Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure  09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch  12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview 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. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Ofqual Regulated Qualification | 100% Online Course | FREE Certificate, Assessment & 20 Premium Courses | Expert Support

Level 3 Award in Education and Training. Become a qualified Trainer.

Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare If you want to learn about Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare course and become an expert in the field, you have arrived at the right place. Teaching is in high demand right now and becoming a Higher-Level Teaching Assistant (HLTA) is an excellent way to get started. This HLTA: Higher Level Teaching Assistant (HLTA) course will teach you everything you need to know to become a Teaching Assistant, allowing you to take the first step toward a rewarding teaching career! Through this Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare course, you will gain a better understanding of the role and responsibilities of a HLTA: Higher Level Teaching Assistant (HLTA) course, as well as schools as organizations, the UK school system, and the National Curriculum. You will learn a variety of skills, including child safety and first aid, as well as how to build relationships and manage a classroom. Main Course: Higher Level Teaching Assistant (HLTA) Free Courses: - Course 01: Diploma in Special Education Needs (SEN) Course 02: Primary Teaching Diploma Course 03: EYFS Teaching Diploma Course 04: Autism Diploma Course 05: Special Educational Needs Coordination Course 06: Level 4 Early Years Course 07: Train the Trainer Course Course 08: Executive Secretary & PA Training Course 09: ADHD Awareness [ Note: Free PDF certificate as soon as completing Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare course] Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare Industry Specialists developed this HLTA: Higher Level Teaching Assistant (HLTA) course into 08 user-friendly modules/ lectures. Course Curriculum of HLTA: Higher Level Teaching Assistant (HLTA) course Course Curriculum of Higher-Level Teaching Assistant (HLTA) Module 01: Understand the Higher Level Teaching Assistant role Module 02: Child Development and Welfare Module 03: Awareness of Special Educational Needs Module 04: Promoting children and young people’s positive behaviour Module 05: Providing support for individual learners and small groups Module 06: Developing skills to promote positive working relationships Module 07: Curriculum planning, delivery and assessment Assessment Method of HLTA: Higher Level Teaching Assistant (HLTA) course After completing Working in Higher Level Teaching Assistant (HLTA), SEN, Early Years, Teaching and Childcare with Child psychology course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of HLTA: Higher Level Teaching Assistant (HLTA) course After completing the Working in Higher Level Teaching Assistant (HLTA), SEN, Early Years, Teaching and Childcare with Child psychology course, you can instantly download your certificate for FREE. Who is this course for? Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare This HLTA: Higher Level Teaching Assistant (HLTA) course is open to everyone. Special Note: Our Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare Course is not a regulated course. If You want to get qualified, you can consider following options: HND Child Care EDI Child Psychology Teaching and child care RQF Early Learning & Childcare NCFE Early Learning and Childcare Teaching Assistant: Teaching and Childcare Online Level 3 Award in Childcare & Education Level 3 Award in Childcare and Education (VRQ) Level 3 Diploma for Residential Childcare (England) (RQF) Level 3 Award in Preparing to Work in Home-Based Childcare Level 5 Diploma in Leadership and Management for Residential Child care (England) (RQF) Level 2 Award in Food Safety in Health and Social Care and Early Years and Child care Settings (RQF) Requirements Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare Online To enrol in this HLTA: Higher Level Teaching Assistant (HLTA) Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our HLTA: Higher Level Teaching Assistant (HLTA) Course. Be energetic and self-motivated to complete our HLTA: Higher Level Teaching Assistant (HLTA) Course. Basic computer Skill is required to complete our HLTA: Higher Level Teaching Assistant (HLTA) Course. If you want to enrol in our HLTA Course, you must be at least 15 years old. Career path Higher Level Teaching Assistant Level 4 (HLTA), SEN, Early Years, Teaching and Childcare

For anyone who has to deliver presentations who wants to become more confident and improve their speaking skills.

This course will provide those who require it, the knowledge of how to use Face Masks correctly...

This qualification provides an introduction to teaching. It can meet the needs of a range of trainee teachers, such as: Individuals not currently teaching or training achievement of the qualification does not require practice other than microteaching unless units from the Learning and Development suite of qualifications are selected; Individuals currently teaching and training (including those who have just begun teaching and training) although the qualification does not require practice other than microteaching (unless units from the Learning and Development suite of qualifications are selected), opportunities may be made available to observe and provide feedback on a trainee teacher’s practice; Individuals currently working as assessors who wish to achieve a qualification that provides an introduction to teaching.

Quantitative Face Fit Testing Training (Train The Tester) Portacount Training

The TQUK LEVEL 2 Certificate in Understanding Children & Young People’s Mental Health (RQF) Qualification is to enable you to gain a recognised (RQF) qualification to support those with mental health difficulties. As a staffing member working with children and young people, you are responsible for the safeguarding of each person and as such having an understanding in supporting children and young people with difficulties in mental health.