Thursday, April 25, 2019

Beginning SQL Queries From Novice to Professional (2nd Edition)

File Size: 5.88 Mb

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.

About the Author
About the Technical Reviewer
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

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.

Download Drive-1

You May Also Like These E-Books:-

No comments:

Post a Comment