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

How to learn MySQL, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

SQL is a structured query language and an application language that generally uses relational databases.

This sentence gives us two keywords, SQL and database. Before you know what a SQL statement is, you must first know what a database is. As its name implies, a database is a library for storing data, while SQL statement is a language dedicated to communicating with the database. Yes, it is a language similar to Java/Python, but it is very easy to learn. There are actually three main types of SQL statements:

DDL data definition language: defines database, table, column and other objects, such as create, drop and other keywords

DML data manipulation statements: used to add, delete, update, query data, such as insert, delete, update, select and other keywords

DCL data control statements: statements used to control the direct permission and access levels of different data segments, such as grant, revoke, and so on.

In fact, these three kinds of sentences are explained in this book, but for data analysts, they are more concerned with DML statements, that is, the operation of adding, deleting, checking and changing data.

Then what is the MySQL introduced in this book? MySQL is a kind of database software and one of the vast database software. other database software such as Oracle, SQL Server, Access and so on are relational databases, as well as distributed databases based on NoSQL technology, such as Hbase, MongoDB, Redis and so on.

This book is only an entry basis, because the SQL sentence is so easy to get started, it is easy to create the illusion of self-expansion, at this time should be accompanied by practical practice, so how to match the practice? In fact, there are many online SQL practice platforms that are very good.

1 、 SQLZOO

The original data has been given, according to the requirements of the topic for the corresponding retrieval, such as SQLZOO, the left is the topic, the right is the exercise output, can be switched to the Chinese version, but after the switch is traditional.

Website: https://sqlzoo.net/

I also sorted out the answers to the questions on the SQLZOO website before, and the background reply: SQLZOO, you can get it.

2 、 XUESQL

If SQLZOO's English website reading experience is not very friendly, you can use XUESQL, this site is an all-Chinese version, with corresponding task exercises, as well as matching bilibili tutorials, very suitable for practice.

Website: http://xuesql.cn/

3. Niuke net

There is also the database SQL actual combat in the Niuke.com item bank, there are 60 actual combat questions based on sqlite, which can be debugged after being written. If not, you can take a look at the solution and discussion to see how others do it, but it is still recommended to complete it under your own thinking. The downside is that some of the questions are not clearly described, write out and debug according to your own understanding, and you can only read everyone's discussion to understand what the topic said.

Website: https://www.nowcoder.com/

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.