Helps make queries snappier using an alias, and explains where aliases can and cannot be used within the query
- [Instructor] We're going to revisit a previous query…and update it to make it quicker and easier to read.…Now one thing I want to point out to you here…is we have concat first name, last name here,…and that is given as the column heading…in the results set here,…and similarly, length concat first name, last name…is the column heading here.…You'll be pleased to know there is a shortcut here.…We can supply a column heading for the output here,…which is called an alias,…and we do that with the as keyword.…So we can say as name, and then for this one,…as len for length.…
That's much better.…Our column headings are nice and neat,…but also this is useful for more than just presentation.…We can use the alias names later in the same query,…so here for instance we could say instead of…concat first name, last name,…we can say order by name, and that works just the same.…Now what if we wanted to filter our results?…We know that we can add a where clause here,…so let's say where len is greater than 17.…
Now I'll tell you now, this query is going to fail.…
Join Emma Saunders as she shows you how to design and write simple SQL queries for data reporting and analysis. Review the different types of SQL, and then learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Learn a bit about data types and database design. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, Emma shows how to save your queries as views, so you can run them again and again.
- Using different versions of SQL
- Retrieving data with SELECT statements
- Filtering and sorting your results
- Transforming results with built-in SQL functions
- Grouping SQL results
- Merging data from multiple tables
- Identifying data types, and how to make sense of your database design
- Saving SQL queries
Skill Level Intermediate
1. Use SQL to Report Data
Data types in SQL databases5m 47s
2. Group your SQL Results
3. Merge Data from Multiple Tables
4. Advanced Features and Taking Your Learning Forwards
- 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.