All geek questions in one place

Starting with SQL

I enthusiastically enter the world of databases through SQL, but I do not know if there are any prerequisites for any value, and I only know C # and Java.

Also, what tools do I need? I have Visual Studio 2008 and SQL Server Management Studio. What else do I need? Do I need to load the server OS?

+4
source share
7 answers

Visual Studio 2008 and SQL Server Express are enough to learn the basics of a relational database management system (RDBMS.). You can learn SQL-SQL ANSI-SQL schema schema, schema, object-relational mapping, and more. SQL Express runs on Windows XP, Vista, and Windows 7.

Oracle also provides an Express version as well as other free options such as MySQL and SQLite.

+2
source

I recommend you try SQL Server Express, it is the easiest server you work with if you work with C #. If you want to learn SQL using Java, almost any database would be good.

A database server is software, like any other, you will have to communicate with it through your own program, creating a connection, throwing SQL commands and interpreting its results. If you only wanted to learn SQL, you could also install the client for the selected database server and study it, after which you could try to connect your program to this database. In this case, SQLite will work very well for you.

+3
source

Definitely install one of the free databases (Oracle Express, SQL Server Express). I used both of them. You can also check out this free tutorial . This will help you learn the syntax of SQL.

+3
source

You do not need a special server OS. SQL Server will work fine on your development machine if you just use it to learn. You will want to make sure that SQL Server is installed in addition to Management Studio.

+2
source

You can also try either MySQL or PostgreSQL . They are free, much easier to install than SQL Server, and work on other platforms.

+2
source

To get started, I would look at the W3 tutorial here: http://www.w3schools.com/sql/default.asp .

I used MySQL, I also get Workbench and WAMP (or LAMP). Then start building! It's good to do what you would use.

+2
source

SQL Server will run on your development system, and SQL Server Management Studio 2008 is a good tool for working with SQL 2008.

If you want to connect through your network, you need to configure the network surface to accept TCP client connections.

+1
source

Source: https://habr.com/ru/post/1306818/

More articles:


All Articles