Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data Extraction, and Custom Queries (English Edition)

Par : Adam Aspin
Offrir maintenant
Ou planifier dans votre panier
Disponible dans votre compte client Decitre ou Furet du Nord dès validation de votre commande. Le format ePub protégé est :
  • Compatible avec une lecture sur My Vivlio (smartphone, tablette, ordinateur)
  • Compatible avec une lecture sur liseuses Vivlio
  • Pour les liseuses autres que Vivlio, vous devez utiliser le logiciel Adobe Digital Edition. Non compatible avec la lecture sur les liseuses Kindle, Remarkable et Sony
  • Non compatible avec un achat hors France métropolitaine
Logo Vivlio, qui est-ce ?

Notre partenaire de plateforme de lecture numérique où vous retrouverez l'ensemble de vos ebooks gratuitement

Pour en savoir plus sur nos ebooks, consultez notre aide en ligne ici
C'est si simple ! Lisez votre ebook avec l'app Vivlio sur votre tablette, mobile ou ordinateur :
Google PlayApp Store
  • FormatePub
  • ISBN978-93-5551-267-3
  • EAN9789355512673
  • Date de parution28/06/2022
  • Protection num.Adobe DRM
  • Infos supplémentairesepub
  • ÉditeurBPB Publications

Résumé

Carry out real-world analytics to advance your career KEY FEATURES  ? Learning the principles of data analysis with MySQL datasets in a practical manner.? Extensive examples guide the reader through all stages of SQL proficiency, from complete newbie to master.? Includes methods and methodologies for doi
Carry out real-world analytics to advance your career KEY FEATURES  ? Learning the principles of data analysis with MySQL datasets in a practical manner.? Extensive examples guide the reader through all stages of SQL proficiency, from complete newbie to master.? Includes methods and methodologies for doing sophisticated MySQL database queries.  DESCRIPTION This book will take you on an interactive journey to understand SQL querying from the most basic to the most expert level utilising a variety of SQL techniques to extract relevant insights from your MySQL databases. The first section of this book serves as an introduction to the fundamental ideas of both SQL and MySQL.
It then walks readers through constructing queries using simple and then more sophisticated table joins and gradually more advanced data filtering to produce advanced queries based on a range of SQL techniques. The reader will better understand MySQL database analysis by mastering the fundamentals of SQL computation, relational logic, and data grouping and aggregation. SQL fundamentals such as query formatting, constructing subqueries, generating derived tables, joining and filtering tables, etc., are also covered.
In addition, the book explains how to do rolling analysis, study time-series data, and manage huge and complex MySQL datasets. After completing the book, readers can create their methods for analysing relational MySQL datasets and gaining the needed insights. WHAT YOU WILL LEARN? Review SQL concepts like table join, data filtering, query structuring, and table derivation.? Make it easier to work with data that is spread out over several tables with similar or identical structures.? Use simple math and logic, multiple filters, and data aggregation to look at the data.? Learn how to use table expressions, subqueries, and complex calculations well.? Use advanced methods to do rolling analysis and time series analysis.
WHO THIS BOOK IS FORThis book is for data professionals, such as database developers, SQL developers, data analysts, and BI experts, who wish to construct complex queries and extract the desired analytics from their datasets. The book also encourages smart new learners to learn SQL and use it right away in their first jobs.  AUTHOR BIO Adam Aspin is an independent Business Intelligence (BI) consultant based in the United Kingdom.
A graduate of Oxford University, Adam is a database and analytics specialist. He is a frequent contributor to SQLServerCentral.com and Simple Talk and is a regular speaker at MySQL User Groups, SQL Saturdays, Power BI Meetups and conferences such as SQL Bits.