This week’s system design refresher:
How Search Really Works (Youtube Video)
The Ultimate Walkthrough of the Generative AI Landscape
Cheatsheet on Relational Database Design
My Favorite 10 Soft Skill Books that Can Help You Become a Better Developer
SPONSOR US
How Search Really Works
The Ultimate Walkthrough of the Generative AI Landscape
Generative AI and LLMs are fast becoming a game-changer in the business world. Everyone wants to learn more about it.
The landscape covers the following points:
What is GenAI?
Foundational Models and LLMs
“Attention is All You Need” and its impact
GenAI vs Traditional AI
How to train a foundation model?
The GenAI Development Stack (LLMs, Frameworks, Programming Languages, etc.)
GenAI Applications
Designing a simple GenAI application
The AI Engineer Job Role
Over to you: What else would you add to the GenAI landscape?
Latest articles
If you’re not a paid subscriber, here’s what you missed.
Infrastructure as Code
A Crash Course on Scaling the Data Layer
A Crash Course on Load Balancers for Scaling
A Crash Course on Scaling the API Layer
A Crash Course on Architectural Scalability
To receive all the full articles and support ByteByteGo, consider subscribing:
Cheatsheet on Relational Database Design
A relational database is a type of database that organizes data into structured tables, also known as relations. These tables consist of rows (records) and columns (fields).
Some key points to know about Relational Database Design
SQL
SQL is the standard programming language used to interact with relational databases. It supports fundamental operations for data manipulation, data definition, and data control.
Fundamental RDBMS Concepts
There are some fundamental RDBMS concepts such as table, row, column, primary key, foreign key, join, index, and view.
Keys in Relational Databases
Different types of keys are as follows:
Primary Key: A column or combination of columns uniquely identifying each record in a table.
Surrogate Key: Artificial key generated by the database system or a globally unique identifier that has no inherent meaning to the data.
Foreign Key: A column or a combination of columns in one table that references the primary key of another table.
Relation Types
Relationships between tables play a key role in defining how data is connected. Three main types of relationships are:
One-to-One Relationship: A record in one table is associated with one record in another table.
One-to-Many Relationship: A record in one table is associated with multiple records in another table
Many-to-Many Relationship: Records in both tables can have multiple records in the other table.
Joins
Joins act as bridges, connecting different tables based on their relationship. They are extremely useful when you need to retrieve data from multiple tables. There are 3 main types of joins:
Inner Join
Right Outer Join
Left Outer Join
Over to you: What else should you know about relational database design?
My Favorite 10 Soft Skill Books that Can Help You Become a Better Developer
Productivity & Personal Development
Deep Work by Cal Newport
Atomic Habits by James Clear
The Effective Executive by Peter Drucker
Communication Skills
Crucial Conversations by Kerry Patterson et al.
How to Win Friends and Influence People by Dale Carnegie
Leadership & Team Dynamics
Extreme Ownership by Jocko Willink and Leif Babin
The Five Dysfunctions of a Team by Patrick Lencioni
Start with Why by Simon Sinek
Design & Craftsmanship
The Clean Coder by Robert Martin
The Design of Everyday Things by Dan Norman
Over to you: What is your favorite book?
SPONSOR US
Get your product in front of more than 1,000,000 tech professionals.
Our newsletter puts your products and services directly in front of an audience that matters - hundreds of thousands of engineering leaders and senior engineers - who have influence over significant tech decisions and big purchases.
Space Fills Up Fast - Reserve Today
Ad spots typically sell out about 4 weeks in advance. To ensure your ad reaches this influential audience, reserve your space now by emailing sponsorship@bytebytego.com
