• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

10675 Courses delivered Online

Child Protection, ADHD and Autism Diploma

4.7(47)

By Academy for Health and Fitness

Take the first step towards a compassionate and fulfilling career with our all-inclusive course bundle: "Child Protection, ADHD, and Autism Diploma". Gain a profound theoretical understanding of child protection and the intricacies of developmental disorders, with three QLS-endorsed courses, complete with hardcopy certification. These include Child Protection & Safeguarding, ADHD Awareness, and Autism. Additionally, five relevant CPD QS accredited courses enrich your knowledge base further, covering Children's Mental Health, Learning Disability Nursing, Diabetes, Dementia Awareness, and Child Language Disorder (CLD). Immerse yourself in the complexities of child development and care, equipping yourself with the theoretical insight to support those who need it most. Elevate your understanding, nurture your empathy, and cultivate your skills with this comprehensive course bundle. Empower yourself to make a significant difference in the lives of children and adults living with developmental and health challenges. Start your journey today! Key Features of the Child Protection, ADHD and Autism Diploma Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Child Protection, ADHD and Autism Diploma bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Child Protection & Safeguarding QLS Course 02: ADHD Awareness QLS Course 03: Autism 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Children's Mental Health CPD Course Course 02: Learning Disability Nursing Course 03: Diabetes Course 04: Dementia Awareness Course 05: Child Language Disorder (CLD) In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Child Protection, ADHD and Autism Diploma courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Outcomes: Upon completion of this bundle, learners will be able to: Understand the fundamentals of Child Protection & Safeguarding. Gain theoretical knowledge on ADHD and Autism. Develop a broad understanding of Children's Mental Health. Grasp the theoretical concepts of Learning Disability Nursing. Gain theoretical insight into managing Diabetes and Dementia. Understand Child Language Disorder (CLD). Apply this theoretical knowledge in a caregiving or educational setting. Embrace the opportunity to make a profound impact with our "Child Protection, ADHD, and Autism Diploma" course bundle. Comprising eight complementary courses, this bundle offers an in-depth theoretical understanding of diverse aspects of child care, mental health, and learning disabilities. Dive into the complexity of developmental disorders and learn how to approach them empathetically and effectively. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course bundle is ideal for: Individuals seeking a career in child protection or care. Health professionals desiring to enhance their understanding of developmental disorders. Educators wanting to expand their theoretical knowledge of children's mental health. Anyone interested in learning about developmental disabilities, dementia, and diabetes. Career path Child Protection Officer (Salary Range: £27,000 - £37,000) Special Education Teacher (Salary Range: £24,000 - £41,000) Mental Health Support Worker (Salary Range: £18,000 - £25,000) Learning Disability Nurse (Salary Range: £24,000 - £37,000) ADHD/Autism Support Worker (Salary Range: £17,000 - £25,000) Dementia Care Specialist (Salary Range: £20,000 - £30,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Child Protection, ADHD and Autism Diploma
Delivered Online On Demand38 hours
£309

The Complete Kotlin Developer Course

By Packt

Programming for Android and JavaScript made easy with the Kotlin language

The Complete Kotlin Developer Course
Delivered Online On Demand12 hours 17 minutes
£140.99

Computer Programmer QLS Endorsed Courses

By Imperial Academy

Computer Programming: Where Inspiration Meets Logic And Dreams Become Lines Of Code

Computer Programmer QLS Endorsed Courses
Delivered Online On Demand
£599

TEFL (TESOL) Course

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 120 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about TEFL / TESOL Understand the core competencies and principles of TEFL / TESOL Explore the various areas of TEFL / TESOL Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert TEFL / TESOL trainer TEFL (TESOL) Course Master the skills you need to propel your career forward in TEFL / TESOL. This course will equip you with the essential knowledge and skillset that will make you a confident TEFL / TESOL trainer and take your career to the next level. This comprehensive TEFL (TESOL) course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this TEFL (TESOL) course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective TEFL / TESOL practice and equip you with the essential skills, confidence and competence to assist you in the TEFL /TESOL industry. You'll gain a solid understanding of the core competencies required to drive a successful career in TEFL / TESOL. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for TEFL / TESOL trainer or for people who are aspiring to specialise in TEFL / TESOL. Enrol in this TEFL (TESOL) course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive TEFL (TESOL) course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this TEFL / TESOL can also take this course. 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. Entry Requirements This TEFL (TESOL) course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This TEFL (TESOL) course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This TEFL (TESOL) course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. 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. 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 Module 01: TEFL Principles Module 01: TEFL Principles 00:12:00 Module 02: TEFL Methodology Module 02: TEFL Methodology 00:27:00 Module 03: Teaching a Language Module 03: Teaching A Language 00:33:00 Module 04: Teaching Vocabulary and Grammar Module 04: Teaching Vocabulary And Grammar 00:37:00 Module 05: Grammar and Tenses Module 05: Grammar And Tenses 02:07:00 Module 06: Teaching Receptive Skills Module 06: Teaching Receptive Skills 00:28:00 Module 07: Classroom Management Module 07: Classroom Management 00:32:00 Module 08: Teaching Tools Module 08: Teaching Tools 00:33:00 Module 09: Correcting Students Module 09: Correcting Students 00:22:00 Module 10: Lesson Planning Module 10: Lesson Planning 00:23:00 Assessment Assessment - TEFL (TESOL) Course 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

TEFL (TESOL) Course
Delivered Online On Demand
£19

Proofreading, Copy Editing & Fact-Checking

4.7(160)

By Janets

Follow your dreams by enrolling on the Proofreading, Copy Editing & Fact-checking course today and develop the experience, skills and knowledge you need to enhance your expert development. Proofreading, Copy Editing & Fact-checking will help you arm yourself with the qualities you need to work towards your dream job. Study the Proofreading, Copy Editing & Fact-checking training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Proofreading, Copy Editing & Fact-checking course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Proofreading, Copy Editing & Fact-checking course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Proofreading, Copy Editing & Fact-checking course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Proofreading, Copy Editing & Fact-checking course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Proofreading, Copy Editing & Fact-checking course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Proofreading, Copy Editing & Fact-checking course. The Proofreading, Copy Editing & Fact-checking course is designed by industry experts and is tailored to help you learn new skills with ease.  The Proofreading, Copy Editing & Fact-checking is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Proofreading, Copy Editing & Fact-checking when it suits you. Access the Proofreading, Copy Editing & Fact-checking course modules from any internet-enabled device, including computers, tablets, and smartphones. The Proofreading, Copy Editing & Fact-checking course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Proofreading, Copy Editing & Fact-checking now and start learning instantly! What You Get Out Of Studying Proofreading, Copy Editing & Fact-checking With Janets: Receive a digital Certificate upon successful completion of the Proofreading, Copy Editing & Fact-checking course Get taught by experienced, expert 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) Description The Proofreading, Copy Editing & Fact-Checking training course is delivered through Janets' online learning platform. Access the Proofreading, Copy Editing & Fact-Checking content from any internet-enabled device whenever or wherever you want to. The Proofreading, Copy Editing & Fact-Checking course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who Is This Course For: The Proofreading, Copy Editing & Fact-checking is ideal for those who already work in this sector or are an aspiring expert. This Proofreading, Copy Editing & Fact-checking course is designed to enhance your expertise and boost your CV. Learn key skills and gain a expert lesson to prove your newly-acquired knowledge. Requirements: The Proofreading, Copy Editing & Fact-Checking is open to all students and has no formal entry requirements. To study the Proofreading, Copy Editing & Fact-Checking course, 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. Career Path: The Proofreading, Copy Editing & Fact-checking is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Proofreading, Copy Editing & Fact-checking and gain an industry-acknowledged lesson that will help you excel in finding your ideal job. Course Content Module 1: Proofreading Basics Proofreading Basics 00:35:00 Module 2: Applying the Style Guide Applying the Style Guide 00:11:00 Module 3: Spelling and Grammar Spelling and Grammar 00:15:00 Module 4: Proofreading on Paper Proofreading on Paper 00:06:00 Module 5: Proofreading On-Screen Proofreading On-Screen 00:40:00 Module 6: Copy-Editing Basics Copy-Editing Basics 00:41:00 Module 7: Copy-Editing - The Use of Language Copy-Editing - the Use of Language 00:26:00 Module 8: Copy-Editing - Checking Accuracy and Facts Copy-Editing - Checking Accuracy and Facts 00:10:00 Module 9: Copy-Editing - The Beginning and The End Copy-Editing - the Beginning and the End 00:10:00 Module 10: Copy-Editing - Legal Checks Copy-Editing - Legal Checks 00:20:00 Module 11: Finding Work and Developing Your Career Finding Work and Developing Your Career 00:15:00 Mock Exam Mock Exam - Proofreading, Copy Editing & Fact-Checking 00:20:00 Final Exam Final Exam - Proofreading, Copy Editing & Fact-Checking 00:20:00 Assignment Assignment - Proofreading, Copy Editing & Fact-Checking 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00: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.

Proofreading, Copy Editing & Fact-Checking
Delivered Online On Demand3 weeks
£25

Autism and Safeguarding Child - Endorsed Training

4.7(47)

By Academy for Health and Fitness

Unlock the keys to the world of Autism and Safeguarding Children with this compelling course bundle! We are excited to bring you two QLS-endorsed courses: "Autism" and "Child Protection & Safeguarding." As an added bonus, we've included five additional relevant CPD QS accredited courses to further enrich your knowledge: "Children's Mental Health," "Learning Disability Nursing," "Diabetes," "Dementia Awareness," and "Child Language Disorder (CLD)." What makes this Autism and Safeguarding Children bundle unique is its emphasis on theoretical understanding. Our QLS-endorsed courses don't just offer top-tier learning material but also equip you with a hardcopy certificate upon completion, validating your dedication and expertise. Alongside, you will delve into a spectrum of critical topics through our five CPD QS accredited courses, each a specialised area with immense societal relevance. This bundle is a goldmine of knowledge for anyone keen on understanding Autism and the complexity of safeguarding children. As you navigate through these courses, you'll discover the layers of mental health, learning disabilities, and disease awareness. Your journey will culminate in mastering Child Language Disorders, empowering you to make significant contributions in the field of Autism and Safeguarding Children. Take your first step towards mastering Autism and Safeguarding Child studies. Immerse yourself in this all-inclusive course bundle today and enjoy a fulfilling learning experience like no other! This bundle comprises the following courses: QLS Endorsed Courses: Course 01: Diploma in Autism and Dyslexia Awareness at QLS Level 5 Course 02: Diploma in Child Protection & Safeguarding Children at QLS Level 5 CPD QS Accredited Courses: Course 03: Children's Mental Health Course 04: Learning Disability Nursing Course 05: Diabetes Course 06: Dementia Awareness Course 07: Child Language Disorder (CLD) Learning Outcomes By the end of this Autism and Safeguarding Children bundle course, learners will be able to: Gain a comprehensive understanding of Autism and child safeguarding measures. Develop an understanding of children's mental health and associated challenges. Enhance your knowledge of learning disability nursing. Learn about diabetes, its effects, and management strategies. Acquire insights into Dementia, its types, symptoms, and care. Understand Child Language Disorder and the techniques to handle it. Become well-versed with child protection and safeguarding protocols. Earn QLS-endorsed hardcopy certificates for Autism and Child Protection & Safeguarding courses. This course bundle is meticulously crafted to provide learners with a broad theoretical understanding of Autism and child safeguarding. The QLS-endorsed courses offer an in-depth study of Autism and the measures necessary for Child Protection & Safeguarding. These topics are of paramount importance and are highly relevant in today's society. The other five courses in the bundle will walk you through topics such as Children's Mental Health, Learning Disability Nursing, Diabetes, Dementia Awareness, and Child Language Disorder. Each course is designed to equip learners with comprehensive knowledge of the respective subjects. By understanding these essential aspects, you can significantly contribute to safeguarding children's health and well-being. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Autism and Safeguarding Children course ideal for: Parents seeking a deeper understanding of their child's development and health. Teachers and school administrators keen on safeguarding students' welfare. Health and social care professionals aiming to enhance their knowledge base. Anyone interested in the fields of Autism and Child Safeguarding. Career path Autism Support Specialist: Salary range £21,000 - £30,000. Child Protection Officer: Salary range £27,000 - £35,000. Children's Mental Health Counselor: Salary range £23,000 - £37,000. Learning Disability Nurse: Salary range £24,000 - £37,000. Dementia Care Specialist: Salary range £20,000 - £33,000. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Autism and Safeguarding Child - Endorsed Training
Delivered Online On Demand27 hours
£149

ICA Internal Auditor for Compliance Management Systems

By International Compliance Association

Achieving certification for Compliance Management Systems (ISO 37301:2021) through an external audit process to help you identify, prevent and address compliance risks within your organisation provides a range of benefits. What if you could gain the expertise to conduct internal audits in-house, to not only successfully complete ISO certification, but allow you to continue to monitor your adherence to that certification standard? 'Prove your competency to the wider compliance industry.' Created by UKAS accredited ISO certification experts, this wholly unique, internationally focussed, 2-day online internal auditor training course is a fantastic way to develop your in-house expertise and allow your team to attain the competence they need to maintain and continually improve your management system. A cost-effective route, negating the need to hire external consultants Avoid closing a business for what might be a lengthy audit Prove your ' culture of compliance', and in turn, strengthen your 2nd and 3rd lines of defence Add additional skills to your CV, demonstrating your commitment to best practice while gaining a competitive advantage for your organisation. 'Don't just tick the boxes, demonstrate a culture of compliance.' Ensure you are fully compliant with relevant legislation and regulation and give confidence to the regulators, your partners, and clients that you have processes in place to comply with the law. Developing knowledge of compliance management system standards/normative documents Developing knowledge of ICA Audit (certification body's) processes Developing knowledge of relevant business sectors Developing knowledge of business management practices and how they integrate into business activities Developing knowledge of audit principles, practices, and techniques Developing knowledge of client products, processes, and organization Developing language skills appropriate to all levels within the client organization Developing notetaking and report-writing skills Developing presentation skills Developing interviewing skills

ICA Internal Auditor for Compliance Management Systems
Delivered OnlineFlexible Dates
£1,095

ISTQB® Foundation Training Course for the team (BCS CTFL) - Manchester

By Day Consulting - ISTQBĀ® accredited training provider

ISTQB® FOUNDATION TRAINING COURSE (2 persons minimum) The aim of this course is to provide you with the knowledge and skills to pass an exam certifying you as an ISTQB® Certified Tester - Foundation Level. Most organisations require this certification as a minimum skill requirement for software testers. In this course you will learn a standardized approach to software testing that will be immediately applicable to your projects. In order to get the certification you will be required to pass a 60-minute exam. Our trainers will fully prepare you by employing scenarios that mirror the exam questions, and by focusing course delivery with a balance of theory and practice. Target group: Functional Tester, Agile Tester, User Acceptance Tester, Test Automation Specialist, Performance Testing Specialist, Testing Team Lead, Test Manager, Business analyst Prerequisites: There are no specific prerequisites for this course. This course is suitable for anyone involved in software testing. Duration: 3 days. Training objectives: Learn aspects of test planning, estimation, monitoring and control. Understand and use international standards and terminology. Understand and implement effective testing techniques. Be well prepared for the exam. Identify the missing testing skills for the career development purposes. This course covers the following areas: Fundamentals of software testing Testing throughout the life cycle (software development models, test levels, test types) Test design techniques (e.g. specification-based or black-box techniques, structure-based or white-box techniques) Static testing (static testing techniques, review process, tool-assisted static analysis) Test management (test organisation, test planning and estimation, test progress monitoring and control, risks) Tools to support testing (types, benefits and risks) Language: English

ISTQB® Foundation Training Course for the team (BCS CTFL) - Manchester
Delivered in person or OnlineFlexible Dates
£1,200

Functional Skills English - QLS Endorsed

By Imperial Academy

FREE Level 3 QLS Hard Copy Certificate | 120 CPD Points | Advanced Learning Materials | Lifetime Access | Tutor Support

Functional Skills English - QLS Endorsed
Delivered Online On Demand
£100

DP-080T00 Querying Data with Microsoft Transact-SQL

By Nexus Human

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.

DP-080T00 Querying Data with Microsoft Transact-SQL
Delivered OnlineFlexible Dates
£1,190