This reading introduces the concept of database deployment models, explaining what they are and why choosing where a database lives—and who manages it—is a foundational organizational decision; learners use it as a conceptual entry point before exploring specific deployment options.
Topics
This module covers 7 topics. Open a topic to see its subtopics.
Module Content
16 items.
-
-
This reading covers on-premises database deployments, explaining how locally hosted systems work, what hardware and software responsibilities fall to the organization, and the trade-offs involved; learners use it to understand the full scope of managing a database entirely within their own facilities.
-
This reading explains managed cloud database services, describing how major cloud providers host and operate database infrastructure on behalf of organizations; learners use it to understand the shift away from physical servers and the capabilities that cloud-based database offerings provide.
-
This reading examines the financial trade-offs between cloud-hosted and on-premises database deployments, covering total cost of ownership beyond surface-level pricing; learners and instructors use it to guide rigorous cost-benefit analysis when evaluating deployment decisions.
-
This reading compares how cloud and on-premises database deployments handle scalability and performance as data volumes and user demand grow, explaining the mechanisms each model uses to expand capacity and maintain response times; learners use it to evaluate deployment options against operational performance requirements.
-
This reading covers the operational responsibilities of database maintenance and administration under cloud versus on-premises models, addressing patching, backups, monitoring, and optimization along with their staffing and budget implications; learners use it to understand how deployment choice shapes day-to-day administrative workload.
-
This reading examines availability, reliability, and security considerations when choosing between cloud and on-premises database hosting, explaining how each model addresses uptime, data loss prevention, and data protection; learners use it to evaluate deployment options against business continuity and compliance requirements.
-
This reading examines availability, reliability, and security considerations when choosing between cloud and on-premises database hosting, explaining how each model addresses uptime, data loss prevention, and data protection; learners use it to evaluate deployment options against business continuity and compliance requirements.
-
An introductory reading that defines what a database deployment model is and contrasts on-premises ownership of servers, storage, patching, and backups with provider-managed alternatives, giving learners the vocabulary and framing used throughout the module.
-
A lesson page on locally hosted (on-premises) database systems, covering the hardware, operating system, engine patching, backup, and physical security responsibilities that fall to an in-house team, which learners use to understand the control and burden of self-managed deployments.
-
A reading on managed cloud database services that explains the division of labor between provider (provisioning, patching, backups, replicas) and customer (schema design, queries, indexing, access control), helping learners recognize what they still own in the cloud.
-
A comparison page examining the financial trade-offs between local and cloud databases, including up-front hardware and license purchases versus ongoing subscription pricing and staffing costs, used by learners to reason about capital versus operating expense decisions.
-
A topic page on scalability and performance that distinguishes the two concepts and compares how on-premises hardware limits and cloud elasticity affect response times as data volume, user counts, and query complexity grow.
-
A reading on database maintenance and administration tasks — OS and engine patching, index and storage upkeep, backups, restore testing, tuning, capacity planning, and security configuration — framed around who performs each task in self-managed versus cloud-managed deployments.
-
A lesson covering availability, reliability, and security considerations in deployment decisions, including tolerable downtime, recovery after failure, and accountability for data exposure, which learners use to evaluate risk alongside cost.
-
A consolidated single-page version of the entire Module 14 content, stringing together all topics from deployment models through availability and security, useful for review, printing, or offline study.