SQL Datasets

We have created an SQL database containing various datasets in their respective tables for you to access via power bi, excel or python for practice. You are given free readonly access. Use datasets in this database freely.

How to Access
You can use following read only credentials to access the database. With these credential, you can not edit the database. All tables are accessible using this username and password.

Server Type: SQL
Server Address: 66.165.248.146
Database Name: datasets
User Name: dspub
Password: 6ke01Eu4#

After connecting to the database, use following SQL command, to get the list of all tables, and their columns.
select Table_Name, Column_Name, Data_Type, Character_Maximum_Length, Numeric_Precision from information_schema.columns

Table_Name	Column_Name	Data_Type	Character_Maximum_Length	Numeric_Precision	Count
Call_Center_Locations	Number	smallint		5	4660
Call_Center_Locations	Regional_Office	nvarchar	64		4660
Call_Center_Locations	City	nvarchar	64		4660
Call_Center_Log	Date	datetime			14
Call_Center_Log	Origin	nvarchar	64		14
Call_Center_Log	Destination	nvarchar	64		14
Call_Center_Log	Duration	tinyint		3	14
Call_Center_Log	Rating	tinyint		3	14
ecommerce	CustomerID	int		10	3598
ecommerce	Gender	nvarchar	8		3598
ecommerce	InvoiceDate	date			3598
ecommerce	InvoiceNumber	int		10	3598
ecommerce	ProductID	tinyint		3	3598
ecommerce	Quantity	tinyint		3	3598
ecommerce	Price	money		19	3598
ecommerce	Total	money		19	3598
ecommerce	OrderStatus	nvarchar	16		3598
ecommerce	Country	nvarchar	32		3598
ecommerce	TrafficSource	nvarchar	32		3598
ecommerce	SessionDuration	tinyint		3	3598
ecommerce	DeviceCategory	nvarchar	16		3598
ecommerce	Device	nvarchar	16		3598
ecommerce	OS	nvarchar	16		3598
ecommerce	DeliveryRating	tinyint		3	3598
ecommerce	ProductRating	tinyint		3	3598
ecommerce	Sales	money		19	3598
Indigeno_Buyers	Buyer_ID	tinyint		3	14
Indigeno_Buyers	Buyer_Name	nvarchar	32		14
Indigeno_Buyers	Buyer_Location	nvarchar	32		14
Indigeno_Inputs	Buyer_ID	tinyint		3	98
Indigeno_Inputs	Buyer_Name	nvarchar	32		98
Indigeno_Inputs	Buyer_Location	nvarchar	32		98
Indigeno_Inputs	Product_Name	nvarchar	64		98
Indigeno_Inputs	Product_Code	smallint		5	98
Indigeno_Inputs	Product_Cost	money		19	98
Indigeno_Inputs	Product_Price	money		19	98
Indigeno_Inputs	Initiate_Sales	varchar	74		98
Indigeno_Products	Product_Name	nvarchar	64		7
Indigeno_Products	Product_Code	smallint		5	7
Indigeno_Products	Product_Cost	money		19	7
Indigeno_Products	Product_Price	money		19	7
Indigeno_Sales	Sales_Date	datetime			13
Indigeno_Sales	Sales_Buyer_ID	tinyint		3	13
Indigeno_Sales	Sales_Product_Code	smallint		5	13
Indigeno_Sales	Sales_Delivery_Status	nvarchar	32		13
Indigeno_Sales	Sales_Payment_Status	nvarchar	32		13
Indigeno_Sales	id	int		10	13
Indigeno_Sales_Report	Sales_Date	datetime			13
Indigeno_Sales_Report	Sales_Buyer_ID	tinyint		3	13
Indigeno_Sales_Report	Sales_Product_Code	smallint		5	13
Indigeno_Sales_Report	Sales_Delivery_Status	nvarchar	32		13
Indigeno_Sales_Report	Sales_Payment_Status	nvarchar	32		13
Indigeno_Sales_Report	id	int		10	13
Indigeno_Sales_Report	Buyer_ID	tinyint		3	13
Indigeno_Sales_Report	Buyer_Name	nvarchar	32		13
Indigeno_Sales_Report	Buyer_Location	nvarchar	32		13
Indigeno_Sales_Report	Product_Name	nvarchar	64		13
Indigeno_Sales_Report	Product_Code	smallint		5	13
Indigeno_Sales_Report	Product_Cost	money		19	13
Indigeno_Sales_Report	Product_Price	money		19	13
Indigeno_Update_Status	Sales_Date	datetime			13
Indigeno_Update_Status	Sales_Buyer_ID	tinyint		3	13
Indigeno_Update_Status	Sales_Product_Code	smallint		5	13
Indigeno_Update_Status	Sales_Delivery_Status	nvarchar	32		13
Indigeno_Update_Status	Sales_Payment_Status	nvarchar	32		13
Indigeno_Update_Status	id	int		10	13
Indigeno_Update_Status	Update_Delivery_Status	varchar	68		13
Indigeno_Update_Status	Update_Payment_Status	varchar	68		13
tj	T	datetime			3
tj	Load_Use	decimal		5	3
tj	Temperature	decimal		5	3
tj	Material_In	decimal		5	3
tj	Material_Out	decimal		5	3
tj	Loss	decimal		5	3
tj	Red	int		10	3
tj	Total_Red	int		10	3
tj	Green	int		10	3
tj	Total_Green	int		10	3
tj	Blue	int		10	3
tj	Total_Blue	int		10	3
tj	Completed	int		10	3
tj	Total_Completed	int		10	3
tj	Damaged	int		10	3
tj	Total_Damaged	int		10	3