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.
Today, every individual and organisation is a publisher. You want everyone in your organisation to be a potential ambassador. And every employee has something to gain from raising their profile and showcasing their expertise. An effective content strategy allows you to deliver compelling stories to your audience in the most seamless way possible to make an emotional connection. This requires a mix of passion for the subject matter, a deep relationship with your audience, robust production processes, and the right tools. With a background in journalism and technology, we’ve worked on many projects that combine the two – including overseeing the iPad edition launches for Condé Nast in the UK, product ownership of a Digital Asset Manager for Condé Nast International, and developing and delivering content training for telco VEON. Publishers and brands we’ve worked with include WIRED, Time Out, GQ, Vanity Fair and Vogue – as well as solo entrepreneurs and startups who are trying to cut through the noise and get their message heard. In this course we'll cover the key elements of an effective content strategy: how to plan across multiple platforms, and how to implement your blueprint without exhausting yourself or your team. Sample learning content Session 1: Planning a content strategy Mapping and understanding your audiences. Defining your content objectives, for you or your organisation. Common pitfalls with poorly targeted content. Session 2: A content creation framework Finding ideas to generate a consistent stream of content. Idenitfying angles that will help you stand out from the crowd. Using different formats across multiple channels. Session 3: Keeping it going Simple processes to help hit deadlines and publish regularly. Balancing content creation and content creation. Creating a mix of evergreen and timely content. Session 4: Measurement and iteration Useful (and useless) metrics for content producers. Handling comments and joining the conversation. Iterating your content strategy based on feedback. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people. Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “The EMpower Network commissioned the content creation workshop to understand how to communicate effectively with a wide range of stakeholders. In light of covid-19, it’s more important than ever to communicate clearly especially as we’ve moved to remote meetings. The workshop was very insightful and Alan was a very engaging speaker making sure all attendees contributed and worked through real-life examples. Attendees praised the usefulness of the workshop and especially liked the content generation framework with one saying 'It has changed the way I think about communicating and given me a toolkit that I will use in both my work and personal projects'.” Shade Nathaniel-Ayodele | EMpower Network, Southwark Council
If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on the core values of customer service.
About this event Definition of epilepsy Various types of seizures Classification and management of seizures Ethical and legal responsibilities Recognising triggers and precipitants Person centred care Documentation and record keeping The impact of rescue medication and anti-epileptic drug therapy Rescue medications: what it is, it’s uses for epilepsy and side effects Emergency care plan and when to call an ambulance Risk assessment/promotion of safeguarding and dignity Epilepsy medication demonstration
QA Level 2 Award In Health And Safety In The Workplace (RQF) Health and Safety Training Courses QA Level 2 Award In Health And Safety In The Workplace (RQF) Course Contents: Roles and responsibilities of employers and employees Health and safety laws Risk assessments and risk control hierarchy Identifying and controlling risks from common workplace hazards, including: Slips, Trips and Falls Manual Handling Fire Working from Height Electricity Hazardous Substances Workplace conditions Ergonomics Equipment Noise and vibration Transport and vehicles Violence Smoking, alcohol and drugs Stress Procedures for responding to accidents and incidents Recording incidents, accidents and ill health Benefits of this course: In 2023/24, 1.7 million people suffered from a work-related illness 600,000 sustained a non-fatal injury 138 People lost their lives 776,000 Workers suffered from work-related stress, depression or anxiety The estimated cost of injuries and ill health last year was £21.6 billion 33.7 million working days, or 140,417 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk This QA Level 2 Award in Health and Safety in the Workplace (RQF) course helps employees gain an understanding of health and safety issues and their own role within that Accredited, Ofqual regulated qualification: This Health and Safety Training Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Health and Safety Certificate fulfils the legal requirements and is an excellent way to make sure you and your employees are trained in Health and Safety. The Ofqual Register number for this course is 603/2687/6
Understand the management of commonly presenting medical conditions and the significance of recording accurate diagnostic investigations.
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
About this training course Transmission lines and sub-stations are essential components in the electrical power systems. Proper design and maintenance are crucial for transmission lines to maintain a continuous operation. The objective of this 5-day training course is to deal appropriately with control systems, design characteristics and electric & magnetic fields. Participants will gain a better understanding on the corona and gap discharge phenomena, constructional features, and optimization of the transmission lines. Training Objectives By participating in this course, you will be able to: Understand transmission line design and its application Examine different types of conductors and electrical characteristics Explore basic and general transmission line parameters Prevent overvoltage through insulation design Determine surge impedance and corona effects Calculate and measure electric and magnetic fields Comprehend the impact of audible noise and electromagnetic interference Identify interference within the transmission line systems Target Audience The course will greatly benefit the following groups but not limited to: Electrical Engineers Civil Engineers Transmission & Distribution Engineers Substation Operators Safety Engineers Reliability Engineers Facility & Plant Engineers Technical Engineers Design Engineers Plant Supervisors Electrical Contractors Course Level Basic or Foundation Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile Power System analysis - Powell Canada Structural/Geotechnical Design and upgrades - Oakville Hydro Underground Cables testing and sizing - Plan Group Relay programming and design optimization - Cenovus Canada Different Arc Flash Analysis and BESS Design - SNC Lavalin Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC Battery energy storage system (BESS) installation at City of London - Siemens Canada EMF audits for 500 kV Transmission Lines - Hydro One EMF audits for 500 kV Transmission Lines - Hydro Quebec AC interference for 138 kV line modeling and mitigations - HBMS Mine POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Introduction to Cardiovascular Disease (2-Day Course)Course Description:BBO Training has responded to numerous requests for a course focused on cardiovascular disease, following the success of our previous courses, such as Introductions to COPD/Asthma/Diabetes and Minor Illness. In response, we have developed a comprehensive two-day agenda on this critical subject.These days are designed to provide a holistic approach to cardiovascular diseases, encompassing Coronary Heart Disease (CHD), Stroke, Heart Failure, and Hypertension. Participants will gain the knowledge and skills necessary to perform annual reviews for patients with these conditions.This course is particularly well-suited for Nurse Associates, Practice Nurses, Nurse Practitioners (NPs), Emergency Nurse Practitioners (ENPs), Paramedics, and Pharmacists. Dr. Tamara Cunningham, an experienced GP Trainer, will lead these interactive online sessions.Day One09.15 - Coffee and Registration09.30 - Introduction and Course Objectives09.45 - Setting the Scene: - Screening, Diagnosis, Pathophysiology, and Symptoms10.30 - Q-Risk Assessment10.45 - Coffee Break11.00 - Diet & Cardiovascular Disease: - Healthy Eating - Range of Dietary Approaches - Weight Management Services (PH25)11.45 - Benefits of Activity for Cardiovascular Disease12.30 - Lunch01.30 - Hypertension - A Review of NICE Guidelines (NG136): - Targets - Risk Assessment - Medications - Assessing Target Organ Damage02.45 - Lipid Modification - A Review of Nice Guidelines (NG181): - How Lipids Affect Cardiovascular Risk03.15 - Case Studies03.30 - Action Plan, Evaluation, and Resources03.45 - CloseDay Two09.15 - Coffee and Registration09.30 - Heart Failure - How to Perform a Safe Annual Review (NG106)10.45 - Coffee Break11.00 - CHD - Performing an Annual Review and Including Assessment of Angina12.30 - Lunch01.30 - Stroke - Secondary Prevention and Management of Long-Term Complications02.30 - Case Studies - Group Work to Consolidate Learning03.30 - Competencies, Training, and Resources03.45 - CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the basic physiology of cardiovascular disease.2. Perform risk assessments with patients and discuss modifiable factors such as diet and exercise.3. Describe the targets for blood pressure and cholesterol and how these affect primary and secondary prevention of CVD.4. Describe the basic anti-hypertensive and cholesterol-lowering medications involved in CVD.5. Name the major complications that may arise in people with a long duration of CVD and measures that may limit or prevent them.6. Describe the key advice to patients regarding Heart Failure and recognition of when to escalate/refer.7. Perform a safe review for stroke, CHD, and HF, recognizing how to work within your professional limits and when to signpost.8. Provide examples of referral pathways to other services, e.g., weight management, secondary care, activity, and psychological services.9. Explain the key components and process of an annual review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective cardiovascular disease care within primary care settings.
ISTQB® FOUNDATION TRAINING COURSE (2 persons minimum) The aim of this course is to provide you with the knowledge and skills to pass an exam certifying you as an ISTQB® Certified Tester - Foundation Level. Most organisations require this certification as a minimum skill requirement for software testers. In this course you will learn a standardized approach to software testing that will be immediately applicable to your projects. In order to get the certification you will be required to pass a 60-minute exam. Our trainers will fully prepare you by employing scenarios that mirror the exam questions, and by focusing course delivery with a balance of theory and practice. Target group: Functional Tester, Agile Tester, User Acceptance Tester, Test Automation Specialist, Performance Testing Specialist, Testing Team Lead, Test Manager, Business analyst Prerequisites: There are no specific prerequisites for this course. This course is suitable for anyone involved in software testing. Duration: 3 days. Training objectives: Learn aspects of test planning, estimation, monitoring and control. Understand and use international standards and terminology. Understand and implement effective testing techniques. Be well prepared for the exam. Identify the missing testing skills for the career development purposes. This course covers the following areas: Fundamentals of software testing Testing throughout the life cycle (software development models, test levels, test types) Test design techniques (e.g. specification-based or black-box techniques, structure-based or white-box techniques) Static testing (static testing techniques, review process, tool-assisted static analysis) Test management (test organisation, test planning and estimation, test progress monitoring and control, risks) Tools to support testing (types, benefits and risks) Language: English