10462 Courses in London delivered Online

E-Learning courses are self study courses which students can join from anywhere in the world.

E-Learning courses are self study courses which students can join from anywhere in the world.

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

Speech Therapy: Speech Therapy Course Online Unlock the Power of Speech Therapy: Speech Therapy Course: Enrol Now! This exclusive Speech Therapy: Speech Therapy Course provides learners with a comprehensive overview of the role of a Speech and Language Therapist, equipping you with the essential skills to advance your career. It includes speech science, speech anatomy, and the characteristics of speech in detail. This Speech Therapy: Speech Therapy Course includes case studies and practical exercises that will teach you how to assess your clients' needs, set long-term goals, and support them every step of the way to recovery using a variety of communication techniques. In addition, you will gain in-demand professional skills that will help you start your career successfully. Learning Outcome After completing this Speech Therapy: Speech Therapy Course, the learner will be able to: Understand the fundamentals of Speech & Language Therapy. Understand the study of communication. Explain components of normal speech, language & voice and communication disorders. Understand eating, drinking and swallowing disorders. Understand the speech & language therapy process. Why choose this Speech Therapy: Speech Therapy Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Speech Therapy: Speech Therapy Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Speech Therapy: Speech Therapy Course. Main Course: Speech Therapy Course Free Courses included with Speech Therapy: Speech Therapy Course: Course 01: Advanced Diploma in Child Care Course 02: Early Years Level 4 [ Note: Free PDF certificate as soon as completing the Speech Therapy: Speech Therapy Course] Speech Therapy: Speech Therapy Course Online This Speech Therapy: Speech Therapy Course consists of 04 modules. Course Curriculum of Speech Therapy: Speech Therapy Course Module 01: Speech & Language Therapy Module 02: Study of Communication Module 03: Components of Normal Speech, Language & Voice and Communication Disorders Module 04: Eating, Drinking and Swallowing Disorders Assessment Method of Speech Therapy: Speech Therapy Course After completing Speech Therapy: Speech Therapy Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Speech Therapy: Speech Therapy Course After completing the Speech Therapy: Speech Therapy Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Speech Therapy: Speech Therapy Course Online This Speech Therapy: Speech Therapy Course is ideal for anyone who wants to: Gain the skills needed to work in the teaching and child care profession. Improve their speech therapy and language therapy skills. Make a career change and explore new career opportunities. Gain a formal, accredited qualification to improve their career opportunities. Requirements Speech Therapy: Speech Therapy Course Online To enrol in this Speech Therapy: Speech Therapy Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Speech Therapy: Speech Therapy Course. Be energetic and self-motivated to complete our Speech Therapy: Speech Therapy Course. Basic computer Skill is required to complete our Speech Therapy: Speech Therapy Course. If you want to enrol in our Speech Therapy: Speech Therapy Course, you must be at least 15 years old. Career path Speech Therapy: Speech Therapy Course Online Opportunities in this Speech Therapy: Speech Therapy Course field include: SEN Teaching Assistant SEN Teacher Language Tutor

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Discover the power of proofreading AI tools like Grammarly and ProWritingAid. Master your skills in editing and proofreading for any legal or official document.

English Grammar course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in English Grammar. Our course starts with the basics of English Grammar and gradually progresses towards advanced topics. Therefore, each lesson of this English Grammar is intuitive and easy to understand. So, stand out in the job market by completing the English Grammar course. Get an accredited certificate and add it to your resume to impress your employers. Along with the English Grammar course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the Course Introduction to the Course Basics of Grammar The Basics of Sentence Structure of Sentence Questions Punctuation and Capitalisation Spelling Common Mistakes and Ways to Improve CPD 10 CPD hours / points Accredited by CPD Quality Standards Chapter 01: Introduction to the Course 02:00 1: Chapter 01: Introduction to the Course 02:00 Chapter 02: Basics of Grammar 02:00 2: Chapter 02: Basics of Grammar 02:00 Chapter 03: The Basics of Sentence 02:00 3: Chapter 03: The Basics of Sentence 02:00 Chapter 04: Structure of Sentence 02:00 4: Chapter 04: Structure of Sentence 02:00 Chapter 05: Questions 02:00 5: Chapter 05: Questions 02:00 Chapter 06: Punctuation and Capitalisation 02:00 6: Chapter 06: Punctuation and Capitalisation 02:00 Chapter 07: Spelling 02:00 7: Chapter 07: Spelling 02:00 Chapter 08: Common Mistakes and Ways to Improve 02:00 8: Chapter 08: Common Mistakes and Ways to Improve 02:00 Order Your CPD Quality Standard Certificate (Optional) 01:00 9: CPD Certificate (Optional) 01:00 Who is this course for? Anyone from any background can enrol in this English Grammar course. Requirements To enrol in this English Grammar course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to English Grammar. Certificates Reed courses certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed CPD Quality Standard Certificate Digital certificate - £7.99

Register on the Proofreading & Copyediting today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Proofreading & Copyediting is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Proofreading & Copyediting Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Proofreading & Copyediting, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 1: Proofreading Basics Proofreading Basics 00:25:00 Module 2: Applying the Style Guide Applying the Style Guide 00:20:00 Module 3: Spelling and Grammar Spelling and Grammar 00:15:00 Module 4: Proofreading on Paper Proofreading on Paper 00:25:00 Module 5: Proofreading On-Screen Proofreading On-Screen 01:00:00 Module 6: Copy-Editing Basics Copy-Editing Basics 01:00:00 Module 7: Copy-Editing - The Use of Language Copy-Editing - The Use of Language 00:45:00 Module 8: Copy-Editing - Checking Accuracy and Facts Copy-Editing - Checking Accuracy and Facts 00:15:00 Module 9: Copy-Editing - The Beginning and The End Copy-Editing - The Beginning and The End 00:15:00 Module 10: Copy-Editing - Legal Checks Copy-Editing - Legal Checks 00:30:00 Module 11: Finding Work and Developing Your Career Finding Work and Developing Your Career 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Deaf Awareness Training Overview 1 to 1 Live Tutor Support Included | Accredited by CPD | Interactive One Day Training Deaf Awareness Training: a powerful tool that promotes inclusion and improves access for deaf people and those with hearing loss. Deaf Awareness Training Course Description: This Deaf Awareness programme is a general introduction to deafness. Its purpose is to provide information and strategies that will enable individuals to understand a range of deaf issues and use the knowledge gained to communicate more effectively with those from the hard of hearing through to the profoundly deaf. It is designed for anyone in a work or social capacity who has the potential to come into contact with deaf people, for example, banks and retail staff, care workers, education and training bodies, emergency services, hospital and health centre staff, housing associations, legal services, public sector workers, support organisations, theatre and cinema staff, transport bodies and breakdown services, friends, family members and partners, whilst also being a valuable first step for people planning on becoming a communication professional. The programme will equip the reader with awareness skills that when applied will reduce the barriers arising from the communication difficulties between hearing and deaf people. **This course is distributed under the Lead Academy licence.** In Deaf Awareness Training you'll learn about: The importance of deaf awareness, being deaf, different experiences of deafness and hearing loss: you'll experience different perspectives of deafness to enable you to understand how it affects individuals. A history of deafness: we look back through history and consider how attitudes and policies impact on deaf people, then and now. Deaf culture and sign language: you'll gain an insight into unique communities who identify not as a group with a disability but as cultural minorities with their own languages. Equal access: we look at why equal access is important, the effectiveness of lipreading, guidance on good communication and adjustments related to deafness. Some commonly available communication aids and support - from qualified communication-support professionals to technology such as real-time speech-to-text. Accredited by CPD CPD is Recognised by Employers Areas for discussion: Understand how to remove communication barriers A personal experience; how it is to live with a hearing loss Strategies for improved communication Managing your environment and improve accessibility to your services Understand the current hearing technologies to help you understand how hearing loss impacts 11 million people who are affected in the UK Meet the Trainer Adam Linsdell Hello. My name is Adam and I am a British Sign Language Teacher. I am Deaf and have been using British Sign Language since I was a teenager. My personal experience of Deafness was my primary reason for learning BSL and why I have such a deep passion for this beautiful and expressive language. I have studied BSL to NVQ Level 6 and trained to become a teacher, enabling me to achieve my dream of teaching BSL in my local community. This opportunity has enabled me to work with the local Deaf community, building strong relationships and links. I have taught sign language throughout Cambridge, teaching at Anglia Ruskin University, Cambridge Regional College, Cambridgeshire Deaf Association and Cottenham Village College. Usually, I teach face to face but due to the COVID pandemic, my classes moved online - this has been a new experience and a great opportunity for me and my learners. Deaf Awareness Training, Winter 2021 Class starts 4th December 2021 Weekly via Zoom with face to face session Duration: 3 Hours Day & Time: Saturday Mornings, 10.00am - 01.00pm Deaf Awareness Training Full Specification Venue: Zoom Online Teacher: Adam Landsdell Who this course is for: The course is aimed at anyone who interacts with deaf people, or those with a hearing loss, who wishes to have a deeper understanding of the issues they face and Deaf culture. Progression Routes: Further courses are available which cover British Sign Language in more depth: BSL Taster (6 to 12 hours) Level 1 Award in British Sign Language BSL at Work (up to 12 hours) **This course is distributed under the Lead Academy licence.** Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Types of Deafness Statistics Differing Abilities Language Barriers Communication Tactics and Tips (Communication Professionals) Communication Support and How to Use it Modifying Documents and Plain English Use Interpreting Technology / Assistive Aids Legislation Deaf History and Deaf Culture Basic British Sign Language (BSL syntax & grammar) Gesture & Expression Obtain Your Certificate

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++