Self-learning SQL, SQL is the standard computer language for accessing and working with databases!

Http://www.w3school.com.cn/sql/index.asp

Self-study is a bumpy and need to persist in SQL. Don't know how to do it if you encounter problems! I did not know how to find the error. Here is the process of learning SQL language with W3cschool. The first step is to build this platform that supports the SQL language.

The software used has three

1windows Environment Preparation

MySQL database: mysql-5.5.22.7z (green version is free to install)

Database modeling tool: Navicat Data Modeler

Database connection tool: Navicat Premium (Of course, you can not use this, with CMD, of course, CMD is not good)

Links: Http://pan.baidu.com/s/1eSCGDs2

1.1

Install the software to start the MySQL database startup method, see the installation instructions.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/99/67/wKioL1lH4qHBQL18AAJZvAp2qvY677.png "style=" float : none; "title=" MySQL Green edition copy c root "alt=" Wkiol1lh4qhbql18aajzvap2qvy677.png "/>

1.2

Attempt to connect using a database client Navicat Premium, Data Modeler These two tools are suitable for most databases.

( oci.dll and local client inconsistencies for Oracle databases 32 and 64 need to be consistent

Ora-28547:connection to server failed,probable Oracle Net admin Error

in the Oracle installation directory (such as D:\app\Administrator\product\11.2.0\client_1\BIN), locate the Oci.dll replacement to the Navicat installation directory (such as D:\Program Files \premiumsoft\navicat premium\instantclient_10_2)

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/99/68/wKiom1lH4qLQUiP6AAEWmFCPrCI264.png "style=" float : none; "title=" Client connection database See Start No "alt=" Wkiom1lh4qlquip6aaewmfcprci264.png "/>

1.3

Create a model and create a table creation condition. Create indexes, internal and external keys what a whole bunch!

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/99/67/wKioL1lH4qKxPw73AAGRIvcLlz4418.png "style=" float : none; "title=" Database modeling tool Modeling "alt=" Wkiol1lh4qkxpw73aagrivcllz4418.png "/>

1.4

Select the type of database here MySQL

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/99/68/wKiom1lH4qPCfG9TAAIQTuXWSl4871.png "style=" float : none; "title=" creates a table and associates "alt=" Wkiom1lh4qpcfg9taaiqtuxwsl4871.png "/>

1.5

Create a good model for synchronous execution of the database

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/99/68/wKiom1lH4qSzwqNOAAHyMGFU1RY289.png "style=" float : none; the "title=" model was successfully poured into the database "alt=" Wkiom1lh4qszwqnoaahymgfu1ry289.png "/>

1.6

Depending on the client tool you can already see the table we created so we can do the learning.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/99/67/wKioL1lH4qTx5HADAALLphqJ5hY865.png "style=" float : none; "title=" synchronizes "alt=" Wkiol1lh4qtx5hadaallphqj5hy865.png "/>

2.1

Open http://www.w3school.com.cn/sql/index.asp Start with a step-by-step study.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/99/68/wKiom1lH4qWA3_kwAAKGQV2PQmo719.png "style=" float : none; "title=" successfully executes query "alt=" Wkiom1lh4qwa3_kwaakgqv2pqmo719.png "/>

2.2 Study not all goes well will have the error, opens oneself to seek the wrong chapter

[SQL] UPDATE person SET FirstName = ' Fred ' WHERE LastName = ' Wilson '

[ERR] 1146-table ' test.person ' doesn ' t exist

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/99/67/wKioL1lH4qfB3H1mAAI7uAoD5Og323.png "style=" float : none; "title=" encountered an error how to exclude "alt=" Wkiol1lh4qfb3h1maai7uaod5og323.png "/>

Self-study is really difficult, I hope everyone can survive. When encountered cannot solve the time (1. Can Baidu, 2 constantly try)

Must first try to ask the master so the memory will be very deep. Hope to write this article on the way of self-study brothers have a little help!

The software used in the Baidu Cloud Connection password: (MBLQ)

The software is from the Internet

This article is from the "Reason" blog, please be sure to keep this source http://reason.blog.51cto.com/9842098/1940045

Self-learning SQL, SQL is the standard computer language for accessing and working with databases!