10164 Courses delivered Online

Join FlashAcademy and two of its customers as they explore the link between EAL and wellbeing. This webinar will provide valuable insights, data and actionable strategies for educators, school leadership and EAL specialists.

For insights into how the four colour energies will transform your team dynamics and performance, join this virtual workshop and find out how to embed the four colour energies within your team. Find out your own communication preferences and how to work effectively with colleagues with a different preference.

A life without anxiety can be yours with our bespoke blend of clinical hypnotherapy and advanced NLP therapy techniques. Start with a free online Q&A session. Start enjoying a life free from anxiety

Become free from Anxiety and say goodbye to managing your anxiety and start living a happy and content life. This masterclass will show you can change how your mind works to eliminate the negative and debilitating emotional impact of anxiety, once and for all!

Study abroad is about stepping out of your comfort zone, embracing a new culture and way of life, and coming home with unforgettable memories

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

Course Overview The comprehensive British Sign Language Level 1 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the British Sign Language Level 1 today, and learn from the very best the industry has to offer! This best selling British Sign Language Level 1 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth British Sign Language Level 1 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The British Sign Language Level 1 is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The British Sign Language Level 1 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the British Sign Language Level 1, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the British Sign Language Level 1 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the British Sign Language Level 1 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview The comprehensive British Sign Language Level 2 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the British Sign Language Level 2 today, and learn from the very best the industry has to offer! This best selling British Sign Language Level 2 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth British Sign Language Level 2 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The British Sign Language Level 2 is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The British Sign Language Level 2 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the British Sign Language Level 2, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the British Sign Language Level 2 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the British Sign Language Level 2 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Highlights of the Course Course Type: Self-Paced Online Learning Accreditation: AQA Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Certificate: Certificate upon passing the official exam Access: 1 Year Access Tutor Support- Paid Tutor Support Customer Support: 24/7 live chat available What you will learn from this course? Upon successful completion of this GCSE English Language Course, you will be able to: Develop the skill of reading a variety of excellent literature swiftly, clearly, and with connections between the books, you are reading. Acquire the skills necessary to read critically, then use what you learn from in-depth reading to improve and inform your own writing. Understand how to properly use standard English while writing in a concise and persuasive way. Develop key skills to spell, punctuate, and apply grammar correctly Become familiar with grammatical concepts, spoken and written language conventions, and a wide vocabulary, and put these abilities to use GCSE English Language Course This GCSE English Language Course is accredited by AQA and regulated by Ofqual, making it a nationally recognised credential that will improve your CV and set you apart from the competition. Through this course, you will improve your speaking, listening, reading, and writing abilities, which will aid you in showcasing a strong command of the language. Towards the end of this course, You will have the knowledge and abilities necessary to succeed in your official exam and land a job in the relevant field. Who is this Course for? The following individuals may benefit from this GCSE English Language Course: University and job applicants Anyone who wants to receive a higher grade in their GCSE Engish Anyone interested to build a career in this sector Anyone planning to pursue English language at University or A level Anyone trying to increase their chances of landing a job Anyone who wants to work in the publishing, journalism, or teaching fields Anyone who desires to develop their English Communication skills Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Eligibility Requirements This GCSE English Language Course has no academic prerequisites and is open to students from all academic disciplines. You must, however, first complete an initial assessment as well as a diagnostic evaluation in order for us to ascertain your progression level and discover any weak areas before we can create an individualised learning plan for you. All course learning resources will be made available to you after successfully completing this assessment, and you will have a year to view them at your convenience. Career Path This GCSE English Language Course will provide you with a fresh opportunity to enter the relevant job market and successfully escalate to advanced vocational study. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Assessment Procedure Students must complete a variety of interactive online examinations at the conclusion of each module to evaluate the understanding and skills they are learning in this GCSE English Language Course. These assessments also determine if students can demonstrate these skills effectively. At the end of the module, you can also keep track of your progress and regularly check your score. Upon successfully completing this course, you can schedule your official exam by contacting us at [email protected]. There are two paper-based assessments and a spoken language task in the AQA-accredited GCSE English Language. Assessment Format of Paper 1 Concepts covered: Reading (literature fiction text) and writing (descriptive or narrative writing) Exam time: 1 Hour 45 minutes written exam Total marks: 80 Total weight: 50% of GCSE Question format: Short question, long question and extended writing question Assessment Format of Paper 2 Concepts covered: Reading (nonfiction text and literature fiction text) and writing (presenting a viewpoint) Exam time: 1 Hour 45 minutes written exam Total marks: 80 Total weight: 50% of GCSE Question format: Short question, long question and extended writing question Non- Assessment “Spoken Language” Section Students will have the opportunity to showcase their speaking and listening abilities during this assessment. Skills tested: Presenting, responding to questions and feedback, and use of Standard English Total Marks: Marked by the teacher Total Weight: separate endorsement (0% weighting of GCSE) This GCSE English Language Course - AQA English Language Online is accredited by AQA and regulated by Ofqual. What is AQA? AQA, a well-known awarding body, sets standards, administers exams at the GCSE, AS, and A Level in a variety of areas, and grants qualifications to peruse a desired career. More than half of the GCSE and A-level exams that are taken and graded in the UK each year are administered by AQA. Additionally, employers and institutions all across the world highly respect these credentials. Benefits of AQA This qualification is recognised in the UK and across the world It is valued by employers all over the world Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market What is Ofqual? Qualifications, exams, and assessments are governed in England by Ofqual (The Office of Qualifications and Examinations Regulation). They are in charge of identifying the knowledge, skills, and understanding that students have displayed, and also ensuring that all the assessments and exams reveal what a student has accomplished. Benefits of Ofqual Regulation This regulation is valued internationally Created in accordance with specific national standards Designed in collaboration with industry to guarantee their suitability. Accurately reflect the knowledge, abilities, and understanding that the learners have shown. Candidates who have obtained a qualification that is governed by Ofqual are seen with greater confidence by employers. Course Curriculum Paper 1: Explorations in Creative Reading and Writing Reading Reading Identify Explicit Information Q1 - Identify Explicit Information 00:00:00 Assessment - Identify Explicit Information 00:10:00 Analysing Writers' Use of Language 1) Analysing a writer_s use of language 00:00:00 2) Further examples of analysing a writer_s use of language 00:00:00 Assessment - Analysing Writers' Use of Language 00:24:00 Structure 1) What do we mean by structure 00:00:00 2) How writers use structure 00:00:00 3) An example of structure in action 00:00:00 Assessment - Structure 00:24:00 Evaluating Writers' Methods 1) Evaluating a writer_s methods 00:00:00 Assessment - Evaluating Writers' Methods 00:16:00 Writing 1) Descriptive Writing - The Basic Techniques 00:00:00 2) Writing a description suggested by a picture 00:00:00 3) Creating a good story opening 00:00:00 Assessment - Writing 00:10:00 Paper 2: Writers' Viewpoints and Perspectives Reading Identify and Interpret Explicit and Implicit Information and Ideas Q1 - Identify Explicit and Implicit Evidence 00:12:00 Assessment - Identify and Interpret Explicit and Implicit Information and Ideas 00:06:00 Synthesising and Summarising 1) Synthesising and Summarising 00:11:00 Assessment - Synthesising and Summarising 00:10:00 How does the Writer use Language? How Does the Writer Use Language 00:11:00 Assessment - How does the Writer use Language 00:14:00 Comparing Viewpoints and Perspectives Comparing Viewpoints and Perspectives 1 00:11:00 Comparing Viewpoints and Perspectives 2 00:11:00 Comparing Viewpoints and Perspectives 3 00:11:00 Assessment - Comparing Viewpoints and Perspectives 00:10:00 Writing Assessment - Writing 00:20:00 Feedback Feedback 00:00:00 06) Writing Example and Revision Tasks for Question 5 00:13:00 01) Different writing tasks for Question 5 00:00:00 02) Writing to Argue or Persuade 00:00:00 03) Planning and Writing an Article 00:11:00 Writing a Speech and Expressing Opinions 00:11:00

Duration 4 Days 24 CPD hours This course is intended for The information protection administrator translates an organization?s risk and compliance requirements into technical implementation. They are responsible for implementing and managing solutions for content classification, data loss prevention (DLP), information protection, data lifecycle management, records management, privacy, risk, and compliance. They also work with other roles that are responsible for governance, data, and security to evaluate and develop policies to address an organization's risk reduction and compliance goals. This role assists workload administrators, business application owners, human resources departments, and legal stakeholders to implement technology solutions that support the necessary policies and controls. Learn how to protect information in your Microsoft 365 deployment. This course focuses on data lifecycle management and information protection and compliance within your organization. The course covers implementation of data loss prevention policies, sensitive information types, sensitivity labels, data retention policies, Microsoft Purview Message Encryption, audit, eDiscovery, and insider risk among other related topics. The course helps learners prepare for the Microsoft Information Protection Administrator exam (SC-400). Prerequisites Foundational knowledge of Microsoft security and compliance technologies. Basic knowledge of information protection concepts. Understanding of cloud computing concepts. Understanding of Microsoft 365 products and services. 1 - Introduction to information protection and data lifecycle management in Microsoft Purview Know your data Protect your data Prevent data loss Govern your data 2 - Classify data for protection and governance Data classification overview Classify data using sensitive information types Classify data using trainable classifiers Review sensitive information and label usage Explore labeled and sensitive content Understand activities related to your data 3 - Create and manage sensitive information types Compare built-in versus custom sensitive information types Create and manage custom sensitive information types Describe custom sensitive information types with exact data match Implement document fingerprinting Create keyword dictionary 4 - Understand Microsoft 365 encryption Learn how Microsoft 365 data is encrypted at rest Understand service encryption in Microsoft Purview Explore customer key management using Customer Key Learn how data is encrypted in-transit 5 - Deploy Microsoft Purview Message Encryption Implement Microsoft Purview Message Encryption Implement Microsoft Purview Advanced Message Encryption Use Microsoft Purview Message Encryption templates in mail flow rules 6 - Protect information in Microsoft Purview Information protection overview Configure sensitivity labels Configure sensitivity label policies Configure auto-labeling policies Manage, monitor, and remediate information protection 7 - Apply and manage sensitivity labels Apply sensitivity labels to Microsoft Teams, Microsoft 365 groups, and SharePoint sites Plan on-premises labeling Configure on-premises labeling for the Unified Labeling Scanner Apply protections and restrictions to email and files Monitor label performance using label analytics 8 - Prevent data loss in Microsoft Purview Data loss prevention overview Identify content to protect Define policy settings for your DLP policy Test and create your DLP policy Prepare Endpoint DLP Manage DLP alerts in the Microsoft Purview compliance portal View data loss prevention reports Implement the Microsoft Purview Extension 9 - Configure DLP policies for Microsoft Defender for Cloud Apps and Power Platform Configure data loss prevention policies for Power Platform Integrate data loss prevention in Microsoft Defender for Cloud Apps Configure policies in Microsoft Defender for Cloud Apps Manage data loss prevention violations in Microsoft Defender for Cloud Apps 10 - Manage data loss prevention policies and reports in Microsoft 365 Configure data loss prevention for policy precedence Implement data loss prevention policies in test mode Explain data loss prevention reporting capabilities Manage permissions for data loss prevention reports Manage and respond to data loss prevention policy violations 11 - Manage the data lifecycle in Microsoft Purview Data Lifecycle Management overview Configure retention policies Configure retention labels Configure manual retention label policies Configure auto-apply retention label policies Import data for Data Lifecycle Management Manage, monitor, and remediate Data Lifecycle Management 12 - Manage data retention in Microsoft 365 workloads Explain retention in Exchange Online Explain retention in SharePoint Online and OneDrive Explain retention in Microsoft Yammer Activate archive mailboxes in Microsoft Exchange Apply mailbox holds in Microsoft Exchange Recover content in Microsoft Exchange 13 - Manage records in Microsoft Purview Records management overview Import a file plan Configure retention labels Configure event driven retention Manage, monitor, and remediate records 14 - Explore compliance in Microsoft 365 Plan for security and compliance in Microsoft 365 Plan your beginning compliance tasks in Microsoft Purview Manage your compliance requirements with Compliance Manager Examine the Compliance Manager dashboard Analyze the Microsoft Compliance score 15 - Search for content in the Microsoft Purview compliance portal Explore Microsoft Purview eDiscovery solutions Create a content search View the search results and statistics Export the search results and search report Configure search permissions filtering Search for and delete email messages 16 - Manage Microsoft Purview eDiscovery (Standard) Explore Microsoft Purview eDiscovery solutions Implement Microsoft Purview eDiscovery (Standard) Create eDiscovery holds Search for content in a case Export content from a case Close, reopen, and delete a case 17 - Manage Microsoft Purview eDiscovery (Premium) Explore Microsoft Purview eDiscovery (Premium) Implement Microsoft Purview eDiscovery (Premium) Create and manage an eDiscovery (Premium) case Manage custodians and non-custodial data sources Analyze case content 18 - Manage Microsoft Purview Audit (Standard) Explore Microsoft Purview Audit solutions Implement Microsoft Purview Audit (Standard) Search the audit log Export, configure, and view audit log records Use audit log searching to investigate common support issues 19 - Prepare Microsoft Purview Communication Compliance Plan for communication compliance Identify and resolve communication compliance workflow Case study--Configure an offensive language policy Investigate and remediate communication compliance alerts 20 - Manage insider risk in Microsoft Purview Insider risk management overview Create and manage insider risk policies Investigate insider risk alerts Take action on insider risk alerts through cases Manage insider risk management forensic evidence Create insider risk management notice templates 21 - Implement Microsoft Purview Information Barriers Explore Microsoft Purview Information Barriers Configure information barriers in Microsoft Purview Examine information barriers in Microsoft Teams Examine information barriers in OneDrive Examine information barriers in SharePoint 22 - Manage regulatory and privacy requirements with Microsoft Priva Create and manage risk management policies Investigate and remediate risk management alerts Create rights requests Manage data estimate and retrieval for rights requests Review data from rights requests Get reports from rights requests 23 - Implement privileged access management Case study--Implementing privileged access management 24 - Manage Customer Lockbox Manage Customer Lockbox requests