43 Database Management Systems courses in London delivered Live Online

Duration 4 Days 24 CPD hours This course is intended for This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data. This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations. Prerequisites AZ-104T00 - Microsoft Azure Administrator Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model. Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods. Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information. Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI. 1 - Manage identities in Microsoft Entra ID Secure users in Microsoft Entra ID Secure groups in Microsoft Entra ID Recommend when to use external identities Secure external identities Implement Microsoft Entra Identity protection 2 - Manage authentication by using Microsoft Entra ID Configure Microsoft Entra Verified ID Implement multifactor authentication (MFA) Implement passwordless authentication Implement password protection Implement single sign-on (SSO) Integrate single sign-on (SSO) and identity providers Recommend and enforce modern authentication protocols 3 - Manage authorization by using Microsoft Entra ID Configure Azure role permissions for management groups, subscriptions, resource groups, and resources Assign built-in roles in Microsoft Entra ID Assign built-in roles in Azure Create and assign a custom role in Microsoft Entra ID Implement and manage Microsoft Entra Permissions Management Configure Microsoft Entra Privileged Identity Management Configure role management and access reviews by using Microsoft Entra Identity Governance Implement Conditional Access policies 4 - Manage application access in Microsoft Entra ID Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants Manage app registrations in Microsoft Entra ID Configure app registration permission scopes Manage app registration permission consent Manage and use service principals Manage managed identities for Azure resources Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication 5 - Plan and implement security for virtual networks Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs) Plan and implement User-Defined Routes (UDRs) Plan and implement Virtual Network peering or gateway Plan and implement Virtual Wide Area Network, including secured virtual hub Secure VPN connectivity, including point-to-site and site-to-site Implement encryption over ExpressRoute Configure firewall settings on PaaS resources Monitor network security by using Network Watcher, including NSG flow logging 6 - Plan and implement security for private access to Azure resources Plan and implement virtual network Service Endpoints Plan and implement Private Endpoints Plan and implement Private Link services Plan and implement network integration for Azure App Service and Azure Functions Plan and implement network security configurations for an App Service Environment (ASE) Plan and implement network security configurations for an Azure SQL Managed Instance 7 - Plan and implement security for public access to Azure resources Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies Plan and implement an Azure Application Gateway Plan and implement an Azure Front Door, including Content Delivery Network (CDN) Plan and implement a Web Application Firewall (WAF) Recommend when to use Azure DDoS Protection Standard 8 - Plan and implement advanced security for compute Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access Configure network isolation for Azure Kubernetes Service (AKS) Secure and monitor AKS Configure authentication for AKS Configure security for Azure Container Instances (ACIs) Configure security for Azure Container Apps (ACAs) Manage access to Azure Container Registry (ACR) Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption Recommend security configurations for Azure API Management 9 - Plan and implement security for storage Configure access control for storage accounts Manage life cycle for storage account access keys Select and configure an appropriate method for access to Azure Files Select and configure an appropriate method for access to Azure Blob Storage Select and configure an appropriate method for access to Azure Tables Select and configure an appropriate method for access to Azure Queues Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage Configure Bring your own key (BYOK) Enable double encryption at the Azure Storage infrastructure level 10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance Enable database authentication by using Microsoft Entra ID Enable and monitor database audit Identify use cases for the Microsoft Purview governance portal Implement data classification of sensitive information by using the Microsoft Purview governance portal Plan and implement dynamic mask Implement transparent data encryption? Recommend when to use Azure SQL Database Always Encrypted 11 - Plan, implement, and manage governance for security Create, assign, and interpret security policies and initiatives in Azure Policy Configure security settings by using Azure Blueprint Deploy secure infrastructures by using a landing zone Create and configure an Azure Key Vault Recommend when to use a dedicated Hardware Security Module (HSM) Configure access to Key Vault, including vault access policies and Azure Role Based Access Control Manage certificates, secrets, and keys Configure key rotation Configure backup and recovery of certificates, secrets, and keys 12 - Manage security posture by using Microsoft Defender for Cloud Implement Microsoft Defender for Cloud Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory Assess compliance against security frameworks and Microsoft Defender for Cloud Add industry and regulatory standards to Microsoft Defender for Cloud Add custom initiatives to Microsoft Defender for Cloud Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud Identify and monitor external assets by using Microsoft Defender External Attack Surface Management 13 - Configure and manage threat protection by using Microsoft Defender for Cloud Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS Configure Microsoft Defender for Servers Configure Microsoft Defender for Azure SQL Database Manage and respond to security alerts in Microsoft Defender for Cloud Configure workflow automation by using Microsoft Defender for Cloud Evaluate vulnerability scans from Microsoft Defender for Server 14 - Configure and manage security monitoring and automation solutions Monitor security events by using Azure Monitor Configure data connectors in Microsoft Sentinel Create and customize analytics rules in Microsoft Sentinel Configure automation in Microsoft Sentinel Additional course details: Nexus Humans AZ-500T00 Microsoft Azure Security Technologies 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 AZ-500T00 Microsoft Azure Security Technologies 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.

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

Course Overview This comprehensive course offers a deep dive into three essential technologies for data science: Python, JavaScript, and Microsoft SQL. Learners will gain foundational knowledge and practical skills in each of these key areas, which are crucial for handling data, creating interactive websites, and working with databases. By the end of the course, students will be proficient in writing Python code for data analysis, creating dynamic web content with JavaScript, and managing data with Microsoft SQL. The course is designed to equip learners with the technical skills needed to succeed in data science, making it a valuable investment for anyone looking to excel in this growing field. Course Description In this course, learners will explore the core principles of Python, JavaScript, and Microsoft SQL, all tailored to the needs of data science professionals. The curriculum covers Python’s data structures, functions, and libraries essential for data analysis, while JavaScript introduces students to web development skills, including client-side validation and data visualisation. The Microsoft SQL section focuses on data management, including filtering, joining, and structuring queries. Learners will develop a solid understanding of these technologies, which will enable them to manipulate data, automate processes, and design interactive applications. The course also includes real-world applications, ensuring learners are well-prepared for future opportunities in data science and web development. Course Modules: Module 01: JavaScript Getting Started Module 02: JavaScript Fundamentals Module 03: JavaScript Strings Module 04: JavaScript Operators Module 05: JavaScript Conditional Statements Module 06: JavaScript Control Flow Statements Module 07: JavaScript Functions Module 08: Data Visualization (Google Charts) Module 09: JavaScript Error Handling Module 10: JavaScript Client-Side Validations Module 11: Python Introduction Module 12: Python Basic Module 13: Python Strings Module 14: Python Operators Module 15: Python Data Structures Module 16: Python Conditional Statements Module 17: Python Control Flow Statements Module 18: Python Core Games Module 19: Python Functions Module 20: Python Args, KW Args for Data Science Module 21: Python Project Module 22: Publish Your Website for Live Module 23: MS SQL Statements Module 24: MS SQL Filtering Data Module 25: MS SQL Functions Module 26: MS SQL Joins Module 27: MS SQL Advanced Commands Module 28: MS SQL Structure and Keys Module 29: MS SQL Queries Module 30: MS SQL Structure Queries Module 31: MS SQL Constraints Module 32: MS SQL Backup and Restore (See full curriculum) Who is this course for? Individuals seeking to enhance their skills in data science. Professionals aiming to expand their knowledge in programming and database management. Beginners with an interest in Python, JavaScript, and SQL. Anyone looking to enter the field of data science or web development. Career Path Data Scientist Web Developer Database Administrator Data Analyst Front-End Developer Full Stack Developer Data Engineer

Start an IT Asset Department Course Overview This course provides a comprehensive introduction to starting and managing an IT Asset Department. Designed to equip learners with the knowledge required to establish and streamline IT asset management (ITAM) processes, it covers the key components and strategies for setting up the department, from understanding the department's purpose to maintaining accurate asset records. Learners will gain a solid understanding of the essential skills required to effectively manage IT assets, ensuring proper tracking, reporting, and operations. By the end of the course, learners will have a clear blueprint for setting up their own IT asset department, ready to implement best practices and improve operational efficiency. Course Description The course delves into the fundamental aspects of starting an IT Asset Department, starting with an overview of the department’s critical role within an organisation. Learners will explore the various functions and responsibilities of the IT Asset Management (ITAM) team, the tools needed to track assets, and how to populate and manage a central database. The course will also cover daily operations, including generating reports and ensuring compliance with industry standards. Learners will leave with the skills necessary to build a structured IT asset management department that can oversee asset tracking, database management, and reporting, ensuring better decision-making and efficiency in the management of IT resources. Start an IT Asset Department Curriculum Module 01: Introduction to the Course Module 02: The Missing Department Module 03: ITAM Team and Activities Module 04: Asset Tracking Tool Module 05: Populating the Database Module 06: Daily Operations and Reports Module 07: Was it a Boring Job? (See full curriculum) Who is this course for? Individuals seeking to develop skills in IT asset management. Professionals aiming to establish or optimise an IT asset management department. Beginners with an interest in IT operations and resource management. Managers looking to improve efficiency in IT asset tracking. Career Path IT Asset Manager IT Operations Specialist IT Procurement Manager Asset Tracking Coordinator IT Project Manager

Functional Skills - IT Course Overview: The "Functional Skills - IT" course is designed to provide learners with a comprehensive understanding of essential IT concepts and skills. It covers a wide range of topics, from the basic components of information technology to more advanced areas such as networking, security, and cloud computing. This course is ideal for individuals seeking to enhance their IT skills for personal or professional development. Learners will gain a strong foundation in IT principles, which will support them in various workplace environments and allow them to apply their knowledge to real-world scenarios. Course Description: This course covers fundamental IT concepts, including the core components of information technology, hardware, software applications, and operating systems. Learners will explore topics such as networking, security, database management, and virtualisation. The course also includes an in-depth look at enterprise-level IT systems, traffic flow, and storage solutions. By the end of the course, learners will have a solid understanding of how IT systems are designed, implemented, and managed. They will gain the skills necessary to work effectively in diverse IT roles, enabling them to confidently support organisational IT needs. Functional Skills - IT Curriculum: Module 01: Introduction Module 02: Information Technology Module 03: Components of IT Module 04: Hardware Module 05: Operating System Module 06: Application/Software Module 07: Networking Module 08: Security Module 09: Traffic Flow & Enterprise Level IT Components Module 10: Storage Module 11: Database Module 12: Virtualisation & Cloud Module 13: Management & Other IT Jobs (See full curriculum) Who is this course for? Individuals seeking to develop a strong understanding of IT principles. Professionals aiming to enhance their technical skills for career progression. Beginners with an interest in information technology and related fields. Those looking to pursue a career in IT management, networking, or support roles. Career Path IT Support Technician Network Administrator Systems Analyst IT Manager Cloud Solutions Specialist Database Administrator IT Consultant Cybersecurity Specialist

IT for Dummies Course Overview This course, IT for Dummies, provides a straightforward introduction to the fundamental concepts of information technology. Designed for beginners and those with limited prior knowledge, it covers a broad range of essential topics including hardware, software, networking, security, and cloud technologies. Learners will develop a clear understanding of how IT systems operate, how different components interact, and the key principles that underpin modern digital environments. By the end of the course, participants will be equipped with foundational IT knowledge that supports both personal and professional development, enabling confident navigation of common IT tasks and providing a stepping stone to more advanced studies or career progression in the technology sector. Course Description IT for Dummies offers a comprehensive exploration of the core elements of information technology in a clear and accessible format. The course covers the basics of IT infrastructure, including hardware components, operating systems, software applications, and network configurations. Learners will also gain insight into IT security measures, data storage solutions, database management, and emerging trends such as virtualisation and cloud computing. Through structured lessons, participants will develop a broad skill set that enhances their understanding of IT environments and prepares them for various roles in the sector. This course is structured to build confidence and competence in IT concepts, suitable for those starting their journey in the technology field or seeking to broaden their digital literacy. IT for Dummies Curriculum: Module 01: Introduction Module 02: Information Technology Module 03: Components of IT Module 04: Hardware Module 05: Operating System Module 06: Application/Software Module 07: Networking Module 08: Security Module 09: Traffic Flow & Enterprise Level IT Components Module 10: Storage Module 11: Database Module 12: Virtualisation & Cloud Module 13: Management & Other IT Jobs (See full curriculum) Who is this course for? Individuals seeking to understand fundamental IT concepts. Professionals aiming to enhance their digital knowledge for career growth. Beginners with an interest in technology and computing. Those preparing for further IT qualifications or certifications. Career Path IT Support Technician Network Administrator Systems Analyst Database Administrator Cloud Services Coordinator Junior IT Manager Technical Assistant in various industries

PHP and MySQL Training Masterclass 2023 Course Overview This PHP and MySQL Training Masterclass 2023 offers a comprehensive guide to mastering dynamic web development using PHP and MySQL. Learners will explore essential programming concepts, database integration, and application building through progressive projects designed to enhance their coding capabilities. The course covers core skills such as user authentication, comment systems, ratings, and interactive applications, equipping students with the confidence to develop fully functional web solutions. By the end, participants will have the knowledge to build, customise, and manage robust web applications, boosting their employability and technical proficiency in today’s digital marketplace. Course Description This masterclass delves into key aspects of PHP programming and MySQL database management, providing learners with a structured learning experience. Starting with installation and configuration, it progresses through multiple project-based modules focusing on real-world applications such as authentication systems, comment and rating features, weather apps, and live search functionality. Each module deepens understanding of server-side scripting and database queries, enhancing problem-solving and coding fluency. Participants will gain expertise in integrating PHP scripts with MySQL databases, optimising application performance, and managing data securely. The course is designed to develop both foundational and advanced skills essential for web development careers, delivered in clear, concise UK English. PHP and MySQL Training Masterclass 2023 Curriculum Module 01: Introduction Module 02: Installation Module 03: First Project: Building an Authentication System Module 04: Second Project: Building a Comments System Module 05: Third Project: Creating a Rating System Module 06: Fourth Project: Creating a Weather App Module 07: Fifth Project: Build a Cool Like and Dislike System Module 08: Sixth Project: Building a Simple CV Builder Module 09: Seventh Project: QR Codes Generator Module 10: Eighth Project: Build a Full Live Search System (See full curriculum) Who Is This Course For? Individuals seeking to develop skills in dynamic web development. Professionals aiming to enhance their web programming career. Beginners with an interest in server-side scripting and databases. Web developers wanting to expand their expertise in PHP and MySQL. Career Path Web Developer Backend Developer PHP Developer Database Administrator Full-Stack Developer Software Engineer Digital Solutions Specialist

Diploma in Python Programming Course Overview The Diploma in Python Programming offers an in-depth exploration of Python, one of the most versatile and in-demand programming languages. This course is designed to provide learners with a strong foundation in Python, covering essential concepts such as data structures, functions, libraries, and file handling. Learners will gain the skills necessary to write Python code to solve real-world problems, enabling them to create applications, automate tasks, and perform data analysis. By the end of the course, learners will have the practical knowledge to use Python effectively for various programming tasks in both professional and personal settings. Course Description This comprehensive course begins with the basics of Python programming, guiding learners through essential concepts such as syntax, data types, and conditional statements. Learners will progress to more advanced topics, including file handling, data storage structures, and error handling. Key modules like the creation of user functions, working with external libraries, and implementing Python in database management provide valuable skills that can be directly applied in the workplace. This course also covers essential tools such as command prompt usage, Jupyter notebooks, and package management in Python. By the end of the course, learners will have developed the confidence and competence to apply Python across various domains, including software development, data analysis, and system automation. Diploma in Python Programming Curriculum Module 01: Introduction to Python Programming Module 02: Getting Started with Python Module 03: Conditional Branching with Python Module 04: Importing External/Internal Library in Python Module 05: Project Rock Paper and Scissors Module 06: Strings Operation in Python Module 07: Date and Time in Python Module 08: File Handling, Read and Write Using Python Module 09: Data Storage Structures: Tuple, List, and Dictionary Module 10: Writing User Functions in Python Module 11: Sending Mail Module 12: Import Tricks in Python Module 13: Import Operating System and Platform Module 14: Exceptions Handling in Python Module 15: Installing Packages and Scheduling in Python Module 16: Database in Python Using SQLite Module 17: Running Programs from Command Prompt and Jupyter Notebook Module 18: Conclusion (See full curriculum) Who is this course for? Individuals seeking to develop a foundational understanding of Python programming. Professionals aiming to enhance their programming skills for career advancement. Beginners with an interest in software development, data analysis, or automation. Anyone looking to pursue a career in programming or technology. Career Path Software Developer Data Analyst Automation Engineer Python Programmer Database Administrator IT Specialist

SQL for Data Science, Data Analytics and Data Visualization Course Overview: This course offers a comprehensive introduction to SQL, designed for those looking to enhance their skills in data science, data analytics, and data visualisation. Learners will develop the ability to work with SQL databases, efficiently query and manage data, and apply these techniques for data analysis in both SQL Server and Azure Data Studio. By mastering SQL statements, aggregation, filtering, and advanced commands, learners will be equipped with the technical skills required to manage large datasets and extract meaningful insights. The course provides a solid foundation in data structures, user management, and working with multiple tables, culminating in the ability to perform complex data analysis and visualisation tasks. Course Description: This course covers a broad range of topics essential for anyone working with data in a professional capacity. From setting up SQL servers to mastering database management tools like SQL Server Management Studio (SSMS) and SQL Azure Data Studio, the course provides a thorough grounding in SQL. Learners will gain expertise in data structure statements, filtering data, and applying aggregate functions, as well as building complex SQL queries for data analysis. The course also includes instruction on SQL user management, group by statements, and JOINs for multi-table analysis. Key topics such as SQL constraints, views, stored procedures, and database backup and restore are also explored. The course incorporates SQL visualisation tools in Azure Data Studio, empowering learners to visualise data effectively. By the end of the course, learners will be proficient in SQL queries, data manipulation, and using Azure for data analysis. SQL for Data Science, Data Analytics and Data Visualization Curriculum: Module 01: Getting Started Module 02: SQL Server Setting Up Module 03: SQL Azure Data Studio Module 04: SQL Database Basic SSMS Module 05: SQL Statements for DATA Module 06: SQL Data Structure Statements Module 07: SQL User Management Module 08: SQL Statement Basic Module 09: Filtering Data Rows Module 10: Aggregate Functions Module 11: SQL Query Statements Module 12: SQL Group By Statement Module 13: JOINS for Multiple Table Data Analysis Module 14: SQL Constraints Module 15: Views Module 16: Advanced SQL Commands Module 17: SQL Stored Procedures Module 18: Azure Data Studio Visualisation Module 19: Azure Studio SQL for Data Analysis Module 20: Import & Export Data Module 21: Backup and Restore Database (See full curriculum) Who is this course for? Individuals seeking to enhance their data management and analysis skills. Professionals aiming to progress in data science, data analytics, or database administration. Beginners with an interest in data analysis and SQL databases. Anyone looking to gain expertise in SQL for Azure and SQL Server environments. Career Path: Data Analyst Data Scientist Database Administrator SQL Developer Business Intelligence Analyst Data Visualisation Specialist

Duration 2 Days 12 CPD hours This course is intended for The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized. The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies. Overview Understand Data Platform Modernization Choose the right tools for Data Migration Migrate SQL Workloads to Azure Virtual Machines Migrate SQL Workloads to Azure SQL Databases Migrate SQL Workloads to Azure SQL Database Managed Instance In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure. Introducing Data Platform Modernization Understand Data Platform Modernization Understanding the stages of migration Data Migration Paths Choose the right tools for Data Migration Discover the Database Migration Guide Build your data estate inventory using Map Toolkit Identify Migration candidates using Data Migration Assistant Evaluate a Data workload using Database Experimentation Assistant Data Migration using Azure Database Migration Service Migrate non-SQL Server workloads to Azure using SQL Migration Assistant Migrating SQL Workloads to Azure Virtual Machines Considerations of SQL Server to Azure VM Migrations SQL Workloads to Azure VM Migration Options Implementing High Availability and Disaster Recovery Scenarios Migrate SQL Workloads to Azure SQL Databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL DB offline Migrate SQL Server to Azure SQL DB online Load and Move data to Azure SQL Database Migrate SQL Workloads to Azure SQL Database Managed Instance Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed instance Load and Move data to SQL Database Managed instance Application Configuration and Optimization