Đang chuẩn bị liên kết để tải về tài liệu:
The Language of SQL- P2

The Language of SQL- P2:Research has shown that, being pressed for time, most readers tend to skip the introduction of any book they happen to read and then proceed immediately to the first real chapter. With that fact firmly in mind, we will only cover relatively unimportant material in the introduction, such as an explanation of what you will and will not learn by reading this book. | About the Author Larry Rockoff has been involved with SQL and Business Intelligence BI development for many years. His main area of expertise is with data warehouse systems and reporting tools. He recently developed a suite of BI tools for ASAP Software a subsidiary of Dell Inc. He holds an MBA from the University of Chicago with a specialization in Management Science. For more information on his current activities or to contact the author please visit LarryRockoff.com. v Contents Introduction .xii Chapter 1 Relational Databases and SQL.1 Language and Logic. 1 SQL Defined.3 Microsoft SQL Server Oracle and MySQL.3 Other Databases.5 Relational Databases.6 Primary and Foreign Keys.7 Datatypes.8 NULL Values. 10 The Significance of SQL. 10 Looking Ahead. 11 Chapter 2 Basic Data Retrieval.13 A Simple SELECT. 13 Syntax Notes. 15 Specifying Columns. 16 Column Names with Embedded Spaces. 17 Looking Ahead. 18 Chapter 3 Calculations and Aliases.19 Calculated Fields. 19 Literal Values.20 vi Contents vii Arithmetic Calculations.22 Concatenating Fields.23 Column Aliases.24 Table Aliases.26 Looking Ahead.27 Chapter 4 Using Functions.29 The Function of Functions.29 Character Functions.30 Composite Functions.36 Date Time Functions.37 Numeric Functions.40 Conversion Functions.41 Looking Ahead.44 Chapter 5 Sorting Data.47 Adding a Sort.47 Sorting in Ascending Order.48 Sorting in Descending Order.49 Sorting by Multiple Columns.50 Sorting by a Calculated Field.51 More on Sort Sequences.52 Looking Ahead.55 Chapter 6 Column-Based Logic.57 IF-THEN-ELSE Logic.57 The Simple Format.58 The Searched Format.60 Looking Ahead.62 Chapter 7 Row-Based Logic.63 Applying Selection Criteria.63 WHERE Clause Operators.65 Limiting Rows.66 Limiting Rows with a Sort.68 Looking Ahead.70 Chapter 8 Boolean Logic.71 Complex Logical .