We study SQL. Generation, selection and processing of data. 3rd edition. Bolie A.

As soon as your company is faced with large data streams, they must immediately be forced to work for the benefit of the company (and all of mankind), and the best tool for this is the SQL language. In the third edition of this leadership, its author, Alan Brae, helps developers master the basics of SQL for writing applications working with databases, fulfilling administrative tasks and creating reports. In this edition you will find new chapters on analytical functions, strategies for working with large databases and SQL relations with great data. Each chapter is an independent lesson in a particular key concept or SQL method, which uses numerous illustrations and examples with comments. The exercises cited at the end of the exercises allow you to put the studied material in practice. With the help of this book, you will acquire the knowledge necessary for effective work and can quickly apply all the power and flexibility of the SQL language for practical work. In the book, in particular, the following topics are disclosed. • Studying the basics of SQL and some of its advanced capabilities. • Using SQL instructions for generating, selecting and processing data. • Creating database objects such as tables, indices and restrictions using the instructions of the SQL scheme. • interaction of data sets with requests; The use of subclasses and their importance for building complex requests. • Transformation and manipulation of data using the built -in functions of SQL and applying conditional logic in data instructions.