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/t-sql/data-types/data-types-transact-sql The documentation for the date and time functions in SQL Server is available at: - https://learn.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql --------------------------------------------------- This is part of the From Excel to SQL playlist, available at: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rhnVPQ_Tj3Q-CI0rGn_uiD Check out the previous video at: - https://youtu.be/-0M-kEkoDqw ...and the next video at: - https://youtu.be/bxZeIkcxYQA The written version of this content is also available at: - https://billwallis.github.io/sql-learning-materials/from-excel-to-sql/main-concepts/data-types/ --------------------------------------------------- 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