MySQL to start with SQL?

-4

I'm just starting with the SQL language, I've run simple code in openoffice base but now I need to learn more, I do not understand what I should download from the page link to be able to practice, what is the correct download option?

    
asked by Robby 07.06.2016 в 06:10
source

5 answers

3

SQL and MySQL are different things. MySQL a database manager system, this interprets and executes the queries made in SQL, as well as this there are many other MSSQL Server, Oracle ORDBMS among others, but those are the main ones.

SQL is the language you use to create queries within one of these managers. SQL refers to Structured Query Language, for its acronym in English Structured Query Language. There is a standard that governs how queries should be constructed so that the compiler can interpret it properly. Currently the version of the standard is SQL-92.

I recommend you to start using preferably the Microsoft manager (MSSQL Server), for this there is a much more extensive documentation and has a large number of users that can help you with more specific questions that arise in the way of learning.

Microsoft offers free of charge the ideal Express version for people who are starting in the world of Databases; to start you need to download the BDs engine and the Manager.

Here is the link:

link

    
answered by 08.06.2016 / 00:54
source
3

There are many relational database management systems that you can use to learn. If you have used OpenOffice, I think it is relevant that you know that the database engine behind OpenOffice Base is HSQL, a database engine that (say its authors) is the most adherence to standards among the open source options . In summary: Using OpenOffice as a SQL learning tool is a good option.

Now, if you want to learn how to use a "large" database management system, MySQL is a good place to start. MySQL has several editions, but the one that suits you best (or, at least, the one that is free) is MySQL Community Server .

If you're working on Windows, you can download the MySQL installer, which will help you install everything you need to have a MySQL server ready to go. At a minimum, I recommend that you install the database server and MySQL Workbench (which will serve as a graphical interface to work, unless you want to work only in the MySQL console).

If you are on the Mac, you must download the MySQL server and then MySQL Workbench. Download the DMG files.

If you are working on Linux, it is very likely that you can install MySQL directly from the repositories of your distribution. For example, in Debian, to install the MySQL server and the Workbench you will need to execute the following instructions in the terminal:

sudo apt-get update
sudo apt-get install mysql-server mysql-client
sudo apt-get install mysql-workbench
    
answered by 09.06.2016 в 22:52
1

to add some more information to the answer of Martín since you are starting in SQL you can enter codeacademy

link

What is an interactive introductory course and a good starting point for those who start in SQL.

Greetings

    
answered by 09.06.2016 в 20:55
0

I would recommend that you do, that you use MySQL to learn the SQL language. There is an excellent book that will make you advance from zero to intermediate quickly, it is called "MySQL Crashcourse" by Ben Forta, it is short, concise and very complete. I learned SQL with this book only, it is the best you can find for beginners. Forget about tutorials on the internet that what they do is confuse you more and surely do not trust the help of Microsoft that is not friendly for beginners.

To download MySQL and start working quickly without much complication, just download Wampserver that brings you the PhphMyAdmin, where you can practice your queries in a simple way without so much configuration.

These are the ways and tools that I have used to learn MySQL and I am not an engineer, I am a historian, therefore you can see that they are the most adapted ways to absolute beginners.

    
answered by 11.07.2016 в 22:02
0

You must download Mysql Community Server and if you want Mysql Workbench tool this last tool is a graphical interface to visualize and design tables, it's good to start learning with Mysql is very popular especially in web development, but everything depends, so you must be clear about your goals and with Stack you want to work, for example if you want to work with .Net then use Microsoft Sql Server, others like PostgreSQL, ORACLE are also very good and you can do very advanced things.

Note: I do not recommend using SQlite as an alternative for the aforementioned ones because it is not the purpose for which it was created, SQLITE competes with fopen () . p>

If you are also learning a programming language or framework mentioned above, I recommend the following:

  • with PHP and its Frameworks I recommend Mysql .

  • with Python / Django I recommend PostgreSQl .

  • with C # / .NET / Asp Core I recommend Microsoft Sql Server .

  • with Ruby / Rails I recommend PostgreSQL / Mysql .

  • with Java I've had the opportunity to connect with Mysql and everything was excellent.

answered by 12.07.2016 в 00:56