Stage 2 · Lesson 3 of 6
MySQL, SQLite and SQL Server: when they fit
is not the only good . is widely used behind websites and PHP apps such as WordPress, is cheap on almost every host and is a fine choice if your team or framework already uses it. SQLite is a whole database in a single file inside your app, with no server at all.
It is ideal for mobile apps, desktop tools, tests, prototypes and small sites with one writer at a time. Server is common in companies built on Microsoft and .NET, and Express edition is free with size limits. The core SQL is shared, so skills carry across. Choose by what your host, framework and team already support.
Common traptreating SQLite as a toy: for a single-user or read-mostly app it is often the simplest correct answer.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with· follow one of these
- CoursePaidGrokking Relational Database Design and Modeling
Design Gurus · Intermediate · $98 one-time
Data modelling, ER diagrams, keys and normalisation for the relational default, with worked designs
- GuideFreePostgreSQL Tutorial
PostgreSQL Global Development Group · Beginner
The short official tutorial: create a database, tables and your first queries in an evening
Practise
Keep handy
Also worth your time
json versus jsonb, the operators and how to index JSON for fast lookups
- Sefism SQL and Databases RoadmapGo deeper
The full Sefism roadmap for SQL: queries, schema design, transactions, indexes and SQL from code