Read the progress of SQL must know

0 Reading plans

[0] 2015/01/04 ch01~10[1] 2015/01/05 ch10~22

Again, after adding this basic knowledge, switch to the basic SQL section of PostgreSQL (9.4) as soon as possible, and practice the operation of the actual database very early.

----------------------------------------

Directory

The1Chapter UnderstandingSQL
The2Chapter Search Data
The3Chapter Sort Retrieve data
The4Chapter Filter Data
The5Chapter Advanced Data Filtering
The6use wildcard characters for filtering
The7Chapter Create a calculated field
The8chapter using data processing Functions
The9Chapter Summary Data
TheTenChapter grouping Data
The OneChapter using sub-query
The AChapter junction Table
The -Chapter Create an advanced junction
The -Chapter Combination Query
The theChapter Insert Data
The -Chapter Update and delete data
The -Chapter Create and manipulate tables
The -Chapter Usage View
The +chapter using Stored procedures
The -Chapter Management Practical Treatment
The +Chapter using Cursors
The AChapter Learn about advancedSQLfeatures

Read the progress of SQL must know