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…
- 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
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.