Commodity pricing data is imported into SQL Server. Data types are specified and tables are merged.
Commodity prices are imported into SQL Server and the data types are specified. A new column is added entitled commodity name and update statements are given to populate the commodity name. An additional table is imported representing orange juice commodity prices. The orange juice table is augmented to have an identical structure to the commodities table. The orange juice table is then merged with the commodities table. At the end of this video, an SQL table has been created with appropriate data types and is ready for analysis. In the next video we take the data in the master commodities table and perform analysis using Python and SQL.
