Are there any free tools for practicing SQL coding and / or ERD modeling?

I am taking a DBMS course this semester and need a free tool to practice SQL coding as well as practical modeling of my ERD modeling, tools like Eclipse for Java and Visual for C #.

We study SQL 99 with Ramakrishnan's book Database Management Systems

if it has any meaning.

What are the recommended tools for SQL and / or ERD modeling that have a beginner user interface?

+3


source to share


3 answers


For practical SQL code, the best tool I know is SQLFiddle - http://www.sqlfiddle.com/ It is available online, you can test your SQL code against various databases (MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite ).

For ER modeling, I recommend Vertabelo . Vertabelo is a Chrome and Safari powered database developer developed by the company I work on. Similar to SQLFiddle, it is also available online. You don't need to install anything.



Vertabelo is free to use for academic projects and has commercial versions for large database projects.

+3


source


I find it difficult to use SQL Express for ease of use, basically a free version of a popular commercial DBMS. It will also give you a "usable" skillset since the interface is the same as the main product.

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx



Forgot to mention that you can use the Chart tool to create an ERD for your database so that it visualizes your design without the need for a third party tool (like Toad).

+3


source


U can download SQL Server Express Edition or Oracle Express Edition or MySQL

& use a newer version of ramakrishnan

Download here Oracle

Download SQL Server here

Download MySQL here

0


source







All Articles