R, Databases & SQL
Preface
Structure of the book
Software information
About the Author
1
Introduction
2
DBI
2.1
Introduction
2.2
Libraries, Code & Data
2.3
Connection
2.3.1
Connection Summary
2.3.2
List Tables
2.3.3
List Fields
2.4
Querying Data
2.4.1
Entire Table
2.4.2
Few Rows
2.4.3
Read Data in Batches
2.5
Query
2.5.1
Query Status
2.5.2
Query Info
2.5.3
Latest Query
2.5.4
Rows Fetched
2.5.5
Rows Affected
2.5.6
Column Info
2.6
Create Table
2.7
Append Data
2.8
Insert Rows
2.9
Remove Table
2.10
SQLite Data Type
2.11
Close Connection
3
dbplyr
3.1
Introduction
3.2
Libraries, Code & Data
3.3
Connect to Database
3.4
Reference Data
3.5
Query Data
3.6
Show Query
3.7
Collect Data
4
SQL Basics
4.1
Introduction
4.2
Libraries, Code & Data
4.3
Set Up
4.4
Select Columns
4.4.1
Syntax
4.4.2
Select Single Column
4.4.3
Select Multiple Columns
4.4.4
Select All Columns
4.5
Limit
4.6
Distinct
4.7
Filter
4.8
And, Or & Not
4.9
BETWEEN
4.10
IN
4.11
IS NULL
4.12
LIKE
5
SQL Advanced
5.1
Introduction
5.2
Libraries, Code & Data
5.3
Set Up
5.4
Aggregate
5.5
Alias
5.6
Order By
5.7
Group By
References
Published with bookdown
R, Databases & SQL
Chapter 1
Introduction