没有合适的资源?快使用搜索试试~ 我知道了~
首页Learning SQL, 2nd Edition
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples.
资源详情
资源评论
资源推荐


Learning SQL, 2nd Edition
By Alan Beaulieu
...............................................
Publisher: O'Reilly Media, Inc.
Pub Date: April 27, 2009
Print ISBN-13: 978-0-596-52083-0
Pages: 336
Slots: 1.0
Table of Contents | Index | Errata
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and
Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly.
Whether you need to write database applications, perform administrative tasks, or generate reports,
Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter
presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and
annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With
this book, you will:
Move quickly through SQL basics and learn several advanced features
Use SQL data statements to generate, manipulate, and retrieve data
Create database objects, such as tables, indexes, and constraints, using SQL schema
statements
Learn how data sets interact with queries, and understand the importance of subqueries
Convert and manipulate data with SQL's built-in functions, and use conditional logic in data
statements
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to
put the power and flexibility of this language to work.
Learning SQL, 2nd Edition
By Alan Beaulieu
...............................................
Publisher: O'Reilly Media, Inc.
Pub Date: April 27, 2009
Print ISBN-13: 978-0-596-52083-0
Pages: 336
Slots: 1.0
Table of Contents | Index | Errata
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and
Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly.
Whether you need to write database applications, perform administrative tasks, or generate reports,
Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter
presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and
annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With
this book, you will:
Move quickly through SQL basics and learn several advanced features
Use SQL data statements to generate, manipulate, and retrieve data
Create database objects, such as tables, indexes, and constraints, using SQL schema
statements
Learn how data sets interact with queries, and understand the importance of subqueries
Convert and manipulate data with SQL's built-in functions, and use conditional logic in data
statements
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to
put the power and flexibility of this language to work.

[ Team Unknown ]
Learning SQL, 2nd Edition
By Alan Beaulieu
...............................................
Publisher: O'Reilly Media, Inc.
Pub Date: April 27, 2009
Print ISBN-13: 978-0-596-52083-0
Pages: 336
Slots: 1.0
Table of Contents | Index | Errata
Copyright
Preface
Chapter 1. A Little Background
Section 1.1. Introduction to Databases
Section 1.2. What Is SQL?
Section 1.3. What Is MySQL?
Section 1.4. What's in Store
Chapter 2. Creating and Populating a Database
Section 2.1. Creating a MySQL Database
Section 2.2. Using the mysql Command-Line Tool
Section 2.3. MySQL Data Types
Section 2.4. Table Creation
Section 2.5. Populating and Modifying Tables
Section 2.6. When Good Statements Go Bad
Section 2.7. The Bank Schema
Chapter 3. Query Primer
Section 3.1. Query Mechanics
Section 3.2. Query Clauses
Section 3.3. The select Clause
Section 3.4. The from Clause
Section 3.5. The where Clause
Section 3.6. The group by and having Clauses
Section 3.7. The order by Clause
orm:knowledge-test 3.8. Test Your Knowledge
Chapter 4. Filtering
Section 4.1. Condition Evaluation
Section 4.2. Building a Condition
Section 4.3. Condition Types
Section 4.4. Null: That Four-Letter Word
orm:knowledge-test 4.5. Test Your Knowledge
Chapter 5. Querying Multiple Tables
Section 5.1. What Is a Join?
Section 5.2. Joining Three or More Tables
Section 5.3. Self-Joins
Section 5.4. Equi-Joins Versus Non-Equi-Joins
Section 5.5. Join Conditions Versus Filter Conditions
orm:knowledge-test 5.6. Test Your Knowledge

Chapter 6. Working with Sets
Section 6.1. Set Theory Primer
Section 6.2. Set Theory in Practice
Section 6.3. Set Operators
Section 6.4. Set Operation Rules
orm:knowledge-test 6.5. Test Your Knowledge
Chapter 7. Data Generation, Conversion, and
Manipulation
Section 7.1. Working with String Data
Section 7.2. Working with Numeric Data
Section 7.3. Working with Temporal Data
Section 7.4. Conversion Functions
orm:knowledge-test 7.5. Test Your Knowledge
Chapter 8. Grouping and Aggregates
Section 8.1. Grouping Concepts
Section 8.2. Aggregate Functions
Section 8.3. Generating Groups
Section 8.4. Group Filter Conditions
orm:knowledge-test 8.5. Test Your Knowledge
Chapter 9. Subqueries
Section 9.1. What Is a Subquery?
Section 9.2. Subquery Types
Section 9.3. Noncorrelated Subqueries
Section 9.4. Correlated Subqueries
Section 9.5. When to Use Subqueries
Section 9.6. Subquery Wrap-up
orm:knowledge-test 9.7. Test Your Knowledge
Chapter 10. Joins Revisited
Section 10.1. Outer Joins
Section 10.2. Cross Joins
Section 10.3. Natural Joins
orm:knowledge-test 10.4. Test Your Knowledge
Chapter 11. Conditional Logic
Section 11.1. What Is Conditional Logic?
Section 11.2. The Case Expression
Section 11.3. Case Expression Examples
orm:knowledge-test 11.4. Test Your Knowledge
Chapter 12. Transactions
Section 12.1. Multiuser Databases
Section 12.2. What Is a Transaction?
orm:knowledge-test 12.3. Test Your Knowledge
Chapter 13. Indexes and Constraints
Section 13.1. Indexes
Section 13.2. Constraints
orm:knowledge-test 13.3. Test Your Knowledge
Chapter 14. Views
Section 14.1. What Are Views?
Section 14.2. Why Use Views?
Section 14.3. Updatable Views
orm:knowledge-test 14.4. Test Your Knowledge

Chapter 15. Metadata
Section 15.1. Data About Data
Section 15.2. Information_Schema
Section 15.3. Working with Metadata
orm:knowledge-test 15.4. Test Your Knowledge
Appendix A. ER Diagram for Example Database
Appendix B. MySQL Extensions to the SQL Language
Section B.1. Extensions to the select Statement
Section B.2. Combination Insert/Update Statements
Section B.3. Ordered Updates and Deletes
Section B.4. Multitable Updates and Deletes
Appendix C. Solutions to Exercises
Section C.1.
Section C.2.
Section C.3.
Section C.4.
Section C.5.
Section C.6.
Section C.7.
Section C.8.
Section C.9.
Section C.10.
Section C.11.
Section C.12.
Section C.13.
Colophon
Index
剩余329页未读,继续阅读
















安全验证
文档复制为VIP权益,开通VIP直接复制

评论0