3154 Courses in Leeds delivered Online

**10 FREE QLS Endorsed Certificates and Included with Lifetime Access** People are the heartbeat of every organisation—and managing people takes more than just a smile and a spreadsheet. This Human Resources Management Diploma Level 4 (QLS Endorsed) is built for those who want to understand what truly keeps a team running smoothly. From hiring to handling disputes, building better staff engagement to understanding workplace laws—this course digs into the details HR professionals need to know. If your idea of HR is just holiday requests and interviews, think again. This goes deeper—minus the jargon and fluff.The course is structured to give you solid HR knowledge from all sides, whether it’s recruitment, performance reviews, or handling sticky situations with professionalism. It’s designed for those aiming to lead or support HR functions without needing years of prior experience. Whether you're working in admin, team leadership, or looking to explore a new direction in people management—this course will give you the right kind of knowledge, in the right kind of way. Fully online, flexible, and informative without putting you to sleep. Human Resources Management - QLS Endorsed Bundle Includes the following Courses Course 01: Diploma in Human Resources Management at QLS Level 4 Course 02: Diploma in Change Management at QLS Level 5 Course 03: Certificate in Bereavement and Grief Counselling at QLS Level 3 Course 04: Diploma in Corporate Compliance and Risk Management at QLS Level 3 Course 05: Certificate in Office Admin and Organisation Skills at QLS Level 3 Course 06: Certificate in Public Relations at QLS Level 3 Course 07: Award in Event Management at QLS Level 2 Course 08: Diploma in Career Coaching at QLS Level 5 Course 09: Diploma in Security Management at QLS Level 5 Course 10: Advanced Diploma in Project Management at QLS Level 7 Learning Outcomes Develop event planning expertise for seamless execution. Acquire adept office administration and organisational skills. Master corporate compliance and risk management strategies. Hone public relations techniques for effective communication. Attain advanced proficiency in human resources management. Navigate complex corporate governance principles and practices. Develop security management skills for a secure work environment. Cultivate grief counselling capabilities with sensitivity and empathy. Gain strategic insight into project management at an advanced level. Excel in the integration of diverse skills across various disciplines. Key Features 10 FREE QLS Endorsed Certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Behind every successful sales team is not just a string of impressive numbers, but a thriving workplace culture crafted by our dedicated Human Resources team. In this bundle, we explore how the human element, championed by HR, is a key ingredient in our journey to success. This curated collection of courses spans a range of essential disciplines, empowering you with versatile skills applicable across diverse industries. Dive into the intricacies of Event Management and HR Management, honing your organisational prowess. Explore the nuances of Bereavement and Grief Counselling, fostering empathy and support. Elevate your strategic thinking with Diplomas in Corporate Compliance, Risk Management, and Corporate Governance, ensuring you're equipped to navigate complex business landscapes. Cultivate essential administrative finesse with Certificates in Office Admin, Organisation Skills, and Public Relations. Progress through the tiers, mastering Human Resources Management and Security Management, culminating in an Advanced Diploma in Project Management. This multifaceted bundle is your gateway to a well-rounded skill set, providing a springboard for success in various professional arenas. By doing this bundle you will gain the ultimate understanding in strategic planning, organisational leadership, crisis management, and interpersonal communication. Develop expertise in compliance, risk mitigation, and project execution. Sharpen administrative skills for seamless office operations and public relations finesse. Master the intricacies of human resources and security management, equipping yourself for diverse roles in the professional landscape. This bundle is designed to nurture well-rounded professionals with a holistic understanding of critical business functions. Certificate Once you've successfully completed your course, you will immediately be sent a CPD Accredited PDF certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). After successfully completing the assignment, learners will be able to order FREE QLS Endorsed certificate for Each Courses. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Health and Safety Professionals Managers and Supervisors Mental Health Care Workers Childcare and Education Professionals Individuals in Substance Control Roles Psychology Enthusiasts Art Therapy Practitioners Those Pursuing Career Advancement Career path Health and Safety Manager Mental Health Care Coordinator Child Safeguarding Officer Substance Control Specialist Psychology Research Assistant Art Therapist Certificates Digital certificate Digital certificate - Included Hard copy 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. QLS Endorsed Certificate Hard copy certificate - Included

About Course Engineering Calculus Made Simple (Derivatives) Learn the basics of derivatives in a clear and concise way, tailored for electrical engineering students. This course is designed to help you understand and apply the concept of derivatives to electrical problems, without requiring you to have a deep understanding of calculus theory. In this course, you will learn: What derivatives are and how to calculate them How to use derivatives to solve real-world engineering problems Useful trigonometric identities How to approach derivatives using limits and theorems And more! By the end of this course, you will be able to: Calculate the derivatives of basic electrical functions Use derivatives to solve for voltage, current, and other electrical quantities Understand the relationship between derivatives and other calculus concepts, such as limits and integrals This course is perfect for electrical engineering students who want to learn the basics of derivatives without getting bogged down in complex calculus theory. Enroll today and start your journey towards becoming a more proficient electrical engineer! Benefits of learning derivatives for electrical engineering students: Derivatives are essential for understanding and solving many electrical engineering problems. For example, derivatives can be used to calculate the voltage and current in circuits, the torque of a motor, and the resonant frequency of a circuit. Derivatives can also be used to design new electrical components and systems. For example, derivatives can be used to design a filter that can remove noise from a signal or to design a control system that can keep a motor running at a constant speed. Having a good understanding of derivatives will make you a more competitive job applicant and will make you more successful in your career as an electrical engineer. Enroll today and start learning the basics of derivatives for electrical engineering! What Will You Learn? Students will learn mathematical derivatives as they apply to electrical functions Students will learn about limits. Students will learn useful Trig Identities. Students will learn the Squeeze Theorem. Course Content Engineering Calculus (Derivatives) Introduction Functions Limits The Derivative Trig Identities The Squeeze Theorem The Derivative of Sin(x) The Derivative of Cos(x) Other Derivatives A course by Graham Van Brunt P. Eng. Lead Instructor and Founder of PSPT RequirementsA basic knowledge of mathematics and trigonometry Audience Electrical Engineers Technologists Technicians Electrical Students Audience Electrical Engineers Technologists Technicians Electrical Students

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK alone, there are over 1.2 million job openings in the tech sector? And guess what? Coding skills are in high demand! But where do you even begin? This Coding Training Bundle is your one-stop shop to becoming a coding wizard, no matter your starting point. Our Coding (Computer Programming, Python & JavaScript) bundle equips you with the fundamental building blocks of coding, empowering you to build websites, automate tasks, and even create your own software. You'll master the fundamentals of web development with HTML, CSS, and JavaScript. Then, refine your knowledge of object-oriented programming with Python and C++, learning to build robust applications. Finally, solidify your understanding of JavaScript with a dedicated course. This Coding Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Introduction to Coding With HTML, CSS, & Javascript Course 03: Python Basic Programming for Absolute Beginners Course 02: C++ Programming for Absolute Beginners Course 04: JavaScript Fundamentals Don't miss out on this opportunity to become a tech-savvy professional and unlock your true potential. Enrol today in this Coding course and start coding your way to success! Learning Outcomes of Coding: Computer Programming (Python) Understand the basic building blocks of web development with HTML, CSS, and Javascript. Grasp core Python programming concepts like variables, data types, loops, and functions. Explore C++, a powerful language for game development and systems programming. Solidify your understanding of Javascript, a cornerstone of web and mobile app development. Gain the foundational knowledge to pursue further learning in various coding specializations. Develop the problem-solving and analytical skills crucial for a successful coding career. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Coding: Computer Programming (Python) Get a free student ID card with Coding: Computer Programming (Python) Training program (£10 postal charge will be applicable for international delivery) The Coding: Computer Programming (Python) is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Coding: Computer Programming (Python) course materials The Coding: Computer Programming (Python) comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Introduction to Coding With HTML, CSS, & Javascript Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design A Landing Page Project 2 - Business Website Project 3 - Portfolio Course 02: Python Basic Programming for Absolute Beginners Section 01: Introduction Section 02: Introduction To Python And Setting Up Section 03: PythonBasic Section 04: Python Strings Section 05: Python Operators Section 06: Python Sequences Section 07: Python Statements Section 08: Python Control Flow Statements Section 09: Python Games For Beginners Section 10: Python Functions Section 11: Working With File Structure Section 12: Regular Expressions Section 13: PythonProject Course 03: C++ Programming for Absolute Beginners Section 01: Getting Started With C++ Section 02: Setting Up Local Development Section 03: C++ Basics Section 04: C++ Data Types Section 05: C++ Operators Section 06: C++ Strings Section 07: C++ Decision Making Section 08: C++ Control Flow Loops Section 09: C++ Arrays Section 10: C++ Functions How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Tech enthusiasts Creative minds Problem solvers Future coders Career changers Requirements You will not need any prior background or expertise in this Coding bundle. Career path This Coding bundle will allow you to kickstart or take your career in the related sector to the next stage, such as: Web Developer Software Engineer Data Analyst Mobile App Developer Game Developer Freelancer Certificates CPD QS Accredited PDF Certificate Digital certificate - Included CPD QS Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

Medical Writing - Turning the language of medicine into narratives that heal and enlighten

Duration 2 Days 12 CPD hours This course is intended for Business Analysts, Technical Managers, and Programmers Overview This intensive training course helps students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice. Over the past few years, R has been steadily gaining popularity with business analysts, statisticians and data scientists as a tool of choice for conducting statistical analysis of data as well as supervised and unsupervised machine learning. What is R ? What is R? ? Positioning of R in the Data Science Space ? The Legal Aspects ? Microsoft R Open ? R Integrated Development Environments ? Running R ? Running RStudio ? Getting Help ? General Notes on R Commands and Statements ? Assignment Operators ? R Core Data Structures ? Assignment Example ? R Objects and Workspace ? Printing Objects ? Arithmetic Operators ? Logical Operators ? System Date and Time ? Operations ? User-defined Functions ? Control Statements ? Conditional Execution ? Repetitive Execution ? Repetitive execution ? Built-in Functions ? Summary Introduction to Functional Programming with R ? What is Functional Programming (FP)? ? Terminology: Higher-Order Functions ? A Short List of Languages that Support FP ? Functional Programming in R ? Vector and Matrix Arithmetic ? Vector Arithmetic Example ? More Examples of FP in R ? Summary Managing Your Environment ? Getting and Setting the Working Directory ? Getting the List of Files in a Directory ? The R Home Directory ? Executing External R commands ? Loading External Scripts in RStudio ? Listing Objects in Workspace ? Removing Objects in Workspace ? Saving Your Workspace in R ? Saving Your Workspace in RStudio ? Saving Your Workspace in R GUI ? Loading Your Workspace ? Diverting Output to a File ? Batch (Unattended) Processing ? Controlling Global Options ? Summary R Type System and Structures ? The R Data Types ? System Date and Time ? Formatting Date and Time ? Using the mode() Function ? R Data Structures ? What is the Type of My Data Structure? ? Creating Vectors ? Logical Vectors ? Character Vectors ? Factorization ? Multi-Mode Vectors ? The Length of the Vector ? Getting Vector Elements ? Lists ? A List with Element Names ? Extracting List Elements ? Adding to a List ? Matrix Data Structure ? Creating Matrices ? Creating Matrices with cbind() and rbind() ? Working with Data Frames ? Matrices vs Data Frames ? A Data Frame Sample ? Creating a Data Frame ? Accessing Data Cells ? Getting Info About a Data Frame ? Selecting Columns in Data Frames ? Selecting Rows in Data Frames ? Getting a Subset of a Data Frame ? Sorting (ordering) Data in Data Frames by Attribute(s) ? Editing Data Frames ? The str() Function ? Type Conversion (Coercion) ? The summary() Function ? Checking an Object's Type ? Summary Extending R ? The Base R Packages ? Loading Packages ? What is the Difference between Package and Library? ? Extending R ? The CRAN Web Site ? Extending R in R GUI ? Extending R in RStudio ? Installing and Removing Packages from Command-Line ? Summary Read-Write and Import-Export Operations in R ? Reading Data from a File into a Vector ? Example of Reading Data from a File into A Vector ? Writing Data to a File ? Example of Writing Data to a File ? Reading Data into A Data Frame ? Writing CSV Files ? Importing Data into R ? Exporting Data from R ? Summary Statistical Computing Features in R ? Statistical Computing Features ? Descriptive Statistics ? Basic Statistical Functions ? Examples of Using Basic Statistical Functions ? Non-uniformity of a Probability Distribution ? Writing Your Own skew and kurtosis Functions ? Generating Normally Distributed Random Numbers ? Generating Uniformly Distributed Random Numbers ? Using the summary() Function ? Math Functions Used in Data Analysis ? Examples of Using Math Functions ? Correlations ? Correlation Example ? Testing Correlation Coefficient for Significance ? The cor.test() Function ? The cor.test() Example ? Regression Analysis ? Types of Regression ? Simple Linear Regression Model ? Least-Squares Method (LSM) ? LSM Assumptions ? Fitting Linear Regression Models in R ? Example of Using lm() ? Confidence Intervals for Model Parameters ? Example of Using lm() with a Data Frame ? Regression Models in Excel ? Multiple Regression Analysis ? Summary Data Manipulation and Transformation in R ? Applying Functions to Matrices and Data Frames ? The apply() Function ? Using apply() ? Using apply() with a User-Defined Function ? apply() Variants ? Using tapply() ? Adding a Column to a Data Frame ? Dropping A Column in a Data Frame ? The attach() and detach() Functions ? Sampling ? Using sample() for Generating Labels ? Set Operations ? Example of Using Set Operations ? The dplyr Package ? Object Masking (Shadowing) Considerations ? Getting More Information on dplyr in RStudio ? The search() or searchpaths() Functions ? Handling Large Data Sets in R with the data.table Package ? The fread() and fwrite() functions from the data.table Package ? Using the Data Table Structure ? Summary Data Visualization in R ? Data Visualization ? Data Visualization in R ? The ggplot2 Data Visualization Package ? Creating Bar Plots in R ? Creating Horizontal Bar Plots ? Using barplot() with Matrices ? Using barplot() with Matrices Example ? Customizing Plots ? Histograms in R ? Building Histograms with hist() ? Example of using hist() ? Pie Charts in R ? Examples of using pie() ? Generic X-Y Plotting ? Examples of the plot() function ? Dot Plots in R ? Saving Your Work ? Supported Export Options ? Plots in RStudio ? Saving a Plot as an Image ? Summary Using R Efficiently ? Object Memory Allocation Considerations ? Garbage Collection ? Finding Out About Loaded Packages ? Using the conflicts() Function ? Getting Information About the Object Source Package with the pryr Package ? Using the where() Function from the pryr Package ? Timing Your Code ? Timing Your Code with system.time() ? Timing Your Code with System.time() ? Sleeping a Program ? Handling Large Data Sets in R with the data.table Package ? Passing System-Level Parameters to R ? Summary Lab Exercises Lab 1 - Getting Started with R Lab 2 - Learning the R Type System and Structures Lab 3 - Read and Write Operations in R Lab 4 - Data Import and Export in R Lab 5 - k-Nearest Neighbors Algorithm Lab 6 - Creating Your Own Statistical Functions Lab 7 - Simple Linear Regression Lab 8 - Monte-Carlo Simulation (Method) Lab 9 - Data Processing with R Lab 10 - Using R Graphics Package Lab 11 - Using R Efficiently

Harness the power of Microsoft SQL Server, the world's leading relational database management system, and gain valuable skills that are in high demand by employers.

Become a data scientist with the in-demand skills of Python, JavaScript, and Microsoft SQL. This comprehensive course will teach you the essential skills you need to succeed.

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.