Shulou(Shulou.com)06/02 Report--

This article is about how to learn MySQL, the editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it with the editor.

What does SQL do?

Pull a random person over on the street, may have heard of "big data", regardless of big data, small data, where on earth is his data? One way is to store it in a relational database (other non-relational databases, HDFS, etc.), just as we put goods in a warehouse, and if we want to see the data in the database, we use SQL.

SQL is also a programming language, low-level, so it will be more boring to learn, unlike Tableau, the visual effect is good, you can pull. As long as he has mastered the basic grammar of SQL, he can apply it directly, just like a mathematical formula.

SQL also has a lot of knowledge points, we do not need to remember, to learn to check documents, use Google, and different databases, his syntax may be different, it is easy to confuse.

What developers usually call SQL scripts are one or more SQL or stored procedures.

How to learn SQL?

With the development of the Internet, the cost of learning is very low, and there are many free resources on the Internet.

Comment on better SQL tutorials like w3school

Here, you can understand the basic grammar of SQL, remember these, and then cooperate with the exercises can be regarded as an introduction.

Sqlzoo is an online exercise site, there are many SQL exercises, we can write SQL directly online, and after submission, will tell us right or wrong.

If there is still time, find a book "SQL must know", "MySQL must know", "SQL", to check and fill the gaps, you can better sort out your knowledge structure.

SQL, like all knowledge, does not have to be easily forgotten, so it is best to use it at work, and you must remember that "practice is the only criterion for testing truth". SQL must practice more and practice more.

MySQL client

If we want to connect to the database and use SQL to query the database, we need to use a client program, just as we need to use a browser to access a web page.

Some students are already learning or using SQL, as long as the computer has installed a client tool that can connect to MySQL, and there is no need to install it repeatedly. Students who do not have the installation can choose the tools that suit them according to the recommendations below.

Navicat (recommended)

Navicat official website: http://www.navicat.com.cn/products

Navicat is easy to use, but it is a fee-based software, so we need to crack it when we use it.

Students who support the genuine version can go to the official website to download and try it out.

Download address of cracked Baidu Cloud: https://pan.baidu.com/s/1c1SNSru

We download the compressed package from Baidu Cloud and choose a version suitable for our system to install.

X86 is 32-bit

X64 is 64-bit

The cracking program is all one, and after the installation is complete, you can execute the cracking program.

Workbench

MySQL official provides a client tool, free, but also quite easy to use

Official download address: https://dev.mysql.com/downloads/workbench/

Baidu Cloud download address: https://pan.baidu.com/s/1c1SNSru

Here, I only downloaded to the 64-bit version, need 32-bit students, go to this address to download: https://dev.mysql.com/downloads/workbench/

To install Workbench, we need to install some dependencies, which is a little troublesome. We can execute the installer first. If we lack dependencies, we will be prompted to install it.

Microsoft .NET Framework 4.5

Visual C++ Redistributable for Visual Studio 2015

Baidu Cloud compressed package only provides Visual C++ installer, .NET Framework installer, please go to the above download address to download by yourself.

The above is how to learn MySQL. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.