FREE SQL
Linux
- Download linux version https://www.sqlite.org/index.html -
- sqlite-tools-linux-x86-3280000.zip (Precompiled Binaries for Linux)
- Open Terminal
- chmod -R 777 sqlite-tools-linux-x86-3280000.zip
- Unzip sqlite-tools-linux-x86-3280000.zip
- cd sqlite-tools-linux-x86-3280000
- sqlite3 test.db # to create a DB
- Dowload SQL studio (Linux installer)
- ./InstallSQLiteStudo-xx
- After Installation , Click on Add Databases
- Select test.db
Estrablishing Connection using Python with pandas:
import sqlite3
import pandas as pd
conn=sqlite3.connect("/home/deepak/Downloads/chinook.db")
#chinook.db- https://drive.google.com/file/d/1uc54BXiil2d4pj1nMCGeBUKxsRrKl9zi/view?usp=sharing
df = pd.read_sql_query("SELECT * from genres",conn)
print(df)
Windows
Installation SQL Server 2005 in XP for Testing
1. Download following SQL Server setups from Microsoft official site .They are free !!
http://www.microsoft.com/en-in/download/details.aspx?id=22625
Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a free, easy-to-use, lightweight version of SQL Server 2005.
http://www.microsoft.com/en-in/download/details.aspx?id=8961
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services
1. Install SQL Server Express First.
2. Download and install SQL Server management Studio Express compatible with the SQL Server Express in our case 2005. Management Studio Express is free to download from Microsoft as well.
3. You should be able to see the IDe on double clicking of SQl management Studio icon.
Note:
If you getan error "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded".
Then install "MicrosoftFixit50701.msi" or go to website do http://support.microsoft.com/kb/918685 which should fix your problem.
