beginner tutorial
How to Design a Database with Tables, Primary Keys and Foreign Keys
To design a database, you decide which tables you need, give each table a primary key that identifies every row, and link related tables with fore…
Category
- access tokens (1)
- acid transactions (1)
- Admin Template (49)
- ai agents (1)
- ai security (1)
- algorithms (2)
- analytics engineering (1)
- apache (1)
- api credentials (1)
- api design (3)
- api development (1)
- api versioning (1)
- apis (1)
- authorization (1)
- automation (1)
- aws lambda (1)
- backend (2)
- backend development (5)
- beginner explainers (1)
- beginner programming (1)
- beginner tutorial (1)
- Bootstrap (3)
- business intelligence (1)
- caching (2)
- cap theorem (1)
- ci/cd (1)
- classes and objects (1)
- cloud computing (1)
- cloud infrastructure (1)
- coding for beginners (2)
- computer science (1)
- computer science basics (1)
- configuration (1)
- Configuration (2)
- connection pooling (1)
- container orchestration (1)
- containers (3)
- continuous integration (1)
- cors (1)
- cross-site scripting (1)
- csrf (1)
- CSS (208)
- cybersecurity (2)
- dashboards (1)
- data cleaning (1)
- data engineering (2)
- data management (1)
- data modeling (2)
- data orchestration (1)
- data pipelines (1)
- data privacy (1)
- data quality (1)
- data storage (1)
- data structures (1)
- data visualization (1)
- database design (3)
- databases (6)
- debugging (2)
- deployment (1)
- developer setup (1)
- devops (6)
- distributed systems (1)
- dns (1)
- docker (1)
- Docker (21)
- docker swarm (1)
- dockerfile (1)
- elt (1)
- error handling (1)
- foreign keys (2)
- functions as a service (1)
- Git (47)
- google calendar api (1)
- google cloud (1)
- google search console (1)
- HOW TO LEARN (9)
- HTML (65)
- http (1)
- http status codes (1)
- https (1)
- idempotency (1)
- JAVASCRIPT (164)
- javascript seo (1)
- jQuery (2)
- kubernetes (1)
- Laravel (270)
- Linux (38)
- Livewire (1)
- llm safety (1)
- message queues (2)
- mobile design (1)
- mongodb (1)
- MongoDB (22)
- monitoring (1)
- MySQL (242)
- networking (1)
- Next.js (7)
- nginx (1)
- Node.js (9)
- normalization (1)
- nosql (2)
- Nuxt.js (6)
- oauth (1)
- oauth 2.0 (1)
- object oriented programming (1)
- online security (1)
- openid connect (1)
- pagination (1)
- performance (1)
- pgbouncer (1)
- PHP (86)
- postgresql (2)
- PostgreSQL (27)
- primary keys (2)
- privacy (1)
- programming basics (2)
- prompt injection (1)
- python (2)
- Python (10)
- rate limiting (1)
- React.js (1)
- Red Hat (2)
- redis (1)
- Redis (1)
- relational databases (1)
- reliability (1)
- reporting systems (1)
- rest api (1)
- reverse proxy (1)
- SASS (2)
- scalability (2)
- search engine indexing (1)
- seo (1)
- serverless (1)
- Shell Scripting (20)
- software architecture (2)
- software design (1)
- software development (3)
- software engineering culture (1)
- software performance (1)
- sql (5)
- SQL (68)
- sql injection (1)
- sqlite (1)
- system design (3)
- tls (1)
- troubleshooting (1)
- Video Playlist (7)
- VIDEOS (1)
- virtual machines (1)
- Vue.js (4)
- web accessibility (1)
- web development (4)
- web hosting (1)
- web performance (3)
- web security (1)
- web servers (1)
- webhooks (1)
- Windows (11)
Cloud
- access tokens
- acid transactions
- Admin Template
- ai agents
- ai security
- algorithms
- analytics engineering
- apache
- api credentials
- api design
- api development
- api versioning
- apis
- authorization
- automation
- aws lambda
- backend
- backend development
- beginner explainers
- beginner programming
- beginner tutorial
- Bootstrap
- business intelligence
- caching
- cap theorem
- ci/cd
- classes and objects
- cloud computing
- cloud infrastructure
- coding for beginners
- computer science
- computer science basics
- configuration
- Configuration
- connection pooling
- container orchestration
- containers
- continuous integration
- cors
- cross-site scripting
- csrf
- CSS
- cybersecurity
- dashboards
- data cleaning
- data engineering
- data management
- data modeling
- data orchestration
- data pipelines
- data privacy
- data quality
- data storage
- data structures
- data visualization
- database design
- databases
- debugging
- deployment
- developer setup
- devops
- distributed systems
- dns
- docker
- Docker
- docker swarm
- dockerfile
- elt
- error handling
- foreign keys
- functions as a service
- Git
- google calendar api
- google cloud
- google search console
- HOW TO LEARN
- HTML
- http
- http status codes
- https
- idempotency
- JAVASCRIPT
- javascript seo
- jQuery
- kubernetes
- Laravel
- Linux
- Livewire
- llm safety
- message queues
- mobile design
- mongodb
- MongoDB
- monitoring
- MySQL
- networking
- Next.js
- nginx
- Node.js
- normalization
- nosql
- Nuxt.js
- oauth
- oauth 2.0
- object oriented programming
- online security
- openid connect
- pagination
- performance
- pgbouncer
- PHP
- postgresql
- PostgreSQL
- primary keys
- privacy
- programming basics
- prompt injection
- python
- Python
- rate limiting
- React.js
- Red Hat
- redis
- Redis
- relational databases
- reliability
- reporting systems
- rest api
- reverse proxy
- SASS
- scalability
- search engine indexing
- seo
- serverless
- Shell Scripting
- software architecture
- software design
- software development
- software engineering culture
- software performance
- sql
- SQL
- sql injection
- sqlite
- system design
- tls
- troubleshooting
- Video Playlist
- VIDEOS
- virtual machines
- Vue.js
- web accessibility
- web development
- web hosting
- web performance
- web security
- web servers
- webhooks
- Windows
Archive
Filter
database design
Posts
beginner programming
by
Souy Soeng
/
Database Design Basics: Plan Your Tables, Keys and Links First
Database design is the planning you do before storing any data: deciding which tables exist, what each column holds, and how the tables connect. I…
data engineering
by
Souy Soeng
/
Database Normalization Explained, One Messy Online Shop at a Time
Database normalization is a way of organising tables so every fact is stored exactly once, in one place, so your data can never disagree with itse…
