3076 Courses in Leicester delivered Live Online

Create a well-structured pathway to optimized content by understanding how information architecture applies to user experience design.

In this comprehensive, step-by-step training, we’ll dive into the essential skills for crafting content, building a loyal following, and using social media platforms to boost your visibility.

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

Definition of Safeguarding Legislation & agreed ways of working Definition of Safeguarding Legislation & agreed ways of working Every child matters guidance Myths and statistics Effects on young people Leadership/worker skills Common indicators of abuse Reporting of abuse and potential abuse Barriers to reporting abuse Understanding the types of abuse Recognising acts, signs and symptoms of abuse Who is vulnerable / at risk The role of dignity in safeguarding Legislation and policies and procedure What to do should you have a concern Overview of prevent How to respond to an individual should they disclose a concern

Miss Date Doctor’s Trust Building coaching is designed to help couples and individuals build and strengthen trust in their relationships. Trust is a critical component of any healthy relationship, and our coaching can provide you with the skills and tools needed to establish and maintain trust with your partner or potential partner. Our Trust Building coaching includes a range of techniques and strategies, such as effective communication, setting clear expectations, demonstrating reliability and consistency, and developing healthy boundaries. We can help you identify and address any trust issues that may be impacting your relationship, and develop a plan to rebuild trust if necessary. With our Trust Building coaching, you can learn to establish and maintain a strong foundation of trust in your relationships, improving communication, increasing intimacy, and building a brighter future together. Have three 1 hour sessions with a M.D.D qualified professional couples therapist The Miss Date Doctor Trust Building package includes the following: Relationship Trust, Trust Building Coaching, Trust Issues, Effective Communication, Setting Clear Expectations, Demonstrating Reliability, Consistency, Healthy Boundaries, Rebuilding Trust, Relationship Building, Trust Techniques, Trust Building Strategies, Trust and Intimacy, Trust Training. https://relationshipsmdd.com/product/trust-building-package/

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

No one teaches you how to effectively chair a board of directors -- until now. This brief, insightful program offers the real-world tools and skills you need to be a vital boardroom leader.

Consistent 11+ Reading is vital to build an extensive vocabulary for all aspects of the 11+ English Exams. Excellent vocabulary is what ultimately brings 11+ English Exam Success and top results.

Become an Expert Immigration Advisor For Only £599.00 View our Immigration Pathway, training course dates below, available remotely via Microsoft Teams. Immigration Pathway Our Immigration Pathway let’s learners take control of their studies and excel their immigration training. Pathways offers a comprehensive program with flexible learning approach tailored to your professional goals. With IAS Legal Training you can study to become an Immigration Expert for only £599.00   Step 1: Pick What OISC Course You Want To Study! OISC Level 1 OISC Level 2 OISC Level 3 (2 Day Course) OISC Level 3 (1 Day Fast Track)   Step 2: Pick 4 CPD Courses To Study! Appendix FM Naturalisation Introduction to Immigration Law Fresh Claims & Further Submissions Deportation Student Visa & Other routes Masterclass: Visit & ancestry Visa Domestic Violence (Achieving Indefinite Leave To Remain) First Time Supervisor / Caseworker (management training) Supporting Vulnerable Clients General Grounds of Refusal British Citizenship For Minors EU Settlement Scheme Private Life Route & Applications Unaccompanied Minors Exam Technique Level 1 (OISC Mock Exam Practice) Exam Technique Level 2 (OISC Mock Exam Practice) Setting Up An OISC Firm (Additional £35.00)   Benefits of Pathways: Gain specialised knowledge and skills in immigration training. Enhance your career prospects and marketability in the field. Earn CPD credits and advance your professional development. Access resources and support to excel in your chosen path. Course joining links, materials and instructions are sent out 24hours before the course starts.  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 each course and ensure you are competent and confident in your studies! Who Should Attend: Designed for individuals looking to start a career in the Immigration Industry You will be provided with training materials to keep after completing each course. *Please note that IAS only deliver training and do not administer OISC Exams to become regulated.   Join over 92% of satisfied customers who found their training with IAS useful and beneficial.