ENGLISH

SQL in 7 Days

By Alex Bolenok

Book information

Publisher
bpb
Year
2022
ISBN
9789355512116, 9355512112
Language
english
Format
EPUB
Filesize
3 MB (2966627 bytes)
Pages
300\0
Time added
2023-03-03 17:09:03

Description

This book provides lucid explanations of the features of SQL, beginning with the most fundamental and progressing to the most advanced. You'll be able to learn how to perform everyday SQL operations like adding new entries, modifying or deleting old ones, and performing simple and sophisticated SQL queries with the assistance of this book, which makes learning SQL a more efficient and practical process. This book will teach you some of the more complex features of database management, including joining algorithms, materialized views, optimizers, and indexing, and it will do so by providing you with proven illustrations. Finally, the book demonstrates how to get started with cloud-based database design by providing step-by-step instructions. With case studies drawn from the author's own experience, the book teaches you everything you need to know about SQL. This book walks you through the inner workings of a database system and teaches you how to utilize SQL to get the most out of your database. As the book progresses, you'll get a deeper understanding of database engineering principles that will speed up data mining and analysis. WHAT YOU WILL LEARN ● Perform operations such as projections, joins, filters, aggregations, and CTE. ● Optimize database performance, including indexing, query planning, and materialization. ● Examine client-side and server-side programming for SQL databases. ● Become proficient with OLTP and data warehouse databases. ● Cutting-edge knowledge of cloud database design techniques. WHO THIS BOOK IS FOR This book is for every data professional, including database developers, project managers, database administrators, software engineers, web developers, and full-stack developers, who wish to learn and apply SQL in their development operations quickly. This book may be read by anyone, regardless of whether or not they are familiar with SQL. TABLE OF CONTENTS 1. Basic Concepts 2. Putting Data in 3. Basic Queries 4. Advanced Queries 5. Data Organization 6. Performance 7. Server-Side Programming 8. Client-Side Programming 9. Design and Management KEYWORDS SQL, Database, RDBMS, Relational, Data, PostgreSQL, DB

Similar books

The arraignment and tryall with a declaration of the Ranters also, several sentences proceedings at the sessions in the Old-Baily, and Councel of War: their protestations and the hanging of one up by the thumbs; with divers penalties to be inflicted upon others. The dancing and revelling of Dr. Buckeridge and his wife, and other gent. dancing all in white, in Berkshire, and their Christmas carol. A dispute between a Ranter in Bridewel, and one that came to see him; with his creed and pater noster: and the names of the false gods they worship. As also, a list of many of the Ranters, from whence they are derived: and of many hundreds of them in England

The arraignment and tryall with a declaration of the Ranters also, several sentences proceedings at the sessions in the Old-Baily, and Councel of War: their protestations and the hanging of one up by the thumbs; with divers penalties to be inflicted upon others. The dancing and revelling of Dr. Buckeridge and his wife, and other gent. dancing all in white, in Berkshire, and their Christmas carol. A dispute between a Ranter in Bridewel, and one that came to see him; with his creed and pater noster: and the names of the false gods they worship. As also, a list of many of the Ranters, from whence they are derived: and of many hundreds of them in England

2019 · EPUB

The discoverer; vvherein is set forth (to undeceive the nation) the reall plots and stratagems of Lievt. Col. John Lilburn, Mr. William Walwyn, Mr. Thomas Prince, Mr. Richard Overton, and that partie ... Namely, under the pretence and colour of libertie ... a most dangerous and destructive designe is carried on to deprive the nation of their religion, rights, liberties, proprieties, lawes, government, &c. and to bring a totall and universall ruine upon the land. And so much is here clearely proved. The first part

The discoverer; vvherein is set forth (to undeceive the nation) the reall plots and stratagems of Lievt. Col. John Lilburn, Mr. William Walwyn, Mr. Thomas Prince, Mr. Richard Overton, and that partie ... Namely, under the pretence and colour of libertie ... a most dangerous and destructive designe is carried on to deprive the nation of their religion, rights, liberties, proprieties, lawes, government, &c. and to bring a totall and universall ruine upon the land. And so much is here clearely proved. The first part

2019 · EPUB

An act to impower Sir John Molesworth: Baronet, and Joseph Moyle, Esquire, Two of the surviving Trustees, in an Indenture, dated the Twenty-Fifth Day of December One thousand Seven hundred and Forty-Three, to raise the several Sums in the said Indenture mentioned, or such of them as are still unsatisfied, and pay the same, as well as the rest of the personal Estate of Hugh Gregor, deceased, to such Person as Jane Gregor, an Infant, shall marry during her Infancy, with the Consent of the surviving Trustees, and of her Guardians

An act to impower Sir John Molesworth: Baronet, and Joseph Moyle, Esquire, Two of the surviving Trustees, in an Indenture, dated the Twenty-Fifth Day of December One thousand Seven hundred and Forty-Three, to raise the several Sums in the said Indenture mentioned, or such of them as are still unsatisfied, and pay the same, as well as the rest of the personal Estate of Hugh Gregor, deceased, to such Person as Jane Gregor, an Infant, shall marry during her Infancy, with the Consent of the surviving Trustees, and of her Guardians

EPUB