Modern Big Data Analysis with SQL Specialization

About Course

Unlock the power of modern big data analysis with SQL! This comprehensive specialization, taught by Cloudera, will equip you with the essential skills to query massive datasets using distributed SQL engines.

Whether you’re a SQL beginner or have experience with relational databases, this course is perfect for you. It goes beyond traditional SQL to delve into the world of distributed SQL engines like Hive, Impala, Presto, and Drill, which are crucial for analyzing the vast amounts of data generated today.

This specialization focuses on Hive and Impala, two widely deployed query engines, and provides excellent preparation for the Cloudera Certified Data Analyst (CCA) Certification Exam.

Here’s what you’ll learn:

Master the fundamentals of SQL and its application to big data.
Gain hands-on experience with Hive and Impala, two leading distributed SQL engines.
Learn to write efficient queries to analyze data stored in distributed clusters and cloud storage.
Prepare for the Cloudera Certified Data Analyst (CCA) Certification Exam.

This specialization is completely FREE!

Enroll now and start your journey to becoming a Big Data Analysis expert!

This course is available on Coursera, Udemy, Udacity, MasterClass, NearPeer, and other platforms.

Course Content

01. foundations-big-data-analysis-sql

A Message from the Professor
003 01_welcome-to-the-specialization.mp4

00:00
006 02_welcome-to-the-course-and-week-1.mp4

00:00
007 03_hardware-requirements-for-the-exercise-environment_instructions.html

00:00
010 01_what-is-data.mp4

00:00
013 02_why-organize-data.mp4

00:00
014 03_data-extraction-from-digital-images_instructions.html

00:00
017 01_what-does-a-dbms-do.mp4

00:00
020 02_relational-databases-and-sql.mp4

00:00
021 03_three-notes-about-sql_instructions.html

00:00
024 04_the-success-of-rdbmss-and-sql.mp4

00:00
026 05_references_instructions.html

00:00
030 01_operational-and-analytic-databases.mp4

00:00
033 02_comparing-operational-and-analytic-dbs-select-statements.mp4

00:00
036 03_comparing-operational-and-analytic-dbs-dml-activity.mp4

00:00
039 04_operational-and-analytic-databases-further-comparisons.mp4

00:00
040 05_data-and-databases_exam.html

00:00
043 01_welcome-to-week-2.mp4

00:00
049 02_null-values.mp4

00:00
052 03_data-types.mp4

00:00
055 01_primary-keys.mp4

00:00
058 02_foreign-keys.mp4

00:00
061 03_two-strategies-for-database-design.mp4

00:00
064 04_database-normalization.mp4

00:00
067 05_denormalization.mp4

00:00
070 06_differences.mp4

00:00
073 07_trade-offs.mp4

00:00
074 08_let-there-be-third-normal-form_instructions.html

00:00
077 01_database-transactions.mp4

00:00
080 02_acid.mp4

00:00
081 03_select-statements-in-transactions_instructions.html

00:00
084 04_enforcing-business-rules-constraints-and-triggers.mp4

00:00
087 05_business-rules-and-acid-for-analytics.mp4

00:00
088 06_database-indexes_instructions.html

00:00
089 07_relational-databases_exam.html

00:00
092 01_welcome-to-week-3-and-the-three-vs-of-big-data.mp4

00:00
098 02_distributed-storage.mp4

00:00
101 03_distributed-processing.mp4

00:00
104 01_structured-data.mp4

00:00
107 02_unstructured-data.mp4

00:00
110 03_semi-structured-data.mp4

00:00
111 04_what-about-velocity_instructions.html

00:00
114 01_strengths-of-traditional-rdbmss.mp4

00:00
117 02_limitations-of-traditional-rdbmss.mp4

00:00
120 01_sql-and-structured-data.mp4

00:00
123 02_sql-and-semi-structured-data.mp4

00:00
126 03_sql-and-unstructured-data.mp4

00:00
127 04_big-data_exam.html

00:00
130 01_welcome-to-week-4.mp4

00:00
131 02_open-source-and-apache_instructions.html

00:00
134 01_big-data-analytic-databases-data-warehouses.mp4

00:00
137 02_nosql-operational-unstructured-and-semi-structured.mp4

00:00
140 03_non-transactional-structured-systems.mp4

00:00
143 04_big-data-acid-compliant-rdbmss.mp4

00:00
146 05_search-engines.mp4

00:00
149 01_challenges.mp4

00:00
152 02_what-we-keep.mp4

00:00
155 03_what-we-give-up.mp4

00:00
158 04_what-we-add.mp4

00:00
161 01_where-to-store-big-data.mp4

00:00
164 02_coupling-of-data-and-metadata.mp4

00:00
165 03_sql-tools-for-big-data-analysis_exam.html

00:00
168 01_welcome-to-week-5.mp4

00:00
171 02_instructions-for-downloading-and-installing-the-exercise-environment_instructions.html

00:00
172 03_troubleshooting-the-vm_instructions.html

00:00
175 01_apache-hive.mp4

00:00
178 02_apache-impala.mp4

00:00
181 01_exploring-structured-data-in-hue.mp4

00:00
183 02_database-overview_peer_assignment_instructions.html

00:00
186 01_welcome-to-the-honors-track.mp4

00:00
187 02_preparation-for-the-quiz_certification.html

00:00
190 03_cloudera-certified-associate-data-analyst-certification_exam.html

00:00
193 04_honors-track-conclusion.mp4

00:00
194 01__resources.html

00:00

02. cloud-storage-big-data-analysis-sql

004 02_review-and-preparation_instructions.html

00:00
005 03_instructions-for-downloading-and-installing-the-exercise-environment_instructions.html

00:00
006 04_troubleshooting-the-vm_instructions.html

00:00
009 01_browsing-tables-with-hue.mp4

00:00
012 02_browsing-tables-with-sql-utility-statements.mp4

00:00
015 01_browsing-hdfs-with-the-hue-file-browser.mp4

00:00
018 02_browsing-hdfs-from-the-command-line.mp4

00:00
021 01_understanding-s3-and-other-cloud-storage-platforms.mp4

00:00
024 02_browsing-s3-buckets-from-the-command-line.mp4

00:00
028 01_week-2-introduction.mp4

00:00
030 02_creating-databases-and-tables-with-sql_instructions.html

00:00
031 03_permissions-to-create-databases-and-tables_instructions.html

00:00
034 01_introduction-to-the-create-table-statement.mp4

00:00
035 02_the-row-format-clause_instructions.html

00:00
036 03_the-stored-as-clause_instructions.html

00:00
037 04_the-location-clause_instructions.html

00:00
038 05_create-table-shortcuts_instructions.html

00:00
041 06_using-different-schemas-on-the-same-data.mp4

00:00
045 01_specifying-tblproperties.mp4

00:00
046 02_using-hive-serdes_instructions.html

00:00
047 03_working-with-unstructured-and-semi-structured-data_instructions.html

00:00
050 01_examining-modifying-and-removing-tables.mp4

00:00
051 02_examining-table-structure_instructions.html

00:00
052 03_dropping-databases-and-tables_instructions.html

00:00
053 04_modifying-existing-tables_impala_alter_table.html

00:00
057 01_hive-and-impala-interoperability.mp4

00:00
060 02_impala-metadata-refresh.mp4

00:00
061 01_week-2-practice-quiz_quiz.html

00:00
062 02_week-2-graded-quiz_exam.html

00:00
065 01_week-3-introduction.mp4

00:00
069 02_integer-data-types_instructions.html

00:00
070 03_decimal-data-types_instructions.html

00:00
071 04_character-string-data-types_impala_string.html

00:00
073 05_other-data-types_instructions.html

00:00
076 01_choosing-the-right-data-types.mp4

00:00
077 02_examining-data-types_instructions.html

00:00
078 03_out-of-range-values_instructions.html

00:00
081 01_overview-of-file-types.mp4

00:00
082 02_text-files_instructions.html

00:00
083 03_avro-files_instructions.html

00:00
086 04_parquet-files_instructions.html

00:00
087 05_orc-files_instructions.html

00:00
088 06_other-file-types_instructions.html

00:00
091 01_choosing-the-right-file-types.mp4

00:00
092 02_creating-tables-with-avro-and-parquet-files_instructions.html

00:00
093 01_week-3-practice-quiz_quiz.html

00:00
094 02_week-3-graded-quiz_exam.html

00:00
097 01_week-4-introduction.mp4

00:00
100 02_refresh-impalas-metadata-cache-after-loading-data.mp4

00:00
103 01_loading-files-into-hdfs-with-hues-table-browser.mp4

00:00
106 02_loading-files-into-hdfs-with-hues-file-browser.mp4

00:00
109 03_loading-files-into-hdfs-from-the-command-line.mp4

00:00
110 04_more-about-hdfs-shell-commands_FileSystemShell.html

00:00
112 05_chaining-and-scripting-with-hdfs-commands_instructions.html

00:00
114 06_hdfs-permissions_HdfsPermissionsGuide.html

00:00
118 01_loading-files-into-s3-from-the-command-line.mp4

00:00
120 02_other-ways-to-load-files-into-s3_instructions.html

00:00
122 03_s3-permissions_instructions.html

00:00
124 04_missing-values_instructions.html

00:00
125 05_character-sets_impala_string.html

00:00
127 01_using-sqoop-to-import-data_instructions.html

00:00
128 02_more-sqoop-import-options_instructions.html

00:00
129 03_using-sqoop-to-export-data_instructions.html

00:00
132 01_using-hive-and-impala-to-load-data-into-tables.mp4

00:00
133 02_sql-load-data-statements_instructions.html

00:00
134 03_sql-insert-statements_impala_insert.html

00:00
136 04_sql-insert-select-and-ctas-statements_instructions.html

00:00
137 01_week-4-practice-quiz_quiz.html

00:00
138 02_week-4-graded-quiz_exam.html

00:00
140 03_data-management_peer_assignment_instructions.html

00:00
143 04_conclusion.mp4

00:00
146 01_week-5-introduction.mp4

00:00
150 02_creating-and-querying-views_instructions.html

00:00
151 03_modifying-and-removing-views_instructions.html

00:00
152 04_materialized-and-non-materialized-views_instructions.html

00:00
153 05_the-order-by-clause-in-views_instructions.html

00:00
156 01_what-to-do-when-queries-take-too-long.mp4

00:00
157 02_choosing-which-query-engine-to-use_instructions.html

00:00
158 03_understanding-map-tasks-and-reduce-tasks_instructions.html

00:00
159 04_hive-query-performance-patterns_instructions.html

00:00
160 05_understanding-execution-plans_instructions.html

00:00
161 06_table-and-column-statistics_instructions.html

00:00
162 07_other-strategies-for-query-optimization_instructions.html

00:00
165 01_when-to-use-table-partitioning.mp4

00:00
166 02_creating-partitioned-tables_instructions.html

00:00
167 03_loading-data-with-dynamic-partition_instructions.html

00:00
168 04_loading-data-with-static-partitioning_instructions.html

00:00
169 05_risks-of-using-partitioning_instructions.html

00:00
172 01_when-to-use-complex-columns.mp4

00:00
173 02_complex-data-types_instructions.html

00:00
174 03_creating-tables-with-complex-data_instructions.html

00:00
175 04_querying-complex-data-with-hive_instructions.html

00:00
176 05_querying-complex-data-with-impala_instructions.html

00:00
177 06_complex-data-in-practice_instructions.html

00:00
180 01_file-systems-versus-storage-engines.mp4

00:00
181 02_overview-of-apache-kudu_instructions.html

00:00
182 01_week-5-practice-quiz_quiz.html

00:00
183 02_week-5-graded-quiz_exam.html

00:00
184 01__resources.html

00:00
Section Quiz

03. cloudera-big-data-analysis-sql-queries

006 02_review-and-preparation.mp4

00:00
007 03_instructions-for-downloading-and-installing-the-exercise-environment_instructions.html

00:00
008 04_troubleshooting-the-vm_instructions.html

00:00
009 05_optional-what-about-spark-sql_instructions.html

00:00
011 06_expectations-for-learners_instructions.html

00:00
014 01_using-the-hue-query-editors.mp4

00:00
017 02_running-sql-utility-statements.mp4

00:00
020 03_running-sql-select-statements.mp4

00:00
023 04_understanding-different-sql-interfaces.mp4

00:00
024 05_optional-using-other-sql-engines_instructions.html

00:00
025 06_week-1-core-quiz_exam.html

00:00
028 01_overview-of-beeline-and-impala-shell.mp4

00:00
031 02_using-beeline.mp4

00:00
034 03_using-impala-shell.mp4

00:00
035 04_week-1-honors-quiz_exam.html

00:00
038 01_introduction.mp4

00:00
041 02_sql-select-building-blocks.mp4

00:00
044 01_introduction-to-the-select-list.mp4

00:00
047 02_expressions-and-operators.mp4

00:00
048 03_order-of-operations_instructions.html

00:00
049 04_division-and-modulo-operators_instructions.html

00:00
052 01_data-types.mp4

00:00
055 02_column-aliases.mp4

00:00
058 03_built-in-functions.mp4

00:00
059 04_common-string-functions_instructions.html

00:00
062 05_data-type-conversion.mp4

00:00
065 06_the-distinct-keyword.mp4

00:00
068 01_introduction-to-the-from-clause.mp4

00:00
071 02_identifiers.mp4

00:00
074 03_formatting-select-statements.mp4

00:00
075 04_case-in-sensitivity-in-sql_instructions.html

00:00
076 05_week-2-core-quiz_exam.html

00:00
079 01_using-beeline-in-non-interactive-mode.mp4

00:00
082 02_using-impala-shell-in-non-interactive-mode.mp4

00:00
085 03_formatting-the-output-of-beeline-and-impala-shell.mp4

00:00
088 04_saving-hive-and-impala-query-results-to-a-file.mp4

00:00
089 05_week-2-honors-quiz_exam.html

00:00
092 01_introduction.mp4

00:00
095 02_about-the-datasets.mp4

00:00
096 03_data-reference_instructions.html

00:00
097 04_optional-unicode-characters_instructions.html

00:00
101 01_introduction-to-the-where-clause.mp4

00:00
104 02_using-expressions-in-the-where-clause.mp4

00:00
107 01_comparison-operators.mp4

00:00
110 02_data-types-and-precision.mp4

00:00
111 03_working-with-literal-strings_instructions.html

00:00
114 04_logical-operators.mp4

00:00
117 05_other-relational-operators.mp4

00:00
120 01_understanding-missing-values.mp4

00:00
123 02_handling-missing-values.mp4

00:00
124 03_missing-values-with-logical-operators_instructions.html

00:00
125 04_missing-values-in-string-columns_instructions.html

00:00
128 05_conditional-functions.mp4

00:00
129 06_week-3-core-quiz_exam.html

00:00
132 01_using-variables-with-beeline-and-impala-shell.mp4

00:00
135 02_calling-beeline-and-impala-shell-from-scripts.mp4

00:00
136 03_optional-exercise-change-vm-desktop-color_instructions.html

00:00
139 04_querying-hive-and-impala-in-scripts-and-applications.mp4

00:00
140 05_week-3-honors-quiz_exam.html

00:00
143 01_introduction.mp4

00:00
149 02_common-aggregate-functions.mp4

00:00
150 03_count-and-sum-1_instructions.html

00:00
153 04_using-aggregate-functions-in-the-select-statement.mp4

00:00
154 05_interpreting-aggregates-populations-and-samples_instructions.html

00:00
155 06_the-least-and-greatest-functions_instructions.html

00:00
158 01_introduction-to-the-group-by-clause.mp4

00:00
161 02_choosing-an-aggregate-function-and-grouping-column.mp4

00:00
164 03_grouping-expressions.mp4

00:00
167 04_grouping-and-aggregation-together-and-separately.mp4

00:00
170 01_null-values-in-grouping-and-aggregation.mp4

00:00
171 02_why-aggregate-expressions-ignore-null-values_instructions.html

00:00
174 03_the-count-function.mp4

00:00
177 04_tips-for-applying-grouping-and-aggregation.mp4

00:00
178 05_optional-shortcuts-for-grouping_instructions.html

00:00
179 06_how-grouping-and-aggregation-can-mislead_instructions.html

00:00
182 01_filtering-on-aggregates.mp4

00:00
185 02_the-having-clause.mp4

00:00
003 01_welcome-to-the-course.mp4

00:00
186 03_week-4-core-quiz_exam.html

00:00
189 01_understanding-hive-and-impala-version-differences.mp4

00:00
192 02_understanding-hue-version-differences.mp4

00:00
193 03_week-4-honors-quiz_exam.html

00:00
196 01_introduction.mp4

00:00
202 02_controlling-sort-order.mp4

00:00
205 03_ordering-expressions.mp4

00:00
207 04_ordering-by-string-columns_instructions.html

00:00
211 05_missing-values-in-ordered-results.mp4

00:00
214 06_using-order-by-with-hive-and-impala.mp4

00:00
217 01_introduction-to-the-limit-clause.mp4

00:00
220 02_when-to-use-the-limit-clause.mp4

00:00
223 03_using-limit-with-order-by.mp4

00:00
226 04_using-limit-for-pagination.mp4

00:00
229 01_review.mp4

00:00
230 02_week-5-core-quiz_exam.html

00:00
233 01_how-to-effectively-use-the-hive-and-impala-documentation.mp4

00:00
236 02_tips-for-using-the-hive-documentation.mp4

00:00
239 03_tips-for-using-the-impala-documentation.mp4

00:00
240 04_week-5-honors-quiz_exam.html

00:00
243 01_introduction.mp4

00:00
247 02_missing-or-truncated-values-from-type-conversion_instructions.html

00:00
250 03_using-order-by-and-limit-with-union.mp4

00:00
251 04_using-union-to-combine-three-or-more-results_instructions.html

00:00
254 01_introduction-to-joins.mp4

00:00
257 02_join-syntax.mp4

00:00
260 03_inner-joins.mp4

00:00
263 04_outer-joins.mp4

00:00
264 05_alternative-join-syntax_instructions.html

00:00
265 06_joining-three-or-more-tables_instructions.html

00:00
266 01_week-6-core-quiz_exam.html

00:00
268 02_analyzing-big-data-with-sql_peer_assignment_instructions.html

00:00
271 03_conclusion.mp4

00:00
274 01_handling-null-values-in-join-key-columns.mp4

00:00
277 02_non-equijoins.mp4

00:00
280 03_cross-joins.mp4

00:00
283 04_left-semi-joins.mp4

00:00
284 05_specifying-two-or-more-join-conditions_instructions.html

00:00
285 06_week-6-honors-quiz_exam.html

00:00
286 01__resources.html

00:00
Section Quiz

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

01. foundations-big-data-analysis-sql

A Message from the Professor

003 01_welcome-to-the-specialization.mp4

006 02_welcome-to-the-course-and-week-1.mp4

007 03_hardware-requirements-for-the-exercise-environment_instructions.html

010 01_what-is-data.mp4

013 02_why-organize-data.mp4

014 03_data-extraction-from-digital-images_instructions.html

017 01_what-does-a-dbms-do.mp4

020 02_relational-databases-and-sql.mp4

021 03_three-notes-about-sql_instructions.html

024 04_the-success-of-rdbmss-and-sql.mp4

026 05_references_instructions.html

030 01_operational-and-analytic-databases.mp4

033 02_comparing-operational-and-analytic-dbs-select-statements.mp4

036 03_comparing-operational-and-analytic-dbs-dml-activity.mp4

039 04_operational-and-analytic-databases-further-comparisons.mp4

040 05_data-and-databases_exam.html

043 01_welcome-to-week-2.mp4

049 02_null-values.mp4

052 03_data-types.mp4

055 01_primary-keys.mp4

058 02_foreign-keys.mp4

061 03_two-strategies-for-database-design.mp4

064 04_database-normalization.mp4

067 05_denormalization.mp4

070 06_differences.mp4

073 07_trade-offs.mp4

074 08_let-there-be-third-normal-form_instructions.html

077 01_database-transactions.mp4

080 02_acid.mp4

081 03_select-statements-in-transactions_instructions.html

084 04_enforcing-business-rules-constraints-and-triggers.mp4

087 05_business-rules-and-acid-for-analytics.mp4

088 06_database-indexes_instructions.html

089 07_relational-databases_exam.html

092 01_welcome-to-week-3-and-the-three-vs-of-big-data.mp4

098 02_distributed-storage.mp4

101 03_distributed-processing.mp4

104 01_structured-data.mp4

107 02_unstructured-data.mp4

110 03_semi-structured-data.mp4

111 04_what-about-velocity_instructions.html

114 01_strengths-of-traditional-rdbmss.mp4

117 02_limitations-of-traditional-rdbmss.mp4

120 01_sql-and-structured-data.mp4

123 02_sql-and-semi-structured-data.mp4

126 03_sql-and-unstructured-data.mp4

127 04_big-data_exam.html

130 01_welcome-to-week-4.mp4

131 02_open-source-and-apache_instructions.html

134 01_big-data-analytic-databases-data-warehouses.mp4

137 02_nosql-operational-unstructured-and-semi-structured.mp4

140 03_non-transactional-structured-systems.mp4

143 04_big-data-acid-compliant-rdbmss.mp4

146 05_search-engines.mp4

149 01_challenges.mp4

152 02_what-we-keep.mp4

155 03_what-we-give-up.mp4

158 04_what-we-add.mp4

161 01_where-to-store-big-data.mp4

164 02_coupling-of-data-and-metadata.mp4

165 03_sql-tools-for-big-data-analysis_exam.html

168 01_welcome-to-week-5.mp4

171 02_instructions-for-downloading-and-installing-the-exercise-environment_instructions.html

172 03_troubleshooting-the-vm_instructions.html

175 01_apache-hive.mp4

178 02_apache-impala.mp4

181 01_exploring-structured-data-in-hue.mp4

183 02_database-overview_peer_assignment_instructions.html

186 01_welcome-to-the-honors-track.mp4

187 02_preparation-for-the-quiz_certification.html

190 03_cloudera-certified-associate-data-analyst-certification_exam.html

193 04_honors-track-conclusion.mp4

194 01__resources.html

02. cloud-storage-big-data-analysis-sql

004 02_review-and-preparation_instructions.html