Menu

git commit●fetch()●SELECT *●HTTP 200●localhost:3000●branch●flexbox●POST /api●INDEX●status 404●merge●JSON●git commit●fetch()●SELECT *●HTTP 200●localhost:3000●branch●flexbox●POST /api●INDEX●status 404●merge●JSON●

Databases

M1FoundationsFree

What is a database?
Tables, rows, and columns
Data types
Primary keys

M2Querying with SQLLocked

SELECT basics
Filtering with WHERE
Sorting and limiting
SQL playground
Counting and aggregates

M3Relationships & performanceLocked

Foreign keys
Joins
Normalization basics
Indexes and performance

M4Changing dataLocked

Inserting rows
Updating & deleting
Transactions & ACID

M5Grouping & growingLocked

Grouping with GROUP BY
Working with NULL
SQL vs NoSQL

Courses/Databases/Tables, rows, and columns

Foundations · Lesson 2 of 19

Tables, rows, and columns

Loading lesson…

Learners.Center

Learn by doing.

A product by DreamyHook Digital Media.