EP129: The Ultimate Walkthrough of the Generative AI Landscape

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:

1. What is GenAI?

2. Foundational Models and LLMs

3. “Attention is All You Need” and its impact

4. GenAI vs Traditional AI

5. How to train a foundation model?

6. The GenAI Development Stack (LLMs, Frameworks, Programming Languages, etc.)

7. GenAI Applications

8. Designing a simple GenAI application

9. 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.

1. Infrastructure as Code

2. A Crash Course on Scaling the Data Layer

3. A Crash Course on Load Balancers for Scaling

4. A Crash Course on Scaling the API Layer

5. 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

1. 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.
   

2. Fundamental RDBMS Concepts
   There are some fundamental RDBMS concepts such as table, row, column, primary key, foreign key, join, index, and view.
   

3. 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.
   

4. 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.
     

5. 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

1. Deep Work by Cal Newport

2. Atomic Habits by James Clear

3. The Effective Executive by Peter Drucker

Communication Skills

1. Crucial Conversations by Kerry Patterson et al.

2. How to Win Friends and Influence People by Dale Carnegie

Leadership & Team Dynamics

1. Extreme Ownership by Jocko Willink and Leif Babin

2. The Five Dysfunctions of a Team by Patrick Lencioni

3. Start with Why by Simon Sinek

Design & Craftsmanship

1. The Clean Coder by Robert Martin

2. 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