Azure SQL DB is a fully managed relational database service, Azure Dedicated SQL pool is a distributed analytics service for large datasets, and Elastic Pool is a resource allocation model for managing multiple SQL databases with varying workloads.