Databases in Web Development
Learn how databases support dynamic web applications by enabling data storage and retrieval. Understand the difference between static and dynamic websites, the function of DBMS, and the key distinctions between SQL and NoSQL databases to build foundational web development skills.
We'll cover the following...
We’ve already discussed the basic structure and underlying protocols of a web page. Now, we will begin looking into what goes into forming a web page. To start with, we will talk about databases and database management systems (DBMS) and the role they play in making the web applications you see all around you, including this one! We know databases are essentially tables used to store and access data, but we now need to look at how these tables fit into the context of web application development. Before we can start talking about what the purpose of a database in a web application is, we must first outline the two kinds of websites that exist.
Static vs. dynamic web pages
Websites may be classified into one of two types:
- Static
- Dynamic
Static websites are ones that only display information such as text or pictures on their web pages that users cannot interact with.
Dynamic websites ...