28049 Development courses in Cardiff delivered Online

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

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.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before In today's competitive job market, the importance of Functional Skills English cannot be overstated. According to recent UK statistics, around 16% of adults are classified as having literacy levels at or below those expected of an 11-year-old. This course addresses a critical need-helping individuals improve their English skills to boost their employability and confidence. Are you ready to play a vital role in this transformative journey? The Level 2 Diploma in Functional Skills English Teaching is a comprehensive course designed to enhance your teaching skills across various key areas. You'll master Functional Skills English at QLS Level 2, explore early childhood education (EYFS), and learn educational psychology. The course also covers remote teaching strategies, learning support, phonics, stress management, time management, and even includes a TV presenting module to boost your communication skills. This Functional Skills English at QLS Level 2 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 100 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Functional Skills English course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Bundle Package includes: Course 01: Certificate in Functional Skills English at QLS Level 2 09 Additional CPD Accredited Premium Courses - Course 01: Early Years Foundation Stage (EYFS) Course 02: Educational Psychology & Development Course Course 03: Remote Teaching Strategies Course 04: Learning Support Assistant Course 05: Teaching Phonics Course 06: Understanding Specific Learning Difficulties Course 07: TV Presenter Online Course Course 08: Professional Diploma in Stress Management Course 09: Time Management Whether you're looking for a new career or aiming for a promotion, this bundle provides the skills and knowledge to make a real difference. Invest in yourself and unlock your full potential. Enrol today! Learning Outcomes of Functional Skills English Teaching Understand core IT concepts and navigate computer systems effectively. Gain the ability to write basic CSS code and style web pages. Develop proficiency in essential office administration tasks. Master effective time management strategies for increased productivity. Build a strong foundation for a career in administration or IT. Enhance your employability and impress potential employers. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Functional Skills English Get a free student ID card with Functional Skills English Training program (£10 postal charge will be applicable for international delivery) The Functional Skills English is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Functional Skills English course materials The Functional Skills English comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Certificate in Functional Skills English at QLS Level 2 Introduction to the Course Basics of Grammar The Basics of Sentence Structure of Sentence Questions Punctuation and Capitalisation Spelling Common Mistakes and Ways to Improve Course 01: Early Years Foundation Stage (EYFS) Module 01: Introduction to EYFS Module 02: Importance of Early Years in Development Module 03: EYFS Teaching Techniques Module 04: Working as an EYFS Teacher Module 05: Promoting Learning and Development Module 06: Children Having Special Education Needs or Disabilities Module 07: Parents' Guide to the Early Years Foundation Stage Module 08: Welfare Requirements Module 09: The EYFS Educational Philosophies and Privileges Module 10: Registration, Inspection, and Quality Improvement Module 11: EYFS Framework in 2021 Course 02: Educational Psychology & Development Course Module 01: Educational Psychology: An Overview Module 02: Educational Psychology And Its History Module 03: Behavioural Views Of Learning Module 04: Cognitive Development Module 05: Social, Moral And Emotional Development Module 06: Constructivism And Motivation Module 07: Dyslexia And Learning Difficulties Module 08: Applying Educational Psychology To Teaching Module 09: Effective Instruction And Technology In Education Module 10: Opportunities And Careers In Educational Psychology =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the 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 Title Course: Previously it was £89) CPD 210 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 teachers Current educators Learning assistants Remote teachers Education professionals 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. Functional Skills Teacher Learning Support Assistant Educational Consultant Remote Educator Phonics Instructor TV Presenter Certificates Certificate in Functional Skills English at QLS Level 2 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.

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

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

Feeling Stuck in Your Career? The Java Certification: Javascript with Coding, HTML, & CSS Training Course Bundle is Your Skill-Building Solution. This exceptional collection of 20 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Javascript with Coding, HTML, & CSS Training Course bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Java Certification: Javascript with Coding, HTML, & CSS Training Course 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 Javascript with Coding, HTML, & CSS Training Course 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 Java Certification: Javascript with Coding, HTML, & CSS Training Course bundle on your job life and career growth! This Java Certification: Javascript with Coding, HTML, & CSS Training Course Bundle Comprises the Following CPD Accredited Courses: Course 01: Java Certification Cryptography Architecture Course 02: jQuery: JavaScript and AJAX Coding Course 03: SQL Programming Masterclass Course 04: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 05: Cocos2d-x v3 JavaScript: Game Development Course 06: jQuery: JavaScript and AJAX Coding Bible Course 07: Intermediate Python Coding Course 08: Mastering Java for Beginners & Experts Course 09: Coding with HTML, CSS, & Javascript Course 10: WordPress Website Creation and Hosting System with Affiliate Marketing! Course 11: Front End Web Development Diploma Course 12: Learn Ethical Hacking From A-Z: Beginner To Expert Course 13: Master JavaScript with Data Visualization Course 14: Creative Thinking for Everyday Life Course 15: Stress Management Training 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 What will make you stand out? Upon completion of this online Java Certification: Javascript with Coding, HTML, & CSS Training Course Bundle, you will gain the following: CPD QS Accredited Proficiency with this Javascript with Coding, HTML, & CSS Training Course Bundle After successfully completing the Javascript with Coding, HTML, & CSS Training Course 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 Javascript with Coding, HTML, & CSS Training Course Bundle The online test with immediate results You can study and complete the Javascript with Coding, HTML, & CSS Training Course bundle at your own pace. Study for the Javascript with Coding, HTML, & CSS Training Course bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Java Certification: Javascript with Coding, HTML, & CSS Training Course 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 Javascript with Coding, HTML, & CSS Training Course bundle, a comprehensive, complete collection of 20 courses. Each course in the Javascript with Coding, HTML, & CSS Training Course 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 Javascript with Coding, HTML, & CSS Training Course bundle offers the flexibility and convenience to learn at your own pace. Make the Javascript with Coding, HTML, & CSS Training Course package your trusted partner in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Java Certification: Javascript with Coding, HTML, & CSS Training Course is perfect for: Expand your knowledge and skillset for a fulfilling career with the Javascript with Coding, HTML, & CSS Training Course bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Javascript with Coding, HTML, & CSS Training Course bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Javascript with Coding, HTML, & CSS Training Course bundle. Learn on your schedule, in the comfort of your home - the Javascript with Coding, HTML, & CSS Training Course 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 Javascript with Coding, HTML, & CSS Training Course bundle. Certificates CPD Certificates Digital certificate - Included

CPD Accredited, Interactive Workshop 2 hr session Learn all about the Five Steps to Mental Wellbeing and how they could be applied into your life Learn from the comfort of your own home Course Contents: Introduction to the Five Steps to Mental Wellbeing The Science Behind the Five Steps Learn about the Five Steps themselves and how to apply them into our own life - Connect - Be Active - Keep learning - Give to others - Be mindful Benefits of this Short Course: People's wellbeing have been under great strain. Stressful lives lead to people suffering from mental health problems. The Five Steps to Mental Wellbeing are a scientifically proven method of improving one's mental wellbeing, and increasing one's general emotional resilience In this Five Steps to Mental Wellbeing workshop, we'll show you what you can do to improve your own mental wellbeing and resilience, and can help you help others do the same!

This course bundle is ideal for anyone looking to establish their Cisco networking career. It consists of one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified DevNet Associate (CCDA) certification, and four Cisco Certified Networking Professional (CCNP) certifications. Although there are no formal prerequisites to enrol on the CCNA, CCDA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The newly retooled CCNA covers a breadth of topics, including: Network fundamentals Network access IP connectivity IP services Security fundamentals Automation and programmability Achieving CCNA certification is the first step in preparing for a career in networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified DevNet Associate certification validates your skills and knowledge in understanding and using APIs, Cisco platforms and development, application development and security, and infrastructure and automation. Ideally, DevNet Associates candidates also have one or more years of experience with software development including Python programming. The CCNP is the next level from the CCNA and CCDA. As with the CCNA, there are no formal prerequisites to enrol on the CCNP certification course and sit for the exams. Learners taking a CCNP course generally have an in-depth knowledge of networking, as well as a good understanding of Cisco technologies. The typical certification path for most learners would begin with either the CCDA or CCNA, then progress onto the CCNP. Learners need to pass two exams (one core exam and one concentration exam) in order to gain one CCNP certification. This course bundle includes the core exam and three concentration exams. Once a learner has passed the core exam, they can choose to specialise in one or all three of the CCNP concentration areas listed in this course. The core exam’s focus is based around implementing and operating Cisco enterprise network core technologies.

Whether you’re aiming to guide others in their personal or professional growth, or simply sharpen your ability to listen, question and encourage—this Coaching and Mentoring Diploma has been thoughtfully designed to help you do just that, with clarity and confidence. Delivered entirely online, the course suits those with an eye for development—both in themselves and others—without demanding classroom attendance or calendar acrobatics. From understanding the psychology behind effective coaching to grasping the nuances of mentoring relationships, each module is laid out in a logical, digestible manner. You'll explore strategies that foster meaningful dialogue, support others’ decision-making, and nurture lasting change. This course is ideal for those who want to elevate their communication and leadership style, whether in the workplace or personal circles. Professional, accessible, and packed with insight—this is structured learning with purpose, minus the waffle. Our Coaching and Mentoring Diploma course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Coaching and Mentoring Diploma QLS Bundle Includes the following Courses Course 01: Diploma in Coaching and Mentoring at QLS Level 5 Course 02: Personal Development Skills Course 03: Goal Setting, Motivation, and Resilience Course 04: Emotional Intelligence, Mindfulness and Empathy Training Course 05: Maximising Personal Productivity Course Key Features of Coaching and Mentoring Diploma Eligibility for QLS endorsed certificate upon successful completion of the Coaching and Mentoring Diploma course Free CPD Accredited Course Fully online, interactive Coaching and Mentoring Diploma course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Coaching and Mentoring Diplomatraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Coaching and Mentoring Diploma course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Coaching and Mentoring Diploma course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Coaching and Mentoring Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Coaching and Mentoring Diploma course, learners will be able to order an endorsed certificate, titled: Diploma in Coaching and Mentoring at QLS Level 5, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Coaching and Mentoring Diploma basics. Requirements No prior degree or experience is required to enrol in this Coaching and Mentoring Diploma course. Career path This Coaching and Mentoring Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

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.