Modern Big Data Analysis with SQL Specialization

Files Included :

01 welcome-to-the-course.mp4 (21.99 MB)
MP4
01 browsing-tables-with-hue.mp4 (15.58 MB)
MP4
02 browsing-tables-with-sql-utility-statements.mp4 (16.76 MB)
MP4
01 browsing-hdfs-with-the-hue-file-browser.mp4 (28.2 MB)
MP4
02 browsing-hdfs-from-the-command-line.mp4 (19.67 MB)
MP4
01 understanding-s3-and-other-cloud-storage-platforms.mp4 (20.16 MB)
MP4
02 browsing-s3-buckets-from-the-command-line.mp4 (13.44 MB)
MP4
01 week-2-introduction.mp4 (11.07 MB)
MP4
01 introduction-to-the-create-table-statement.mp4 (15.29 MB)
MP4
06 using-different-schemas-on-the-same-data.mp4 (19.99 MB)
MP4
01 specifying-tblproperties.mp4 (9.7 MB)
MP4
01 examining-modifying-and-removing-tables.mp4 (5.15 MB)
MP4
01 hive-and-impala-interoperability.mp4 (11.3 MB)
MP4
02 impala-metadata-refresh.mp4 (13.9 MB)
MP4
01 week-3-introduction.mp4 (6.75 MB)
MP4
01 overview-of-data-types.mp4 (3.67 MB)
MP4
01 choosing-the-right-data-types.mp4 (12.26 MB)
MP4
01 overview-of-file-types.mp4 (11.12 MB)
MP4
01 choosing-the-right-file-types.mp4 (13.48 MB)
MP4
01 week-4-introduction.mp4 (8.92 MB)
MP4
02 refresh-impalas-metadata-cache-after-loading-data.mp4 (9.8 MB)
MP4
01 loading-files-into-hdfs-with-hues-table-browser.mp4 (16.3 MB)
MP4
02 loading-files-into-hdfs-with-hues-file-browser.mp4 (13.81 MB)
MP4
03 loading-files-into-hdfs-from-the-command-line.mp4 (16.47 MB)
MP4
01 loading-files-into-s3-from-the-command-line.mp4 (33.05 MB)
MP4
01 using-hive-and-impala-to-load-data-into-tables.mp4 (11.74 MB)
MP4
04 conclusion.mp4 (10.05 MB)
MP4
01 week-5-introduction.mp4 (8.13 MB)
MP4
01 what-to-do-when-queries-are-too-complex.mp4 (5.79 MB)
MP4
01 what-to-do-when-queries-take-too-long.mp4 (5.06 MB)
MP4
01 when-to-use-table-partitioning.mp4 (30.86 MB)
MP4
01 when-to-use-complex-columns.mp4 (7.92 MB)
MP4
01 file-systems-versus-storage-engines.mp4 (15.26 MB)
MP4
01 welcome-to-the-course.mp4 (15.45 MB)
MP4
02 review-and-preparation.mp4 (17.55 MB)
MP4
01 using-the-hue-query-editors.mp4 (20.44 MB)
MP4
02 running-sql-utility-statements.mp4 (17.13 MB)
MP4
03 running-sql-select-statements.mp4 (15.07 MB)
MP4
04 understanding-different-sql-interfaces.mp4 (13.82 MB)
MP4
01 overview-of-beeline-and-impala-shell.mp4 (5.77 MB)
MP4
02 using-beeline.mp4 (19.68 MB)
MP4
03 using-impala-shell.mp4 (11.5 MB)
MP4
01 introduction.mp4 (9.48 MB)
MP4
02 sql-select-building-blocks.mp4 (8.14 MB)
MP4
01 introduction-to-the-select-list.mp4 (21.37 MB)
MP4
02 expressions-and-operators.mp4 (19.76 MB)
MP4
01 data-types.mp4 (15.92 MB)
MP4
02 column-aliases.mp4 (11.57 MB)
MP4
03 built-in-functions.mp4 (18.12 MB)
MP4
05 data-type-conversion.mp4 (13.18 MB)
MP4
06 the-distinct-keyword.mp4 (13.41 MB)
MP4
01 introduction-to-the-from-clause.mp4 (11.29 MB)
MP4
02 identifiers.mp4 (19.75 MB)
MP4
03 formatting-select-statements.mp4 (11.85 MB)
MP4
01 using-beeline-in-non-interactive-mode.mp4 (13.76 MB)
MP4
02 using-impala-shell-in-non-interactive-mode.mp4 (11.59 MB)
MP4
03 formatting-the-output-of-beeline-and-impala-shell.mp4 (12.12 MB)
MP4
04 saving-hive-and-impala-query-results-to-a-file.mp4 (11.1 MB)
MP4
01 introduction.mp4 (4.63 MB)
MP4
02 about-the-datasets.mp4 (13.72 MB)
MP4
01 introduction-to-the-where-clause.mp4 (5.44 MB)
MP4
02 using-expressions-in-the-where-clause.mp4 (22.31 MB)
MP4
01 comparison-operators.mp4 (24.55 MB)
MP4
02 data-types-and-precision.mp4 (12.16 MB)
MP4
04 logical-operators.mp4 (20.51 MB)
MP4
05 other-relational-operators.mp4 (12.68 MB)
MP4
01 understanding-missing-values.mp4 (27.4 MB)
MP4
02 handling-missing-values.mp4 (19.57 MB)
MP4
05 conditional-functions.mp4 (22.43 MB)
MP4
01 using-variables-with-beeline-and-impala-shell.mp4 (20.97 MB)
MP4
02 calling-beeline-and-impala-shell-from-scripts.mp4 (19.03 MB)
MP4
04 querying-hive-and-impala-in-scripts-and-applications.mp4 (7.4 MB)
MP4
01 introduction.mp4 (5.92 MB)
MP4
01 introduction-to-aggregation.mp4 (6.13 MB)
MP4
02 common-aggregate-functions.mp4 (8.69 MB)
MP4
04 using-aggregate-functions-in-the-select-statement.mp4 (24.48 MB)
MP4
01 introduction-to-the-group-by-clause.mp4 (21.03 MB)
MP4
02 choosing-an-aggregate-function-and-grouping-column.mp4 (15.65 MB)
MP4
03 grouping-expressions.mp4 (22.15 MB)
MP4
04 grouping-and-aggregation-together-and-separately.mp4 (17.91 MB)
MP4
01 null-values-in-grouping-and-aggregation.mp4 (15.35 MB)
MP4
03 the-count-function.mp4 (27.8 MB)
MP4
04 tips-for-applying-grouping-and-aggregation.mp4 (23.12 MB)
MP4
01 filtering-on-aggregates.mp4 (7.66 MB)
MP4
02 the-having-clause.mp4 (27.15 MB)
MP4
01 understanding-hive-and-impala-version-differences.mp4 (30.1 MB)
MP4
02 understanding-hue-version-differences.mp4 (4.43 MB)
MP4
01 introduction.mp4 (4.23 MB)
MP4
01 introduction-to-the-order-by-clause.mp4 (13.09 MB)
MP4
02 controlling-sort-order.mp4 (14.68 MB)
MP4
03 ordering-expressions.mp4 (7.47 MB)
MP4
05 missing-values-in-ordered-results.mp4 (19.65 MB)
MP4
06 using-order-by-with-hive-and-impala.mp4 (13.14 MB)
MP4
01 introduction-to-the-limit-clause.mp4 (11.01 MB)
MP4
02 when-to-use-the-limit-clause.mp4 (19.48 MB)
MP4
03 using-limit-with-order-by.mp4 (22.54 MB)
MP4
04 using-limit-for-pagination.mp4 (22.53 MB)
MP4
01 review.mp4 (13.25 MB)
MP4
01 how-to-effectively-use-the-hive-and-impala-documentation.mp4 (8.91 MB)
MP4
02 tips-for-using-the-hive-documentation.mp4 (15.94 MB)
MP4
03 tips-for-using-the-impala-documentation.mp4 (18.64 MB)
MP4
01 introduction.mp4 (5.67 MB)
MP4
01 combining-query-results-with-the-union-operator.mp4 (21.56 MB)
MP4
03 using-order-by-and-limit-with-union.mp4 (18.08 MB)
MP4
01 introduction-to-joins.mp4 (10.04 MB)
MP4
02 join-syntax.mp4 (19.21 MB)
MP4
03 inner-joins.mp4 (9.24 MB)
MP4
04 outer-joins.mp4 (24.93 MB)
MP4
03 conclusion.mp4 (11.79 MB)
MP4
01 handling-null-values-in-join-key-columns.mp4 (13.03 MB)
MP4
02 non-equijoins.mp4 (4.12 MB)
MP4
03 cross-joins.mp4 (13.15 MB)
MP4
04 left-semi-joins.mp4 (12.78 MB)
MP4
01 welcome-to-the-specialization.mp4 (27.17 MB)
MP4
02 welcome-to-the-course-and-week-1.mp4 (16.24 MB)
MP4
01 what-is-data.mp4 (10.26 MB)
MP4
02 why-organize-data.mp4 (16.25 MB)
MP4
01 what-does-a-dbms-do.mp4 (17.16 MB)
MP4
02 relational-databases-and-sql.mp4 (18.04 MB)
MP4
04 the-success-of-rdbmss-and-sql.mp4 (15.01 MB)
MP4
01 operational-and-analytic-databases.mp4 (15.88 MB)
MP4
02 comparing-operational-and-analytic-dbs-select-statements.mp4 (8.04 MB)
MP4
03 comparing-operational-and-analytic-dbs-dml-activity.mp4 (13.31 MB)
MP4
04 operational-and-analytic-databases-further-comparisons.mp4 (6.12 MB)
MP4
01 welcome-to-week-2.mp4 (5.64 MB)
MP4
01 introducing-table-schemas.mp4 (13.37 MB)
MP4
02 null-values.mp4 (9.97 MB)
MP4
03 data-types.mp4 (11.37 MB)
MP4
01 primary-keys.mp4 (15.39 MB)
MP4
02 foreign-keys.mp4 (17.15 MB)
MP4
03 two-strategies-for-database-design.mp4 (11 MB)
MP4
04 database-normalization.mp4 (24.71 MB)
MP4
05 denormalization.mp4 (17.91 MB)
MP4
06 differences.mp4 (19.52 MB)
MP4
07 trade-offs.mp4 (13.63 MB)
MP4
01 database-transactions.mp4 (21.73 MB)
MP4
02 acid.mp4 (18.1 MB)
MP4
04 enforcing-business-rules-constraints-and-triggers.mp4 (22.07 MB)
MP4
05 business-rules-and-acid-for-analytics.mp4 (18.63 MB)
MP4
01 welcome-to-week-3-and-the-three-vs-of-big-data.mp4 (6.19 MB)
MP4
01 how-big-is-big-data.mp4 (9.97 MB)
MP4
02 distributed-storage.mp4 (20.81 MB)
MP4
03 distributed-processing.mp4 (27.95 MB)
MP4
01 structured-data.mp4 (13.69 MB)
MP4
02 unstructured-data.mp4 (21.79 MB)
MP4
03 semi-structured-data.mp4 (10.72 MB)
MP4
01 strengths-of-traditional-rdbmss.mp4 (14.24 MB)
MP4
02 limitations-of-traditional-rdbmss.mp4 (25.1 MB)
MP4
01 sql-and-structured-data.mp4 (16.8 MB)
MP4
02 sql-and-semi-structured-data.mp4 (15.29 MB)
MP4
03 sql-and-unstructured-data.mp4 (31.96 MB)
MP4
01 welcome-to-week-4.mp4 (5.85 MB)
MP4
01 big-data-analytic-databases-data-warehouses.mp4 (7.07 MB)
MP4
02 nosql-operational-unstructured-and-semi-structured.mp4 (14.13 MB)
MP4
03 non-transactional-structured-systems.mp4 (9.35 MB)
MP4
04 big-data-acid-compliant-rdbmss.mp4 (5.98 MB)
MP4
05 search-engines.mp4 (14.86 MB)
MP4
01 challenges.mp4 (14.77 MB)
MP4
02 what-we-keep.mp4 (10.28 MB)
MP4
03 what-we-give-up.mp4 (16.11 MB)
MP4
04 what-we-add.mp4 (24.63 MB)
MP4
01 where-to-store-big-data.mp4 (22.76 MB)
MP4
02 coupling-of-data-and-metadata.mp4 (20.07 MB)
MP4
01 welcome-to-week-5.mp4 (6.52 MB)
MP4
01 apache-hive.mp4 (20.49 MB)
MP4
02 apache-impala.mp4 (13.79 MB)
MP4
01 exploring-structured-data-in-hue.mp4 (34.78 MB)
MP4
01 welcome-to-the-honors-track.mp4 (8.53 MB)
MP4
04 honors-track-conclusion.mp4 (3.52 MB)
MP4








Free search engine download: Modern Big Data Analysis with SQL Specialization