Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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-300T00: Administering Microsoft Azure SQL Solutions 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.
An accredited qualification for current and prospective managers. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. One of the main responsibilities of a manager is to make sure that employees are satisfied with their job and reaching their full potential. A manager who can energise his or her employees will have a team which has a much greater potential and capability of achieving company goals and objectives. It is therefore vital that a manager has the essential skills to fully support and lead their team to success. This 3-day programme brings together the key leadership skills that you will need to be an effective manager so that you can return to the workplace and deliver tangible results. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 3 Award in Leadership and Management course is split into three main modules, covering the following: Module OneSolving Problems and Making Decisions What is a problem? How to identify a problem, its nature, scope and impact Identifying the root cause Understanding how to interpret information to solve a problem What is involved in making an informed decision? Generate ideas/solutions- creative thinking techniques How to evaluate your options Finding the critical path Having confidence to commit to a decision Planning approach Communicating the decision Implementing the plan Module TwoUnderstanding Leadership What is leadership? Recognise the differences and similarities between leadership and management Qualities and skills of a leader Action Centered Leadership - Team, Task, Individual - John Adair Varying leadership styles Evaluating a range of leadership models and their significance for: Task, Performance, Culture, Relationships Reflect on your own leadership styles and behaviours Create an action plan to enhance your performance Module ThreeUnderstanding the Communication Process in the Workplace Identify what is effective communication Understand the importance of effective communication at work Recognise the different ways we communicate Recognise possible barriers to communication and how to overcome them Johari's window - communication flows How others will perceive and interpret the information you have provided Active listening Developing questioning skills Understanding the significance of non-verbal communication and body language Developing sensory acuity and how to use it effectively in the workplace In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. In-House Courses As well as being one of the most popular open courses, we can also arrange this course as an in-house programme for companies and organisations who wish to develop a number of their managers at the same time, and would find an in-house course at their own premises much more suitable. Scheduled Courses Classroom Course - Nottingham (NG12 4DG) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 2 work-based assignments. Cost: £995 + vat 07-08 September 2023 14-15 December 2023 12-13 February 2024 Classroom Course - Reading (RG41 5QS) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 2 work-based assignments. Cost: £995 + vat 05-06 October 2023 15-16 January 2024 11-12 April 2024 Zoom™ Course Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same. The only difference is that we split the course into four half-day sessions to make it easier on your eyes! Cost: £895 + vat November 2023 - 7th Nov (morning), 7th Nov (afternoon), 8th Nov (morning), 8th Nov (afternoon) March 2024 - 19th Mar (morning), 19th Mar (afternoon), 20th Mar (morning), 20th Mar (afternoon) June 2024 - 11th Jun (morning), 11th Jun (afternoon), 12th Jun (morning), 12th Jun (afternoon) Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.
Elevate your expertise with EnergyEdge's Tripod Beta Practitioner Bronze Level 2 course. Enroll now and stay ahead of the competition.
Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in Company Law This Advanced professional certificate course covers concepts, evolution, and mechanisms of English company law. The course covers rules framing the activities of sole traders, public limited companies, private companies limited by shares, companies limited by guarantee, and unlimited companies. In addition, the course provides insight into various types of partnerships. On a practical level, the course explains the role and components of the articles of association and addresses the controversial issue of the corporate veil. Also, the course is designed to cover companies' duties, rights, and liquidation. The course covers the general duties of a company and the role and rights of majority and minority shareholders. This includes rules framing their rights to vote and act against the company and thus remedies available for minority shareholders. In addition, the course provides insight into the role and duties of auditors and the liability of directors. The course explains the process and effects of a liquidation process on a procedural level. Course Details After the successful completion of this lecture, you will be able to; Understand the evolution of English company law. Understand the concept of a sole trader. Reflect on different types of companies under UK Laws. Understand the concept and types of partnerships. Understand the role and components of the articles of association. Understand the concept of the corporate veil. Reflect on different types of companies under EU Laws. Understand the general duties of a company. Understand the role and rights of shareholders. Reflect on the rights and remedies available for minority shareholders. Understand the role and duties of auditors. Understand the duties and liability of directors. Understand the process and effects of a liquidation process. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Law lecturers. Business lecturers. Legal and business researchers.
Enhance your knowledge on methane emissions mitigation and management in the oil and gas industry with EnergyEdge's virtual instructor-led training course.
Introducing the ultimate bundle for sports enthusiasts and aspiring professionals: the Sports Therapy, Hydrotherapy & Sports Psychology (QLS) bundle! Get ready to dive into a world of knowledge and unlock your potential with eight comprehensive courses designed to take your understanding of sports therapy, hydrotherapy, and sports psychology to new heights. What sets this bundle apart are the three QLS-endorsed courses that come with hardcopy certificates upon completion. These courses have been carefully curated and validated by industry experts, ensuring that you receive the highest standard of theoretical education. No need to worry about missing out on practical skills or hands-on experience-these courses are packed with valuable insights, strategies, and techniques that will equip you with the knowledge to excel in your field. But that's not all! In addition to the QLS-endorsed courses, you'll also gain access to five CPD QS-accredited courses. These courses cover a range of relevant topics, including sports coaching, common sports injuries, sports medicine fundamentals, sports nutrition, and functional skills in fitness. With this comprehensive bundle, you'll acquire a well-rounded understanding of the key aspects that contribute to success in the world of sports therapy and psychology. Imagine being able to confidently analyse and treat sports injuries, implement effective fitness and nutrition strategies, and understand the psychological factors that drive athletes to perform at their best. Whether you're an aspiring sports therapist, coach, or simply passionate about the field, this bundle is your gateway to a wealth of knowledge that will set you apart from the competition. Expand your horizons, enhance your career prospects, and become an invaluable asset in the world of sports therapy, hydrotherapy, and sports psychology. Enrol in the Sports Therapy, Hydrotherapy & Sports Psychology (QLS) bundle today and embark on an exciting journey of discovery and growth. Don't miss out on this opportunity to fuel your passion and take your skills to the next level! Key Features of the Sports Therapy, Hydrotherapy & Sports Psychology (QLS) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Sports Therapy, Hydrotherapy & Sports Psychology (QLS) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Sports Therapy QLS Course 02: Hydrotherapy QLS Course 03: Sports Psychology 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Sports Coaching: Fitness & Nutrition Course 02: Sports Therapy: Common Sports Injuries Course 03: Sports Medicine Fundamentals Course 04: Sports Nutrition Course Course 05: Functional Skills - Fitness In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Sports Therapy, Hydrotherapy & Sports Psychology (QLS) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of sports therapy principles, including injury assessment, rehabilitation techniques, and therapeutic modalities. Acquire in-depth knowledge of hydrotherapy and its application in sports injury management, including immersion techniques, hydrostatic pressure, and resistance exercises. Develop a solid foundation in sports psychology, exploring the psychological factors that influence athletic performance, motivation, and mental skills training. Learn effective sports coaching strategies encompassing fitness and nutrition principles, goal setting, and athlete development. Identify and evaluate common sports injuries, understanding their causes, symptoms, and appropriate treatment approaches. Familiarize yourself with the fundamentals of sports medicine, including biomechanics, exercise physiology, and the role of sports nutrition in optimising performance. Enhance your functional skills in fitness, encompassing core strength, flexibility, endurance, and overall physical fitness. Discover the fascinating world of sports therapy, hydrotherapy, and sports psychology with our comprehensive bundle. Through a series of carefully curated courses, you'll explore the theoretical foundations of these fields, empowering you with the knowledge to excel in sports-related disciplines. With three QLS-endorsed courses, each accompanied by a hardcopy certificate, and an additional five CPD QS-accredited courses, this bundle provides a comprehensive understanding of key principles and practices. Dive deep into sports coaching, injury assessment and rehabilitation, sports psychology, hydrotherapy techniques, and more. Expand your horizons, boost your career prospects, and unleash your potential in the realm of sports therapy and psychology. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring sports therapists looking to gain a strong theoretical foundation in the field. Sports coaches seeking to enhance their knowledge of injury management, sports psychology, and fitness and nutrition principles. Fitness enthusiasts interested in understanding the theoretical underpinnings of sports therapy and psychology. Individuals passionate about the sports industry and keen to explore the theoretical aspects of sports medicine and rehabilitation. Career path Sports Therapist: £20,000 - £40,000 per year Sports Coach: £18,000 - £35,000 per year Fitness Instructor: £14,000 - £30,000 per year Rehabilitation Specialist: £25,000 - £45,000 per year Sports Nutritionist: £20,000 - £40,000 per year Sports Psychology Consultant: £30,000 - £60,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Introducing the ultimate knowledge package for professionals seeking to excel in the fields of rigging, lifting, port management, and warehouse safety! With our exclusive Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course bundle, you'll gain comprehensive expertise across a range of essential disciplines. This exceptional bundle boasts an impressive lineup of courses designed to equip you with the knowledge and skills needed to thrive in today's competitive industries. What sets us apart is our unwavering commitment to quality, as evidenced by the inclusion of three QLS-endorsed courses. By completing these courses, you'll not only enhance your expertise but also receive a coveted hardcopy certificate attesting to your mastery of these specialised domains. In addition to the QLS-endorsed courses, we have carefully curated five CPD QS-accredited courses that perfectly complement your learning journey. Delve into the intricacies of airport management, logistic management, supply chain management, import/export operations, and warehouse management diploma. Each course is meticulously crafted to provide you with a deep understanding of the subject matter and enable you to excel in your professional endeavours. Forget generic online tutorials and quizzes; we offer a refreshingly unique approach to learning. Our course content is delivered in an engaging and accessible format, making it easy for you to absorb the material at your own pace. No need for hands-on experience or practical skills - we believe in empowering you with theoretical knowledge that is directly applicable to real-world scenarios. Are you ready to unlock new career opportunities and become an industry leader in rigging, lifting, port management, and warehouse safety? Enroll in our Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course bundle today and embark on a transformative educational journey that will propel you towards success. Expand your horizons, gain valuable expertise, and secure a brighter future in these dynamic industries. Key Features of the Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Rigging and Lifting QLS Course 02: Port Management QLS Course 03: Warehouse Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Airport Management Course 02: Logistic Management Course 03: Supply Chain Management Course 04: Import/Export Course 05: Warehouse Management Diploma In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of rigging and lifting techniques, ensuring safe and efficient operations in various industries. Develop the knowledge and skills necessary for effective port management, including logistics, supply chain operations, and import/export procedures. Acquire expertise in warehouse safety, identifying and implementing best practices to minimise risks and maintain a secure working environment. Explore the intricacies of airport management, including passenger handling, security protocols, and air cargo logistics. Master the fundamentals of logistic management, optimising transportation, inventory, and distribution processes. Deepen your knowledge of supply chain management, understanding how to streamline operations and improve overall efficiency. Attain proficiency in warehouse management, including inventory control, storage optimisation, and effective material handling techniques. Unleash your potential with our Rigging & Lifting, Port Management and Warehouse Safety - 3 QLS Course bundle. This meticulously curated package offers a unique opportunity to delve into the core aspects of rigging, lifting, port management, and warehouse safety. Featuring three QLS-endorsed courses, you'll receive hardcopy certificates upon completion, validating your expertise in these specialised fields. Additionally, explore five CPD QS accredited courses that complement your learning journey, expanding your knowledge in airport management, logistic management, supply chain management, import/export, and warehouse management diploma. With our theoretical approach to learning, you'll acquire in-depth knowledge without the need for practical skills or hands-on experience. Prepare to excel in these dynamic industries and unlock limitless career opportunities. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to enhance their knowledge and expertise in rigging, lifting, port management, and warehouse safety. Individuals aspiring to pursue careers in airport management, logistic management, supply chain management, import/export, and warehouse management. Those who wish to upgrade their skills and stay up-to-date with industry best practices. Graduates looking to kick-start their careers in the fields mentioned above. Career path Rigging and Lifting Specialist: £25,000 - £45,000 per year Port Operations Manager: £30,000 - £60,000 per year Warehouse Safety Coordinator: £25,000 - £40,000 per year Airport Operations Supervisor: £20,000 - £40,000 per year Logistic Manager: £30,000 - £60,000 per year Supply Chain Analyst: £25,000 - £45,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Enhance your knowledge in process safety engineering with EnergyEdge's advanced classroom training course. Register now to secure your spot!