Chapter 1 Introduction to Database11.1 Overview of database technology 21.1.1 Data21.1.2 Records31.1.3 Databases31.1.4 Database management systems41.1.5 Database systems51.2 Development history of database technology51.2.1 The emergence and development of database technology51.2.2 Comparison of the three stages of data management61.2.5 Hierarchical model, network model and relational model81.2.6 Structured Query Language111.2.7 Characteristics of relational database121.2.8 History review of relational database products121.2.9 Other data models141.2.10 New challenges in data management technology151.2.11 NoSQL database161.2.12 NewSQL181.2.13 Database ranking191.3 Architecture of relational database191.3.1 Development of database architecture191.3.2 Standalone architecture201.3.3 Packet architecture - active/standby211.3.4 Packet architecture - master/slave221.3.5 Packet architecture - master/master221.3.6 Shared storage multi-site architecture231.3.7 Sharding architecture241.3.8 Non-sharing architecture241.3.9 Massively parallel processing architecture 251.3.10 Comparison of the characteristics of database architecture261.4 Main stream application scenarios of relational database271.4.1 Online transaction processing271.4.2 Online analytical processing271.4.3 Measurement indicators of database performance281.5 Summary of the chapter291.6 Exercises30
Chapter 2 Database Fundamentals312.1 Introduction to database management322.1.1 Database management and its scope of work322.1.2 Object management332.1.3 Backup and recovery management342.1.4 Security management382.1.5 Performance management412.1.6 Operation and maintenance management432.2 Important concepts of database462.2.1 Database and cases of database462.2.2 Database connection and session472.2.3 Schema482.2.4 Tablespace492.2.5 Table502.2.6 How tables are stored512.2.7 Partition522.2.8 Data distribution542.2.9 Data types552.2.10 View572.2.11 Index582.2.12 Constraints592.2.13 Transaction612.4 Exercises66Chapter 3 Introduction to SQL Syntax...673.1 Overview of SQL statement683.1.1 Introduction to SQL statement683.1.2 Comprehensive application of SQL statement693.2 Data types693.2.1 Common data types703.2.2 Uncommon data types723.2.3 Cases of data types723.3 System functions733.3.1 Numeric computation functions733.3.2 Character handling functions753.3.3 Date and time functions783.3.4 Type conversion functions803.3.5 System information functions813.4 Operators813.4.1 Logical operators823.4.2 Comparison operators833.4.3 Arithmetic operators833.4.4 Test operators843.4.5 Other operators863.5 Summary863.6 Exercises86
Chapter 4 Classification of SQL Syntax...884.1 Data queries894.1.1 Simple queries894.1.2 Remove duplicate values904.1.3 Query column selection904.1.4 Conditional queries924.1.5 Join queries954.1.6 Subqueries994.1.7 Merge result set1004.1.8 Differential result set1024.1.9 Data packet1024.1.10