Data Engineering
Showing 553–564 of 829 results
Optimize Enterprise-scale Data Models – DP-500
This course will teach you how to design optimal enterprise-scale data models to support efficient business decision-making.
Optimize N1QL Queries
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.
Optimize performance with Spark and Delta Live Tables
Learn how to Optimize performance with Spark and Delta Live Tables in Azure Databricks.
Optimize vacuum in Azure Database for PostgreSQL
Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.
Optimizing Apache Spark on Databricks
This course will teach you how to optimize the performance of Spark clusters on Azure Databricks by identifying and mitigating various issues such as data ingestion problems and performance bottlenecks
Optimizing Query Performance with Columnstore Indexes
Have you considered creating columnstore indexes to defeat slow queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in today's busy database environment.
Optimizing SQL Queries in Oracle
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
Optimizing SQL Server Procedures: Best Practices and Performance
Manipulating the data from SQL Server is something that every data professional should know. However, manipulating the SQL Server data by using stored procedures in an efficient and performant way is a mastery on its own!
Oracle 12.2 Upgrade
Oracle is the most widely-used relational database in the world. This course will teach you how to evaluate the database for issues that might interfere with the upgrade, and methods to migrate your database in complex environments.
Oracle Database 12c Disaster Recovery and Data Movement
This course will give you the skills you need to perform backup and recovery for Oracle Database 12c under Microsoft Windows and Oracle Linux. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam in Oracle Database 12c.
Oracle Database 12c Fundamentals
This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam.
Oracle Database 12c Performance Tuning and Optimization
This course will teach you how to perform maintenance and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives.