Introduces date functions, and shows how to use them within where clauses
- [Narrator] Now for dates.…Dates can be really tricky to get right in SQL…and in most other programming languages.…Problems arise, generally, because of the wide variety…of date formats.…The information I'm going to share with you, in this video,…is taken from the SQL standard…which is a set of rules governing how the language…should work across all vendors.…In many cases, the standard is ignored, though,…and you should also know that database wide settings…controlled by your IT Department might mean…that dates appear differently in your database.…
But if you're writing a query and supplying a date,…this is the best place to start.…So, the query that we're looking at here…looks as though it ought to work.…We're saying WHERE the last_update field…is equal to the 15th of February, 2006,…and if we look in this data in this field,…we see they are uniformly set…to the 15th of February.…But when we run that query, we get a zero result set.…And the reason for that, is you may have noticed…the time there was set to half past four in the morning.…
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.