Level I | Level II | Level III | Article Links | Is External | Score | Comments |
---|---|---|---|---|---|---|
Introduction | - | - | - | - | - | - |
What is PostgreSQL | - | - | - | - | - | - |
Why host in Azure? | - | - | - | - | - | - |
Introduction to Azure Data for PostgreSQL | - | - | - | - | - | - |
Deployment models | - | - | - | - | - | - |
- | Virtual Machine | - | - | - | - | - |
- | Single | - | - | - | - | - |
- | Flexible | - | - | - | - | - |
- | PostgreSQL in App | - | - | - | - | - |
- | Pricing | - | - | - | - | - |
- | Unsupported features and limitations | - | - | - | - | - |
Getting Started | - | - | - | - | - | - |
- | Azure Subscriptions | - | - | - | - | - |
- | Authentication | - | - | - | - | - |
- | Landing Zones | - | - | - | - | - |
- | - | Secure vs Non-secure | - | - | - | - |
- | - | Server Parameters | - | - | - | - |
- | Azure Resource Manager | - | - | - | - | - |
- | - | Azure CLI | - | - | - | - |
- | - | Azure PowerShell | - | - | - | - |
- | - | Azure Rest | - | - | - | - |
- | Tools | - | - | - | - | - |
- | - | Visual Studio | - | - | - | - |
- | - | Visual Studio Code | - | - | - | - |
- | - | PostgreSQL Extension | - | - | - | - |
- | Language Support | - | - | - | - | - |
- | - | PHP | - | - | - | - |
- | - | Java | - | - | - | - |
- | - | Python | - | - | - | - |
- | - | Others(Ruby) | - | - | - | - |
- | - | Drivers | - | - | - | - |
- | Creating databases | - | - | - | - | - |
- | - | Azure Portal | - | - | - | - |
- | - | Azure CLI | - | - | - | - |
- | - | ARM Template | - | - | - | - |
- | Connecting and Querying the Database | - | - | - | - | - |
- | - | My SQL Workbench | - | - | - | - |
- | - | Azure CLI | - | - | - | - |
- | - | .NET | - | https://www.codeguru.com/azure/connecting-to-a-PostgreSQL-azure-database-from-asp-net/ | - | - |
- | - | PHP | - | - | - | - |
- | - | Python | - | https://www.foteinisavvidou.codes/connect-to-azure-database-for-PostgreSQL-using-python/ | - | - |
- | - | Java | - | https://aashikahamed.medium.com/setup-PostgreSQL-and-service-deployment-in-azure-82012f839157 | - | - |
End to end application development | - | - | - | - | - | - |
- | Types of Applications | - | - | - | - | - |
- | - | Web App | - | - | - | - |
- | - | Azure Functions | - | - | - | - |
- | - | Microservices | - | - | - | - |
- | - | Event-driven | - | - | - | - |
- | - | Batch processing (chron, web jobs) | - | - | - | - |
- | - | Logic Apps | - | - | - | - |
- | Hosting Applications | - | - | - | - | - |
- | - | On-prem | - | - | - | - |
- | - | Hybrid | - | - | - | - |
- | - | Multi-cloud | - | - | - | - |
- | - | Azure | - | - | - | - |
- | - | 3rd party | - | https://www.percona.com/blog/2021/06/24/deploy-a-dedicated-percona-server-for-PostgreSQL-8-0-in-azure/ | - | - |
- | - | - | - | - | - | - |
- | Tutorials | - | - | - | - | - |
- | - | Azure VM | - | - | - | - |
- | - | Azure App Svc | - | - | - | - |
- | - | Spring, Java | - | https://docs.chunliu.me/appservice/spring-boot-PostgreSQL.html, https://azuredevopslabs.com/labs/vstsextend/tomcat/ | - | - |
- | - | Function App | - | https://towardsdatascience.com/access-azure-database-for-PostgreSQL-from-azure-functions-with-ssl-certification-verification-b6c6784f76fb | - | - |
- | - | Logic App | - | - | - | - |
- | - | Micro-services | - | - | - | - |
- | - | Azure Spring Cloud | - | - | - | - |
- | - | Power BI | - | - | - | - |
- | - | PostgreSQL in App | - | https://transcendentsoftware.com/blog/how-to-setup-azure-PostgreSQL-in-app/ | - | - |
- | - | Azure Data Factory | - | - | - | - |
- | - | AI/ML | - | - | - | - |
- | - | IoT | - | - | - | - |
- | 3rd Party | - | - | - | - | - |
- | Version Control | - | - | - | - | - |
- | CI/CD | - | - | https://azuredevopslabs.com/labs/vstsextend/tomcat/ | - | - |
Monitoring | - | - | - | - | - | - |
- | Azure Monitor / Log Analytics | - | - | - | - | - |
- | App Insights | - | - | - | - | - |
- | Debugging Apps | - | - | - | - | - |
- | Azure Service Health | - | - | - | - | - |
Security and Compliance | - | - | - | - | - | - |
- | Microsoft Entra | - | - | - | - | - |
- | Azure Key Vault | - | - | - | - | - |
- | Managed Service Identities | - | - | - | - | - |
- | Virtual Networks | - | - | - | - | - |
- | Private Endpoints | - | - | - | - | - |
- | Azure Firewall | - | - | - | - | - |
- | Application Gateway | - | - | - | - | - |
- | Security Baselines | - | - | - | - | - |
- | Azure Defender | - | - | - | - | - |
- | Azure Sentinel / Log Analytics | - | - | - | - | - |
- | Azure Advisor and Security Center | - | - | - | - | - |
- | GPDR | - | - | - | - | - |
- | Compliance Center | - | - | - | - | - |
- | Azure Purview / Professie? | - | - | - | - | - |
Testing | - | - | - | - | - | - |
- | JMeter | - | - | - | - | - |
- | Automated Testing | - | - | - | - | - |
- | - | Azure Test Plans | - | - | - | - |
BCDR | - | - | - | - | - | - |
- | Backup and Restore | - | - | - | - | - |
- | High Availability | - | - | - | - | - |
- | Service Level Agreements | - | - | - | - | - |
Optimization | - | - | - | - | - | - |
- | Load Balancers | - | - | - | - | - |
- | - | Azure Traffic Manager | - | - | - | - |
- | - | Front Door | - | - | - | - |
- | Caching | - | - | - | - | - |
- | - | Azure Cache for Redis | - | - | - | - |
- | CDN | - | - | - | - | - |
- | - | Azure CDN | - | - | - | - |
- | Connection Pooling | - | - | - | - | - |
- | Batch Execution | - | - | - | - | - |
- | Re-try | - | - | - | - | - |
- | - | Wait and re-try | - | - | - | - |
- | - | Polly | - | - | - | - |
- | Scaling | - | - | - | - | - |
- | - | read-replica | - | - | - | - |
Architectures | - | - | - | - | - | - |
- | Industry (Gaming, etc) | - | - | - | - | - |
- | Multi-node | - | - | - | - | - |
- | Geo-routing | - | - | - | - | - |
- | Case studies | - | - | - | - | - |
Resources | - | - | - | - | - | - |
- | - | - | - | - | - | |
- | PostgreSQL Team | - | - | - | - | - |
- | Forums | - | - | - | - | - |