Please assist me create a relational database for prison service.
#Database
coarse nexus
near bloom
Hi @coarse nexus thanks for sharing, have you considered using a tool like GitHub Copilot to ask this question and get it to design you a learning plan and maybe some architectural considerations to get you started. I noticed when exploring your question using these coding LLMs it gave some great learning resources to start your journey
Microsoft Learn: curated training path (from zero → project-ready)
A. Core relational & SQL fundamentals (beginner)
Explore fundamental relational data concepts — normalization, SQL statement types, and common RDBMS objects. [https://learn.microsoft.com/en-us/training/modules/explore-relational-data-offerings/]
Explore performance‑based database design — normal forms, choosing data types, and indexing basics. [https://learn.microsoft.com/en-us/training/modules/explore-performance-based-design/]
B. Azure SQL Database essentials (beginner → intermediate)
Azure SQL fundamentals (learning path) — what to use when (Single DB vs Managed Instance), how to deploy, secure, monitor. [https://learn.microsoft.com/en-us/training/paths/azure-sql-fundamentals/]
Quickstart: Create a single Azure SQL Database (Portal/CLI/PowerShell) — fastest way to spin up a dev database. [https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&tabs=azure-portal]
Connect & query Azure SQL — reference quickstarts for SSMS, Azure Data Studio, VS Code, and common client SDKs. [https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-content-reference-guide?view=azuresql]
Develop data‑driven apps with Azure SQL Database (learning path) — CI/CD with SQL Database Projects, Data API Builder, and securing your DB. [https://learn.microsoft.com/en-us/training/paths/develop-data-driven-app-sql-db/]
