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

  • Penetration Testing of Computer Networks Using Burpsuite and Various Penetration Testing Tools - cover

    Penetration Testing of Computer...

    Dr. Hidaia Mahmood Alassouli

    • 0
    • 0
    • 0
    Burp Suite is an integrated platform/graphical tool for performing security testing of web applications. Burp suite is a java application that can be used to secure or crack web applications. The suite consists of different tools, like a proxy server, a web spider an intruder and a so-called repeater, with which requests can be automated. You can use Burp's automated and manual tools to obtain detailed information about your target applications.
    Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is damn vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, help web developers better understand the processes of securing web applications and aid teachers/students to teach/learn web application security in a class room environment.
    In this report I am using a combination of Burp tools to detect and exploit vulnerabilities in Damn Vulnerable Web App (DVWA) with low security. By default, Burp Scanner scans all requests and responses that pass through the proxy. Burp lists any issues that it identifies under Issue activity on the Dashboard. You can also use Burp Scanner to actively audit for vulnerabilities. Scanner sends additional requests and analyzes the application's traffic and behavior to identify issues.
    Various examples are outlined in this report for different types of vulnerabilities such as: SQL injection, Cross Site Request Forgery (CSRF), Cross-site scripting, File upload, Local and Remote File Inclusion. I tested various types of penetration testing tools in order to exploit different types of vulnerabilities. The report consists from the following parts:
    1. Installing and Configuring BurpSuite
    2. BurpSuite Intruder.
    3. Installing XMAPP and DVWA App in Windows System.
    4. Installing PHP, MySQL, Apache2, Python and DVWA App in Kali Linux.
    5. Scanning Kali-Linux and Windows Using .
    6. Understanding Netcat, Reverse Shells and Bind Shells.
    7. Adding Burps Certificate to Browser.
    8. Setting up Target Scope in BurpSuite.
    9. Scanning Using BurpSuite.
    10. Scan results for SQL Injection Vulnerability with BurpSuite and Using SQLMAP to Exploit the SQL injection.
    11. Scan Results for Operating System Command Injection Vulnerability with BurpSuite and Using Commix to Exploit the OS Command Injection.
    12. Scan Results for Cross Side Scripting (XSS) Vulnerability with BurpSuite, Using Xserve to exploit XSS Injection and Stealing Web Login Session Cookies through the XSS Injection.
    13. Exploiting File Upload Vulnerability.
    14: Exploiting Cross Site Request Forgery (CSRF) Vulnerability.
    15. Exploiting File Inclusion Vulnerability.
    16. References.
    Show book
  • Exploring the Awesome Depths of the Ocean - cover

    Exploring the Awesome Depths of...

    Susan Casey

    • 0
    • 0
    • 0
    In this 2024 conversation with Justine Willis Toms, Susan Casey, a premiere chronicler of the aquatic world, highlights the complexity and ecological importance of the ocean's depths as she shares her personal and historical perspectives on exploring its mysteries. She points out that we are oddly unacquainted with its depths and importance, which make up more than 70% of Earth’s surface, notwithstanding its depth. She also reports on diving to the pulsing night-club-like life of the Twilight Zone (600-3300 feet) that is filled with bioluminescent creatures that sparkle and glow. Despite these delights, Casey points to the terrestrial bias and the lack of funding for ocean exploration compared to space. There is a need for a better understanding of the ocean's role in regulating the planet's chemistry before engaging in any large-scale mining, which could have severe consequences for the ocean's ecosystem. 
    Susan Casey is the author of several books including: Devil's Teeth: A True Story of Survival and Obsession Among American’s Great White Sharks (Henry Holt 2005)The Wave: In Pursuit of the Rogues, Freaks and Giants of the Ocean (Doubleday 2010)Voices in the Ocean: A Journey into the Wild and Haunting World of Dolphins (Anchor 2016)Underworld: Journeys to the Depths of the Ocean (Doubleday 2023) 
    Interview Date: 8/5/2024         Tags: Susan Casey, ocean, bathysphere, bathyscaphe, submersibles, ocean depths, twilight zone, William Beebe, Otis Barton, Mariana Trench, Wyville Thompson, John Murray, deep sea mining, bottom trawling, ghost nets, Patrick Lahey, Victor Vescovo, Tonga Trench, hydrothermal vents, Ecology/Nature/Environment, History, Science, Technology, Travel
    Show book
  • Galaxy Girls - 50 Amazing Stories of Women in Space - cover

    Galaxy Girls - 50 Amazing...

    Libby Jackson

    • 0
    • 0
    • 0
    Galaxy Girls has descriptive copy which is not yet available from the Publisher.
    Show book
  • Woman Watching - Louise de Kiriline Lawrence and the Songbirds of Pimisi Bay - cover

    Woman Watching - Louise de...

    Merilyn Simonds

    • 0
    • 0
    • 0
    “Woman, Watching is an entrancing blend of biography, memoir, history, research, and homage that is unlike anything I’ve ever read. It’s radical, it’s ravishing.” — Kyo Maclear, author of Birds Art Life
    		 
    From award-winning author Merilyn Simonds, a remarkable biography of an extraordinary woman — a Swedish aristocrat who survived the Russian Revolution to become an internationally renowned naturalist, one of the first to track the mid-century decline of songbirds.
    		 
    Referred to as a Canadian Rachel Carson, Louise de Kiriline Lawrence lived and worked in an isolated log cabin near North Bay. After her husband was murdered by Bolsheviks, she refused her Swedish privilege and joined the Canadian Red Cross, visiting her northern Ontario patients by dogsled. When Elzire Dionne gave birth to five babies, Louise became nurse to the Dionne Quintuplets. Repulsed by the media circus, she retreated to her wilderness cabin, where she devoted herself to studying the birds that nested in her forest. Author of six books and scores of magazine stories, de Kiriline Lawrence and her “loghouse nest” became a Mecca for international ornithologists.
    		 
    Lawrence was an old woman when Merilyn Simonds moved into the woods not far away. Their paths crossed, sparking Simonds’s lifelong interest. A dedicated birder, Simonds brings her own songbird experiences from Canadian nesting grounds and Mexican wintering grounds to this deeply researched, engaging portrait of a uniquely fascinating woman.
    Show book
  • Winter Wind: Cozy White Noise for Baby's Dreamland - For a Quality Baby Sleep Rountine - cover

    Winter Wind: Cozy White Noise...

    Baby Sleep

    • 0
    • 0
    • 0
    This audiobook features the soft, soothing sound of a gentle winter wind, creating a serene and calming white noise ideal for babies. The subtle hum of the breeze helps to drown out distractions, making it easier for your little one to relax and fall asleep. 
    Imagine your baby peacefully falling asleep to the comforting sound of a soft winter wind. The gentle white noise provides warmth and tranquility, ensuring a restful and uninterrupted night’s sleep for your baby. 
    Transform your baby's bedtime into a cozy, peaceful experience. Download Winter Wind: Cozy White Noise for Baby's Dreamland and let the soothing winter wind guide your baby into dreamland.This audiobook features the soft, soothing sound of a gentle winter wind, creating a serene and calming white noise ideal for babies. The subtle hum of the breeze helps to drown out distractions, making it easier for your little one to relax and fall asleep. 
    Imagine your baby peacefully falling asleep to the comforting sound of a soft winter wind. The gentle white noise provides warmth and tranquility, ensuring a restful and uninterrupted night’s sleep for your baby. 
    Transform your baby's bedtime into a cozy, peaceful experience. Download Winter Wind: Cozy White Noise for Baby's Dreamland and let the soothing winter wind guide your baby into dreamland.
    Show book
  • Marx for Cats - A Radical Bestiary - cover

    Marx for Cats - A Radical Bestiary

    Leigh Claire La Berge

    • 0
    • 0
    • 0
    At the outset of Marx for Cats, Leigh Claire La Berge declares that "all history is the history of cat struggle." Revising the medieval bestiary form to meet Marxist critique, La Berge follows feline footprints through Western economic history to reveal an animality at the heart of Marxism. She draws on a twelve-hundred-year arc spanning capitalism's feudal prehistory, its colonialist and imperialist ages, the bourgeois revolutions that supported capitalism, and the communist revolutions that opposed it to outline how cats have long been understood as creatures of economic critique and liberatory possibility. By attending to the repeated archival appearance of lions, tigers, wildcats, and "sabo-tabbies," La Berge argues that felines are central to how Marxists have imagined the economy, and by asking what humans and animals owe each other in a moment of ecological crisis, La Berge joins current debates about the need for and possibility of eco-socialism. In this playful and radical bestiary, La Berge demonstrates that class struggle is ultimately an interspecies collaboration.
    Show book