SQL Fundamentals SQL Fundamentals

SELECTing Columns Exercise

This course is out of date and does not reflect our quality standards.

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