1200 Courses delivered Live Online

Personalized SketchUp Training: Pay-As-You-Go One-to-One Sessions

For those who are looking to get top marks in the Maths 11+ exam Save Your Child’s Spot in the 11+ Advanced Maths Small Group Classes Tricky Algebra Confusing word problems Fractions, Decimals and Percentages Tricks to answer questions more efficiently (and save time!) Topics that really stretch your child Personalised weekly homework Exam-style questions PLUS! Bettering Youth's Signature Mindset Coaching + exam stress management tools Our engaging course doesn’t just teach numbers; Our Maths courses build confidence.  This course is perfect for students in Year 5 students who are at "greater depth" and are preparing for their 11+ Exam in 2024.  Course breakdown: Each week begins with independent completion of a topic pre-learning I use the data from these pre-learning activities to build a personalised and highly intentional in-person weekly lesson We ensure full mastery of the topic through discussions around efficient methods and provide plenty of opportunities for practise At the end of the topic, students will complete a mock exam to measure their progress and understanding. We use spaced repetition and interleaving throughout the course to ensure that students have multiple exposures to each topic. You regularly get feedback and have a parent's portal to view your child's assignments! We transform 11+ Maths exam prep from a challenge to an exciting adventure, helping your child become a resilient and prepared student. Mathematics can be a battleground for many students, especially when faced with word problems. We understand the fear of numbers, the confusion with multiplication tables, and the frustration of not being able to solve real-world math challenges. Key Details: Duration: Each half term is 5 weeks Official Lesson Start Date: January 11th at 6pm Maths Focus Areas:Algebra, advanced geometry, tricky word problems Group Size: 4 to 8 students For Just £127.00 *save 20% with our Small Business Saturday offer!   What our families have to say:

Introduction to understanding neurodiversity and working with/adapting practice for neurodivergent clients in clinical settings

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

Beyond a refresher, the course will bring advisers up-to-speed on the latest developments on the EU Settlement Scheme, including the latest statement of changes, considerations of late applications and practical insights from real-world experiences, ensuring you as an adviser are well-equipped to navigate challenges posed by stricter documentation requirements and heightened scrutiny from the Home Office. We will be unpacking the EUSS and Family Members, demystifying Appendix EU and Appendix EU Family Permit making it easy to understand and will provide you with a clear framework on identifying eligible family members and the appropriate route for them as well as sharing practical tips with evidencing dependency. Mastering the EU Settlement Scheme: Navigating the Latest Updates and Practical Insights Are you an adviser dealing with EU Settlement Scheme applications and seeking to stay current with the latest developments? Look no further! Our comprehensive course is designed to bring advisers up-to-speed on the intricacies of the EU Settlement Scheme, equipping you with the knowledge and practical insights needed to assist applicants effectively. In this course, you will dive into the latest updates, explore EUSS family member provisions, demystify Appendices EU and EU Family Permit, and gain valuable tips for navigating the application process. With a focus on practicality and real-world experiences, you’ll be well-prepared to tackle challenges posed by stricter documentation requirements and increased scrutiny from the Home Office. By the end of this course, you will be well-versed in the EU Settlement Scheme, adept at assisting applicants, and ready to handle various challenges that may arise during the application process. Join us and become an informed and confident adviser in the field of EUSS applications.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why choose IAS' Immigration Training Courses? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our EU Settlement Scheme training course will give you all the knowledge and tools you need to successfully complete EU Settlement Scheme applications. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent in making applications. This an opportunity not to be missed by immigration/legal professionals. Contact our London, Manchester, or Birmingham immigration lawyers, or use the office finder to find your nearest branch. How is this course structured? 1. Overview and Updates:a. Quick Overview – Brexit and EU National Rightsb. Updates: Statement of Changesb. Late Applications 2. EUSS Family Members:a. Family Members under the Withdrawal Agreementb. Joining Family Members: Dependency and Difficultiesc. Practical Tips for Family Member Applications 3. Administrative Review Overview 4. Practical Tips:a. Completing Applications with Precisionb. Key Differences from EEA Regulationsc. Utilizing Useful Contacts and Resourcesd. Leveraging the Resolution Centre for Problem Resolutione. Handling Difficulties with Documents: Using SARs (Subject Access Requests)

This course equips immigration practitioners and advocates with the knowledge and skills to assist domestic violence survivors in obtaining Indefinite Leave to Remain (ILR) in the UK. Course Overview:   Achieving Indefinite Leave to Remain in Domestic Violence Cases” is a comprehensive training program designed for immigration practitioners and advocates. It provides the necessary knowledge and skills to support domestic violence survivors in obtaining Indefinite Leave to Remain (ILR) in the UK. Participants will explore eligibility criteria, evidence gathering, exceptional circumstances, and application processes to empower survivors on their journey to safety and security. Throughout the course, participants will gain a deep understanding of the eligibility requirements for ILR, enabling them to effectively advise and support their clients. They will learn how to guide survivors in collecting and presenting compelling evidence that strengthens their cases, while also understanding alternative routes and exceptional circumstances for those who do not meet standard eligibility criteria. The course provides practical strategies for enhancing the chances of a successful outcome. Participants will also learn the step-by-step procedures for making a domestic violence concession application, equipping them with the skills to compile persuasive application packages. By the end of the training, participants will be equipped with the knowledge, practical skills, and strategies necessary to assist domestic violence survivors in achieving ILR.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why Choose IAS’ Immigration Training Courses? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our fully qualified and OISC regulated trainer will guide you through the content in our comprehensive training course. See why others like to study with IAS: Delivered Online Expert Course Trainer Free Course Materials Certificate of Attendance   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. How is this course structured? The “Domestic Violence (Immigration based)” training workshop will involve the following: 1. Understanding Eligibility: Who Qualifies for Indefinite Leave to Remain Overview of the criteria and requirements for domestic violence survivors seeking Indefinite Leave to Remain Exploring the key factors that determine eligibility 2. Advising Clients about Evidence Guidance on effectively advising clients on gathering and presenting compelling evidence to support their cases Understanding the types of evidence that can strengthen an application and highlight the impact of domestic violence 3. Considering Exceptional Circumstances when Clients Do Not Qualify under the Rules Exploring alternative routes and exceptional circumstances that may still enable survivors to secure Leave to Remain Discussing strategies for presenting exceptional circumstances to enhance the chances of a successful outcome 4. Making a Domestic Violence Concession Application

AAT Level 3 is an Advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. Duration You can expect this qualification to take 1-1.5 year to complete for most students. Tutors Tutors are highly qualified with extensive knowledge of accountancy. Study Options Online Live - Live Interactive Online Classes are offered through the State of The Art Virtual Learning Campus. Classes are recorded to catch up later. In-Campus - Study at our London campus for AAT level 3. Daytime, weekend and evening courses for AAT available. AAT Distance Learning- Self-Study at home at your own pace with Study Material and access to Online study Material through Virtual Learning Campus (VLC). AAT Qualification Once you finish AAT qualification and pass all exams successfully, you will be awarded globally recognised AAT Certificate in Accounting from AAT. AAT Level 3 Course Syllabus Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

This highly interactive program focuses on building the business focus on value to be achieved from initiatives. The practices in this program apply equally to projects and programs. Participants will gain insight into the capabilities needed to develop the culture, processes, and tools behind validation, what true initiatives' success looks like, which can be closely linked to achieving value. They will learn and experiment with a variety of value definition and management techniques. Working in small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to the ongoing value confirmation goal. Participants will also discover the importance of designing metrics around value and addressing blind spots that could happen when the focus is on the wrong metrics and how that could lead to the wrong behaviors being practiced. Participants will also gain insights into key skills for leading and working in the future. Hands-on experimentation activities enhance the theoretical learning, grounding it in real life and giving opportunities to practice creativity in capturing value.

Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop: Virtual In-House Training The Disciplined Agile Value Stream Consultant workshop teaches you how to use value stream management to create a tailored approach for any organization to accelerate delivery of value to their customers. It provides a combination of Lean, Flow, Theory of Constraints and Organizational Development theories and practices. The workshop integrates with the Disciplined Agile tool kit to provide those practices that will be most effective for where it is applied, whether it be a new Agile transition or continuing a stagnated SAFe® or Spotify one.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.