Lift and shift your SSIS Packages to the cloud. In this course, you will learn the benefits of cloud migration and how to run, schedule, secure and monitor your SSIS Packages with Azure Data Factory v2.

This course covers different ways to alter document data in Couchbase using the N1QL query language. It explores the queries used to add new data, modify existing data, and remove unwanted documents.

The structure of document-oriented databases, such as MongoDB, introduce benefits and challenges when working with data. This course explores the create, update, and delete portion of CRUD from the perspective of a MongoDB administrator or developer.

This course will teach you you the essential skills and tools required to manage MongoDB effectively. It covers MongoDB administration tools, syntax, and management principles addressing everything from installation to configuration, backups, monitoring, scaling out, security, and performance tuning.

This course covers different ways to monitor a Couchbase cluster - from gathering diagnostic data from logs and real-time statistics, to the analysis of running and completed N1QL queries. These are performed using the Couchbase UI, CLI and REST API.

In this course, you'll learn essential concepts and practical techniques to effectively adminstrate MySQL databases, including performance tuning, security, query optimization, partitioning, and high availability architectures.

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

This course focuses on Query Optimization and Performance Tuning of MySQL.

This course focuses on the MySQL Workbench Integrated Development Environment.

Learn the new architecture and management features of the Oracle 12c database. Learn the new Oracle 12c topics that are covered in the Oracle certification upgrade test 1Z0-060.

This course looks into the various factors affecting the performance of N1QL queries and the options available in Couchbase to optimize their executions. This covers topics such as the Couchbase architecture, indexes, and data replication.

Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.