28534 Development courses in Cardiff delivered Online

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

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.

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

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.

🚀 Unlock Your Leadership Potential with 'Leadership Metamorphosis: Empowerment Course and Development Program' 🚀 Are you ready to undergo a transformative journey and emerge as a powerful, influential leader? Welcome to 'Leadership Metamorphosis,' where leadership isn't just a role-it's a dynamic process of growth and empowerment.   🌟 Introduction: Lay the Groundwork for Leadership Excellence Embark on your leadership metamorphosis with a comprehensive introduction that sets the stage for your transformation. Gain insights into the essence of leadership, understand the key principles, and prepare to unleash your true leadership potential. 🏆 Foundational Ideas For Leaders: Building a Solid Leadership Foundation Forge a rock-solid foundation for your leadership journey. Dive deep into the fundamental concepts and skills that every great leader possesses. From effective communication to strategic decision-making, this module equips you with the essential tools for success. 🚀 Powerful Cutting-Edge Leadership Tips - Foundational: Elevate Your Leadership Game Explore the cutting-edge strategies that set exceptional leaders apart. Learn how to inspire and motivate your team, navigate challenges with resilience, and lead with a forward-thinking mindset. Elevate your leadership game and start making a lasting impact in your professional sphere. 🌐 Powerful Cutting-Edge Leadership Tips - Intermediate: Mastering the Art of Leadership Ready to take your leadership skills to the next level? Delve into intermediate-level techniques that empower you to navigate complex situations with finesse. Discover the secrets of effective delegation, conflict resolution, and fostering a culture of innovation within your team. 🚀 Powerful Cutting-Edge Leadership Tips - Advanced: Leadership Mastery Unleashed Become a true master of leadership with advanced strategies designed for those aiming for the pinnacle of success. Unleash your leadership potential with insights into visionary leadership, transformative decision-making, and the art of building high-performing teams. Navigate the challenges of leadership with confidence and poise. 🌈 Final Thoughts: Your Leadership Metamorphosis Culmination As you near the end of your journey, reflect on your transformation and solidify your newfound leadership skills. Discover the keys to sustaining your success, leaving a lasting legacy, and continuing your leadership evolution beyond the course.   🎓 Why Choose 'Leadership Metamorphosis'? ✅ Expertly crafted curriculum by seasoned leadership professionals. ✅ Practical, real-world strategies applicable to various industries. ✅ Interactive and engaging learning experience. ✅ Lifetime access to course materials and updates.   🔥 Transform Your Leadership Journey Today! Don't miss the opportunity to become the leader you were destined to be. Enroll in 'Leadership Metamorphosis' now and embark on a transformative journey towards leadership excellence. Your metamorphosis awaits-unleash the leader within! 🌟 Course Curriculum Introduction Leadership Training: Introduction 00:00 Foundational Ideas For Leaders Leadership Training: Foundational Ideas That Create Powerful Leaders 2 00:00 Leadership Training: Foundational Ideas That Create Powerful Leaders 2 00:00 Powerful Cutting-Edge Leadership Tips - Foundational Leadership Training: Tips For Wise Leaders - Section 4 00:00 Leadership Training: Tips For Wise Leaders - Section 5 00:00 Leadership Training: Tips For Wise Leaders - Section 6 00:00 Leadership Training: Tips For Wise Leaders - Section 7 00:00 Leadership Training: Tips For Wise Leaders - Section 8 00:00 Leadership Training: Tips For Wise Leaders - Section 9 00:00 Leadership Training: Tips For Wise Leaders - Section 10 00:00 Leadership Training: Tips For Wise Leaders - Section 11 00:00 Powerful Cutting-Edge Leadership Tips - Intermediate Leadership Training: Tips For Wise Leaders - Section 12 00:00 Leadership Training: Tips For Wise Leaders - Section 13 00:00 Leadership Training: Tips For Wise Leaders - Section 14 00:00 Leadership Training: Tips For Wise Leaders - Section 15 00:00 Leadership Training: Tips For Wise Leaders - Section 16 00:00 Powerful Cutting-Edge Leadership Tips - Advanced Leadership Training: Advanced Tips For Wise Leaders - Section 17 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 18 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 19 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 20 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 21 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 22 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 23 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 24 00:00 Leadership Training: Advanced Tips For Wise Leaders - Section 25 00:00 Final Thoughts Leadership Training: Final Thoughts For Wise Leaders 00:00

The Level 5 qualifications in Management and Leadership are aimed at those who are working as middle managers and those who are aspiring to be senior managers. This qualification is mainly focused on the improvement of the student’s capabilities and core management skills such as resource management, recruitment, and information management. The Level 5 Diploma in Management and Leadership has been devised for developing the key skills of middle managers and those who are striving to be senior managers. This diploma is a benchmark qualification for full CMI membership which will take you one step closer to the status of a Chartered Manager. We have a 100% pass rate due to the high levels of support delivered through our online learning platform and individual coaches/assessors are assigned to all students. Our speed of response is second to none and our 5-star rating from our students speaks for itself. We are delighted to have supported students to unleash their potential from a diverse range of organisations both within the UK and internationally from organisations that have most recently included: Michelin Barclays Firstsource Mercedes Benz Shangrila Hotels and Resorts Virgin Money UK Person College London North Norfolk District Council G&L Scientific Coca Cola New Balance PureGym As a CMI accredited Chartered Manager Centre, many of our students go on to achieve recognition as Chartered Managers through our centre. Study method Online, self-paced Duration 6months Access to content Access until course completion Qualification Level 5 Diploma in Management and Leadership (RQF) CPD 370 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students CPD 370 CPD hours / points Accredited by Chartered Management Institute Key Benefits Latest and emerging as well as classical leadership and management concepts, theories and models. Practical guidance and support from our coaches and assessors who are all CMI Chartered Managers or Fellows. An internationally – recognised professional qualification. The credits earned at this course can be transferred to other courses if the students want to pursue MBA or any other Masters. On successful completion of the programme, students will be able to demonstrate their understanding and ability to apply leadership and management good practice which will improve their attractiveness to employers. The programme covers a choice of the following Units to a Total Qualification Time of 540 hours: CMI 502 Developing, Managing and Leading Individuals and Teams to Achieve Success (60 Hours TUT) CMI 504 Managing Performance (50 Hours TUT) CMI 506 Managing Equality, Diversity and Inclusion (50 Hours TUT) CMI 514 Managing Change (50 Hours TUT) CMI 513 Managing Projects to Achieve Results (60 Hours TUT) CMI 515 Creating and Delivering Operational Plans (60 Hours TUT) CMI 517 Principles of innovation (50 Hours TUT) CMI 520 Managing finance (60 Hours TUT) CMI 523 Principles of marketing products and services (60 Hours TUT) CMI 524 Conducting a Management Project (100 Hours TUT) CMI 525 Using Reflective Practice to Inform Personal and Professional Development (50 Hours TUT) We also provide students with access to the full CMI syllabus and support them if they wish to choose alternative Units. What the programme offers Level 5 Diploma in Leadership & Management from Chartered Management Institute (CMI) Student membership of the Chartered Management Institute Full learning support and all course materials All registration and assessment fees (We don't believe in hidden costs) Unrivalled one-to-one tutor support throughout the entire learning journey. A dedicated Chartered Manager as your programme coach/assessor 24-7 access to our extensive online Academy and CMI's Management Direct learning platform. All assessment and support materials are accessible through our online learning platform Assessment feedback within 48 hours to keep students motivated and on track The opportunity to progress to become recognised as a Chartered Manager upon successful completion Who is this course for? Middle Managers, potential middle managers and senior managers/business owners who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None - we offer an inclusive and welcoming learning environment to all our students and there are no barriers to entry. Prospective students should be aware this CMI level 5 qualification is approximately equivalent to an academic degree level. Students will be required to submit assignments to this level. Career path A career in leadership and management. A possible progression route on successful completion of a Level 5 qualification in Strategic Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to Level 6 or 7 Certificate)

Are you eager to learn Django and build real web applications? Do you want to gain hands-on experience with Python, Django, and Git? Look no further! This beginner-friendly course has got you covered. Discover the secrets of Django applications, templates, models, and migrations as we guide you through the process step-by-step. Tired of struggling with deployment? We will show you how to deploy your applications on a Railway Server effortlessly.

Unlock your potential in the property sector with the Real Estate Development Mini Bundle—designed for those looking to build a strong, hireable skillset in property finance and management. By focusing on essential skills like Finance, MS Excel, Business Analysis, Proofreading, and Business Law, this bundle provides everything you need to stand out in the competitive world of real estate development. Description Success in real estate development depends on a deep understanding of Finance and the ability to analyze business opportunities critically. The Finance skills gained here will make you a valuable asset for companies needing experts who can manage budgets, assess investment viability, and optimize project funding. No modern real estate professional can overlook MS Excel. From financial modeling to data analysis, MS Excel proficiency is a must-have. Employers actively seek candidates skilled in MS Excel to streamline reporting and support data-driven decision-making. Adding depth to your profile, Business Analysis enhances your capability to evaluate market trends, client needs, and project feasibility. Strong Business Analysis skills empower you to identify risks and opportunities, making you indispensable in real estate project teams. The importance of clear communication and error-free documents can’t be overstated, so Proofreading is an invaluable addition. With impeccable Proofreading, you ensure contracts, proposals, and reports reflect professionalism and accuracy, a vital skill for client-facing roles. Finally, understanding Business Law is fundamental in real estate development. Whether it’s contracts, property rights, or regulatory compliance, Business Law knowledge sets you apart as a knowledgeable and reliable professional. Combining Finance, MS Excel, Business Analysis, Proofreading, and Business Law prepares you to confidently enter and thrive in real estate development roles. FAQ Q: Who should consider this bundle? A: Aspiring real estate developers, project managers, financial analysts, and professionals seeking expertise in Finance, MS Excel, Business Analysis, Proofreading, and Business Law. Q: Can this bundle help me in property investment? A: Yes, the combined skills in Finance, MS Excel, Business Analysis, and Business Law give you a significant edge. Q: Do I need prior experience? A: No, this bundle supports beginners and professionals looking to sharpen their real estate development skills.

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.

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.