Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Databases All Around You: PostgreSQL: Uncharted

Courses PostgreSQLDatabases All Around You

Databases All Around You

See why applications need databases, read table structure, and run your first PostgreSQL queries.

PostgreSQL
Unit 1 of 12
10 lessons
75 min
220 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

10 total

1Where Your Data LivesExplain how a database helps an application remember and organize shared data.InteractiveConcept6 min20 XPOpen
2When the Spreadsheet BreaksRecognize when shared, inconsistent, or very large data needs a database.InteractiveConcept7 min20 XPOpen
3Tables, Rows, and ColumnsDistinguish a table, row, column, and individual value in cafe data.InteractiveConcept8 min20 XPOpen
4Every Row Needs an IDExplain how an identifier keeps similar or duplicate rows distinct.InteractiveConcept6 min20 XPOpen
5Data Has TypesMatch common cafe values to PostgreSQL text, numeric, boolean, and date types.InteractiveConcept7 min20 XPOpen
6Meet PostgreSQLIdentify PostgreSQL as a database management system that stores and queries data.InteractiveConcept6 min20 XPOpen
7Your First SELECTRun a SELECT query that retrieves every row and column from a table.CodeConcept8 min20 XPOpen
8Pick Your ColumnsProject only the columns needed for a simple cafe price board.CodeConcept8 min20 XPOpen
9Reading Tables WorkoutWrite two SELECT statements that project different column pairs.CodePractice10 min20 XPOpen
10Foundations Mastery CheckInterpret a table using database purpose, structure, types, IDs, and projection.InteractiveMastery check9 min40 XPOpen

Your First Queries