Beginning SQL Queries: From Novice to Professional
Apress (4-2008) | PDF | 240 pages | 1590599438 | 11.1Mb
Beginning SQL Queries: From Novice to Professional /by Clare Churcher. This book is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results.
* Does not bore with syntax!
* Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
* Provides exceptionally clear examples and explanations
* Is academically sound while being practical and approachable
What you’ll learn
* Write simple queries to extract data from a single table.
* Understand relational algebra and calculus and why they are important.
* Combine data from many tables into one business result.
* Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
* Summarize large amounts of data for reporting purposes.