From Excel to SQL - Data Types (CHAR, INT, DATE)
Although they're not particularly exciting, data types are a huge part of SQL -- it's important to know the most common data types and how to convert between them.
The dbfiddle website can be accessed for free and without an account at:
https://dbfiddle.uk/
Make sure to use the SQL Server dialect and the AdventureWorks sample database to be able to follow along with these examples!
The documentation for the data types in SQL Server is available at:
https://learn.microsoft.com/en-us/sql...
The documentation for the date and time functions in SQL Server is available at:
https://learn.microsoft.com/en-us/sql...
---------------------------------------------------
This is part of the From Excel to SQL playlist, available at:
• From Excel to SQL
Check out the previous video at:
• From Excel to SQL - Top Rows, Distinct Row...
...and the next video at:
• From Excel to SQL - Operators (+, -, *, /)
The written version of this content is also available at:
https://billwallis.github.io/sql-lear...
---------------------------------------------------
CHAPTERS
00:00 dbfiddle
00:28 Data types in Excel
03:25 Data types in SQL
06:39 Excel formatting is not in SQL
09:17 Converting between types in Excel
12:09 Converting between types in SQL (CAST)
16:10 Text data types in SQL
18:11 VARCHAR
21:49 Number data types in SQL
22:33 INTEGER
23:44 BIGINT
25:34 DECIMAL
29:11 Dates in Excel
32:07 Dates in SQL
34:06 Using dates in SQL
36:58 Missing values (NULLs)
41:21 Wrap up