Skip to main content
Taylor & Francis Group Logo
    Advanced Search

    Click here to search products using title name,author name and keywords.

    • Login
    • Hi, User  
      • Your Account
      • Logout
      Advanced Search

      Click here to search products using title name,author name and keywords.

      Breadcrumbs Section. Click here to navigate to respective pages.

      Chapter

      Database querying using SQL
      loading

      Chapter

      Database querying using SQL

      DOI link for Database querying using SQL

      Database querying using SQL book

      Database querying using SQL

      DOI link for Database querying using SQL

      Database querying using SQL book

      ByBenjamin S. Baumer, Daniel T. Kaplan, Nicholas J. Horton
      BookModern Data Science with R

      Click here to navigate to parent product.

      Edition 2nd Edition
      First Published 2021
      Imprint Chapman and Hall/CRC
      Pages 38
      eBook ISBN 9780429200717
      Share
      Share

      ABSTRACT

      This chapter explores approaches for working with data sets that are larger. Database management systems implementing Structured Query Language (SQL) provide a ubiquitous architecture for storing and querying data that is relational in nature. While the death of SQL has been presaged many times, it continues to provide an effective solution for medium data. The chapter helps the readers learn how to write SQL queries. What is actually happening is that dplyr translates our pipeline into SQL. We can see the translation by passing the pipeline through the show_query() function using our previously created query. The chapter focuses on MySQL, but most aspects are similar in PostgreSQL or SQLite. Every SQL SELECT query must contain SELECT and FROM. The analyst may specify columns to be retrieved.

      T&F logoTaylor & Francis Group logo
      • Policies
        • Privacy Policy
        • Terms & Conditions
        • Cookie Policy
        • Privacy Policy
        • Terms & Conditions
        • Cookie Policy
      • Journals
        • Taylor & Francis Online
        • CogentOA
        • Taylor & Francis Online
        • CogentOA
      • Corporate
        • Taylor & Francis Group
        • Taylor & Francis Group
        • Taylor & Francis Group
        • Taylor & Francis Group
      • Help & Contact
        • Students/Researchers
        • Librarians/Institutions
        • Students/Researchers
        • Librarians/Institutions
      • Connect with us

      Connect with us

      Registered in England & Wales No. 3099067
      5 Howick Place | London | SW1P 1WG © 2022 Informa UK Limited