程序员sql金典(大纲)（Programmer SQL Golden (outline)）.doc

程序员sql金典(大纲)（Programmer SQL Golden (outline)） Back to the top of the first chapter = directory database entry 1.1 database overview 1.1.1 database and database management system What can the 1.1.2 database do? Introduction of 1.1.3 mainstream database management system 1.2 basic concepts of database 1.2.1 catalog 1.2.2 table (table) 1.2.3 column (column) 1.2.4 data type (datatype) 1.2.5 record (record) 1.2.6 primary key (primarykey) 1.2.7 index (index) 1.2.8 table Association The language of the 1.2.9 database -- SQL 1.2.10, DBA, and programmers The second chapter is the establishment and management of data tables 2.1 data type 2.1.1 integer type 2.1.2 numeric type 2.1.3 character correlation type 2.1.4 date, time, type 2.1.5 binary type 2.2 manage data tables through the SQL statement 2.2.1 creates data tables 2.2.2 defines nonempty constraints 2.2.3 defines default values 2.2.4 defines primary keys 2.2.5 defines foreign keys 2.2.6 modifies existing data tables 2.2.7 delete data table Flexible solutions for 2.2.8 restricted operations The third chapter is data addition, deletion and modification 3.1 insertion of data 3.1.1 simple insert statement 3.1.2 simplified insert statement The impact of 3.1.3 non null constraints on data insertion The impact of the 3.1.4 primary key on data insertion The impact of 3.1.5 foreign keys on data insertion 3.2 update data 3.2.1 simple data update 3.2.2 the update statement with the where clause The impact of 3.2.3 non null constraints on data update The impact of the 3.2.4 primary key on data updates The impact of 3.2.5 foreign keys on data updates 3.3 deletion of data 3.3.1 simple data deletion 3.3.2 the delete statement with the where clause The fourth chapter is data retrieval 4.1 basic usage of select 4.1.1 simple data retrieval 4.1.2 retrieves the required columns 4.1.3 column alias 4.1.4 filters by condition 4.1.5 data aggregation 4.1.6 sort 4.2 advanced data filtering 4.2.1 wildcard filtering 4.2.2 null value detection 4.2.