Luis Caparroz dos Santos

Ph.D. student. Project Development at @gft_br. University Professor at @uninoveoficial. Passionate about algorithms, research and tech in general.

[Luis Caparroz dos Santos @_luiscarlosjr]

Já dizia Mario Quintana: "Não importa saber se a gente acredita em Deus: o importante é saber se Deus acredita na gente..."

[Bytebytego @bytebytego]

What are the data structures used in daily life?

A good engineer needs to recognize how data structures are used in our daily lives.

🔹 list: keep your Twitter feeds
🔹 stack: support undo/redo of the word editor
🔹 queue: keep printer jobs, or send user actions in-game
🔹 heap: task scheduling
🔹 tree: keep the HTML document, or for AI decision
🔹 suffix tree: for searching string in a document
🔹 graph: for tracking friendship, or path finding
🔹 r-tree: for finding the nearest neighbor
🔹 vertex buffer: for sending data to GPU for rendering

To conclude, data structures play an important role in our daily lives, both in our technology and in our experiences. Engineers should be aware of these data structures and their use cases to create effective and efficient solutions.

Over to you: Which additional data structures have we overlooked?

—
Get a Free System Design PDF (158 pages) by subscribing to our weekly newsletter today: https://t.co/FIzCeaWsZV

[Luis Caparroz dos Santos @_luiscarlosjr]

What Are Deployment Patterns?, by @milan_milanovic https://t.co/LXgC2yuL8M

[Luis Caparroz dos Santos @_luiscarlosjr]

Premature Optimization https://t.co/7QDk1wL7ny via @YouTube

[Luis Caparroz dos Santos @_luiscarlosjr]

Best Practices for Developing High-Quality Software https://t.co/0qagRXbXOm via @DZoneInc

[Luis Caparroz dos Santos @_luiscarlosjr]

Uma bela demonstração de como a matemática é maravilhosa. A animação faz uma brincadeira com um boneco que caiu em uma universo. O video apresenta como o boneco está usando a matemática para retornar a sua origem #Animation vs. #Math #science https://t.co/BaEKAxgTy2

[Luis Caparroz dos Santos @_luiscarlosjr]

How to Automate Common Tasks with Shell Scripts via @dailydotdev https://t.co/dMazzLOqUV

[Luis Caparroz dos Santos @_luiscarlosjr]

Decoding #BigONotation Time and Space Complexities in JavaScript by Irene Smolchenko https://t.co/IHOF4kqVTN #Algorithms

[Luis Caparroz dos Santos @_luiscarlosjr]

A Comprehensive Guide to Unsafe, Unmanaged Code and Pointers by @GevorgChobanya https://t.co/kp0qDeg97E

[Luis Caparroz dos Santos @_luiscarlosjr]

Breaking Down the Monolith https://t.co/EIb0sPp2Af via @DZoneInc

[Luis Caparroz dos Santos @_luiscarlosjr]

EP60: Netflix Tech Stack - Databases , by @alexxubyte https://t.co/FU5pmC9nwd

[Luis Caparroz dos Santos @_luiscarlosjr]

Understanding Database Types, by @alexxubyte https://t.co/c5vQFzCjk2

[Dvz | Python Architect @PythonDvz]

How to Create Home Surveillance System Using Python
#python
https://t.co/FN7kwykNNJ

[Matheus Fidelis @ 0.0.0.0 @fidelissauro]

https://t.co/f8xutvPn5p

[freeCodeCamp.org @freeCodeCamp]

Git has many helpful features you can use to more easily update your code.

And the rebase command is one of them - but it can be a bit scary if you're not familiar with it.

In this guide Nick explains how rebase works + when and why you should use it.

https://t.co/BjANHi8L49

[Luis Caparroz dos Santos @_luiscarlosjr]

@laiscaparroz @stuartdois Exatamente 🙂

[Aurimas Griciūnas @Aurimas_Gr]

What is the 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝘆 𝗼𝗿𝗱𝗲𝗿 𝗼𝗳 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻?

There are many steps involved in optimising your SQL Queries. It is helpful to understand the order of SQL Query Execution as we might have constructed a different picture mentally.

The actual order is as follows:

𝟭. 𝗙𝗥𝗢𝗠 𝗮𝗻𝗱 𝗝𝗢𝗜𝗡: determine the base data of interest.

𝟮. 𝗪𝗛𝗘𝗥𝗘: filter base data of interest to retain only the data that meets the where clause.

𝟯. 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬: group the filtered data by a specific column or multiple columns. Groups are used to calculate aggregates for selected columns.

𝟰. 𝗛𝗔𝗩𝗜𝗡𝗚: filter data again by defining constraints on the columns that we grouped by.

𝟱. 𝗦𝗘𝗟𝗘𝗖𝗧: select a subset of columns from the filtered grouped result. This is also where 𝗪𝗜𝗡𝗗𝗢𝗪 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗮𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗶𝗼𝗻𝘀 happen.

𝟲. 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬: order the result by one or multiple columns.

𝟳. 𝗟𝗜𝗠𝗜𝗧: only retain the top n rows from the ordered result.

Below is a nice way to visualize it.

What are your thoughts? Let me know in the comment section 👇

--------

Follow me to upskill in #MLOps, #MachineLearning, #DataEngineering, #DataScience and overall #Data space.

Also hit 🔔to stay notified about new content.
𝗗𝗼𝗻’𝘁 𝗳𝗼𝗿𝗴𝗲𝘁 𝘁𝗼 𝗹𝗶𝗸𝗲 💙, 𝘀𝗵𝗮𝗿𝗲 𝗮𝗻𝗱 𝗰𝗼𝗺𝗺𝗲𝗻𝘁!

Join a growing community of Data Professionals by subscribing to my 𝗡𝗲𝘄𝘀𝗹𝗲𝘁𝘁𝗲𝗿.

[Luis Caparroz dos Santos @_luiscarlosjr]

8 best opensource projects you should try out via @dailydotdev https://t.co/5bFU4PfmFv

[Luis Caparroz dos Santos @_luiscarlosjr]

20 Essential Tools For Backend Development via @dailydotdev https://t.co/tThWMLNPRj

[Luis Caparroz dos Santos @_luiscarlosjr]

Don’t Learn a Programming Language. Learn Software Engineering by Weston Ludeke https://t.co/tx9k2YIX7v

[Programmer Humor @PR0GRAMMERHUM0R]

JavaScript equality operator (==) explained in one easy to remember diagram https://t.co/PAVeOxYVHK