20322 Addition courses

Python Data Analytics boot camp. 12 1 day lessons, learn Python Basics through to machine learning and front-ends. With practical project to give you full confidence and credibility.

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

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.

***24 Hour Limited Time Flash Sale*** Cleaning, Plumbing & Infection Prevention and Control Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unleash Your Potential in Cleaning, Plumbing & Infection Prevention and Control with Our Comprehensive Course Bundle! Are you ready to become a master in the vital fields of Cleaning, Plumbing, and Infection Prevention and Control? Look no further! Introducing our exclusive bundle of 8 courses designed to equip you with the knowledge and expertise needed to excel in these essential areas. With a combination of three QLS-endorsed courses and five CPD QS accredited programs, this bundle is your key to success. At the heart of this bundle lie three prestigious QLS-endorsed courses: Cleaning, Professional Plumbing, and Principles of Infection Prevention and Control. By enrolling in this bundle, you gain access to these top-tier courses recognized by the Quality Licence Scheme. Upon completion, you will receive hardcopy certificates, a testament to your dedication and expertise, providing a tangible proof of your accomplishments. In addition to the QLS-endorsed courses, our bundle includes five relevant CPD QS accredited programs that further enhance your knowledge and skills. These courses, including Heating, Ventilation & Air Conditioning (HVAC) Technician, Spill Management Training, Infection Prevention Training, COSHH Training for Assessors, and First Aid at Work, provide comprehensive insights into crucial aspects of the cleaning, plumbing, and infection prevention fields. Key Features of the Cleaning, Plumbing & Infection Prevention and Control Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Cleaning, Plumbing & Infection Prevention and Control bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Cleaning QLS Course 02: Professional Plumbing QLS Course 03: Principles of Infection Prevention and Control 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: Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Spill Management Training Course 03: Infection Prevention Training Course 04: COSHH Training for Assessors Course 05: First Aid at Work 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 Cleaning, Plumbing & Infection Prevention and Control courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: By completing this Cleaning, Plumbing & Infection Prevention and Control bundle, you will: Develop a comprehensive understanding of cleaning techniques, plumbing principles, and infection prevention and control practices. Gain expertise in HVAC systems and their maintenance, ensuring optimal performance. Acquire the skills to effectively manage spills and mitigate their impact on the environment. Understand the principles and best practices for preventing infections in various settings. Learn how to assess and manage hazardous substances to ensure a safe working environment. Gain knowledge in providing first aid in workplace emergencies, ensuring the well-being of individuals. Master essential techniques and protocols for maintaining cleanliness, plumbing systems, and infection prevention in diverse environments. This comprehensive package offers a unique opportunity to delve deep into these critical disciplines, equipping you with the knowledge and skills necessary to excel in today's demanding environment. Within this bundle, you'll discover three QLS-endorsed courses that serve as the foundation of your learning journey. These courses are meticulously designed to provide you with a solid understanding of theoretical principles and their practical applications. Complementing the QLS-endorsed courses are five CPD QS accredited programs that further enhance your knowledge and proficiency. From mastering HVAC systems and spill management to infection prevention training, COSHH assessment, and first aid protocols, these courses cover a range of essential topics, empowering you to make informed decisions and contribute effectively in your chosen profession. By enrolling in this bundle, you'll gain in-depth insights into the intricacies of HVAC systems, the management of spills, infection prevention strategies, hazardous substances assessment, and first aid protocols. Armed with this knowledge, you'll be equipped to address challenges and implement effective solutions in a variety of environments. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to enhance their knowledge and skills in cleaning, plumbing, and infection prevention and control. Aspiring practitioners looking to establish a solid foundation in these fields. Individuals interested in gaining expertise in HVAC systems, spill management, infection prevention, hazardous substances assessment, and first aid. Those aiming to advance their careers and contribute effectively to the cleaning, plumbing, and infection prevention industry. Career path Upon completing this bundle, you can pursue various career paths in cleaning, plumbing, and infection prevention and control, with positions such as: Facilities Manager: £30,000 - £60,000 per annum Plumbing Engineer: £25,000 - £45,000 per annum Infection Control Officer: £25,000 - £45,000 per annum Health and Safety Manager: £30,000 - £60,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

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.

HSE, First aid at work, EFAW, FAW,

Elevate your expertise with EnergyEdge's Tripod Beta Practitioner Bronze Level 2 course. Enroll now and stay ahead of the competition.

Enhance your knowledge on methane emissions mitigation and management in the oil and gas industry with EnergyEdge's virtual instructor-led training course.

Enhance your knowledge in process safety engineering with EnergyEdge's advanced classroom training course. Register now to secure your spot!

Develop your expertise in process hazard assessment and lead HAZOP teams effectively with EnergyEdge's classroom training course. Enroll now!