Tài liệu Beginning SQL Queries - From Novice to Professional

About the Author . xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction . xix
■CHAPTER 1 Relational Database Overview . 1
■CHAPTER 2 Simple Queries on One Table . 17
■CHAPTER 3 A First Look at Joins . 41
■CHAPTER 4 Nested Queries 61
■CHAPTER 5 Self Joins . 77
■CHAPTER 6 More Than One Relationship Between Tables 95
■CHAPTER 7 Set Operations . 107
■CHAPTER 8 Aggregate Operations . 133
■CHAPTER 9 Efficiency Considerations . 153
■CHAPTER 10 How to Approach a Query . 169
■CHAPTER 11 Common Problems . 191
■APPENDIX Sample Database . 209
■INDEX 211