27932 Development courses delivered Online

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Step into the role of a responsible fire marshal with the confidence and knowledge needed to make a genuine difference. This QLS Endorsed Level 3 course is tailored for those looking to sharpen their understanding of fire safety regulations, risk assessment procedures, and emergency response planning—all from the comfort of your own environment. Whether you're a manager, a health and safety officer, or simply the one everyone trusts to keep calm during a fire drill, this course speaks your language. Packed with insight and structured for maximum clarity, the course explores everything from fire prevention strategies to legal responsibilities and evacuation protocols. You won’t find fluffy jargon here—just sharp, focused content designed to hold your attention and deliver the facts you need. Learn at your own pace, pick up proven methods, and walk away with a recognised endorsement that adds weight to your role. It’s fire safety training, done properly—clear, relevant, and easy to navigate. Our Fire Marshal course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Fire Marshal QLS Bundle Includes the following Courses Course 01: Certificate in Fire Marshal at QLS Level 3 Course 02: Fire Extinguisher Technician Course 03: Emergency First Aid at Work (EFAW) Course 04: DSEAR Training Course 05: Working at Height Training Key Features of Fire Marshal Eligibility for QLS endorsed certificate upon successful completion of the Fire Marshal course Free CPD Accredited Course Fully online, interactive Fire Marshal 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 Fire Marshaltraining 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 Fire Marshal course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Fire Marshal 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 Fire Marshal 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 Fire Marshal course, learners will be able to order an endorsed certificate, titled: [Certificate in Fire Marshal at QLS Level 3], as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 60 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 Fire Marshal basics. Requirements No prior degree or experience is required to enrol in this Fire Marshal course. Career path This Fire Marshal 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.

Tired of browsing and searching for a Human Resources Administrator Diploma course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Human Resources Administrator Diploma bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Human Resources Administrator Diploma course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Human Resources Administrator Diploma and help you along your learning journey. Advanced audio-visual learning modules of these Human Resources Administrator Diploma courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Human Resources Administrator Diploma, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Human Resources Administrator Diploma Bundle Consists of the following Premium courses: Course 01: HR Management Level 2 Course 02: Recruitment Officer Diploma Course 03: Resourcing and Managing Talent Course Course 04: Employee Hiring and Termination Training Course 05: Employment Law Level 3 Course 06: Virtual Interviewing for HR Course 07: Payroll Management Course Course 08: People Management Skills Level 3 Course 09: Performance Management Course 10: Human Resources (HR) Audit Course 11: Recruitment Consultant - Level 4 Course 12: Leadership & Management Diploma Course 13: Equality and Diversity Course 14: GDPR Data Protection Level 5 Enrol now in Human Resources Administrator Diploma to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Human Resources Administrator Diploma expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Introduction to Human Resources Employee Recruitment and Selection Procedure Employee Training and Development Process Performance Appraisal Management Employee Relations Motivation and Counselling Ensuring Health and Safety at the Workplace Employee Termination Employer Records and Statistics Essential UK Employment Law CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Human Resources Administrator Diploma bundle. Requirements Our Human Resources Administrator Diploma course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Human Resources Administrator Diploma expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Human Resources Administrator Diploma) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Human Resources Administrator 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.

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Sales Forecast mega bundle. This 37 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Sales Forecast bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Sales Forecast bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Sales Forecast Bundle Consists of the following Premium courses: Course 01: Sales Executive Training Course 02: 10 Sales Secrets for Success Course 03: Creating Highly Profitable Sales Funnels Course 04: Salesforce Heroku Masterclass Course 05: Sales Analysis in Excel Course 06: Get a Job in Sales: Your Fast Track to Career Success Course 07: Marketing Masterclass Course 08: Sales: Reading Body Language As A Sales Tool Course 09: Professional Marketing and Advertising Complete Online Course Course 10: Building Sales Funnels With ClickFunnels Course 11: Sales Optimization Skills: Increase Your Sales by 1000% Course 12: Business Development & Sales Course 13: Digital Marketing Diploma Level 3 Course 14: Digital Marketing Strategies for Business Owners Course 15: Affiliate Marketing Masterclass Course 16: SEO Masterclass Course 17: Professional Copywriter - Level 4 Course 18: Social Media Marketing (SMM) Course 19: LinkedIn Marketing & Sales Lead Generation Blueprint Course 20: Facebook Ads For Scaling Business - Complete Training Course 21: Content Creation & Content Marketing Course 22: Digital Marketing - Business Tips Course 23: Digital Marketing and SEO Course 24: Investment Basics Course 25: Making Budget & Forecast Course 26: Retargeting Ads Guide - How Retargeting Works Course 27: Customer Service Course 28: Business Productivity Training Course 29: Commercial law Course 30: Body Language Secrets Moreover, this bundles include 7 career-focused courses: 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 Course 06: Business English Perfection Course Course 07: Networking Skills for Personal Success Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Sales Forecast mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Sales Forecast to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your 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. Certificate: PDF Certificate: Free for all 37 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Sales Forecast bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Sales Forecast bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. 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 (Sales Executive Training) 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.

Feeling Stuck in Your Career? The Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 Courses bundle on your job life and career growth! This Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: Natural Nutrition: Naturopathy Course Course 02: Alternative Medicine - Homeopathy Course 03: Ayurveda Diploma Course 04: Herbalism: Herbs and Foods for Long-term Health Course 05: Aging & Longevity Course Course 06: Agricultural Science Course 07: Forestry Course 08: Botany Course 09: Horticulture Course 10: Hydroponics Gardening Online Course Course 11: Hydrotherapy Course 12: Physiotherapy Course 13: aromatherapy-using essential oils in your everyday life Course 14: Aromatherapy Acupressure - Massage Therapist Course 15: Lomi Lomi massage Course 16: Deep Tissue Massage Therapy Online Course for Professionals Course 17: Shiatsu massage for beginners Course 18: Hot Stones Massage Course Course 19: Instant Pain Relief with Reflex Tapping Course 20: Diet and Nutrition Diploma Course 21: Nutrition Masterclass: Build Your Perfect Diet & Meal Plan Course 22: Home Workout for Fitness, Weight and Health Course 23: Immunity Boosting Food Course 24: Best Healthy Lifestyle Diet Course 25: Ketogenic Diet Course 26: Biohacking Your Physical and Mental Health Course 27: Stress Management Training Course 28: Life Coaching Course 29: Personal Hygiene Course 30: Public Healthcare What will make you stand out? Upon completion of this online Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this Naturopathy, Alternative Medicine (Herbalism) & Nutrition Bundle After successfully completing the Naturopathy, Alternative Medicine (Herbalism) & Nutrition 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition Bundle The online test with immediate results You can study and complete the Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle at your own pace. Study for the Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle, a comprehensive, complete collection of 30 courses. Each course in the Naturopathy, Alternative Medicine (Herbalism) & Nutrition 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle offers the flexibility and convenience to learn at your own pace. Make the Naturopathy, Alternative Medicine (Herbalism) & Nutrition 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition - 30 Courses is perfect for: Expand your knowledge and skillset for a fulfilling career with the Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle. Learn on your schedule, in the comfort of your home - the Naturopathy, Alternative Medicine (Herbalism) & Nutrition 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 Naturopathy, Alternative Medicine (Herbalism) & Nutrition bundle. Certificates CPD Certificates Digital certificate - Included

Unlock Your Potential: Leadership vs Management Course Are you ready to step into your full potential as a leader? 🚀 Are you seeking clarity on the differences between leadership and management? Look no further! Our comprehensive course, 'Leadership vs Management,' is designed to equip you with the skills, insights, and strategies you need to thrive in today's dynamic business landscape. Why Choose 'Leadership vs Management' Course? In today's fast-paced world, the ability to lead effectively is paramount for success. However, many individuals often confuse leadership with management. While both are crucial components of organizational success, they entail distinct skill sets, mindsets, and approaches. Our course delves deep into the nuances of leadership and management, offering you invaluable insights to distinguish between the two and leverage their respective strengths. From understanding different leadership styles to mastering key management principles, this course provides you with a holistic understanding of leadership and management dynamics. What Will You Learn? 🔍 Differentiating Between Leadership and Management: Gain clarity on the fundamental differences between leadership and management and understand how they complement each other in driving organizational success. 📚 Exploring Leadership Styles: Explore various leadership styles and discover which ones resonate with your personality, values, and goals. 🔑 Mastering Management Principles: Learn essential management principles, including planning, organizing, leading, and controlling, to enhance your effectiveness in driving team performance and achieving objectives. 🌟 Developing Emotional Intelligence: Cultivate emotional intelligence skills to inspire and motivate teams, navigate conflicts, and foster a positive work culture. 💡 Strategic Decision-Making: Hone your strategic decision-making abilities to anticipate challenges, seize opportunities, and steer your organization towards sustainable growth. Who is This For? Our 'Leadership vs Management' course is ideal for: Aspiring Leaders: Individuals who aspire to lead teams, departments, or organizations and are eager to develop their leadership skills. Seasoned Managers: Experienced managers looking to refine their leadership abilities, enhance their management competencies, and stay ahead in their careers. Entrepreneurs: Business owners and entrepreneurs seeking to cultivate effective leadership practices to drive business success and inspire their teams. Whether you're a seasoned professional or a budding leader, this course is designed to empower you with the knowledge, tools, and confidence to excel in your leadership journey. Career Path Upon completing our 'Leadership vs Management' course, you'll be equipped to: 🌱 Lead with Confidence: Confidently lead teams, departments, or organizations, inspiring others to achieve common goals and objectives. 🚀 Accelerate Your Career Growth: Position yourself for career advancement opportunities by demonstrating strong leadership and management capabilities. 🔧 Drive Organizational Success: Drive organizational success by effectively managing resources, fostering innovation, and cultivating a high-performance culture. Frequently Asked Questions (FAQ) Q: Can I take this course if I have no prior leadership or management experience? A: Absolutely! Our course is designed to cater to individuals at all levels of experience, from beginners to seasoned professionals. Whether you're new to leadership or looking to enhance your existing skills, you'll find valuable insights and practical strategies to propel your growth. Q: Is this course suitable for entrepreneurs and small business owners? A: Yes! Entrepreneurs and small business owners stand to benefit immensely from our course. Effective leadership and management are essential for driving business success, fostering innovation, and building high-performing teams. Our course equips entrepreneurs with the skills and insights they need to lead with confidence and navigate the challenges of entrepreneurship effectively. Q: Will I receive a certificate upon completing the course? A: Yes, upon successful completion of the course, you will receive a certificate of completion. This certificate serves as a testament to your commitment to professional development and can be a valuable addition to your resume or LinkedIn profile. Unlock Your Leadership Potential Today! Don't miss out on the opportunity to unlock your full leadership potential! Enroll in our 'Leadership vs Management' course today and embark on a transformative journey towards becoming a more effective, influential leader. Whether you're aspiring to lead teams, drive organizational change, or excel in your career, this course will empower you to make a lasting impact in today's dynamic business landscape. Join us and take the first step towards realizing your leadership dreams! 🌟 Course Curriculum Module 1 Food Delivery Service in the USA. Food Delivery Service in the USA. 00:00 Module 2 Regulations and Platform Development. Regulations and Platform Development. 00:00 Module 3 Restaurant Partner and Customer Engagement. Restaurant Partner and Customer Engagement. 00:00 Module 4 Quality Control and Sustainability. Quality Control and Sustainability. 00:00 Module 5 Data Analytics and Marketing. Data Analytics and Marketing. 00:00

Getting Started The qualification has been planned to lay the business administration sector groundwork. They convey recognition and demonstrable skills to the management segments as well. We allow the learners to use the chance to gain from these programs that will offer them relevant aptitudes and qualities. The diploma is credited at Level 6, with a total credit of 120 points. It is devised that the learners completing level 6 Diploma will progress to either Qualifi Level 7 Diplomas in Management. The underlying principle of the course is to ensure a career path for learners who wish to build their care capacities within the business sector. The result of the diploma, an accepted UK qualification, is for the aspirants to have the expertise and the skills needed by organisations worldwide. All the programs are designed to provide learning based on concepts and practical insights that are necessary for the companies of the present and future. Apart from this, we look forward to building up efficient team leaders, managers and leaders through the invention and delivery of learning required for the industry. The qualification is also fit for part-time learners in the workplace but yet eligible for full-time learners who can involve informal work placements or part-time employment. The learners can advance into or within employment in the business sector, either by the achievement of the awards directly or following further study QUALIFI Level 7 Diplomas. Key Benefits This qualification will benefit the learner: To understand and apply the principles of leadership in a business environment. Review and apply the principles of business management within the industry. Select, collate, review and analyse information from various sources. To improve learner's employability by allowing them to explore the relationship between theories and their practical application. Upon completing this Level 6 diploma, learners can progress to the first year of postgraduate study or a Qualifi Level 7 Diploma. Key Highlights Are you visualising yourself as the future manager to continue to bring recognition and professionalism across several sectors? Then, the Level 6 Diploma in Business Administration designed by Qualifi helps to develop and reward the business managers of today and the future. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our Qualifi-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The Qualifi Level 6 Level Diploma in Business Administration can open many career pathways including, but not limited to: Operations Manager, with an estimated average salary of £46,814 per annum Account Manager, with an estimated average salary of £36,338 per annum Financial Analyst with an estimated average salary of £47,465 per annum Marketing Manager, with an estimated average salary of £45,623 per annum Sales Manager, with an estimated average salary of £48,042 per annum Business Analyst, with an estimated average salary of £54,347 per annum Business Consultant with an estimated average salary of £64,223 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, including real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform. This facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   The qualifications have been made available to all without artificial barriers denying access and progression. The primary requirement is to get through the interview, and they are expected to hold the following, Learners who possess Qualifications at Level 5 and or Learners who have work experience in the business sector and exhibit ambition with apparent career goals; We also accommodate students with significant years of experience even though they do not possess formal qualifications. The criteria for admission will be through interviews for those who can demonstrate the skills to cope with the demands of the course. Progression   Learners completing the QUALIFI Level 6 Diploma in Business Administration will progress to: Any QUALIFI Level 7 Diploma, or The first year of postgraduate study, or Directly into employment in an associated profession.   Why gain a QUALIFI Qualification?   This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the business management sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex business management environment. The learners will be introduced to managing various business management functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also learn to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle problems and difficulties. Practice judgment, own and take responsibility for decisions and actions, and. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Management Control Reference No : BA601 Credit : 20 || TQT : 200 The primary aim of this unit is to make learners understand the concepts and their application in business organisations of management control systems. UNIT2- Management of Sales force Reference No : BA602 Credit : 20 || TQT : 200 The unit aims to explore the concept of customer relationship management, planning and decision-making process to achieve sales force target at local and international markets. UNIT3- Strategic Marketing Management Reference No : BA603 Credit : 20 || TQT : 200 This unit aims to introduce learners about the strategic reflections on the significant issues on marketing management. Learners will be able to know marketing nature, planning process, segmentation and target marketing. UNIT4- Business Law Reference No : BA604 Credit : 20 || TQT : 200 This unit aims to introduce the importance of law in businesses and organisations, including main features of English Legal systems, contract laws, sales of goods acts and credit transactions as well as intellectual property law. This unit will develop skills in direction and encourages their application to business. UNIT5- Research Project including Research Methods Reference No : BA605 Credit : 20 || TQT : 200 This unit aims to introduce the learner to research methods and how to produce a new project based on their findings. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Getting Started The Qualifi Level 7 Diploma in Risk Management is a comprehensive program designed to equip learners with the necessary skills and knowledge to manage risks in organisations effectively. Throughout the course, learners will be exposed to various topics, including ISO standard 'harmonisation' programmes, organisational strategy and risk plans, contemporary issues in CSR risk management systems, and risk financing options available for an organisation. Additionally, learners will learn how to evaluate various tools to assess an organisation's position in the market and prepare a risk management plan to mitigate potential risks. The course also covers mathematical models such as VAR, CVAR, and EVAR and teaches learners how to develop and design a research proposal on a chosen risk management-related topic. Completing this diploma opens up opportunities for further study or employment in risk management. Key Benefits Understand the principles and formation of agreements. Comprehend the aims, general principles and sources of risk management. Understand the strategy risk and its different types. Understand the significance of corporate governance in organisations. Understand how to construct research methods in the context of risk management Career Pathways The Qualifi 7 Diploma in Risk Management can open many career pathways including, but not limited to: Project Manager with an estimated average salary of £65,000 per annum Trainee- Risk Management, with an estimated average salary of £25,000 per annum Risk Manager with an estimated average salary of £60,000 per annum Senior Enterprise Manager - Risk & Compliance; with an estimated average salary of £74,000 per annum About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Entry Requirements Approved centres are responsible for reviewing and making decisions regarding applicants' ability to complete the learning programme successfully and meet the demands of the qualification. The initial assessment by the centre will need to consider the readily available support that can be made available to meet individual learner needs as appropriate. The qualification has been designed to be accessible without artificial barriers restricting access. For this qualification, applicants must be aged 19 or older and will be expected to hold the following: UK Level 6 Qualification or; First Degree, or An equivalent overseas qualification. In the case of applicants whose first language is not English, then IELTS 6 (or equivalent) is required. International qualifications will be checked for appropriate enrolment in UK higher education postgraduate programmes where applicable. Applicants are required to produce two supporting references, at least one of which should be academic.   Progression   Completing the Qualifi Level 7 Diploma in Risk Management will enable learners to progress to: Qualifi Level 8 Diploma Strategic Management University for top-up to a Masters Employment in an associated profession   Why gain a QUALIFI Qualification? This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also acquire the ability to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle problems and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.   Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Principles of Risk Management Reference No : L/650/5656 Credit : 20 || TQT : 200 This unit aims to develop learners' understanding of legislative frameworks that contribute to implementing organisational risk assessment plans and learn the basics of ISO standards. ISO is a universally recognised international standard that provides principles and guidelines on risk management. These standards offer principles, a framework, and a process for managing risk that any organisation can use. The learners will become aware of the principles of the ISO standards. UNIT2- Strategic Risk Management Reference No : M/650/5657 Credit : 20 || TQT : 200 This unit aims to introduce learners to the critical examination of strategies concerning the setting and continuous improvement of performance standards and the establishment and maintenance of an effective system of risk management; all aspects of risk management are considered, including, but not limited to, health and safety, environmental and security; planning and alignment of risk objectives with other corporate strategy. UNIT3- Responsible Leadership and Governance Reference No : R/650/5658 Credit : 20 || TQT : 200 This unit aims to provide learners with an understanding of the modern organisational necessity of governance, which leads to examining efficient corporate governance practices. This unit gives learners an understanding of law's impact and global integration on administrative decisions, policies, processes and activities. UNIT4- Organisational and Environmental Risk Reference No : T/650/5659 Credit : 20 || TQT : 200 This unit aims to help learners develop their knowledge and understanding of the importance of managing risks in business organisations and enable them to develop an effective risk management plan and review risk financing options. UNIT5- Risk Analysis and Modelling Reference No : D/650/5660 Credit : 20 || TQT : 200 This unit aims to familiarise learners with the core concepts and tools to build modern risk analysis models. It introduces learners to the foundations of risk analysis. These core concepts are combined to explore contemporary risk analysis modelling techniques. This unit will provide learners with the skills to apply these techniques in real-life situations. UNIT6- Advanced Research Methods in Risk Management Reference No : F/650/5661 Credit : 20 || TQT : 200 This unit aims to develop learners' ability to prepare for various types of academically based management research by developing and designing a research proposal. Learners will develop a critical understanding of the philosophical, practical and ethical research concepts within the business environment. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Duration 4 Days 24 CPD hours This course is intended for This course is for the Identity and Access Administrators who are planning to take the associated certification exam, or who are performing identity and access administration tasks in their day-to-day job. This course would also be helpful to an administrator or engineer that wants to specialize in providing identity solutions and access management systems for Azure-based solutions; playing an integral role in protecting an organization. The Microsoft Identity and Access Administrator course explores how to design, implement, and operate an organization?s identity and access management systems by using Microsoft Entra ID. Learn to manage tasks such as providing secure authentication and authorization access to enterprise applications. You will also learn to provide seamless experiences and self-service management capabilities for all users. Finally, learn to create adaptive access and governance of your identity and access management solutions ensuring you can troubleshoot, monitor, and report on your environment. The Identity and Access Administrator may be a single individual or a member of a larger team. Learn how this role collaborates with many other roles in the organization to drive strategic identity projects. The end goal is to provide you knowledge to modernize identity solutions, to implement hybrid identity solutions, and to implement identity governance. Prerequisites SC-900T00: Microsoft Security, Compliance, and Identity Fundamentals AZ-104T00 - Microsoft Azure Administrator 1 - Explore identity in Microsoft Entra ID Explain the identity landscape Explore zero trust with identity Discuss identity as a control plane Explore why we have identity Define identity administration Contrast decentralized identity with central identity systems Discuss identity management solutions Explain Microsoft Entra Business to Business Compare Microsoft identity providers Define identity licensing Explore authentication Discuss authorization Explain auditing in identity 2 - Implement initial configuration of Microsoft Entra ID Configure company brand Configure and manage Microsoft Entra roles Configure delegation by using administrative units Analyze Microsoft Entra role permissions Configure and manage custom domains Configure tenant-wide setting 3 - Create, configure, and manage identities Create, configure, and manage users Create, configure, and manage groups Configure and manage device registration Manage licenses Create custom security attributes Explore automatic user creation 4 - Implement and manage external identities Describe guest access and Business to Business accounts Manage external collaboration Invite external users - individually and in bulk Demo - manage guest users in Microsoft Entra ID Manage external user accounts in Microsoft Entra ID Manage external users in Microsoft 365 workloads Implement and manage Microsoft Entra Verified ID Configure identity providers Implement cross-tenant access controls 5 - Implement and manage hybrid identity Plan, design, and implement Microsoft Entra Connect Implement manage password hash synchronization (PHS) Implement manage pass-through authentication (PTA) Demo - Manage pass-through authentication and seamless single sign-on (SSO) Implement and manage federation Trouble-shoot synchronization errors Implement Microsoft Entra Connect Health Manage Microsoft Entra Health 6 - Secure Microsoft Entra users with multifactor authentication What is Microsoft Entra multifactor authentication? Plan your multifactor authentication deployment Configure multi-factor authentication methods 7 - Manage user authentication Administer FIDO2 and passwordless authentication methods Explore Authenticator app and OATH tokens Implement an authentication solution based on Windows Hello for Business Deploy and manage password protection Configure smart lockout thresholds Implement Kerberos and certificate-based authentication in Microsoft Entra ID Configure Microsoft Entra user authentication for virtual machines 8 - Plan, implement, and administer Conditional Access Plan security defaults Plan Conditional Access policies Implement Conditional Access policy controls and assignments Test and troubleshoot Conditional Access policies Implement application controls Implement session management Implement continuous access evaluation 9 - Manage Microsoft Entra Identity Protection Review identity protection basics Implement and manage user risk policy Monitor, investigate, and remediate elevated risky users Implement security for workload identities Explore Microsoft Defender for Identity 10 - Implement access management for Azure resources Assign Azure roles Configure custom Azure roles Create and configure managed identities Access Azure resources with managed identities Analyze Azure role permissions Configure Azure Key Vault RBAC policies Retrieve objects from Azure Key Vault Explore Microsoft Entra Permissions Management 11 - Plan and design the integration of enterprise apps for SSO Discover apps by using Microsoft Defender for Cloud Apps and Active Directory Federation Services app report Configure connectors to apps Design and implement app management roles Configure preintegrated gallery SaaS apps Implement and manage policies for OAuth apps 12 - Implement and monitor the integration of enterprise apps for SSO Implement token customizations Implement and configure consent settings Integrate on-premises apps with Microsoft Entra application proxy Integrate custom SaaS apps for single sign-on Implement application-based user provisioning Monitor and audit access to Microsoft Entra integrated enterprise applications Create and manage application collections 13 - Implement app registration Plan your line of business application registration strategy Implement application registration Register an application Configure permission for an application Grant tenant-wide admin consent to applications Implement application authorization Manage and monitor application by using app governance 14 - Plan and implement entitlement management Define access packages Configure entitlement management Configure and manage connected organizations Review per-user entitlements 15 - Plan, implement, and manage access review Plan for access reviews Create access reviews for groups and apps Create and configure access review programs Monitor access review findings Automate access review management tasks Configure recurring access reviews 16 - Plan and implement privileged access Define a privileged access strategy for administrative users Configure Privileged Identity Management for Azure resources Plan and configure Privileged Access Groups Analyze Privileged Identity Management audit history and reports Create and manage emergency access accounts 17 - Monitor and maintain Microsoft Entra ID Analyze and investigate sign-in logs to troubleshoot access issues Review and monitor Microsoft Entra audit logs Export logs to third-party security information and event management system Analyze Microsoft Entra workbooks and reporting Monitor security posture with Identity Secure Score

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure. In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage. Prerequisites Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Introduction to data engineering on Azure What is data engineering Important data engineering concepts Data engineering in Microsoft Azure 2 - Introduction to Azure Data Lake Storage Gen2 Understand Azure Data Lake Storage Gen2 Enable Azure Data Lake Storage Gen2 in Azure Storage Compare Azure Data Lake Store to Azure Blob storage Understand the stages for processing big data Use Azure Data Lake Storage Gen2 in data analytics workloads 3 - Introduction to Azure Synapse Analytics What is Azure Synapse Analytics How Azure Synapse Analytics works When to use Azure Synapse Analytics 4 - Use Azure Synapse serverless SQL pool to query files in a data lake Understand Azure Synapse serverless SQL pool capabilities and use cases Query files using a serverless SQL pool Create external database objects 5 - Use Azure Synapse serverless SQL pools to transform data in a data lake Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement Encapsulate data transformations in a stored procedure Include a data transformation stored procedure in a pipeline 6 - Create a lake database in Azure Synapse Analytics Understand lake database concepts Explore database templates Create a lake database Use a lake database 7 - Analyze data with Apache Spark in Azure Synapse Analytics Get to know Apache Spark Use Spark in Azure Synapse Analytics Analyze data with Spark Visualize data with Spark 8 - Transform data with Spark in Azure Synapse Analytics Modify and save dataframes Partition data files Transform data with SQL 9 - Use Delta Lake in Azure Synapse Analytics Understand Delta Lake Create Delta Lake tables Create catalog tables Use Delta Lake with streaming data Use Delta Lake in a SQL pool 10 - Analyze data in a relational data warehouse Design a data warehouse schema Create data warehouse tables Load data warehouse tables Query a data warehouse 11 - Load data into a relational data warehouse Load staging tables Load dimension tables Load time dimension tables Load slowly changing dimensions Load fact tables Perform post load optimization 12 - Build a data pipeline in Azure Synapse Analytics Understand pipelines in Azure Synapse Analytics Create a pipeline in Azure Synapse Studio Define data flows Run a pipeline 13 - Use Spark Notebooks in an Azure Synapse Pipeline Understand Synapse Notebooks and Pipelines Use a Synapse notebook activity in a pipeline Use parameters in a notebook 14 - Plan hybrid transactional and analytical processing using Azure Synapse Analytics Understand hybrid transactional and analytical processing patterns Describe Azure Synapse Link 15 - Implement Azure Synapse Link with Azure Cosmos DB Enable Cosmos DB account to use Azure Synapse Link Create an analytical store enabled container Create a linked service for Cosmos DB Query Cosmos DB data with Spark Query Cosmos DB with Synapse SQL 16 - Implement Azure Synapse Link for SQL What is Azure Synapse Link for SQL? Configure Azure Synapse Link for Azure SQL Database Configure Azure Synapse Link for SQL Server 2022 17 - Get started with Azure Stream Analytics Understand data streams Understand event processing Understand window functions 18 - Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics Stream ingestion scenarios Configure inputs and outputs Define a query to select, filter, and aggregate data Run a job to ingest data 19 - Visualize real-time data with Azure Stream Analytics and Power BI Use a Power BI output in Azure Stream Analytics Create a query for real-time visualization Create real-time data visualizations in Power BI 20 - Introduction to Microsoft Purview What is Microsoft Purview? How Microsoft Purview works When to use Microsoft Purview 21 - Integrate Microsoft Purview and Azure Synapse Analytics Catalog Azure Synapse Analytics data assets in Microsoft Purview Connect Microsoft Purview to an Azure Synapse Analytics workspace Search a Purview catalog in Synapse Studio Track data lineage in pipelines 22 - Explore Azure Databricks Get started with Azure Databricks Identify Azure Databricks workloads Understand key concepts 23 - Use Apache Spark in Azure Databricks Get to know Spark Create a Spark cluster Use Spark in notebooks Use Spark to work with data files Visualize data 24 - Run Azure Databricks Notebooks with Azure Data Factory Understand Azure Databricks notebooks and pipelines Create a linked service for Azure Databricks Use a Notebook activity in a pipeline Use parameters in a notebook Additional course details: Nexus Humans DP-203T00 Data Engineering on Microsoft Azure training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-203T00 Data Engineering on Microsoft Azure course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.