Mastering SQL: Queries - Take It Easy

1st Edition
id: 301854 not VIP Open in MaM

By Yuli Vasiliev

Language: English

Category: Ebook - Computer/Internet

Categories: Computer/Internet

Size: 901.4 KiB azw3, epub, mobi, pdf Files: 4

Uploader:

Uploaded At: 2016-04-10 23:19:57

AZW3, EPUB, MOBI, PDF, 1st edition 2016

Description

You don’t have to be an SQL guru to realize that adding another condition to the WHERE clause will not pick up your query to a higher level of complexity, since this task can be normally accomplished by a beginner. That’s not a surprise though, taking into account that filtering is perhaps the most common operation when it comes to SQL queries. So it is natural to assume that SQL was designed with filtering in mind. 

Some other SQL coding tasks however may not seem so easy to accomplish, including: aggregating data at different levels, using non-equi joins, fabricating data sets, and handling nulls. As you will learn in this text though, the queries for such tasks do not look frightening once you have them implemented. 

To run the queries provided in this text, you will need access either to MySQL or to Oracle Database (both have versions that you can download and use for free). To be used in other database systems, some adjustments may be necessary. 

Other Torrents