File Size: 5.88 Mb
Description
The syntax of SQL is quite easy to learn. A few basic ideas and a handful of keywords allow you to tackle a huge range of queries. However, many users often find themselves completely stumped when faced with a particular problem. It isn’t really a great deal of help for someone to say “this is how I would do it.” What you need is a variety of ways to get started on a tricky problem. Once you have made a start on a query, you need to be able to check, amend, and refine your solution until you have what you need.
Content:-
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Relational Database Overview
Chapter 2: Simple Queries on One Table
Chapter 3: A First Look at Joins
Chapter 4: Subqueries
Chapter 5: Self Joins
Chapter 6: Multiple Relationships Between Tables
Chapter 7: Set Operations
Chapter 8: Aggregate Operations
Chapter 9: Window Functions
Chapter 10: Efficiency Considerations
Chapter 11: How to Tackle a Query
Chapter 12: Common Problems
Appendix 1: Example Database
Appendix 2: Relational Notation
Index
Author Details
"Clare Churcher" was a senior academic at Lincoln University, Christchurch, New Zealand, for twenty years and won a teaching award for her contribution to developing and delivering several undergraduate and postgraduate courses, including the analysis and design of databases.
You May Also Like These E-Books:-
No comments:
Post a Comment