"SQL Meditations" uses a large number of examples to explain in detail the fundamental changes in thinking methods that must be faced in order to improve SQL programming skills - from thinking in procedural programming to thinking in terms of data sets. In addition, this book also discusses the application of lookup tables, views, auxiliary tables, and virtual tables in SQL programming, and uniquely describes how to correctly handle time values in the SQL system and other technical difficulties in SQL programming.
Directory:
Chapter 1 SQL is a declarative language, not a procedural language
Chapter 2 Hardware, data volume and maintaining database
Chapter 3 Data Access and Logging
Chapter 4 Lookup Table
Chapter 5 Auxiliary Table
Chapter 6 View
Chapter 7 Virtual Table
Chapter 8 Complex functions implemented using tables
Chapter 9 Tenses Table
Chapter 10 Cleaning data using non-first normal form tables
Chapter 11 Thinking in SQL
Chapter 12 Group Characteristics
Chapter 13: Turn technical specifications into code
Chapter 14 Using Procedures and Function Calls
Chapter 15 Row Numbering
Chapter 16 Saving Calculated Data
Chapter 17 Constraint Triggers
Chapter 18 Procedural Solutions and Data-Driven Solutions
Statement:
All resources on this website are contributed and published by netizens, or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this website are for learning and reference only. Please do not use them for commercial purposes, otherwise you will be responsible for all consequences incurred! If there is any infringement, please contact us to delete and remove it. Contact information: admin@php.cn