SQL Fundamentals SQL Fundamentals

SELECTing Columns Exercise

This course has been updated! We now recommend you take the Complete Intro to SQL & PostgreSQL course.

Check out a free preview of the full SQL Fundamentals course:
The "SELECTing Columns Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

Since selecting all columns in a table is inappropriate for a production app, Mike shows how to explicitly pick which columns are needed for several collections of data that the app needs, and shows the improved performance gained.

Get Unlimited Access Now