Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
SQL for Data Analytics - Harness the power of SQL to extract insights from data - cover

SQL for Data Analytics - Harness the power of SQL to extract insights from data

Benjamin Johnston, Upom Malik, Matt Goldwasser, Jun Shan

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

Every day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level.
SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience.
You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation.
By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of analytics professional.
Available since: 08/29/2022.
Print length: 540 pages.

Other books that might interest you

  • Essential Information After High School Graduation - cover

    Essential Information After High...

    Michael Anthony White

    • 0
    • 0
    • 0
    Many subjects critical to personal growth have slowly become regarded as inflammatory: Communication. Culture. Money. Nutrition. Science. Social Media. Politics. Equality. Feminism. 
    Refreshingly operating without bias, these “hot seat” topics are constructively discussed with intelligence and heart — going far beyond the offerings of public school curriculum.
    Show book
  • In RNJesus They Trust - Game Design Your Time & Your Luck - cover

    In RNJesus They Trust - Game...

    Kobra KaiSa, Sage Reedfields

    • 0
    • 0
    • 0
    In RNJesus They Trust: Game Design, Your Time & Your Luck is a witty, sharp-eyed exploration of randomness in modern gaming — and how it blesses, tests, or exploits the players who kneel before it. From the ecstatic thrill of a rare drop to the soul-crushing grind of gacha pulls, game developers have turned RNG (random number generation) into a design pillar that fuels excitement and monetization. But where does randomness stop being fun and start wasting your time — or draining your wallet? This book unpacks that question across genres: MMOs, gacha games, roguelikes, shooters, and strategy titles. It blends game design insight with psychological analysis and a dash of sacred satire, portraying “RNJesus” as the unpredictable deity we’ve all prayed to at 2 AM. Whether you're a game designer, critic, or lifelong gamer tired of losing to the dice, this book offers clarity, laughter, and empowerment. Learn to recognize fair design, spot exploitative patterns, and advocate for gaming systems that respect your time — and your luck.
    Show book
  • Infinity - Why Nothing Ends and Everything Is Possible - cover

    Infinity - Why Nothing Ends and...

    Ylia Callan

    • 0
    • 0
    • 0
    This audiobook is narrated by an AI Voice.   
    Imagine a universe with no edges, no beginning, no end—a universe where every possible version of reality already exists. Infinity: Why Nothing Ends and Everything Is Possible takes you on a journey into the heart of this eternal, infinite cosmos. 
    Through the lens of physics, cosmology, philosophy, and human experience, this book explores: 
    How infinite space and infinite time guarantee that all possibilities exist somewhere. 
    Why consciousness is not an accident, but a fundamental aspect of reality, allowing the universe to know itself. 
    How time is an illusion, and how the “present moment” contains all pasts, all futures, and all possibilities. 
    How infinite versions of “you” exist across timelines, universes, and dimensions, all connected through awareness. 
    How life itself reflects infinity, from the fractal geometry of the cosmos to the way human connection creates infinite reflections in one another. 
    Richly illustrated with metaphors, thought experiments, and poetic insights, this book guides readers to a profound understanding: you are not separate from the infinite - you are an expression of it. When two people meet, when a gaze connects, infinity is mirrored back through consciousness, creating endless patterns of experience and connection. 
    Infinity is a book for those who are curious about the universe, fascinated by consciousness, or seeking a deeper understanding of reality. It blends science, philosophy and spirituality into a coherent vision of life and existence that is both awe-inspiring and deeply practical. 
    Open it, and you will never see yourself - or the universe - the same way again.
    Show book
  • Unleashing Mobile App Innovation - Mastering Mobile App Development: Advanced Techniques and Best Practices - cover

    Unleashing Mobile App Innovation...

    Nathanial Morrison

    • 0
    • 0
    • 0
    Are you prepared to advance your knowledge of developing mobile apps? Discover the upcoming landscape of app development with our in-depth book! 
    To become a skilled app developer, "Unleashing Mobile App Innovation: Mastering Mobile App Development- Advanced Techniques and Best Practices" is the best resource. This book provides insightful tips, strategies, and best practices that will assist you to stand out in the always changing world of mobile apps, regardless of your experience level. 
    Unlock the possibilities of 5G connectivity, AI, and augmented reality. Examine cutting-edge security protocols, cross-platform software development, and moral issues. Discover how to make applications that are unique in the market, satisfy user needs, and stand out. 
    Take advantage of this chance to improve your app development abilities. To start your road towards being an expert in mobile app development, get a copy of "Unleashing Mobile App Innovation: Mastering Mobile App Development- Advanced Techniques and Best Practices" right away. Keep up with the times, be creative, and develop apps that impact the digital world. This is where your journey into mobile app development begins! 
      
     
    Show book
  • Teaching Primary Programming with Scratch Pupil Book Year 4 - cover

    Teaching Primary Programming...

    Phil Bagge

    • 0
    • 0
    • 0
    Scratch teaching and learning made easy thanks to up-to-date, classroom-tested methodologies. Draws on the expertise of Code-IT and HIAS.
    Show book
  • Why We Run - A Natural History - cover

    Why We Run - A Natural History

    Bernd Heinrich

    • 0
    • 0
    • 0
    When Bernd Heinrich decided to write a memoir of his ultramarathon running experience he realized that the preparation for the race was as important, if not more so, than the race itself. Considering the physiology and motivation of running from a scientific point of view, he wondered what he could learn from other animals. 
     
     
     
    In Why We Run, Heinrich considers the flight endurance of birds, the antelope's running prowess and limitations, and the ultra-endurance of camels to understand how human physiology can or cannot replicate these adaptations. With his characteristic blend of scientific inquiry and philosophical musings, Heinrich offers an original and provocative work combining the rigors of science with the passion of running.
    Show book