~Get Your Files Here !

  data-wrangling-analysis-abtesting

   01_data-of-unknown-quality

    01_getting-started

     02_course-introduction.en.srt

     02_course-introduction.mp4

    02_course-dataset

     01_introduction-of-data-of-unknown-quality.en.txt

     02_connecting-to-mode-analytics_Connecting_to_Mode.pdf

     03_introduction-to-the-course-dataset.en.srt

     03_introduction-to-the-course-dataset.mp4

    03_data-of-unknown-quality

     01_error-codes-solution.en.txt

     02_flexible-data-formats.en.srt

     02_flexible-data-formats.mp4

     03_flexible-data-formats-solution.en.txt

     04_identifying-unreliable-data-nulls.en.srt

     04_identifying-unreliable-data-nulls.mp4

     05_unreliable-data-part-1-solution.en.txt

     06_unreliable-data-part-2-solution.en.srt

     06_unreliable-data-part-2-solution.mp4

     07_unreliable-data-part-3-solution.en.txt

     08_answering-ambiguous-questions.en.srt

     08_answering-ambiguous-questions.mp4

     09_users-table-solution.en.txt

    04_review

   02_creating-clean-datasets

    01_creating-clean-datasets

     01_creating-clean-datasets-introduction.en.txt

     02_tools-of-the-trade-coding-guide-with-sublime-text-optional.en.srt

     02_tools-of-the-trade-coding-guide-with-sublime-text-optional.mp4

     03_data-types.en.txt

     04_what-is-a-dependency.en.srt

     04_what-is-a-dependency.mp4

     05_create-a-view-item-table.en.txt

     06_turn-a-clean-query-into-a-table-activity-solution.en.srt

     06_turn-a-clean-query-into-a-table-activity-solution.mp4

     07_hierarchy-of-data.en.txt

     08_create-user-info-table.en.srt

     08_create-user-info-table.mp4

     09_create-a-user-snapshot-table-activity-solution.en.txt

     10_partitions-in-hive-optional.en.srt

     10_partitions-in-hive-optional.mp4

   03_sql-problem-solving

    01_sql-problem-solving

     01_introduction-to-sql-problem-solving.en.txt

     02_map-out-your-joins.en.srt

     02_map-out-your-joins.mp4

     03_test-queries-vs-final-queries.en.txt

     04_example-create-an-aggregate-table-with-a-rolling-date-period.en.srt

     04_example-create-an-aggregate-table-with-a-rolling-date-period.mp4

     05_rolling-orders-solution.en.txt

     06_find-each-users-most-recently-viewed-page-for-an-email-campaign.en.srt

     06_find-each-users-most-recently-viewed-page-for-an-email-campaign.mp4

     07_review-windowing-functions.en.txt

     08_promo-email-solution.en.srt

     08_promo-email-solution.mp4

     09_product-analysis.en.txt

     10_product-analysis-solution.en.srt

     10_product-analysis-solution.mp4

     11_coding-with-style.en.txt

   04_case-study-ab-testing

    01_case-study-ab-testing

     01_how-is-ab-testing-used.en.txt

     02_statistics-refresher-optional.en.srt

     02_statistics-refresher-optional.mp4

     03_test-assignments.en.txt

     04_test-assignments-solution.en.srt

     04_test-assignments-solution.mp4

     05_create-a-new-metric.en.txt

     06_creating-a-new-metric-solution.en.srt

     06_creating-a-new-metric-solution.mp4

     07_analyze-results.en.txt

     08_analyzing-results-solution.en.srt

     08_analyzing-results-solution.mp4

    02_final-project

     01_peer-review-overview.en.txt

     01_peer-review-overview_Peer_Review_Assignments.pdf

    03_course-summary

     02_course-summary.en.srt

     02_course-summary.mp4

  spark-sql

   01_introduction-to-spark

    01_getting-started

     02_course-introduction.en.srt

     02_course-introduction.mp4

    02_introduction-to-spark

     01_why-distributed-computing.en.txt

     02_spark-dataframes.en.srt

     02_spark-dataframes.mp4

     03_the-databricks-environment.en.txt

     04_sql-in-notebooks.en.srt

     04_sql-in-notebooks.mp4

     05_import-data.en.txt

     06_readings-and-resources_Lessons.dbc

     06_readings-and-resources_instructions.html

    03_queries-in-spark-sql

   02_spark-core-concepts

    01_spark-core-concepts

     01_module-introduction.en.txt

     02_spark-terminology.en.srt

     02_spark-terminology.mp4

     03_caching.en.txt

     04_shuffle-partitions.en.srt

     04_shuffle-partitions.mp4

     05_spark-ui.en.txt

     06_adaptive-query-execution-aqe.en.srt

     06_adaptive-query-execution-aqe.mp4

     07_readings_instructions.html

    02_spark-internals

   03_engineering-data-pipelines

    01_engineering-data-pipelines

     01_module-introduction.en.txt

     02_spark-as-a-connector.en.srt

     02_spark-as-a-connector.mp4

     03_accessing-data.en.txt

     04_file-formats.en.srt

     04_file-formats.mp4

     05_json-schemas-and-types.en.txt

     06_writing-data.en.srt

     06_writing-data.mp4

     07_tables-and-views.en.txt

     08_readings_instructions.html

    02_engineering-data-pipelines

   04_data-lakes-warehouses-and-lakehouses

    01_data-lakes-warehouses-and-lakehouses

     01_module-introduction.en.txt

     02_data-lakes-vs-data-warehouses.en.srt

     02_data-lakes-vs-data-warehouses.mp4

     03_what-is-a-lakehouse.en.txt

     04_delta-lake.en.srt

     04_delta-lake.mp4

     05_delta-lake-demo.en.txt

     06_delta-advanced-features-demo.en.srt

     06_delta-advanced-features-demo.mp4

     07_continuing-with-spark-and-data-science.en.txt

     08_readings_diving-into-delta-lake-dml-internals-update-delete-merge.html

     08_readings_diving-into-delta-lake-unpacking-the-transaction-log.html

     08_readings_introducing-delta-time-travel-for-large-scale-data-lakes.html

    02_lakehouse

    03_course-summary

     01_course-summary.en.txt

   05_Resources

    01_week-1-resource-notebook

     01__resources.html

  sql-data-science-capstone

   01_getting-started-and-milestone-1-project-proposal-and-data-selection-preparation

    01_getting-started

     02_course-introduction-and-welcome.en.srt

     02_course-introduction-and-welcome.mp4

    02_milestone-1-project-proposal-and-data-selection-preparation

     01_milestone-1-introduction.en.txt

     01_milestone-1-introduction_DSV1070_L01.1.pdf

     02_the-proposal-process.en.txt

     03_choose-your-client-dataset_instructions.html

     04_import-of-elon-musk-data.en.txt

     05_initial-feature-exploration-hypotheses.en.srt

     05_initial-feature-exploration-hypotheses.mp4

     06_entity-relationship-diagram-erd-for-analysis.en.txt

    03_resources

     01_data-models-part-1-thinking-about-your-data.en.txt

     01_data-models-part-1-thinking-about-your-data_Data_Models_Part_1_Thinking_About_Your_Data.pdf

     02_data-models-part-2-the-evolution-of-data-models.en.txt

     02_data-models-part-2-the-evolution-of-data-models_The_Evolution_of_Data_Models.pdf

     03_data-models-part-3-relational-vs-transactional-models.en.txt

     03_data-models-part-3-relational-vs-transactional-models_Data_Models_Part_3_Relational_vs_Transactional_Models

     04_sql-in-notebooks.en.txt

     04_sql-in-notebooks_SQL_in_Notebooks.pdf

     05_import-data.en.txt

     05_import-data_Import_Data.pdf

     06_introduction-of-data-of-unknown-quality.en.txt

     07_connecting-to-mode-analytics_Connecting_to_Mode.pdf

    04_milestone-1-assignment

   02_milestone-2-descriptive-stats-understanding-your-data

    01_milestone-2-descriptive-stats-understanding-your-data

     01_milestone-2-introduction.en.txt

     01_milestone-2-introduction_DSV1070_L02.1.pdf

     02_importance-of-understanding-your-data.en.txt

     02_importance-of-understanding-your-data_DSV1070_L02.2.pdf

     03_foundational-stats-in-sql-sheets.en.txt

     04_pandas-teach-on-stats.en.srt

     04_pandas-teach-on-stats.mp4

     05_visualization-with-raw-graphics-io.en.srt

     05_visualization-with-raw-graphics-io.mp4

     06_impact-of-findings-on-hypotheses.en.txt

    02_resources

     01_statistics-refresher-optional.en.txt

     02_additional-resources_descriptive-statistics-in-sql.html

     02_additional-resources_instructions.html

   03_milestone-3-beyond-descriptive-stats-dive-deeper-go-broader

    01_milestone-3-beyond-descriptive-stats

     01_milestone-3-introduction.en.txt

     01_milestone-3-introduction_DSV1070_L03.1.pdf

     02_tf-idf-for-word-frequency-theme-analysis.en.txt

     03_text-analysis-of-elon-musk-tweets.en.srt

     03_text-analysis-of-elon-musk-tweets.mp4

    02_resources

     01_create-a-new-metric.en.txt

     02_analyze-results.en.srt

     02_analyze-results.mp4

   04_milestone-4-presenting-your-findings-storytelling

    01_milestone-4-presenting-your-findings-storytelling

     01_milestone-4-introduction.en.txt

     01_milestone-4-introduction_DSV1070_L04.1.pdf

     02_sample-output-presentation.en.txt

    02_resources

     02_resources-on-audience_instructions.html

     04_finding-the-story_instructions.html

     06_tell-the-story-of-your-data_instructions.html

     07_module-introduction.en.txt

     07_module-introduction_Modifying_and_Analyzing_Data_with_SQL.pdf

     08_working-with-text-strings.en.txt

     08_working-with-text-strings_Working_with_Text_Strings.pdf

     09_working-with-date-and-time-strings.en.txt

     09_working-with-date-and-time-strings_Working_with_Date_and_Time_Strings.pdf

     10_date-and-time-strings-examples.en.txt

     10_date-and-time-strings-examples_Date_and_Time_String_Examples.pdf

     11_case-statements.en.txt

     11_case-statements_Case_Statements.pdf

     12_views.en.txt

     12_views_Views.pdf

     13_data-governance-and-profiling.en.txt

     13_data-governance-and-profiling_Data_Governance_and_Profiling.pdf

     14_using-sql-for-data-science-part-1.en.txt

     14_using-sql-for-data-science-part-1_Using_SQL_for_Data_Science_Part_1.pdf

     15_using-sql-for-data-science-part-2.en.txt

     15_using-sql-for-data-science-part-2_Using_SQL_for_Data_Science_Part_2.pdf

    03_summary

     01_course-summary.en.txt

  sql-for-data-science

   01_getting-started-and-selecting-retrieving-data-with-sql

    01_getting-started

     01_course-introduction.en.txt

    02_selecting-and-retrieving-data-with-sql

     01_module-introduction.en.txt

     01_module-introduction_Selecting_and_Retrieving_Data_with_SQL.pdf

     02_what-is-sql-anyway.en.txt

     02_what-is-sql-anyway_What_Is_SQL_Anyway.pdf

     03_data-models-part-1-thinking-about-your-data.en.txt

     03_data-models-part-1-thinking-about-your-data_Data_Models_Part_1_Thinking_About_Your_Data.pdf

     04_data-models-part-2-the-evolution-of-data-models.en.txt

     04_data-models-part-2-the-evolution-of-data-models_The_Evolution_of_Data_Models.pdf

     05_data-models-part-3-relational-vs-transactional-models.en.txt

     05_data-models-part-3-relational-vs-transactional-models_Data_Models_Part_3_Relational_vs_Transactional_Models.

     06_retrieving-data-with-a-select-statement.en.txt

     06_retrieving-data-with-a-select-statement_Retrieving_Data_with_a_Select_Statement.pdf

     07_creating-tables.en.txt

     07_creating-tables_Creating_Tables.pdf

     08_creating-temporary-tables.en.txt

     08_creating-temporary-tables_Creating_Temporary_Tables.pdf

     09_adding-comments-to-sql.en.txt

     09_adding-comments-to-sql_Adding_Comments_to_SQL.pdf

     11_practice-simple-select-queries_quiz.html

     12_summary.en.txt

     12_summary_Module_1_Summary.pdf

     13_sql-overview_instructions.html

     14_data-modeling-and-er-diagrams_instructions.html

    03_review

     02_module-1-coding-questions_exam.html

   02_filtering-sorting-and-calculating-data-with-sql

    01_filtering-sorting-and-calculating-data-with-sql

     01_module-introduction.en.txt

     01_module-introduction_Filtering_Sorting_and_Calculating_Data_with_SQL.pdf

     02_basics-of-filtering-with-sql.en.txt

     02_basics-of-filtering-with-sql_Basics_of_Filtering_with_SQL.pdf

     03_advanced-filtering-in-or-and-not.en.txt

     03_advanced-filtering-in-or-and-not_Advanced_Filtering_IN_OR_NOT.pdf

     04_using-wildcards-in-sql.en.txt

     04_using-wildcards-in-sql_Using_Wildcards_in_SQL.pdf

     05_sorting-with-order-by.en.txt

     05_sorting-with-order-by_Sorting_with_ORDER_BY.pdf

     06_math-operations.en.txt

     06_math-operations_Math_Operations.pdf

     07_aggregate-functions.en.txt

     07_aggregate-functions_Aggregate_Functions.pdf

     08_grouping-data-with-sql.en.txt

     08_grouping-data-with-sql_Grouping_Data_with_SQL.pdf

     09_putting-it-all-together.en.txt

     09_putting-it-all-together_Putting_It_All_Together.pdf

     11_sql-for-various-data-science-languages_index.html

     11_sql-for-various-data-science-languages_sql-programming-guide.html

    02_review-and-practice

     02_module-2-coding-assignment_exam.html

   03_subqueries-and-joins-in-sql

    01_subqueries-and-joins-in-sql

     01_module-introduction.en.txt

     01_module-introduction_Subqueries_and_Joins_with_SQL.pdf

     02_using-subqueries.en.txt

     02_using-subqueries_Using_Subqueries.pdf

     03_subquery-best-practices-and-considerations.en.txt

     03_subquery-best-practices-and-considerations_Subquery_Best_Practices_and_Considerations.pdf

     04_joining-tables-an-introduction.en.txt

     04_joining-tables-an-introduction_Joining_Tables_An_Introduction.pdf

     05_cartesian-cross-joins.en.txt

     05_cartesian-cross-joins_Cartesian_Cross_Joins.pdf

     06_inner-joins.en.txt

     06_inner-joins_Inner_Joins.pdf

     07_aliases-and-self-joins.en.txt

     07_aliases-and-self-joins_Aliases_and_Self_Joins.pdf

     08_advanced-joins-left-right-and-full-outer-joins.en.txt

     08_advanced-joins-left-right-and-full-outer-joins_Advanced_Joins_Left_Right_and_Full_Outer_Joins.pdf

     09_unions.en.txt

     09_unions_Unions.pdf

     11_summary.en.srt

     11_summary.mp4

     12_sql-and-python_instructions.html

    02_review-and-practice

     02_module-3-coding-assignment_exam.html

   04_modifying-and-analyzing-data-with-sql

    01_modifying-and-analyzing-data-with-sql

     01_module-introduction.en.txt

     01_module-introduction_Modifying_and_Analyzing_Data_with_SQL.pdf

     02_working-with-text-strings.en.txt

     02_working-with-text-strings_Working_with_Text_Strings.pdf

     03_working-with-date-and-time-strings.en.txt

     03_working-with-date-and-time-strings_Working_with_Date_and_Time_Strings.pdf

     04_date-and-time-strings-examples.en.txt

     04_date-and-time-strings-examples_Date_and_Time_String_Examples.pdf

     05_case-statements.en.txt

     05_case-statements_Case_Statements.pdf

     06_views.en.txt

     06_views_Views.pdf

     07_data-governance-and-profiling.en.txt

     07_data-governance-and-profiling_Data_Governance_and_Profiling.pdf

     08_using-sql-for-data-science-part-1.en.txt

     08_using-sql-for-data-science-part-1_Using_SQL_for_Data_Science_Part_1.pdf

     09_using-sql-for-data-science-part-2.en.txt

     09_using-sql-for-data-science-part-2_Using_SQL_for_Data_Science_Part_2.pdf

    02_review-and-practice

     02_module-4-coding-questions_exam.html

    03_peer-review-assignment

     02_data-scientist-role-play-profiling-and-analyzing-the-yelp-dataset_YelpDataCourseraPR2.txt

     03_yelp-dataset-sql-lookup_instructions.html

    04_course-summary

     01_course-summary.en.txt