From Front-end to Back-end: Understanding Databases Step

Larissa Dantier — Fri, 21 Feb 2025 11:30:00 +0000

Hello everyone! I'm here again for continue with an articles :), it's been a while since the last post, I ended up getting a bit busy but we came back. Let's go talk about Databases (The beginning of everything).

Understanding database

Basically, Database is an organized collection that help us a manage a large volum of data.

Helps manage the volum of data and information;
Allow quickly access to data;
Easy data recovery;

Collection: grouping of data organized and managed together.

Why use `databases`?

Databases play a crucial role in the efficient management of information in various sections. It offer a range of benefits.

Benefit	Description
Organization	`Data` is stored in a logical way, structure and allows for more efficient management and reduces redundancy
Easy Acces	With an efficient query it's possible to retrieve specific information in miliseconds, optimizing time and resources
Escability	`Database` are designed for handle with crescent volum of information, support from small operations to millions of users simultaneously

In addition to these benefits, they also promote data integrity and security. In increasingly data-driven world, a more efficient information management capacity is essential for the success of any organization.

📝 Example:
Hospitals use databases for patients' medical records, follow-ups, histories, notes and invoices.

Store use databases for products, invoices, amount, categories and others.

Key components of a `database`

We have some components for some fundamental elements that work in collections to store, organize and manage data, let's continue!

Name	Description
Table	`Tables` are the main units in a `database`, work in a similar way to spreadsheets. They are made up for `rows` and `columns`, which organize the data in a structured way
Rows	Each `row` represents a unit of log data. Contain specific information about an entity or item.
Column	The `columns` defines an attribute or property of stored data. Each `column` in a `table` represents a specific category of information, such as name, age or address

We've seen some very important points about Databases and how they work. The next article let's continue talking about databases yet :D.

Next Topics

Databases Types
- Relational
- Non-Relational
Differences of Relational vs Non-Relational
Primary Keys 🔑
Foreign Keys 😶‍🌫️

Thank you for reading this far!

Feel free to recommend articles, channels and so on of Back-end, I appreciate it 😎.

Starting my Back-end Journey (1/?)

Larissa Dantier — Wed, 05 Feb 2025 02:07:23 +0000

Hello, everyone! I'm Larissa and Front-end Developer, I have 5-6 years of professional experience and I started to see the need for learn back-end concepts in order to evolve my hard skills (Back-end is my achilles heel 😅).

The purpose of this post is tell you my steps of what I doing and also practicing my writing in English.

My expections and objectives

Last month, I started studying on uphop.ai. Uphop is a plataform with any courses free, I search video or other plataforms, but I didn't understand it very well and all video I found used ORM (Object Relational Mapping) like Prisma, TypeORM and others.

I began to feel that I was just copying and pasting, just creating tables without really knowing why or how it works and their rules. I ended up finding on Reddit in community called r/SQL and I found the Uphop.

I thought why not start at the bottom, My Front-end Journey started the same way!

So, that's why I explored the course SQL for Beginners which also has AI to help with any doubts and has some very nice practical examples.

I using Obsidian for my studies and probably I will use some notes I writed, themes like Databases, SQL, Syntax with your commands and how use and more!

Initial Steps

Learn SQL, Database, PostgreSQL, ORM (At some point) and others;
- Introduction to Databases and SQL
- Basic Data Retrieval with SQL
- Data Manipulation with SQL
- Joining Tables and Basic SQL Data Types
- Data Manipulation with SQL
- Database Structure and Views

Next steps

Learn NodeJS, Fastify, NestJS, Prisma and others
- Start a basic project using all concepts learn of Databases without ORM yet
- Read the Prisma Documentation - ORM(I'm going to write an article just about the Prisma`) and make a new project with it.

This initial article is more for you understand my objectives, how I'm going to study and to get to know myself a bit.

Thank you for reading this far! And I hope to write more about this new journey for me!