4728 Courses in Bradford delivered Online

  ISO 14001 Lead Auditor training enables you to develop the necessary expertise to perform an Environmental Management System (EMS) audit by applying widely recognized audit principles, procedures and techniques. About This Course   During this training course, you will acquire the knowledge and skills to plan and carry out internal and external audits in compliance with ISO 19011 and ISO/IEC 17021-1 certification process. Based on practical exercises, you will be able to master audit techniques and become competent to manage an audit program, audit team, communication with customers, and conflict resolution. After acquiring the necessary expertise to perform this audit, you can sit for the exam and gain "Certified ISO 14001 Lead Auditor' Certificate. By holding this Certificate, you will demonstrate that you have the capabilities and competencies to audit organizations based on best practices.    Learning objectives   Understand the operations of an Environmental Management System (EMS) based on ISO 14001 Acknowledge the correlation between ISO 14001, ISO 14040 and other standards and regulatory frameworks Understand an auditor's role to: plan, lead and follow-up on a management system audit in accordance with ISO 19011 Learn how to lead an audit and audit team Learn how to interpret the requirements of ISO 14001 in the context of an EMS audit Acquire the competencies of an auditor to: plan an audit, lead an audit, draft reports, and follow-up on an audit in compliance with ISO 19011   Educational approach   This training is based on both theory and best practices used in EMS audits Lecture sessions are illustrated with examples based on case studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam Prerequisites   A fundamental understanding of ISO 14001 and comprehensive knowledge of audit principles.  Who Should Attend?   Auditors seeking to perform and lead Environmental Management System (EMS) certification audits Managers or consultants seeking to master an Environmental Management System audit process Individuals responsible for maintaining conformance with EMS requirements Technical experts seeking to prepare for an Environmental Management System audit Expert advisors in Environmental Management What's Included?   Refreshments & Lunch (Classroom courses only) Course Slide Deck Official Study Guides CPD Certificate The Exam   Accreditation Assessment     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 4 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success. Provided by   This course is Accredited by NACS and Administered by the IECB

Give a compliment to your career and take it to the next level. This Change Management bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Change Management skills for your next job or elevate your skills for your next promotion, this Change Management bundle will help you stay ahead of the pack. Throughout the Change Management programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Change Management course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Change Management Bundle Consists of the following Premium courses: Course 01: Change Management Course 02: Diploma in Lean Leadership and Change Management Course 03: Entrepreneurship & Innovation Management Course 04: Strategic Management - Industry Change And Value Curves Course 05: Operations Management: Enterprise Resource Planning Course 06: Operations Management: Resource & Workout Layout Course 07: Performance Centered Asset Management Course 08: Process Improvement: Reduce Waste Course 09: Change of Culture Course 10: Rapid Business Improvement Course 11: Automation of Processes Course 12: Operations Management: Process Mapping & Supply Chain Course 13: Cost Control Process and Management Course 14: Quality Management and Strategic Training - ISO 9001 Course 15: Document Control Course 16: Resourcing and Managing Talent Course Course 17: Fundamentals of Quality Management Course 18: Giving and Receiving Feedback Course 19: People Management Skills Level 3 Course 20: Performance Management Enrol now in Change Management to advance your career, and use the premium study materials from Apex Learning. The Change Management bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Change Management expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Change Management from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Change Management Course: Previously it was £10) CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Change Management bundle. Requirements This Change Management course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course Change Management 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.

11 in 1 "Management Skills - Team Leadership Skills" Bundle only at £53 Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Management Skills - Team Leadership Skills bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Management Skills - Team Leadership Skills bundle will help you stay ahead of the pack. Throughout the Management Skills - Team Leadership Skills programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Management Skills - Team Leadership Skills course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Management Skills - Team Leadership Skills Bundle Consists of the following Premium courses: Course 01: Operations Management Course 02: Diploma in Lean Leadership and Change Management Course 03: Motivation Skills Course 04: Delegation Skills Course 05: Giving and Receiving Feedback Course 06: People Management Skills Level 3 Course 07: Performance Management Course 08: Coaching Leaders for Success Course 09: Dealing With Difficult People Training Course Course 10: Decision Making and Critical Thinking Course 11: Time Management Training Enrol now in Management Skills - Team Leadership Skills to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Management Skills - Team Leadership Skills expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Bundle Course 01: Operations Management Module 01: Introduction to Operations Management Module 02: Project Management Module 03: Business Development and Succession Planning Module 04: Process Management Module 05: Supply Chain Management Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Management Module 08: Manufacturing & Delivery Operations Module 09: Quality Management Module 10: Managing Risk and Recovery Module 11: Performance Management Module 12: Talent Management Module 13: Communication Skills Module 14: Negotiation Techniques Module 15: Conflict Management Module 16: Stress Management Module 17: Time Management Module 18: Business Environment Module 19: Business Writing Skills CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Management Skills - Team Leadership Skills bundle. Requirements This Management Skills - Team Leadership Skills course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Management Skills - Team Leadership Skills) 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.

***24 Hour Limited Time Flash Sale*** Commercial Management (Logistic & Supply Chain Management) - QLS Endorsed Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In an era where over £500 billion worth of goods are moved annually in the UK alone, the efficiency of logistics and supply chain management becomes paramount. The "Commercial Management (Logistic & Supply Chain Management)" bundle offers specialised courses designed to elevate your expertise and readiness in a sector that is the backbone of global commerce. Are you prepared to lead in this dynamic field, ensuring that goods and services are delivered efficiently and sustainably? This robust educational bundle includes courses, ranging from Logistics and Supply Chain Management to specialised trainings in Retail Management, Transport Management, and Commercial Law. Each course is crafted to enhance your understanding of the complex logistics networks and supply chain processes. You'll learn how to manage and optimise Transport and Warehousing, navigate Legal Aspects of Commerce, and implement effective Import/Export strategies, all within a framework that emphasises strategic innovation. This bundle comprises the following courses: QLS Endorsed Courses: Course 01: Diploma in Logistics Management at QLS Level 5 Course 02: Diploma in Supply Chain Management at QLS Level 5 CPD QS Accredited Courses: Course 03: Retail Management Course 04: Transport Manager Course 05: Import/Export Course 06: Warehouse Management Diploma Course 07: Commercial law Join in on this journey to become a leader in the crucial fields of logistics and supply chain management. By enroling in the "Commercial Management (Logistic & Supply Chain Management)" bundle, you position yourself at the forefront of an industry critical to global economic health. Don't just participate in the marketplace-master it. Enrol in this course and enhance your career trajectory and develop the skills that will define the future of commerce! Learning Outcomes: Optimise and manage supply chain and logistics operations effectively. Strategically solve problems within global supply chains. Navigate and apply commercial law in business transactions. Manage retail operations aligning with current market demands. Design and oversee transport logistics with efficiency. Execute import/export operations adhering to legal standards. Why Prefer this Course? Get a Free QLS Endorsed 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: Diploma in Logistics Management at QLS Level 5 Module 01: Introduction to Logistic Management Module 02: Planning Framework for Logistics Module 03: Supply Chain Management Module 04: Logistics Management and Organisation Module 05: Sourcing, Purchasing, and Procurement Module 06: Channels of Distribution Module 07: Supplier Relationship Management Module 08: Inventory Planning and Management Module 09: Principles of Warehousing Module 10: Transport Management Module 11: Negotiation Techniques Module 12: Customer Service and Logistics Module 13: Getting Started Module 14: Understanding Lean Module 15: Liker's Toyota Way Module 16: The TPS House Module 17: The Five Principles of Lean Business Module 18: The First Improvement Concept (Value) Module 19: The Second Improvement Concept (Waste) Module 20: The Third Improvement Concept (Variation) Module 21: The Fourth Improvement Concept (Complexity) Module 22: The Fifth Improvement Concept (Continuous Improvement) Module 23: The Improvement Toolkit Module 24: Wrapping Up Course 02: Diploma in Supply Chain Management at QLS Level 5 Module 01: Course Overview Module 02: Getting Started Module 03: The Evolution of the Supply Chain Module 04: The Basic Supply Chain Structure Module 05: Supply Chain Drivers Module 06: Aligning Your Supply Chain with Business Strategy Module 07: Managing Supply Chain Risks Module 08: Tracking and Evaluating Supply Chain Data Module 09: Troubleshooting Supply Chain Problems Module 10: Sharing Supply Chain Activities Module 11: Sustainable Supply Chain Strategies Module 12: Applying Lean Techniques to the Supply Chain Module 13: The Future of Supply Chain Management =========>>>>> And 5 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*7 = £91) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) 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: Future logistics managers Supply chain professionals Business management students Aspiring import/export agents Retail management personnel Legal advisors in commerce 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. Supply Chain Manager: £35,000 - £55,000 Logistics Coordinator: £25,000 - £40,000 Transport Manager: £30,000 - £50,000 Warehouse Manager: £27,000 - £45,000 Export Manager: £30,000 - £55,000 Retail Operations Manager: £28,000 - £48,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Description Aviation Management And Safety Diploma Aviation Management And Safety Diploma is a comprehensive online course tailored to equip students and professionals with the knowledge and skills necessary to succeed in the evolving aviation industry. This robust programme offers a well-rounded education in various aspects of aviation management and safety without compromising on detail and relevance. Starting with an introduction to aviation management, students are introduced to the fundamental principles governing the aviation sector. The course presents a detailed look at the components, responsibilities, and roles involved in managing an aviation operation, including the commercial, administrative, and technical aspects. Safety culture in aviation forms a core part of the course. Aspiring professionals learn about the importance of safety within the aviation environment, focusing on the values, attitudes, and beliefs that foster safety awareness. By understanding how to implement a safety-first culture, students prepare themselves to create a positive impact in their future aviation careers. Air Traffic Management is another critical area covered in the Aviation Management And Safety Diploma. Students gain insights into air traffic control, air navigation, and flow management, acquiring a robust understanding of how these components intertwine to ensure the smooth operation of the global aviation network. The course also encompasses aviation law and regulation, offering an overview of international agreements, national laws, and governing bodies. This knowledge empowers students to operate within the legal confines of the aviation industry, ensuring compliance with various regulatory frameworks. Airlines' operations management is carefully considered, with a focus on strategies, planning, and control mechanisms. Participants learn how to manage resources, scheduling, and logistics to optimise efficiency in an airline's operations, positioning them for success in a highly competitive field. Risk management in aviation forms an essential part of the curriculum, guiding students through the methodologies and tools to identify, assess, and mitigate risks within aviation operations. By mastering these principles, students are well-prepared to foster safety and enhance decision-making in their professional roles. Human factors in aviation safety are explored, highlighting the significance of human performance and limitations in maintaining safety standards. The course covers physiological and psychological factors, the design of tools and equipment, and error management. In the Aviation Management And Safety Diploma, emergency response and crisis management in aviation are thoroughly examined. Students learn about developing and implementing emergency plans, handling unexpected situations, and coordinating multi-agency responses. The future of aviation safety is also a vital component of this course. As the industry evolves, safety standards and protocols must adapt. This section prepares students for emerging technologies, new regulations, and innovations that will shape the future of aviation safety. Finally, case studies in aviation management and safety provide real-world examples and learning opportunities. By studying actual incidents and management decisions, students gain a deep understanding of the practical applications of the theories and concepts they have learned. The Aviation Management And Safety Diploma offers an all-encompassing education in one of the world's most dynamic and critical sectors. By enrolling in this online course, students position themselves at the forefront of an industry, where safety and effective management are paramount. Through the insights, knowledge, and skills acquired, participants will be well-prepared for a rewarding career in aviation, enhancing their prospects in an ever-growing and essential field. What you will learn 1:Introduction to Aviation Management 2:Safety Culture in Aviation 3:Air Traffic Management 4:Aviation Law and Regulation 5:Airline Operations Management 6:Risk Management in Aviation 7:Human Factors in Aviation Safety 8:Emergency Response and Crisis Management in Aviation 9:The Future of Aviation Safety 10:Case Studies in Aviation Management and Safety Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Essential 5G training course description This course is designed to give delegates an explanation of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. we will investigate the 10 pillars for 5G which will include various Radio Access Technologies that are required to interwork smoothly. We will look at the 4G Pro features and other RATs. What will you learn List the ten pillars of 5G deployment. Describe the 5G Internet. Explain virtualization and RAT virtulization. Describe Software Defined Networks (SDN). Explain carrier aggregation. Describe the mobile cloud. Explain an overall picture of 5G architecture. Essential 5G training course details Who will benefit: Anyone looking for an understanding of the technologies and interworking requirements of the next generation of cellular communications. Prerequisites: None. Duration 3 days Essential 5G training course contents Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, oSON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. 4G LTE Advanced MIMO technology in release 8, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP. ICIC & eICIC ICIC, Homogeneous to heterogeneous network evolution, Introduction to eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). Carrier aggregation Component carriers (CC), CC aggregation deployments, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configs. eIMTA TDD UL-DL reconfig. for traffic adaptation, Reconfig. mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, 5G in North America, academy research, company R&D, 5G specifications. The 5G internet High-level view of Cloud Services, The Internet of Things & context awareness, Network reconfiguration & virtualization support, server proliferation, how VMs fix underutilised server problem, enter the hypervisor, why are VM such a big deal? SDN, evolution of the data centre network, high availability, low latency, scalability, security, cost model explodes, service-oriented API. OpenFlow switches, OpenFlow controllers, how SDN works. The big picture, pulling it all together, why the network had to change, how SDN & NFV tie together. Evolutionary approach to the internet, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture. VNet, INM, NetInf, ForMux, MEEM. Generic Path (GP) & anchorless mobility (AM), Quality of Service support, network resource provisioning, resourcing inside a network. IntServ, RSVP, DiffServ, CoS. Emerging approach for resource over- provisioning, example use case architecture for scalable resource control scenarios in the 5G internet. Integrating SDN/NFV for efficient resource over-reservation control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations & operations. Small cells for 5G Average spectral efficiency evolution, WiFi & Femto cells, Capacity limits. Achievable gains with densifications, multi-antenna techniques, small cells. Mobile data demand, approach & methodology, subscriber density and traffic demand projections to 2020. Demand versus capacity, global mobile data traffic increase modelling, country level backhaul traffic projections, Small cell challenges, backhaul, spectrum, automation. Cooperation for next gen wireless networks Diversity & relaying strategies, cooperation & network coding, ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol analysis, NCCARQ overview, PHY layer impact, Case study on NCCARQ. Mobile clouds Mobile cloud, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4 & software stacks, infrared, near field communications (NFC). Network coding, store & forward vs compute & forward, linear network coding, random linear coding. Security for 5G communications Potential 5G communication systems architectures, Security issues & challenges. Mobile malware attacks targeting the UE, 5G mobile botnets, access networks, attacks on 4G networks, C-RNTI & packet sequence number based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, credential attacks, configuration and protocol attacks, attacks on MON, user data & identity attacks, mobile operator's core network, DDoS attacks targeting MON, signalling amplification, HSS saturation, external IP networks.

Program Management Skills: Virtual In-House Training Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected. The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness. The participant will learn and apply the principles of program management through discussions, activities, and case study exercises. What You Will Learn At the end of this workshop, you will be able to: Maximize the transformational impact of a program according to the business needs Explain management principles and techniques and apply them within a program context Implement program governance and organization that will produce expected benefits Plan for and manage benefit realization, risks, issues, and quality Manage component projects' interdependencies that are linked to both program and strategic objectives Engage program stakeholders effectively. Improve communication and action planning effectiveness for programs in organizations Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Fundamental definitions and concepts Program challenges and benefits Program best practices and success criterion Stakeholder management Governance: program management office and program boards Standard for Program Management overview Vision, Leadership, and the Business Case What is vision, why, and how? Leadership vs. Management Program business case Program Organization and Governance Program organization Program governance Program board roles and responsibilities Benefits Management Benefits explored Benefits management Benefits realization Program Management Planning Program management plan Program blueprint and roadmap Program component dossier Program tranches Program estimating Program scheduling Program Monitoring and Controlling Program Control - An Overview Program Monitoring and Controlling Monitoring and Controlling Transition Program Risk and Issue Management Risk and issue management overview Program risk management Program issue management Program Quality Management Program quality management overview Program quality management principles Program Stakeholder Management Stakeholder engagement overview Stakeholder engagement planning EI, trust, communication and stakeholder engagement Program Closure and Benefits Sustainment Program closure overview Closing the program Program benefits sustainment Summary What did we learn, and how can we implement this in our work environments?

Step into the dynamic realm of process planning, where business, operations, and people unite to achieve stellar outcomes. This course lights the path!

This is the only Six Sigma Yellow Belt Certification course that covers all the 15 steps of the Six Sigma Yellow Belt DMAIC roadmap comprehensively, which are needed to be successful in the competitive market. You learn using a project-based approach: the Six Sigma Yellow Belt project evolves as you progress through this Six Sigma Yellow Belt training.

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.