Hi. I need to learn SQL. I need to know what software to download so I can practice. I have Oracle, but I don't like it. Anyone have a suggestion? Thanks in advance!
Page 1 of 1
4 Replies - 976 Views - Last Post: 04 October 2012 - 04:51 PM
Replies To: What software to use to practice SQL?
Re: What software to use to practice SQL?
Posted 04 October 2012 - 04:46 PM
Microsoft's SQL Express is a good home based environment and so is MYSQL. Both are free and great. I prefer MSSQL over MYSQL though.
I have been given the 3 choices shown below. I am not sure which one that I need. I just want to be able to make a database table and practice SQL commands.
1.) SQL Server Express with Tools (with LocalDB, Includes the database engine and SQL Server Management Studio Express)
Need to learn SQL Server Management? This contains everything needed to install and configure SQL Server as a database server.
2.)SQL Server Management Studio (Tools only)
Need to learn SQL Server development? This package does not contain the database, only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, etc. Use this if you already have the database and only need the management tools.
3.)SQL Server Express LocalDB (MSI installer)
Need to embed SQL Server Express into an application? New to the Express family, LocalDB is a lightweight version of Express that has all its programmability features yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites.
Page 1 of 1