Introduces data types, explaining their importance as well as how to identify the data type of any given field
- [Instructor] Now, a little bit about datatypes.…It might be obvious to you whether something is a number,…date, or text, but it's not obvious to a database.…Whoever sets up the database has to tell it explicitly…for each field.…This is true of all databases apart from MS Access.…You can't create a field in fact…without giving it a datatype.…There are more than 30 datatypes,…but they can be grouped into number, text, and date.…And actually, you may have had similar problems in Excel…without realizing it.…
Let's say you've got some numeric data.…They're obviously numeric to the naked eye…but Excel stubbornly refuses to accept…that it's anything other than text…and you find that your numbers are lying to the left.…You have to go and reformat the cells and run various tricks…to make Excel accept that the data are actually numeric.…Well databases are a bit similar.…If you store a number as text,…when you try to pull the number back out of a database,…you can't work with it as you would expect to.…Let's say you stored the number 66 in a cost column…
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.