Databases!

Database is a collection of data where you are able to store the information and access them from within the database.

Data within the most common types of databases in operation today is usually modelled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized within the database.

Most databases use structured query language (SQL) for writing and querying data.

What is the difference between SQL and NoSQL?

SQL stands for Structured Query Language, SQL also lets you access and manipulate databases.

NoSQL has flexible data models, horizontal scaling, fast queries and is easy for developers

Types of databases

There are different types of databases, NoSQLand SQL(sql is pronounced as “sequel”)

Examples of NoSQL databases would be:

  • Firebase by Google
  • DynamoDB by Amazon
  • Azure Cosmo DB by Microsoft
  • MongoDB

Examples of SQL databases would be:

  • MySQL
  • SQLite
  • Microsoft Access

How do we link databases to our HTML and CSS

We can use either PHP or JS to link the database together. Each database has their own way of connecting to the webpage and you would have to go on their respective websites to check it out.

PHP

Basically, to connect our page with Database you need to install Wamp or Xampp in your PC.

And after Installing it …you need to store all your files in the htdocs folder , which is there in the C drive -> Xampp -> htdocs.

And the run your localhost …and place the exact location of your htdocs Html file and again run it in the Browser.

Then your webpage is connected with the Database.

JS

For JS, there are some databases that output data in a JSON format and connecting to it does not require another software to do it.