02 welcome-to-sql-for-data-science (8.14 MB)
03 select-statement (5.75 MB)
04 count-distinct-limit (3.29 MB)
05 insert-statement (3.41 MB)
06 update-and-delete-statements (4.13 MB)
01 introduction-to-databases (7.06 MB)
02 relational-database-concepts (7.4 MB)
03 types-of-sql-statements-ddl-vs-dml (3.03 MB)
04 create-table-statement (5.17 MB)
05 alter-drop-and-truncate-tables (5.89 MB)
02 how-to-create-a-database-instance-on-cloud (9.82 MB)
01 using-string-patterns-and-ranges (5.96 MB)
02 sorting-result-sets (3.64 MB)
03 grouping-result-sets (4.47 MB)
01 built-in-database-functions (8.09 MB)
02 date-and-time-built-in-functions (5.17 MB)
03 sub-queries-and-nested-selects (6.47 MB)
04 working-with-multiple-tables (8.31 MB)
01 why-use-r-with-relational-databases (3.78 MB)
02 r-persistence-options (2.05 MB)
03 terminology-comparison (2.94 MB)
04 mapping-data-between-r-and-rdbms (3.47 MB)
05 database-design-considerations (4.3 MB)
01 connectivity-options (4.34 MB)
02 connecting-with-rjdbc (4.72 MB)
03 connectivity-using-odbc (4.84 MB)
04 rodbc-in-detail (7.52 MB)
05 metadata-discovery (5.19 MB)
01 working-with-data (6.36 MB)
02 database-design-and-data-preparation (3.88 MB)
03 creating-physical-database-objects (5.16 MB)
04 loading-the-data (1.94 MB)
05 querying-data-sql-select (6.58 MB)
06 analyzing-the-data (4.25 MB)