Learning SQL. Data Generation, Selection, and Processing

The current century can undoubtedly be called the age of information, but information without the ability to select and process it is nothing more than just a set of bytes in data storage. For several decades, the SQL language has provided developers with the ability to efficiently select and process data. It is closely related to relational databases. However, recently, as the importance of large volumes of data has grown, the mentioned language has been evolving in such a way as to facilitate data search in databases built on various technologies. This book features a wide coverage of both topics (from the basics of SQL to complex issues such as analytical functions and working with large databases) and specific databases (MySQL, Oracle Database, SQL Server) and the peculiarities of implementing certain functionalities of SQL on these servers. The book is ideal as a textbook for a beginner developer in the field of databases. It describes all possible applications of the SQL language and the most common database servers.