Database Management Courses and Certifications

Bryan Cafferky

Master SQL with Python: Maintaining Data in SQL Server Using Merge - Lesson 13

Learn to efficiently update SQL Server tables using the Merge statement and pandas integration, ensuring data stays current for analysis. Covers inserting, updating, and deleting rows with practical demonstrations.

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

Learn With Jason

Improving the Database Experience of Deploy Previews with Xata

Explore Xata's GitHub integration for seamless data management across Deploy Previews. Learn to enhance Next.js apps, ensure data safety during collaboration, and implement new features efficiently.

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

MySQL Administration

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.

• Pluralsight
• 2 hours 1 minute
• On-Demand
• Free Trial Available

Simons Institute

Optimizing Relational Programs I

Explore fine-grained complexity, logic, and query evaluation techniques for optimizing relational programs in database systems and computational theory.

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

USENIX

Deconstructing an Abstraction to Reconstruct a Database Outage

Explore a complex Postgres cluster outage, learn to reproduce failures locally, and gain insights into debugging complex systems and understanding database internals.

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

Paul G. Allen School

Database Management Systems - Lecture 7

Explore advanced database concepts, query optimization techniques, and data management strategies in this comprehensive lecture on modern database systems.

• YouTube
• 2 hours 47 minutes
• On-Demand
• Free Video

Paul G. Allen School

Database Management Systems - Lecture 9

Explore advanced database concepts and techniques in this comprehensive lecture, focusing on query optimization, indexing strategies, and performance tuning for efficient data management.

• YouTube
• 2 hours 50 minutes
• On-Demand
• Free Video

Envato Tuts+

Continuous Integration: Database Selection and Model Creation - Day 2

Learn database selecting techniques, including creating models, using Active Records, query bindings, and testing, to enhance your database management skills.

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

Simons Institute

Direct Access for Conjunctive Queries with Negation

Explores efficient direct access techniques for signed conjunctive queries, extending tractability results to queries with negative atoms using circuit-based approaches.

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

Simons Institute

Factorized Databases

Explore compressed yet lossless representations of relational data, their efficient processing, and applications in algorithms, probabilistic databases, and in-database machine learning.

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

Error Handling in SQL Server

This course will teach you how to deal with and manage errors effectively.

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

Simons Institute

Measuring the Importance of Database Elements

Explore methods for quantifying the significance of database components, including tuples, constraints, and graph elements, using impact measurement and game theory concepts.

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

Kunal Kushwaha

New Age for Developers and Databases - Database Guardrails

Explore the paradigm shift in database development, focusing on guardrails for improved code quality, observability, and automated issue resolution.

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

Simons Institute

Direct Access for Conjunctive Queries with Aggregation

Explore efficient algorithms for simulating sorted query answers with aggregation, examining tractability for various aggregate functions and lexicographic ordering scenarios.

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

Simons Institute

Approximating Certain and Possible Answers Beyond Sets

Explore techniques for modeling uncertainty in databases using semiring-annotated relations, enabling efficient approximations of certain and possible answers for complex queries.

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