27912 Development courses in Leeds delivered Online

Course Overview Learn how to Install and configure NGINX on Ubuntu step-by-step. Includes MySQL, PHP, PhpMyAdmin, WordPress & SSL integration. NGINX is one of the most powerful Web Server technologies in the world. In this course, you will learn how to install NGINX on a DigitalOcean droplet or any virtual server of your choice, with complete step-by-step guidance. It also covers key topics such as the differences between Apache & NGINX, configuring DNS one files, and creating a database for WordPress. This practical training course is a great introduction to NGINX and other open source software, ideal for students interested in web development and web design. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. This best selling Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu, 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in England and Wales alone, anti-social behaviour costs an estimated £19 billion a year? This can take many forms, from vandalism and graffiti to noise nuisance and verbal abuse. Young people are often involved, either as victims or perpetrators. But what can be done? This course bundle equips you with the knowledge and skills to make a positive difference. This comprehensive bundle combines three QLS courses with additional modules to provide a well-rounded understanding of youth work, anti-social behaviour, and social work practices. You'll gain insights into youth development, explore strategies for addressing anti-social behaviour, and learn how social workers support vulnerable individuals. Additionally, you'll develop essential skills in safeguarding children, corporate social responsibility, personal development, and ethical leadership. Key Features of the Youth Work, Anti-Social Behaviour & Social Worker Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Youth Work, Anti Social Behaviour & Social Worker bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Youth Work QLS Course 02: Anti-Social Behaviour QLS Course 03: Social Worker 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: Social Work Studies Course 02: Safeguarding Children Course 03: CSR - Corporate Social Responsibility Course 04: Personal Development Masterclass Course 05: The Principles of Ethical Leadership 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 Learning Outcomes of Youth Work & Social Worker Gain an in-depth understanding of youth work, social work, and anti-social behaviour. Understand the principles of ethical leadership and how it shapes societal interactions. Explore the theoretical underpinnings of safeguarding children and their application in different contexts. Develop knowledge about the role and impact of Corporate Social Responsibility (CSR) in contemporary society. Improve personal development strategies using proven theoretical methods. Examine different social work studies and their implications on policy and practice. Learn the necessary theoretical framework to handle and mitigate anti-social behaviour effectively. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Youth Work & Social Worker Get a free student ID card with Youth Work & Social Worker Training program (£10 postal charge will be applicable for international delivery) The Youth Work & Social Worker is affordable and simple to understand This Youth Work & Social Worker course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Youth Work & Social Worker course materials The Youth Work & Social Worker comes with 24/7 tutor support Start your learning journey straightaway with Youth Work & Social Worker! *** Course Curriculum *** QLS Course 01: Youth Work Module 01: Introduction to Youth Work Module 02: Who Are the Youth Workers? Module 03: Youth Worker Role and Methods Module 04: Legal Responsibilities Module 05: Youth Work as a Career (Social Work) Module 06: Social Influences Module 07: Youth Work in Mental Health Module 08: Social Work and Criminal Justice QLS Course 02: Anti-Social Behaviour Module 1: Overview of Anti-social Behaviour Module 2: Family Influences on Anti-social Behaviour Module 3: Anti-Social Behaviour Order Module 4: Anger and Anti-social Behaviour Module 5: Understanding Antisocial Personality Module 6: Prevention of Anti-social Behaviour QLS Course 03: Social Worker Module 01: An Overview Of Social Work Module 02: Social Work Basics Module 03: Theories Of Social Work And Sociology Module 04: Casework Process And Teamwork Module 05: Dimensions Of Social Work / Models Of Intervention Module 06: Practice Contexts And Application Module 07: Working With Adults Module 08: Principles Of Conduct And Role As Social Care Worker =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the Youth Work & Social Worker course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Courses: Previously it was £357) CPD 250 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 Social Worker bundle. This bundle is ideal for: Youth Workers Social Workers Teachers Community Leaders Requirements You will not need any prior background or expertise to enrol in this Social Worker bundle. Career path After completing this Social Worker bundle, you are to start your career or begin the next phase of your career. Youth Worker Social Worker Teacher Counsellor Certificates Certificate in Anti-Social Behaviour at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. 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. Diploma in Youth Work at QLS Level 4 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

SAFe® for Government: Virtual In-House Training Transitioning to Lean-Agile practices for building technology-based capabilities is especially challenging in the government context. But issues of legacy governance, contracting, and organizational barriers can be overcome with the right information and strategies. During this course, attendees will learn the principles and practices of the Scaled Agile Framework® (SAFe®), how to execute and release value through Agile Release Trains, and what it means to lead a Lean-Agile transformation of a program inside a government agency. Attendees gain an understanding of the Lean-Agile mindset and why it's an essential foundation for transformation. They'll also get practical advice on building high-performing, multi-vendor Agile teams and programs, managing technology investments in Lean flow, acquiring solutions with Agile contracting, launching the program, and planning and delivering value using SAFe®. Attendees also learn how specific leadership behaviors can drive successful organizational change in government. What you will Learn To perform the role of a SAFe® for Government leader, you should be able to: Transition government programs from traditional software and systems development models to Lean-Agile and DevOps mindsets, principles, and practices using SAFe® Adapt technology strategy, budgeting and forecasting, acquisition, compliance, and governance processes to flow-based practices using emerging government guidelines Organize government programs into one or more Agile Release Trains (ARTs) and execute in Program Increments (PIs) Explore Large Solution coordination in a government and multi-vendor environment Identify and internalize the mindset and leader behaviors essential to successful Lean-Agile transformation Follow success patterns for SAFe® implementations adapted to the government context Build a preliminary outline of next steps to begin and / or accelerate the SAFe® implementation in your program or agency Advancing Lean-Agile in government Embracing a Lean-Agile mindset Understanding SAFe® Principles Creating high-performing Agile teams and programs Planning with cadence and synchronization Delivering value in Program Increments Mapping the path to agency and program agility Leading successful change

Are you already established in a career in Facilities Management? Are you ready to advance to the next level in your career and gain a professional Facilities Management qualification? This short course offers the opportunity to complete smaller blocks of learning, designed to motivate you to go further. On successful completion of these qualifications, recognition by employers enables learners to progress into or within employment and/or continue their study in Facilities Management or in more specialised areas.

Feeling Stuck in Your Career? The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Microsoft Azure Fundamentals bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Microsoft Azure Fundamentals bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! bundle on your job life and career growth! This Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle Comprises the Following CPD Accredited Courses: Course 01: Basic PowerPoint Course 02: Microsoft Excel Course 03: Microsoft Azure Cloud Concepts Course 04: Microsoft Word Advanced Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 09: Microsoft Excel: Master Power Query in 120 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis In Excel Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: Outlook Tips and tricks Course 18: PowerBI Formulas Course 19: Excel PowerQuery and PowerPivot Course 20: Microsoft Power BI Course 21: Microsoft Outlook - 25 Must-Know Tips and Tricks Course 22: Microsoft Access for Beginners Course 23: Microsoft Access Tables and Queries Course 24: Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams for Everyone Course 26: Advance Windows 10 Troubleshooting for IT HelpDesk Course 27: Microsoft SQL Server Development for Everyone Course 28: Microsoft Excel for Business Accounting Course 29: Microsoft Project: Learn the Fundamentals of Project Management Course 30: Admin, Secretarial & PA What will make you stand out? Upon completion of this online Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle, you will gain the following: CPD QS Accredited Proficiency with this Microsoft Azure Fundamentals Bundle After successfully completing the Microsoft Azure Fundamentals bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Microsoft Azure Fundamentals Bundle The online test with immediate results You can study and complete the Microsoft Azure Fundamentals bundle at your own pace. Study for the Microsoft Azure Fundamentals bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Microsoft Azure Fundamentals bundle, a comprehensive, complete collection of 30 courses. Each course in the Microsoft Azure Fundamentals bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Microsoft Azure Fundamentals bundle offers the flexibility and convenience to learn at your own pace. Make the Microsoft Azure Fundamentals package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! is perfect for: Expand your knowledge and skillset for a fulfilling career with the Microsoft Azure Fundamentals bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Microsoft Azure Fundamentals bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Microsoft Azure Fundamentals bundle. Learn on your schedule, in the comfort of your home - the Microsoft Azure Fundamentals bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Microsoft Azure Fundamentals bundle. Certificates CPD Certificates Digital certificate - Included

Limited Time Offer | 13-in-1 Premium Bundle | CPD QS Certified | 145 CPD Points | Gifts: Hard Copy + PDF Certificates + Transcript + SID - Worth £180 | Customer Support | Lifetime Access

Coaching and mentoring are increasingly popular in the UK. To start, try the QLS Endorsed Coach & Mentor Complete Bundle

Are you looking for a course which will help you to advance your career in child care setting then this course is perfect for you. Learn everything about child care and their psychology with this Bundle course! This course covers everything from the fundamentals of child attachment to the complexities of children's mental health. You'll learn everything you need to know to become an expert in Child Care and thrive in your career! What else? You will also gain the ability to nurture a responsive relationship with children, thereby contributing to their cognitive and physical development, simply by recognizing your child caring skills, as provided by our Bundle course that has been specifically designed for you. Training Tale is dedicated to providing you with the best Child Care skills possible. With this bundle course, you will get 8 courses! It means you will get 8 different certificates of achievement once you complete all the courses successfully. Imagine how your CV will be enriched. And the PDF certificates are completely free. At Training Tale, we provide more than just courses, we also provide a rich learning experience. When you purchase a course from Training Tale, you get unlimited access to the course with tutor support. Our expert instructors are always available to answer any questions you may have and make your learning experience unforgettable. This Course is ideal for all aspiring Child Care professionals because it is packed with up-to-date Child Care knowledge. Enrol in our this Course now to take your Child Care eLearning experience to the next level! Let's see what are those 8 courses included in this Bundle course Dyslexia Autism Diploma ADHD Awareness Course Nursery Nurse Childcare and Nutrition Level 3 Designated Safeguarding Lead Training Course Level 2 Certificate in Behaviour that Challenges in Children Advanced Diploma in Child Care Learning Outcomes By the end of this Advanced Child Care Course - Bundle, you will be able to - Understand the fundamentals of child attachment training to secure the best chance of many years of Child Care employment Understand trauma treatments in children to be the best in the Child Care setting Understand the development of a child. Gain a solid understanding of all the Child Care factors that influence the development of a child Understand immunisation in children Gain a thorough understanding of infancy in Child Care Gain in-depth knowledge about mental health in children and much more! Why Choose Advanced Child Care Course - Bundle from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Other Benefits of this Bundle Course 8 PDF Certificate Free Expert Tutor Support Lifetime Access Unlimited Retake Course 01: Dyslexia Course Curriculum Module 01: An Overview of Dyslexia Module 02: Learning Difficulties Due to Dyslexia Module 03: Impact of Dyslexia in the Educational Setting Module 04: Helping Adults with Dyslexia Module 05: Dyslexia in the Workplace Module 06: Approaches in Dyslexia Module 07: Dyslexia Strengths and Rewards Module 08: Assessment and Evaluation of Dyslexia Module 09: Dyslexia Friendly Learning Environment Module 10: Relevant Laws for Dyslexia Course 02: Autism Diploma Course Curriculum Module 01: Introduction to Autism Spectrum Disorder (ASD) Module 02: Approaches to Helping People and Children with Autism Module 03: Diagnosis of Autism Module 04: Communication Module 05: Cognitive Styles and Functions in Autism Module 06: Autistic Behaviour Module 07: Organisation Systems with Autistic Individuals Module 08: Autism Awareness Module 09: Government Policies on Autism in England Course 03: ADHD Awareness Course Course Curriculum Module 01: Overview of ADHD Module 02: The Experience of Treatment and Care for ADHD Module 03: Families and ADHD Module 04: Psychological Interventions for Children with ADHD in Educational Settings and Parent Training Module 05: ADHD and Attention Difficulties Module 06: Cognitive Approaches in ADHD Module 07: The Organisation of Care for ADHD Course 04: Nursery Nurse Course Course Curriculum Module 01: An Overview of Nursery Nurse Module 02: Recognizing Children's Growth and Development Module 03: Observation and Assessment of Children in Early Childhood Settings Module 04: How to Promote Equality, Diversity and Inclusive Practice in Early Years of Learning Module 05: Safeguarding and Protecting Young Children Module 06: Ensuring Health and Safety of Children in the Early Years Module 07: The Essence of Nutrition and Healthy Food for Children Module 08: Importance of Play and Learning in Children's Education Module 09: Ways of Working with Children Having Special Needs Module 10: Working in Partnership with Parents and Carers Course 05: Childcare and Nutrition Course Curriculum Module 01: Childcare and Nutrition Module 02: Children Growth and Development Module 03: Health and Safety of Children Module 04: Hygiene for Child Caring Module 05: The Use of Macronutrients Module 06: The Use of Micronutrients Module 07: Nutritional Requirements of Child Module 08: Child Nutritional Problem and Physical Development Module 09: Caring for Special Needs Children Module 10: Child Abuse and Neglect Module 11: Nutrition Education and Activities Course 06: Level 3 Designated Safeguarding Lead Training Course Course Curriculum Module 01: Introduction Module 02: Safeguarding Structure and Guidance Module 03: Recognising and Responding to Abuse Module 04: Responses Under the Safeguarding Structure Module 05: Working Together and Sharing Information Module 06: Recording Information Course 07: Level 2 Certificate in Behaviour that Challenges in Children Course Curriculum Module 1: Understand Behaviour That Challenges Module 2: Understand How to Support Positive Behaviour Module 3: Understand the Importance of Effective Communication and the Management of Behaviour That Challenges Module 4: Understand the Role of Reflection and Support for Those Involved in Incidents of Behaviour That Challenges Advanced Diploma in Child Care Course Curriculum Module 01: An Overview of Early Childhood Education Module 02: Empowering Children to Learn in the Early Years Module 03: The Process of Caring for Child's Development Module 04: Developing Socially and Emotionally Module 05: Aspects That Influence the Development Process Module 06: Stages of Language Development Module 07: The Process of Moral Development Module 08: Personality Development of Children Module 09: Problems During Infancy and Childhood Period Module 10: Adolescence's Problems Explained Module 11: Safeguarding Children Assessment Method After completing each module of this course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this bundle course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Advanced Child Care Course - Bundle This course is ideal for anyone who wants to work or is already working in a child care setting. Requirements Advanced Child Care Course - Bundle There is no specific requirement to enrol for this bundle course. However, you need to be over 16. Career path Advanced Child Care Course - Bundle After completing this course, you may be able to pursue a variety of career opportunities. Such as - Child Protection Officer (Average Annual Salary in the UK: £25,000 to £40,000) Psychological Wellbeing Practitioner (Average Annual Salary in the UK: £24,907 to £44,503) Child Carer

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.