Databases - SQL/Excel/MongoDB

Post Reply
Phonetician
Posts: 10
Joined: Sun Jan 19, 2020 7:09 pm

Databases - SQL/Excel/MongoDB

Post by Phonetician »

Here we can have a general discussion on Databases. Menaging huge amounts of data, creating tables and data types, inserting and removing data from a table, creating auto incrementing integer type of data (means that every time you upload something new, the ID of the product increments automatically in a special column of your table). We can discuss from a basic Excel table forms up to advanced databases made in SQL and some other programming language.
In fact, the most popular programming language and one of the earliest languages that handle databases is called SQL (structured query language). It has basic English syntax and it is a great opportunity to understand the basic programming logic, so later on it can help you in learning more complex programming. This programming language helps you to create databases, create tables, remove tables, remove databases, insert data like string or integers etc... it help us to map through data, update, select anything we need from huge databases that can contain billions of data.
On the other hand we can do the same in Microsoft Excel but not so advanced, while MongoDB is also a good way to handle databases.
In order to start to create your own databases you need to install the latest version of MySQL and you can start coding in your command prompt/Terminal.
The databases that you are going to create are going to be there until someone do not delete them or you reinstall your OS.
Post Reply