Learning SQL Queries for R Users: Request the Database to Furnish Only the Specific Data You Require

Learning SQL Queries for R Users: Request the Database to Furnish Only the Specific Data You Require

by Djoni Darmawikarta
     
 
The book title implies that SQL Queries for R Users is for R users who need to get the data they need from a database.
Loading large raw data from a database into R workspace is often unnecessary or even prohibitive.
The book teaches you how to write SQL queries to retrieve precisely only the data needed from an SQL database.
But, this book covers topics on

Overview

The book title implies that SQL Queries for R Users is for R users who need to get the data they need from a database.
Loading large raw data from a database into R workspace is often unnecessary or even prohibitive.
The book teaches you how to write SQL queries to retrieve precisely only the data needed from an SQL database.
But, this book covers topics on metadata, which is equally important if not more than the SQL queries. To write an SQL query you must first know where the data is, the name of the tables and columns, their relationships, and the characteristics of the data. The book shows you how to identify this information.
In Oracle SQL Developer ......

Explore Metadata
Visualize Data Model
Inquire Data Dictionary
Build and Test Query Incrementally
Wrap and Secure Query as Database View
Deploy Generic SELECT query in R program

Product Details

ISBN-13:
9781522959304
Publisher:
CreateSpace Publishing
Publication date:
01/20/2016
Pages:
190
Product dimensions:
6.00(w) x 9.00(h) x 0.40(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >