7237 Power courses in Cardiff delivered Online

Symmetrical Components for Three Phase Power Analysis Course Overview This course on Symmetrical Components for Three Phase Power Analysis provides a comprehensive introduction to a fundamental technique used in electrical power engineering. Learners will explore how symmetrical components simplify the analysis of unbalanced three-phase power systems, enhancing their ability to diagnose and solve complex electrical faults. The course offers clear explanations of key concepts such as positive, negative, and zero sequence components, as well as the mathematical tools required to apply them effectively. By completing this course, participants will gain valuable skills that improve their understanding of power system behaviour, enabling more accurate system design, fault analysis, and operational decision-making. This knowledge is essential for engineers, technicians, and students engaged in power system analysis and maintenance. Course Description This detailed course delves into the principles and applications of symmetrical components within three-phase power systems. Starting with an introduction to the historical background and theoretical framework, learners will examine the mathematical derivation and significance of symmetrical components. Key topics include the definition and roles of the positive, negative, and zero sequence components, the “a” operator used in transformations, and the synthesis equations that enable conversion between phase and sequence quantities. The course also emphasises problem-solving techniques through a variety of illustrative examples, fostering a thorough understanding of how symmetrical components aid in analysing unbalanced loads and fault conditions. Learners will develop the ability to interpret and manage three-phase system data with greater precision, a crucial skill for careers in electrical engineering and power system operation. Symmetrical Components for Three Phase Power Analysis Curriculum: Module 01: Introduction Module 02: Symmetrical Components Overview Module 03: The Components Module 04: The “a” Operator Module 05: Working with the a Operator Module 06: Synthesis Equations Module 07: Problems & Solutions (See full curriculum) Who is this course for? Individuals seeking to enhance their understanding of three-phase power systems. Professionals aiming to advance their expertise in electrical power engineering. Beginners with an interest in electrical engineering and power system analysis. Engineering students preparing for careers in power distribution and fault analysis. Career Path Electrical Power Engineer Power System Analyst Electrical Design Engineer Maintenance Engineer in Power Utilities Technical Specialist in Energy Sector

24-Hour Flash Sale! Prices Reduced Like Never Before!! Advanced Diploma in CNC (Computer Numerical Control) Programming for Machining Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Precision and efficiency dictate manufacturing excellence, and CNC (Computer Numerical Control) Programming has emerged as the backbone of modern machining operations. With the UK's manufacturing sector contributing £200 billion to the economy in recent times, the demand for skilled CNC programmers is on the rise. The "Advanced Diploma in CNC Programming for Machining" bundle offers a unique convergence of technical training, aiming to equip professionals with the skills required to thrive in this advanced field. This course bundle surpasses traditional CNC programming education, introducing learners to a comprehensive array of related disciplines including 3D Printing, AutoCAD and Electronic Device Protection. It talks about the core of Mechanical Engineering, Rotating Machines, and HVAC Fundamentals, supplemented by specialised courses in Electrical Machines, Power Electronics, and Engine Lubricant Systems. Robotics, and Embedded Systems courses provide a foray into automation and control. Courses Are Included in this Bundle: Course 01: Advanced Diploma in CNC (Computer Numerical Control) Programming for Machining Course 02: 3D Modelling for 3D Printing Course 03: CAD Design Training Course 04: AutoCAD VBA Programming - Beginner course Course 05: AutoCAD Programming using with Windows Forms Course 06: LEED V4 - Building Design and Construction Course 07: Read Construction & Structural Drawing Like Expert Course 08: Mechanical Engineering Course 09: Rotating Machines Course 10: Electronic Device and Circuits Protection Training Course 11: Autocad Electrical Design Course 12: HVAC Basics and Load Calculation Masterclass Course 13: Electrical Machines for Electrical Engineering Course 14: MATLAB Simulink for Electrical Power Engineering Course 15: PAT Training (Updated 2022) Course 16: Electrical Engineering DC Circuit Analysis Course 17: Power Electronics for Electrical Engineering Course 18: Electric Circuits for Electrical Engineering Course 19: Engine Lubricant System Training - Level 4 Course 20: Robotics - Sensors Course 21: Microcontroller Simulation Course 22: Embedded Systems with 8051 Microcontroller Course 23: Power Tools and How to Use Them Course 24: Supercharger Automobile Engineering Course 25: Data Center Training Essentials: Mechanical & Cooling Course 26: JavaScript Foundations Course 27: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 28: Basic HTML 5 Course 29: CSS Fundamentals Course 30: HTML and CSS Coding: Beginner to Advanced The "Advanced Diploma in CNC Programming for Machining" is more than a course; it's a catalyst for those aspiring to lead in the fast-paced world of manufacturing and engineering. By integrating technical prowess with programming and design skills, graduates are well-prepared to tackle the challenges of the manufacturing and engineering sectors. So enrol now and get ready to contribute to the evolving landscape of global manufacturing! Learning Outcomes: Master CNC programming for advanced machining operations. Design and model 3D parts for manufacturing and 3D printing. Apply CAD design principles and AutoCAD programming in real-world projects. Understand electronic circuits and mechanical engineering fundamentals. Program microcontrollers and develop embedded systems for automation. Utilise web development skills for manufacturing and engineering applications. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Advanced Diploma in CNC (Computer Numerical Control) Programming for Machining Module 1: Scope of the Course Module 2: Numerical Control of Machine Tools Module 3: CNC- Computer Numerical Control Syst Module 4: Components of CNCs Module 5: Point to Point CNC Machines Module 6: Incremental & Absolute CNC Machines Module 7: Open & Close Control Loop CNC Machines Module 8: 2 &3 Axes CNC Machines Module 9: Importance of Higher Axes Machining Module 10: Programming Format Module 11: Cartesian Coordinate System Module 12: How to Write a Program Module 13: Basic CNC Programming (Absolute Mode) Module 14: Basic CNC Programming (Incremental) Module 15: A Simple Coding Exercise Module 16: Applications of CNC Course 02: 3D Modelling for 3D Printing Module 01: Introduction to Modeling for 3D Printing Module 02: Introduction to Maya Module 03: Blocking In the Head and Torso Module 04: Creating the Arm Module 05: Creating Details on the Arm Module 06: Creating the Legs Module 07: Creating the Foot Module 08: Creating the Hand Module 09: Preparing the Model for 3D Print Module 10: STL Cleanup and Check Module 11: Final Thoughts Course 03: CAD Design Training Module 01: Introduction to CAD Design Module 02: CAD Designer Career in the United Kingdom Module 03: Basics for CAD Design: Part 1 Module 04: Basics for CAD Design: Part 2 Module 05: 2D Shape in CAD Module 06: 3D Shape in CAD Module 07: Geometry and Modelling Module 08: Assemblies in CAD Design Module 09: Extrusion and Rotations Module 10: Blending Operations in CAD Module 11: Grids and Regular Polygons Module 12: Parameters in Civil Drawings Module 13: Introduction to AutoCAD Module 14: Introduction to T-Flex CAD Module 15: Introduction to SolidWorks Module 16: Introduction to FreeCAD =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The Title Course: Previously it was £29.99) CPD 300 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: Manufacturing engineers CNC machinists Mechanical engineers Electrical engineers Programmers Career switchers Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. CNC Programmer - £25,000 to £40,000 Mechanical Engineer - £30,000 to £50,000 Electrical Engineer - £28,000 to £45,000 Robotics Technician - £27,000 to £40,000 CAD Designer - £25,000 to £35,000 Web Developer (Manufacturing Sector) - £24,000 to £35,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that international students have to pay an additional £10 as a shipment fee.

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

About This VILT This 3 half-day course is designed to give a clear businessperson’s summary of the technological, market and economic/competitive issues around the key commodities which can be decarbonised through the use of clean hydrogen in their production. It will examine direct derivatives such as ammonia, methanol and synfuels, along with the impact clean hydrogen may have on the production and trading of other products such as green steel. Clear explanations will be given on technological pathways and key terminologies, in language accessible to non-engineers and commercial businesspeople. The positioning of these hydrogen derivatives in both current and potential future markets will be presented, framed with discussion around the economic and competitive factors which will determine market growth As well as explaining key concepts, the presented content will draw on current market examples, published models, scenarios and forecasts, and on fundamental physical and chemical constraints (for example illustrated by utilising simple calculations and quantifications). Download your brochure Email me the brochure TRAINING OBJECTIVES Upon completion of this VILT course, the participants will be able to: Review the key derivatives of hydrogen, with their market drivers Understand common terminology and technologies within the sector Quantify essential metrics and constraints to the production and trade of hydrogen derivatives Assess the role of clean ammonia in the future hydrogen supply chain Analyse the pathways to combine clean hydrogen with captured CO2 Understand how different policy mechanisms and end-use drivers will influence the growth and competition between different hydrogen derivatives Examine market and project examples, both current and planned Assess the impact of decarbonisation in key sectors such as shipping, aviation and power TARGET AUDIENCE This VILT course has been specifically designed for: Business developers Company strategy developers Investors Product and project management executives Policymakers and regulators Other commercial roles (e.g. marketing, regulatory etc.) Engineers or technical people entering new roles / new to the subject COURSE LEVEL Intermediate TRAINING METHODS The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. TRAINER Your Expert Course Instructor is an internationally renowned energy communicator and business educator, focused on the interconnected clean energy transition topics of renewable power, energy storage, energy system electrification and hydrogen. His own independent technology tracking, market assessment and opportunity/risk analysis is delivered to clients through a mix of business advisory work, commissioned content, small-group training (online & in-person), and one-to-one executive coaching (online). In the hydrogen sector, he is currently lead consultant and trainer to the World Hydrogen Leaders network, and writer of their ‘This Week in Hydrogen’ news column. He is also co-presenter of the ‘New Energy Chinwag’ podcast, which regularly covers hydrogen-related issues. During more than 15 years as an independent energy expert, he has helped companies from large multinationals to innovative start-ups – totalling assignments in over 30 countries across 5 continents. Most recently, he has presented clean energy training in locations as diverse as Singapore, the UK, South Africa, The Philippines, the USA, Mexico, Spain and Dubai – and, in recent times of course, online to international audiences from across the world. Prior to this, he was Research Director for over 10 years at Informa, a $9 billion business intelligence provider; where he drove new market identification, analysis and project deployment work, and managed teams in the UK and US. He has a strong science background, holding a 1st Class Honours degree in Natural Sciences from the University of Cambridge, a PhD in Earth Sciences and a further Diploma in Economics & Sustainability from the UK’s Open University. Download your brochure Email me the brochure POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized “One to One” coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!

Unlock the hidden recesses of your mind and rediscover forgotten memories in our comprehensive Masterclass on age regression. This masterclass offers a deep dive into the fascinating world of memory, exploring advanced techniques for memory regression and revivification through hypnosis. Whether you're a professional looking to expand your therapeutic toolkit or an individual curious about the potential of your own mind, this masterclass provides the knowledge and skills you need to harness the power of memory.

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

Bleeding control for general public and security industry.

Overview The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging. So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle. Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will learn the basics step by step with clear lessons and support from experienced tutors. You will be able to hone your knowledge from beginner to advanced level of Microsoft office as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest. As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this Microsoft Office bundle as a one-stop solution for you. This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 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: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training 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: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Learning Outcomes of Microsoft Office bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Microsoft Office Know your responsibilities as Microsoft Office and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Microsoft Office Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle. Certificates Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (MS Word Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for anyone who wants to learn Microsoft Office for office admin jobs. It’s ideal for beginners who are just starting or for those who want to refresh their Microsoft Office skills. By mastering Microsoft Office, you’ll be better prepared to handle office tasks efficiently. Requirements This Microsoft Office course has been designed to be fully compatible with tablets and smartphones. Career path Completing this course will enhance your CV and prepare you for a range of office administration roles where Microsoft Office skills are highly valued. Office Assistant: £18,000 to £25,000 Administrative Coordinator: £20,000 to £30,000 Executive Secretary: £25,000 to £40,000 Office Manager: £30,000 to £50,000 Senior Administrative Officer: £40,000 to £60,000 Operations Administrator: £45,000 to £70,000 With strong Microsoft Office knowledge, you’ll be ready to excel in these roles and stand out in the competitive job market.

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.