This Free Online Course Includes: 3-4 Hours of Learning CPD Accreditation Final Assessment

This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment

This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment

This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment

Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It's important to understand how performance tuning works and how you can assess performance metrics.

Learn about connection handling in MySQL, back up and restore, and the client interface options available for MySQL.

PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.

Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.

Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.

The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.

Learn about and use the Intelligent Query Processing feature enhancements in SQL Server 2022.

Learn about MySQL's pluggable storage engine model, common storage engines, and storage engines supported by Azure Database for MySQL.