Learn how to select which columns will be returned in a query and if you can specify the order of the columns returned.
- You can choose which columns…to return in a query by listing…the columns in your select statement.…Choose the world database here…and type in a simple query.…Select everything from the country table,…and when I press go you see we get 239 rows…and all of the columns here in the table.…So if I want to select specific columns, I can say…name, continent, and region.…
And if I press go I get name, continent, and region.…That's only the listed columns now.…I've selected which columns to return in my…query by listing them in the select statement.…Of course, if I don't like the word "Name" here as the…identifier for that column, I can change that…and I can say "As Country," and when I press "Go"…now that column is named "Country" instead of "Name."…And I can list the columns in any order if I like.…
If I want continent and region before name, I can…list them in that order and then when I press "Go"…I now get continent, region, and country, instead of…country, continent, and region.…You may choose which columns to return…
Author
Bill Weinman
Released
7/2/2018- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 16s
-
Exercise files2m 21s
-
Course overview1m 38s
-
-
1. Installation
-
Installing on Windows: Part II10m 16s
-
Installing on a Mac: Part I6m 45s
-
Installing on a Mac: Part II12m 10s
-
2. SQL Overview
-
About the overview3m 39s
-
Database organization2m 54s
-
The SELECT statement5m 49s
-
Selecting rows2m 3s
-
Selecting columns1m 29s
-
Counting rows2m 42s
-
Inserting data3m 9s
-
Updating data2m 28s
-
Deleting data1m 42s
-
-
3. Fundamental Concepts
-
Creating a table3m 40s
-
Deleting a table2m 14s
-
Inserting rows3m 31s
-
Deleting rows1m 55s
-
The NULL value5m 22s
-
Constraining columns3m 17s
-
Changing a schema2m 3s
-
ID columns2m 21s
-
Filtering data5m 43s
-
Removing duplicates2m 37s
-
Ordering output2m 23s
-
Conditional expressions2m 30s
-
-
4. Relationships
-
Understanding JOIN2m 19s
-
Accessing related tables4m 31s
-
Relating multiple tables4m 27s
-
-
5. Strings
-
About SQL strings1m 33s
-
Removing spaces2m 26s
-
Folding case2m 13s
-
-
6. Numbers
-
Numeric types3m 32s
-
What type is that value?2m 12s
-
Integer division1m 56s
-
Rounding numbers1m 2s
-
-
7. Dates and Times
-
Dates and times1m 52s
-
-
8. Aggregates
-
What are aggregates?4m 38s
-
Using aggregate functions1m 57s
-
Aggregating DISTINCT values1m 53s
-
-
9. Transactions
-
What are transactions?2m 2s
-
Data integrity3m 10s
-
Performance3m 27s
-
-
10. Triggers
-
Preventing updates2m 36s
-
Example: Timestamps2m 26s
-
11. Views and Subselects
-
Creating a subselect3m 47s
-
Creating a view3m 32s
-
Creating a joined view2m 32s
-
-
12. Defined Functions
-
Overview1m 7s
-
Defining functions in PHP4m 27s
-
-
13. A Simple CRUD Application
-
Embedding SQL4m 50s
-
The SELECT functions3m 30s
-
-
Conclusion
-
Goodbye1m 3s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Selecting columns