Database Basics: Database Introduction, SQL vs NoSQL
Author: Aleksandar Peev 📅 12.01.2021 🕥22:30
▶️ Watch the video here: https://youtu.be/ufzqY8WAZ9c
In this video, I will be explaining what databases are. They are very widely used and you might be using them every day without even knowing.
First I will be explaining what type of databases there are and then we will be creating our first database.
A database is a collection of data, organized to be easily accessed, managed and updated 💾
Storing data is not the primary reason to use a database. Flat storage runs into issues with:
■ Ease of searching 🔎
■ Ease of updating 🖊️
■ Performance 🏎️
■ Accuracy and consistency 🎯
■ Security and access control 🔒
CRUD operations are foundation operations that every database developer needs to understand. The acronym refers to the major operations which are implemented by databases. Each letter in the acronym can be mapped to a standard Structured Query Language (SQL) statement.
You need to follow and do all my steps because you won’t gain anything just by watching me. Even if the best database administrator is giving you a tutorial you won’t understand anything without the code going through your fingers by typing it yourself.
💾 Materials:
https://drive.google.com/drive/folders/1j7ayq6fZ9TBl8XAmtSiTnVYZofL-2Sbs
Remember that coding is a skill, which should be practiced. To learn to code, you should write code, every day, for a long time. Watching tutorials is not enough. You should code!
We would love to hear from you, so leave a comment below saying what topics you would like to see next.