| 1 |
Introduction |
index.Rmd |
chapter_introduction |
| 2 |
How to use this book |
020-using-this-book.Rmd |
chapter_how-to-use-this-book |
| 3 |
Chapter Learning Goals and Use Cases |
030-learning-goals-use-cases.Rmd |
chapter_learning-goals |
| 4 |
Create and connect to the adventureworks database in PostgreSQL |
050-docker-setup-postgres-with-adventureworks.Rmd |
chapter_setup-adventureworks-db |
| 5 |
Securing and using your dbms log-in credentials |
060-secure-and-use-dbms-credentials-in-r.Rmd |
chapter_dbms-login-credentials |
| 6 |
Connecting to the database with R code |
065-connect-to-adventureworks-with-dplyr.Rmd |
chapter_connect-to-db-with-r-code |
| 7 |
Introduction to DBMS queries |
080-elementary-queries.Rmd |
chapter_dbms-queries-intro |
| 8 |
Asking Business Questions From a Single Table |
083-exploring-a-single-table.Rmd |
chapter_exploring-a-single-table |
| 9 |
Sales Forecasting |
085-sales-forecasting.Rmd |
chapter_sales-forecasting |
| 10 |
Lazy Evaluation and Lazy Queries |
090-lazy-evalutation-intro.Rmd |
chapter_lazy-evaluation-queries |
| 11 |
Lazy Evaluation and Execution Environment |
095-lazy-evalutation-and-timing.Rmd |
chapter_lazy-evaluation-and-timing |
| 12 |
Leveraging Database Views |
098-leveraging-database-views.Rmd |
chapter_leveraging-database-views |
| 13 |
DBI package and SQL |
100-dbi-and-sql.Rmd |
chapter_dbi-package-sql |
| 14 |
SQL & dplyr joins additional data |
130-sql-dplyr-joins-data.Rmd |
chapter_sql-dplyr-data |
| 15 |
SQL & dplyr joins |
140-sql-dplyr-joins.Rmd |
chapter_sql-dplyr-joins |
| 16 |
SQL Metadata exercises |
150-sql-joins-exercises.Rmd |
chapter_sql-metadata-exercises |
| 17 |
NA |
153-sql-joins-exercises.Rmd |
NA |
| 18 |
NA |
155-sql-joins-exercises-with-answers.Rmd |
NA |
| 19 |
Anti-join cost comparisons |
160-anti-join-cost-comparisons.Rmd |
chapter_anti-join-cost-comparisons |
| 20 |
SQL Quick start - simple retrieval |
170-sql-quick-start-simple-retrieval.Rmd |
chapter_sql-quick-start |
| 21 |
Getting metadata about and from PostgreSQL |
180-r-query-postgres-metadata.Rmd |
chapter_postgresql-metadata |
| 22 |
Drilling into your DBMS environment |
190-drilling-into-db-environment.Rmd |
chapter_dbms-environment |
| 23 |
SQL queries broken down |
210-sql-query-steps.Rmd |
chapter_sql-queries-breakdown |
| 24 |
NA |
900-appendices-section.Rmd |
NA |
| 25 |
Background and Basic Concepts |
905-background-basic-concepts.Rmd |
appendix_background_basic-concepts |
| 26 |
- Setup instructions |
910-setup-instructions.Rmd |
chapter_appendix-setup-instructions |
| 27 |
Appendix E - Install adventureworks on your own machine |
915-local-setup-with-adventureworks.Rmd |
chapter_appendix-postgres-local-db-installation |
| 28 |
Mapping your local environment diagram |
920-environment-diagram.Rmd |
chapter_environment-diagram |
| 29 |
Appendix B - Additional technical details for Windows users |
920-windows-tech-details.Rmd |
chapter_windows-tech-details |
| 30 |
Appendix C - PostgreSQL Authentication |
930-postgresql-authentication.Rmd |
chapter_appendix-postresql-authentication |
| 31 |
Dplyr functions and SQL cross-walk |
970-dplyr-sql-summary-table.Rmd |
chapter_appendix-dplyr-functions |
| 32 |
DBI package functions - INDEX |
980-dbi-summary-table.Rmd |
chapter_appendix-dbi-index |
| 33 |
Appendix _ Dplyr to SQL translations |
985-dbplyr-sql-translations.Rmd |
chapter_appendix-dplyr-to-postres-translation |
| 34 |
Appendix Additional resources |
997-additional-resources.Rmd |
chapter_appendix-additional-resources |
| 35 |
NA |
999-references.Rmd |
NA |