Database Optimization Courses and Certifications

Logical and Physical Modeling for Analytical Applications

215 ratings at Pluralsight

Optimize analytical applications with effective logical design, understand data access challenges for large-scale queries, and explore SQL Server optimizations for improved performance in data warehousing.

• Pluralsight
• 2 hours 28 minutes
• On-Demand
• Free Trial Available

SQL Server 2008 Advanced Database Administration: Part 3

37 ratings at Pluralsight

Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security.

• Pluralsight
• 3 hours 6 minutes
• On-Demand
• Free Trial Available

Hussein Nasser

Table Clustering in MySQL and Postgres - The Pros and Cons

Explore database clustering in MySQL and Postgres, including benefits, drawbacks, and implementation across popular databases. Learn about this crucial feature for optimizing data organization and retrieval.

• YouTube
• 28 minutes
• On-Demand
• Free Video

Accelerating Analytical Queries using the AlloyDB Columnar Engine

In this lab you will explore features of the AlloyDB Columnar Engine.

• Google Cloud Skills Boost
• 1-2 hours
• On-Demand
• Paid Course

CNCF [Cloud Native Computing Foundation]

From Insanity to Ingenuity: Seven Practical Tips for Navigating the AI Storm in DBaaS Evolution

Explore AI's impact on DBaaS evolution with seven practical tips. Learn about LLMs, data quality, storage management, and innovative trends shaping the future of cloud-native databases and developer workflows.

• YouTube
• 38 minutes
• On-Demand
• Free Video

CMU Database Group

OtterTune: AI-Powered Database Optimization as a Service

Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.

• YouTube
• 1 hour 7 minutes
• On-Demand
• Free Video

SQLBits

Should We Defragment Indexes? - A Deep Dive into Modern Disk Architecture and I/O Performance

Explore modern disk architecture and I/O dynamics to understand when index defragmentation may hinder performance, challenging conventional practices.

• YouTube
• 19 minutes
• On-Demand
• Free Video

DSDSD - Dutch Seminar on Data Systems Design

LingoDB: An Open Compilation and Optimization Framework for Sustainable Data Processing

Discover how LingoDB's open-source framework enables efficient data processing through flexible architecture, cross-domain optimizations, and seamless adaptation to modern hardware capabilities.

• YouTube
• 27 minutes
• On-Demand
• Free Video

CNCF [Cloud Native Computing Foundation]

Database Parameter Auto-Tuning Through CI/CD Pipelines

Learn how Yahoo Japan automates MySQL parameter tuning using machine learning in CI/CD pipelines, addressing challenges in cloud computing and improving database performance.

• YouTube
• 25 minutes
• On-Demand
• Free Video

Advanced Transaction Management in SQL Server

Utilizing SQL Server transactions is a fundamental piece of understanding how SQL queries maintain consistency and integrity in a database. This course will build upon your existing skills of interacting with SQL Server transactions.

• Pluralsight
• 39 minutes
• On-Demand
• Free Trial Available

Conf42

Enhancing a Distributed SQL Database Engine - Performance Optimization Techniques

Explore optimization techniques for distributed SQL databases, focusing on benchmarking, performance analysis, and containerization strategies to enhance engine efficiency and scalability.

• YouTube
• 38 minutes
• On-Demand
• Free Video

Amazon Web Services;  Amazon

Travailler avec des index dans DynamoDB (Français) | Working with Indexes in DynamoDB (French)

Découvrez les requêtes, analyses et index secondaires de DynamoDB pour optimiser l'accès aux données. Apprenez à concevoir des index efficaces adaptés à vos besoins spécifiques.

• AWS Skill Builder
• 2-3 hours
• On-Demand
• Free Certificate

AI Interviews: System Performance and Security

Master system performance optimization and security through AI interview practice, covering load balancing, monitoring, database optimization, authentication, and vulnerability assessment techniques.

• CodeSignal
• On-Demand
• Free Certificate

Microsoft SQL Server 2012 Certification Training Exam 70-462

640 ratings at Udemy

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases

• Udemy
• 12 hours
• On-Demand
• Paid Course

MySQL Database Training for Beginners

381 ratings at Udemy

Learn MySQL and Take Your Web Development to the Next Level.

• Udemy
• 6 hours
• On-Demand
• Paid Course