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 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Are you looking to kickstart a career in the UK property market or looking to expand your knowledge of residential lettings and real estate investment? Our Residential Lettings Diploma course is the perfect choice for you! This comprehensive online training package includes 11 courses, each designed to provide you with an in-depth understanding of the UK property market. The first course is QLS-endorsed, which means you will receive a QLS hardcopy certificate for free upon completion. This certificate is highly respected in the UK property market and will give you a competitive edge when applying for jobs. The remaining 10 courses are CPD-QS accredited, providing you with valuable Continuing Professional Development (CPD) points. Throughout the course, you will learn how to manage rental properties, handle sales, negotiate contracts, and more. You will also develop essential interpersonal skills and learn how to provide excellent customer service, which is crucial in the property market. This online and self-paced course gives you the flexibility to study at your own pace. Enrol now and gain the skills and knowledge you need to succeed in the UK property market! This Residential Lettings Diploma Bundle Package includes: Course 01: Diploma in Residential Lettings at QLS Level 4 10 Premium Additional CPD QS Accredited Courses - Course 01: Residential Property Sales Course 02: Diploma in Basic Real Estate Agents Training at QLS Level 5 Course 03: Real Estate Investor Training Course 04: UK Property Development & Law Course Course 05: Contracts Law UK Course 06: Diploma in Construction Industry Scheme (CIS) Course 07: Letting Agent & Property Management Training Course 08: Negotiation Skills Certificate Course 09: Level 3 Diploma in Customer Service Course 10: Developing Interpersonal Skills Course Why Prefer This Residential Lettings Diploma Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Residential Lettings Diploma bundle courses, you will be able to learn: By completing the Residential Lettings Diploma, you will be able to: Understand the UK property market and its legal framework Manage residential rental properties effectively Handle residential property sales from start to finish Develop essential negotiation and customer service skills Navigate the Construction Industry Scheme (CIS) and understand its implications for property development Understand contracts law in the UK Develop skills to become a successful property investor ***Curriculum breakdown of Residential Lettings Diploma*** Module 01: A Look Inside a Letting Agency Module 02: Keeping Tenants Long Term Module 03: Legal Requirements for Letting Agents Module 04: Listing Properties and Marketing Module 05: Operating Cost Module 06: The Letting Process and Tenancy Agreement Module 07: The Property Management Process How is the Residential Lettings Diploma Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Residential Lettings Diploma is perfect for anyone who wants to gain a deeper understanding of the UK property market. It is especially suitable for: People looking to start a career in property management or real estate investment Property owners who want to manage their own rental properties Property agents who want to expand their knowledge and skills Anyone interested in the UK property market and its legal framework Professionals who want to develop their negotiation and customer service skills Career path This bundle will give you an edge in various professions such as: Residential Letting Agent - £22,000 - £30,000 Real Estate Sales Agent - £18,000 - £35,000 Property Manager - £20,000 - £40,000 Real Estate Investor - £25,000 - £75,000 Construction Project Manager - £40,000 - £70,000 Customer Service Manager - £25,000 - £45,000 Contract Manager - £30,000 - £50,000 Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Residential Lettings at QLS Level 4 Hard copy certificate - Included
About this Virtual Instructor Led Training (VILT) Electrification of the transportation sector will impact the power system in several ways. Besides the additional load, local impact on the grid needs to be managed by the grid operators. Simultaneously charging of many electric vehicles (EVs) might exceed the limits in specific locations. On the other hand, EVs can provide flexibility and other ancillary services that will help grid operators. This 3 half-day VILT course will provide a complete overview of integrating electric vehicles (EVs) into the power grid. It will cover the whole value chain from grid operations to the car battery. This includes the control room, possible grid reinforcement, demand side management and power electronics. This course will demonstrate the impact on the grid and solutions for a safe & cost-effective grid plan and operation, with examples of successful integration of EVs. The course will also provide vital knowledge about technology used for EVs such as power electronics, demand side management, communication and batteries. In this context, the focus will be on power electronics as it has the highest impact on the grid. The grid planning tool, pandapower, is introduced as an open source tool for power system modelling. The set-up of the training course allows for discussion and questions. Questions can be formulated by the participants upfront or during the training. This course is delivered in partnership with Fraunhofer IEE. Training Objectives At the end of this course, the participants will: Understand the charging options for EVs and its impact on the grid and batteries Identify system services for EVs with regards to voltage quality at the point of common coupling Discover what are the 'grid friendly' and grid supporting functions in EVs Uncover the different applications, standards and data researched on EVs Examine the application of a grid planning tool (pandapower) for power system modelling Be able to develop code snippets with pandapower Apply and execute a code example for power system modelling with pandapower Target Audience EV and grid project developers and administrators Power grid operators and planners EPC organisations involved in grid development EV/ battery manufacturers and designers EV transport planners and designers Government regulators and policy makers Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes breaks per day, including time for lectures, discussion, quizzes and short interactive exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end of every session/day. Trainer Our first course expert is Head of Department Converters and Electrical Drive Systems at Fraunhofer IEE and Professor for Electromobility and Electrical Infrastructure at Bonn-Rhein-Sieg University of Applied Sciences. He received his engineering degree in automation in 2008 by the THM Technische Hochschule Mittelhessen (FH Giessen-Friedberg). Afterwards he studied power engineering at University of Kassel and received his diploma certificate in 2010. In 2016 he received the Ph.D. (Dr.-Ing.) from the University of Hannover. The title of his dissertation is Optimized multifunctional bi-directional charger for electric vehicles. He has been a researcher at the Fraunhofer IEE in Kassel since 2010 and deals with power converters for electric vehicles, photovoltaics and wind energy. His current research interests include the bidirectional inductive power transfer, battery charger and inverter as well as new power electronic components such as SiC MOSFETs and chokes. Additionally, our key expert is Chairman of the IEEE Joint IAS/PELS/IES German Chapter and a member of the International Scientific Committee of the EPE Association. Our second course expert is deputy head of energy storage department at Fraunhofer IEE. Prior to this he was the Director of Grid Integration department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, our course expert was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a degree of electrical engineering of the University of Kassel, Germany. In 2003 he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the 'Institute of Solar Energy Supply Technology' (now Fraunhofer IEE) in Kassel. In 2004 he started his career at RWE TSO with main focus on wind power integration and congestion management. Our course expert is chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Our third course expert is Research Associate at Fraunhofer IEE. He is actively working on different projects related to the integration of electric vehicle charging into the electric distribution grid. The focus of this work concerns time series based simulations for grid planning and operation in order to investigate the effect of a future rollout of electric vehicles and charging infrastructure on economics e.g. costs for grid reinforcement. He completed his master degree (MSc.) in Business Administration and Engineering: Electrical Power Engineering at RWTH Aachen University, Germany. Our trainers are experts from Fraunhofer Institute for Energy Economics and Energy System Technology (Fraunhofer, IEE), Germany. The Fraunhofer IEE researches for the national and international transformation of energy supply systems 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
This course aims to prepare the learner to plan and contribute to human resource management planning. The learner will be able to appreciate different dynamics and challenges in the planning of human resource management. After the successful completion of this lecture, you will be able to understand the following: Human Resource Planning. Human Resource Functionalities. Human Resource Planning Length. Costs and Benefits of Business. Empowerment and Talent Management. The course aims to provide the learner with a fundamental understanding of the Human Resource Plan. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Fundamentals Of Human Resource Plan QUIZ: Fundamentals Of Human Resource Plan Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. 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. CEO, Director, Manager, Supervisor Strategy Specialist Human Resource Manager Training Manager Talent Manager People Development Specialist Learning and Development Manager Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
Level 5 QLS Diploma | QLS Certificate Included | 10 CPD Courses & PDF Certificates | 145 CPD Points | Lifetime Access
Discover the power of human resources with our Introduction to Modern Human Resource Management course. From people resourcing to performance management, conflict resolution, and health and safety management, you'll learn essential skills to succeed in this fast-paced industry. If you're looking to break into the world of human resources, our Introduction to Modern Human Resource Management course is the perfect place to start. Through six comprehensive modules, you'll gain essential knowledge and skills in key areas such as people resourcing, performance management, conflict resolution, and health and safety management. Human resources is a dynamic and ever-evolving industry that offers a wide range of exciting opportunities for individuals looking to advance their careers. From recruitment and employee relations to learning and development, compensation and benefits, and more, the HR industry is full of diverse and rewarding roles that can lead to a successful and fulfilling career. Learning Outcomes: Understand the fundamentals of human resource management Analyse strategic human resource management practices Learn techniques for people resourcing Develop skills in performance management Master conflict resolution methods Gain knowledge in health and safety management Are you interested in a career in human resources? Our Introduction to Modern Human Resource Management course is designed to equip you with the skills and knowledge necessary to excel in this dynamic industry. Through these comprehensive modules, you'll learn about the fundamentals of HR management, strategic practices, people resourcing, performance management, conflict resolution, and health and safety management. Our course is perfect for anyone looking to break into the world of human resources or for those who want to refresh their knowledge of current practices. With no prior experience required, this course is ideal for beginners and seasoned professionals alike. At the end of the course, you'll have the knowledge and confidence to advance your career in the HR industry, from recruitment to employee relations, with the potential to earn a salary between £20,000 to £70,000 per annum in the UK. Don't miss out on this opportunity to advance your career in HR. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Those interested in a career in human resources Those who want to refresh their knowledge of current practices Those who want to gain skills in people management Beginners and seasoned professionals alike Career path Recruitment Coordinator: £20,000 - £25,000 per annum Human Resources Assistant: £22,000 - £28,000 per annum Employee Relations Advisor: £25,000 - £40,000 per annum Human Resources Manager: £35,000 - £50,000 per annum HR Business Partner: £40,000 - £60,000 per annum Head of Human Resources: £50,000 - £70,000 per annum
This course embarks on a journey through advanced strategies in Customer Relationship Management (CRM), exploring pivotal concepts and methods essential for effective implementation. Upon successful completion, participants will gain proficiency in the following areas: Explore CRM models driving loyalty and engagement to shape successful customer relationships. Delve into managing interactions, fostering enduring relationships via empathetic communication and issue resolution. Uncover the customer lifecycle stages, gaining insights into navigation and optimization from awareness to loyalty. Explore CLV's (Customer Lifetime Value) importance, its calculation, and leveraging for strategic business decisions. This course delves into advanced CRM strategies, including diverse models fostering loyalty and engagement. It covers managing interactions, navigating customer lifecycles, and leveraging Customer Lifetime Value (CLV) for strategic decision-making. This course delves deeply into CRM strategies, including advanced models, customer interaction management, and customer lifecycle value, aiming to equip professionals with vital skills for business success. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Exploring Advanced Strategies in Customer Relationship Management (CRM) Self-paced pre-recorded learning content on this topic. Exploring Advanced Strategies In Customer Relationship Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. 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 get updated on current ideas in their respective field. We recommend this certificate for the following audience. CRM Manager Relationship Marketing Manager Customer Experience Manager Sales Operations Manager Customer Retention Specialist Business Development Manager Account Manager Customer Success Manager CRM Implementation Consultant Marketing Automation Specialist Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
10 QLS Endorsed Courses for Stock Trader | 10 Endorsed Certificates Included | Life Time Access
"You have to see failure as the beginning and the middle, but never entertain it as an end"
3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support