Learn About Databases on Azure
If you're new to databases on Azure, the best place to start is Microsoft Learn. This free online platform provides videos and tutorials for hands-on learning. Microsoft Learn offers learning paths that are based on your job role, such as developer or data analyst. You can browse Azure data modules or use this learning path to understand Azure SQL ...
Path to Production
To find options helpful for dealing with relational data, consider these resources: 1. To learn about resources for gathering data from multiple sources and how to and apply data transformations within the data pipeline, see Extract, transform, and load (ETL). 2. To learn about Online analytical processing (OLAP), which organizes large business dat...
Azure SQL Database Security Baselines
Security is a vital part of any database solution. 1. Azure security baseline for Azure SQL Database 2. Azure security baseline for Azure Database Migration Service
What is the architecture of database systems?
We study the architecture of database systems in this chapter, starting with the traditional centralized systems, and covering client–server, parallel, and distributed database systems. Centralized database systems are those that run on a single computer system and do not interact with other computer systems.
What is a single server cloud architecture?
Single-Server Cloud Architecture: A single server is often utilized by small businesses to process and store all data, eliminating the need for a dedicated team and on-premises infrastructure. This kind of cloud solution offers the benefits of the cloud without a large investment.
What is a single web and database server?
Single Web and Database Server. The most simple architecture uses a single dedicated server to host both your database and web servers, website scripts and other files. Although simple, this can be a high performance option providing that your web and database usage is not too intensive.
What is the shared-nothing database architecture?
The Teradata database machine was among the earliest commercial systems to use the shared-nothing database architecture. The Grace and the Gamma research prototypes also used shared-nothing architectures. The hierarchical architecture combines the characteristics of shared-memory, shareddisk, and shared-nothing architectures.
Best Practices for Database Consolidation