Repository navigation
Chapter cross walk: number, file names, title
John David Smith edited this page Feb 8, 2019
·
4 revisions
| Ch # | Chapter Title | File Name | Link Tag |
|---|---|---|---|
| 1 | Introduction | index.Rmd | chapter_introduction |
| 2 | Basic Concepts | 010-basic-concepts.Rmd | chapter_basic-concepts |
| 3 | How to use this book | 020-using-this-book.Rmd | chapter_how-to-use-this-book |
| 4 | Learning Goals and Use Cases | 030-learning-goals-use-cases.Rmd | chapter_learning-goals |
| 5 | Connecting Docker, PostgreSQL, and R | 040-docker-setup-postgres-connect-with-r.Rmd | chapter_connect-docker-postgresql-r |
| 6 | Create the dvdrental database in PostgreSQL in Docker | 050-docker-setup-postgres-with-dvdrental.Rmd | chapter_setup-dvdrental-db |
| 7 | Securing and using your dbms log-in credentials | 060-secure-and-use-dbms-credentials-in-r.Rmd | chapter_dbms-login-credentials |
| 8 | Mapping your local environment | 070-environment-diagram.Rmd | chapter_your-local-environment |
| 9 | Introduction to DBMS queries | 080-elementary-queries.Rmd | chapter_dbms-queries-intro |
| 10 | Lazy Evaluation and Lazy Queries | 090-lazy-evalutation-and-downloading.Rmd | chapter_lazy-evaluation-queries |
| 11 | DBI package and SQL | 100-dbi-and-sql.Rmd | chapter_dbi-package-sql |
| 12 | Introduction to SQL Joins | 110-sql-dplyr-joins.Rmd | chapter_sql-joins |
| 13 | SQL joins and complex queries | 120-sql-joins-and-complex-queries.Rmd | chapter_sql-joins-complex |
| 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 Joins exercises | 150-sql-joins-exercises.Rmd | chapter_sql-joins-exercises |
| 17 | Anti-join cost comparisons | 160-anti-join-cost-comparisons.Rmd | chapter_anti-join-cost-comparisons |
| 18 | SQL Quick start - simple retrieval | 170-sql-quick-start-simple-retrieval.Rmd | chapter_sql-quick-start |
| 19 | Getting metadata about and from PostgreSQL | 180-r-query-postgres-metadata.Rmd | chapter_postgresql-metadata |
| 20 | Drilling into your DBMS environment | 190-drilling-into-db-environment.Rmd | chapter_dbms-environment |
| 21 | Explain queries | 200-explain-queries.Rmd | chapter_explain-queries |
| 22 | SQL queries broken down | 210-sql-query-steps.Rmd | chapter_sql-queries-breakdown |
| 23 | Writing to the DBMS | 220-write-to-the-database.Rmd | chapter_writing-to-the-dbms |
| 24 | NA | 900-appendices-section.Rmd | NA |
| 25 | Other resources | 910-other-resources.Rmd | chapter_appendix-other-resources |
| 26 | Mapping your local environment diagram | 920-environment-diagram.Rmd | chapter_environment-diagram |
| 27 | Creating the sql-pet Docker container one step at a time | 930-docker-detailed-postgres-setup-with-dvdrental.Rmd | chapter_step-at-a-time-docker |
| 28 | APPENDIX D - Quick Guide to SQL | 940-sqlguide.Rmd | chapter_appendix-sql-quick-guide |
| 29 | Additional technical details for Windows users | 950-windows-tech-details.Rmd | chapter_windows-tech-details |
| 30 | Setup instructions | 960-setup-instructions.Rmd | chapter_appendix-setup-instructions |
| 31 | Dplyr functions and SQL cross-walk | 970-dplyr-sql-summary-table.Rmd | chapter_appendix-dplyr-functions |
| 32 | DBI package functions - coverage | 980-dbi-summary-table.Rmd | chapter_appendix-dbi-functions |
| 33 | PostgreSQL Authentication | 990-postgresql-authentication.Rmd | chapter_appendix-postresql-authentication |
| 34 | NA | 999-references.Rmd | NA |