28597 Development courses in Leeds delivered Online

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before. Do you aspire to create exceptional websites? Embrace the power of the Modern Web Design Training course - CPD Certified. This web design course promises a comprehensive journey through the world of creative, innovative, and responsive web design. Our meticulously structured modules will help you acquire mastery over the aesthetic and technical aspects of web design, setting a foundation for your future projects. It doesn't matter if you're a beginner or a seasoned professional seeking to upgrade your skills, this course offers something for everyone. Experience an inspiring and enriching journey, exploring the cutting-edge techniques that today's web design industry demands. With a focus on CPD-certified learning, our Modern Web Design Training course is your gateway to success. Courses Are Included in this Web Design: Modern Web Design Training - CPD Certified Bundle: Course 01: Diploma in Complete Web Development at QLS Level 5 Course 02: HTML Web Development Crash Course Course 03: CSS Web Development Course 04: User Experience Design from A-Z: Adobe XD UI/UX Design Course 05: Bootstrap - Responsive Web Design Learning Objectives of Web Design Bundle: Understand the fundamental principles of web design and its role in modern digital communication. Develop proficiency in using web design tools and technologies to create responsive, user-friendly websites. Gain a comprehensive knowledge of the latest trends and practices in the web design industry. Enhance your creative capabilities and technical skills in web design, while building an impressive portfolio. Establish a solid understanding of web design usability and accessibility, ensuring your websites reach a broad audience. Learn to effectively manage web design projects, ensuring timely delivery while maintaining high-quality standards Why Choose Our Web Design Course? FREE Web Design certificate accredited Get a free student ID card with Web Design Training Get instant access to this Web Design course. Learn Web Design from anywhere in the world Web Design is an entirely online, interactive lesson with voiceover audio Lifetime access 24/7 tutor support Start your learning journey straightaway with Web Design: Modern Web Design Training - CPD Certified ! This course curriculum has been designed by Web Design experts with years of experience behind them. Assessment Process of Web Design: Modern Web Design Training - CPD Certified Once you have completed all the courses in this bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterward. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is suitable for everyone. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path This bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Certificate Of Completion Digital certificate - £10 Certificate Of Completion Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

Get ready for an exceptional online learning experience with the Transport and Logistics (Import/Export, Logistics & Supply Chain Management) bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Transport and Logistics (Import/Export, Logistics & Supply Chain Management) is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Transport and Logistics package has something for everyone. As part of the Transport and Logistics (Import/Export, Logistics & Supply Chain Management) package, you will receive complimentary PDF certificates for all courses in the Transport and Logistics bundle at no extra cost. Equip yourself with the Transport and Logistics bundle to confidently navigate your career path or personal development journey. Enrol our Transport and Logistics bundle today and start your career growth! This Transport and Logistics Bundle Comprises the Following CPD Accredited Courses: Course 01: Transport Manager Course 02: Import/Export Course 03: Logistics Management Course 04: Operations Management Course 05: Supply Chain Management Course 06: Certificate in Purchasing and Procurement Course 07: Quality Management Course 08: Product Management Course 09: Anti-Money Laundering & Staff Awareness Training Course 10: Operations and Warehouse Management with Transport Management Course 11: Warehouse Safety Course 12: Manual Handling for Warehouse Operation Course 13: Airport Management Course Course 14: Driver Safety Awareness Certificate Course 15: Compliance Management Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the Transport and Logistics (Import/Export, Logistics & Supply Chain Management) course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Transport and Logistics Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Transport and Logistics Bundle. Build a strong knowledge base in your chosen course via the Transport and Logistics Bundle. Benefit from the flexibility and convenience of online learning. With the Transport and Logistics package, validate your learning with a CPD certificate. Each course in Transport and Logistics (Import/Export, Logistics & Supply Chain Management) bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Transport and Logistics (Import/Export, Logistics & Supply Chain Management), a rich anthology of 15 diverse courses. Each course in the Transport and Logistics bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisTransport and Logistics (Import/Export, Logistics & Supply Chain Management) bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Transport and Logistics (Import/Export, Logistics & Supply Chain Management) bundle offers you the flexibility and convenience to learn at your own pace. Make the Transport and Logistics package your trusted companion in your lifelong learning journey. CPD 205 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Transport and Logistics (Import/Export, Logistics & Supply Chain Management) bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Transport and Logistics (Import/Export, Logistics & Supply Chain Management) course. Career path Unleash your potential with the Transport and Logistics (Import/Export, Logistics & Supply Chain Management)bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Transport and Logistics bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

*** 24 Hour Limited Time Flash Sale *** Life Coaching, Mentoring and Train the Trainer Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you passionate about helping others reach their full potential and overcoming personal challenges? The demand for life coaches and mentors in the UK has grown significantly, with a recent survey revealing that 75% of individuals seeking personal development turn to professional coaching. Imagine being able to help others excel, guide them towards their goals, and become a confident leader yourself. This comprehensive course bundle equips you with the tools and knowledge to become a life coach, a mentor, and even a trainer! Our course on Life Coaching, Mentoring and Train the Trainer equips you with the core skills and knowledge to excel in life coaching, mentoring, and even training others. Learn powerful coaching methodologies, master communication to build strong relationships, and develop the confidence to become a captivating speaker. You'll also gain effective strategies for overcoming phone addiction and building resilience-essential skills for success in today's fast-paced world. Key Features of the Coaching & Mentoring, Spiritual Life and Train the Trainer Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Coaching & Mentoring, Spiritual Life and Train the Trainer bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Coaching & Mentoring QLS Course 02: Spiritual Life Coaching QLS Course 03: Train the Trainer - Trainer Training 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: Leadership Skills for The FutureCourse 02: Communication Masterclass Building Strong RelationshipsCourse 03: Public Speaking: Presentations like a BossCourse 04: The Power of ResilienceCourse 05: Learn How to Overcome Phone Addiction In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV WritingCourse 02: Job Search SkillsCourse 03: Self Esteem & Confidence BuildingCourse 04: Professional Diploma in Stress ManagementCourse 05: Complete Communication Skills Master Class Convenient Online Learning: Our Coaching & Mentoring, Spiritual Life and Train the Trainer courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Start your transformative journey today and embrace a brighter future. Say goodbye to ordinary and embrace extraordinary with our Coaching & Mentoring, Spiritual Life, and Train the Trainer Bundle. Enrol now and empower yourself with knowledge that will last a lifetime. Learning Outcomes of Life Coaching, Mentoring and Train the Trainer Develop effective coaching techniques to support clients' personal growth. Create impactful mentoring strategies tailored to individual needs. Design and deliver engaging training programs for diverse audiences. Enhance leadership skills to navigate future challenges confidently. Master communication skills to build strong, effective relationships. Learn resilience techniques to thrive in challenging environments. Why Choose Us? Get 3 QLS Endorsed Certificate upon completion of Life Coaching and Train the Trainer Get a free student ID card with Life Coaching and Train the Trainer Training program (£10 postal charge will be applicable for international delivery) The Life Coaching and Train the Trainer is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Life Coaching and Train the Trainer course materials The Life Coaching and Train the Trainer comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Coaching & Mentoring Module 01: Introduction to Performance Coaching Module 02: The Coach/Client Relationship Module 03: Coaching and Mentoring Models Module 04: Ethical Aspects of Coaching and Mentoring Module 05: Effective Communication Skill Module 06: Personal Skills Module 07: Management Skills Module 08: Organisational Skills Module 09: Motivation and Mindset Module 10: Key Themes of NLP Module 11: The Relationship Between Stress and Performance: The Inverted-U Theory Module 12: Leadership Under Pressure Module 13: Setting Up as a Coach QLS Course 02: Spiritual Life Coaching Basics of Spiritual Life Coaching Understanding Spiritual Life Coaching Fundamental Qualities of a Coach Advanced Coaching Ethical Guideline Marketing Your Business Growing Your Business QLS Course 03: Train the Trainer - Trainer Training Introduction And Welcome Introduction to Trainer Bootcamp What Makes a Great Trainer? Make Them Feel Safe Before Class Make Them Feel Safe Before Class Introduction Make Comfortable Small Talk - Part 1 Make Comfortable Small Talk - Part 2 Make Comfortable Small Talk - Activity Feedback Make an Impressive First Impression Give Last Minute Reminders - Part 1 Give Last Minute Reminders - Part 2 Start With An Amazing Opener Give Your Introduction - Part 1 Give Your Introduction - Part 2 Give Your Introduction - Part 3 Find Out About Them Reveal the Takeaways Set Boundaries and Expectations - Part 1 Set Boundaries and Expectations - Part 2 Give the Lesson Hook Build Credibility And Rapport Qui Do an Oral Review - Part 1 Do an Oral Review - Part 2 Send Them to Break Walk and Talk During Break Bring Them Back From Break =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*13 = £168) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Course: Previously it was £119*3 =357) CPD 450 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring coaches and mentors looking to enhance their skills and empower others. Individuals seeking personal and spiritual growth. Professionals interested in becoming trainers and delivering impactful training sessions. Leaders and managers aiming to develop advanced leadership skills. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Professional Coach or Mentor: Salary range - £30,000 to £100,000 per year. Spiritual Life Coach: Salary range - £25,000 to £70,000 per year. Corporate Trainer: Salary range - £25,000 to £60,000 per year. Leadership Development Specialist: Salary range - £35,000 to £80,000 per year. Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Embark on a captivating journey into the mind with our comprehensive course 'The Neuroscience of Learning: Unlocking Your Cognitive Potential'. This enlightening course delves into the intricate world of neuroscience and its pivotal role in learning, providing you with invaluable insights into cognitive development, neuroplasticity, attention, focus, and the influence of emotions on learning. Through this course, you will explore the neuroscience behind motivation and reward systems, gain an understanding of learning disorders and neurodiversity, and discover effective, brain-based learning strategies. Unravel the mysteries of the human brain and unlock your full cognitive potential to enhance your learning capability and overall performance. Learning Outcomes Understand the basics of neuroscience and its connection to learning. Explore the concept of neuroplasticity and its role in learning. Understand cognitive development, attention, focus, and the impact of emotions on learning. Gain insight into motivation and reward systems in the brain. Develop effective, brain-based learning strategies and understand learning disorders and neurodiversity. Why choose this The Neuroscience of Learning: Unlocking Your Cognitive Potential course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this The Neuroscience of Learning: Unlocking Your Cognitive Potential course for? Educators and teachers seeking to understand the neuroscience behind learning. Students aiming to enhance their learning potential. Professionals working in cognitive development and brain-based learning. Individuals interested in understanding the brain and its impact on learning. Healthcare professionals working with learning disorders and neurodiversity. Career path Educational Neuroscientist: £35,000 - £45,000 per annum Learning and Development Specialist: £30,000 - £40,000 per annum Cognitive Enhancement Coach: £28,000 - £38,000 per annum Neuroeducation Consultant: £26,000 - £36,000 per annum Education Technology Specialist: £30,000 - £40,000 per annum Neuroscience Research Assistant: £28,000 - £38,000 per annum Prerequisites This The Neuroscience of Learning: Unlocking Your Cognitive Potential does not require you to have any prior qualifications or experience. You can just enrol and start learning.This The Neuroscience of Learning: Unlocking Your Cognitive Potential was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Neuroscience and Learning Introduction to Neuroscience and Learning 00:09:00 Module 02: Basics of Neuroscience Basics of Neuroscience 00:16:00 Module 03: Neuroplasticity and Learning Neuroplasticity and Learning 00:14:00 Module 04: Cognitive Development and Learning Cognitive Development and Learning 00:13:00 Module 05: Attention and Focus Attention and Focus 00:13:00 Module 06: Emotions and Learning Emotions and Learning 00:11:00 Module 07: Motivation and Reward Systems Motivation and Reward Systems 00:12:00 Module 08: Learning Disorders and Neurodiversity Learning Disorders and Neurodiversity 00:12:00 Module 09: Brain-Based Learning Strategies Brain-Based Learning Strategies 00:10:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

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 Introduction Introduction 00:03:00 What is Executive Coaching aka Leadership Coaching 00:02:00 Why is Executive Coaching so Popular Why is Executive Coaching so Popular Introduction 00:01:00 The Fundamental Problem With Most Leadership Development Methods 00:03:00 Leadership Development is Very Similar to Achieving Fitness Goals. 00:04:00 Executive Coaching Process is Both Time and Resource Efficient 00:01:00 Confidentiality And a “Safe” Environment - to The Leader 00:03:00 The Mid-career Crisis and How To Overcome it Intro to this Section 00:01:00 Hitting The Plateau 00:02:00 The Traditional View of Professional Development 00:01:00 A Coaching Approach to Professional Development 00:06:00 What is The Difference Between Executive coaching and Leadership Coaching Executive coaching Vs Leadership Coaching 00:05:00 Overview of The Executive Coaching Process Introduction 00:01:00 Leadership Development Goals 00:01:00 Knowing Your Strengths and Improvement Areas 00:06:00 What is 360-Degree Feedback 00:04:00 Deciding on Improvement Areas 00:02:00 Hiring a Leadership Coach to Debrief 00:01:00 What Happens in An Executive Coaching Session? What Happens in An Executive Coaching Session 00:06:00 What happens IN BETWEEN the coaching sessions? What happens IN BETWEEN the Coaching Sessions 00:03:00 How To Select The Right Executive Coach For You Introduction 00:02:00 Supportive and Challenge 00:03:00 Honest Feedback & Structured Process 00:04:00 Confidentiality and Altering Perception 00:03:00 Role Model of Behaviour 00:02:00 Qualification & Experience 00:03: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

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Screenwriting & Script Writing - Level 5 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Learn how to write and develop excellent scripts and screenplays, and kickstart a professional writing career by enrolling in our Screenwriting & Script Writing - Level 5. Through this course, you will get equipped with all the fundamental knowledge and skills to develop and research ideas for writing screenplays and adapting stories into a script for stage presentation. This course covers a comprehensive range of modules to give you deep insight into screenwriting and script writing basics. After course completion, you will have a solid understanding of multiple screenplay forms, story and plot, structure and format. You will learn about all the necessary elements of a screenplay to work smoothly on a story. What other courses are included with this Screenwriting & Script Writing - Level 5? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Curriculum: ***Screenwriting & Script Writing - Level 5*** Module 01: Introduction to Screenwriting Module 02: Motivation & Ideas Module 03: Research & Development Module 04: Genre Module 05: Story & Plot Module 06: Character & Dialogue Module 07: Structure & Format Module 08: Synopses, Outlines & Treatments Module 09: Drafts Module 10: Marketing Module 11: Troubleshooting Module 12: Glossary Module 13: Screenwriting and British Film Industry Module 14: Agreements Module 15: How Much Do UK Screenwriters Earn? Module 16: Greatest British Screenwriters of All Time How will I get my Screenwriting & Script Writing Diploma - CPD Certified Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Screenwriting & Script Writing - Level 5. It is available to all students, of all academic backgrounds. Requirements Our Screenwriting & Script Writing is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this Screenwriting & Script Writing Diploma - CPD Certified course, it can be studied in your own time at your own pace. Career path Having this Screenwriting & Script Writing Diploma - CPD Certified certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included

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