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.
The Simplest Guide⢠to Advanced SAS Programming | Macros | SQL is an accelerated path to learning advanced SAS programming taught in a simple, visual, and immersive style. If you already know SAS, this course will equip you with skills to reveal amazing insights within your data, while helping you prepare for advanced SAS certification exams.
SEN Teacher Training - Special Educational Needs Are you ready to significantly impact the lives of students with special educational needs? Our SEN Teacher Training - Special Educational Needs course offers a comprehensive exploration of critical topics essential for Special Needs Education Teachers. This course is your path to becoming an influential and dedicated educator in special education. As the SEN Teacher Training - Special Educational Needs course begins, you will gain a deep understanding of the legal framework and regulations that govern special education. Besides, you will acquire the skills to analyse how different disabilities and conditions impact the students' participation, engagement, and academic performance. Moreover, this SEN Teacher Training - Special Educational Needs course will assist you in developing leadership skills that are essential for making a difference in the lives of students with SEN. One of the foundations of excellent SEN teaching is understanding how disabilities and conditions affect participation and learning. We break down the learning profiles of SEN conditions like dyslexia, ADHD, and autism spectrum disorder so that you can understand your students' specific problems. With this knowledge, you can develop targeted strategies to unlock each student's potential. In this SEN Teacher Training - Special Educational Needs course, you will learn step-by-step methods for assessment, individualised education plans, differentiation, and evidence-based techniques to enhance learning and engagement. You will also explore the roles and functions contributing to successful support for students with special needs. Enrol now in the SEN Teacher Training - Special Educational Needs course and gain the knowledge to help every child thrive in an academically, socially, and emotionally supportive environment. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. SEN Teacher Training - Special Educational Needs Module 1: Special Needs Education Teacher Special Educational Needs (SEN) Teacher 00:11:00 Module 2: Statutory and Regulatory Context for SEN Statutory and Regulatory Context for SEN 01:02:00 Module 3: Principles and Practice of Leadership in Different Contexts Principles and Practice of Leadership in Different Contexts 00:33:00 Module 4: How SEN and Disabilities Affect Pupils' Participation and Learning How SEN and Disabilities Affect Participation and Learning 00:31:00 Module 5: Strategies for Improving the Performance of the Pupils with SEN Strategies for Improving the Performance of the Pupils with SEN 00:18:00 Module 6: Whole-School Planning and Organisation Whole-school Planning and Organisation 01:04:00 Module 7: Assessment Assessment 00:14:00 Module 8: Teamwork for SEN: Roles and Functions Teamwork for SEN Roles and Functions 01:05:00 Module 9: Planning for Individual Students with SEN Planning for Individual Students with SEN 00:22:00 Module 10: Teaching and Learning in the Inclusive School Teaching and Learning in the Inclusive School 00:40:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Event Management - Party Planner Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Event Management - Party Planner Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Event Management - Party Planner Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Event Management - Party Planner Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Event Management - Party Planner? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Event Management - Party Planner there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Event Management - Party Planner course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Event Management - Party Planner does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Event Management - Party Planner was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Event Management - Party Planner is a great way for you to gain multiple skills from the comfort of your home. Module 01: Introduction to Party Planner Introduction to Party Planner 00:12:00 Module 02: Types of Parties - Overview Types of Parties - Overview 00:16:00 Module 03: Skills You Need to Be a Party Planner Skills You Need to Be a Party Planner 00:15:00 Module 04: Starting Your Party Planning Business Starting Your Party Planning Business 00:13:00 Module 05: Party Planning Business Functions Party Planning Business Functions 00:18:00 Module 06: Initial Planning & Budgeting Initial Planning & Budgeting 00:21:00 Module 07: Guest Demographics Guest Demographics 00:13:00 Module 08: Choosing a Theme Choosing a Theme 00:17:00 Module 09: Venue Requirements Venue Requirements 00:16:00 Module 10: Food and Beverage Food and Beverage 00:13:00 Module 11: Vendors Every Party Planner Should Know Vendors Every Party Planner Should Know 00:19:00 Module 12: Generating a Client Base Generating a Client Base 00:23:00 Module 13: Networking Networking 00:18:00 Module 14: Making the Party Memorable Making the Party Memorable 00:24:00 Assignment Assignment - Event Management - Party Planner 07:01:00
Unlock the full potential of Excel with our Spreadsheet Training Course. From basic functions to advanced techniques, learn how to navigate and utilize Excel effectively for data analysis, reporting, and organization. Whether you're a beginner or looking to enhance your skills, this course provides hands-on training to help you become proficient in Excel. Enroll now and excel in spreadsheet management, boosting your productivity and efficiency in any professional setting.
Course Overview Gain complete proficiency in the world's most popular and evolving front-end framework, with step-by-step guidance from the experts. The Learn Bootstrap 4 Responsive Web Development course is designed for those looking to take their coding and programming knowledge to the next level. It will take you through all the features and functions of Bootstrap 4 in detail, equipping you with the skills to create high-quality responsive websites from scratch. Through eight easy to follow audiovisual training modules, you will learn all about the Bootstrap language and the format of coding applications. Become a Bootstrap expert in no time and learn in-demand skills to take your career to the next level, by gaining an industry-recognised certificate. This best selling Learn Bootstrap 4 Responsive Web Development has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Learn Bootstrap 4 Responsive Web Development is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Learn Bootstrap 4 Responsive Web Development is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Learn Bootstrap 4 Responsive Web Development is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Learn Bootstrap 4 Responsive Web Development, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Learn Bootstrap 4 Responsive Web Development will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Learn Bootstrap 4 Responsive Web Development to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
Course Overview Discover how to make images come to life and use them to make projects stand out from the crowd with this 2D Animation: Adobe Animate course. During the coaching, you will be given a masterclass on this incredibly popular online application, which is well-known in the professional industry for creating components of video games, films, and company websites. This Adobe Animate tutorial enables you to quickly learn the benefits and functions of this benchmark software. Starting from the basics, you will soon be proficient in digital drawing, character moving and imagery impact. Everything you need to create a unique and functional design for your future productions can be found here, and all are supported by expert guidance and simple instructions. Enrol now and take your animating abilities to new levels of excellence and potential. This best selling 2D Animation: Adobe Animate has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth 2D Animation: Adobe Animate is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The 2D Animation: Adobe Animate is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The 2D Animation: Adobe Animate is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the 2D Animation: Adobe Animate, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the 2D Animation: Adobe Animate will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the 2D Animation: Adobe Animate to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
Course Overview Access the database and set of services that will put you in touch with the network resources that will get your work completed with this training for Windows Active Directory. The AD is a directory service developed explicitly by Microsoft for Windows domain networks, and knowledge of it is crucial for those working in Network or Security Administration. With this total learning package, you can gain all the skills and techniques for utilising AD to make your IT life more straightforward. This Active Directory (AD) course provides a valuable introduction to the foundations of the Active Directory Domain Services and their support functions. You will be taught multifunctional competencies with them, from installing and configuring to maintenance and management. A masterclass will also be given for using AD certificate services and managing group policies. Ensure that your knowledge of Windows is complete by taking this comprehensive coaching now. This best selling Active Directory has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Active Directory is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Active Directory is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Active Directory is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Active Directory, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Active Directory will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Active Directory to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
Level 7 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited