220 Database Management courses delivered Online

In today's competitive business environment, effective customer relationship management (CRM) is a must. This CPD Accredited CRM Course provides a solid understanding of the strategies and tools used to manage customer interactions and drive business growth. Designed to provide you with a thorough grounding in CRM principles, this course equips you with the knowledge needed to build strong customer connections, enhance loyalty, and improve overall business performance. Whether you're an aspiring marketer or looking to expand your skill set in the customer service realm, this course will give you the critical insights to handle customer relationships with confidence. The course content covers a wide range of topics including CRM strategy, customer segmentation, database management, and the role of technology in enhancing customer engagement. Delivered entirely online, it allows you to learn at your own pace while building up essential CRM expertise. By the end of the course, you’ll have a comprehensive understanding of the CRM landscape, along with the tools to implement successful strategies within your organisation, enhancing customer satisfaction and retention. This course provides the flexibility to improve your knowledge base from anywhere, with no need for physical attendance—ideal for busy professionals. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The CRM - Customer Relationship Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our CRM - Customer Relationship Management - CPD Accredited training.

This comprehensive course dives deep into Oracle database RAC administration, spanning 12c and 19c versions. Gain practical skills in architecture, installation, tuning, upgrading, mastering backup, recovery, dynamic services, load balancing, patching, Flex Clusters, and more. Discover advanced techniques through hands-on practice videos.

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.

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

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

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