Analyzing Big Data with SQL

Welcome to the Course, Review and Preparation, Using the Hue Query Editors, Running SQL Utility Statements, Running SQL SELECT Statements, Understanding Different SQL Interfaces, Overview of Beeline and Impala Shell, Using Beeline, Using Impala Shell, Instructions for Downloading and Installing the Exercise Environment, Troubleshooting the VM, (Optional) What about Spark SQL?, Expectations for Learners, (Optional) Using Other SQL Engines, Week 1 Core Quiz, Week 1 Honors Quiz, Your Expectations

Introduction, SQL SELECT Building Blocks, Introduction to the SELECT List, Expressions and Operators, Data Types, Column Aliases, Built-In Functions, Data Type Conversion, The DISTINCT Keyword, Introduction to the FROM Clause, Identifiers, Formatting SELECT Statements, Using Beeline in Non-Interactive Mode, Using Impala Shell in Non-Interactive Mode, Formatting the Output of Beeline and Impala Shell, Saving Hive and Impala Query Results to a File, Order of Operations, Division and Modulo Operators, Common String Functions, Case (In)Sensitivity in SQL, Week 2 Core Quiz, Week 2 Honors Quiz, Data Analysis and You

Introduction, About the Datasets, Introduction to the WHERE Clause, Using Expressions in the WHERE Clause, Comparison Operators, Data Types and Precision, Logical Operators, Other Relational Operators, Understanding Missing Values, Handling Missing Values, Conditional Functions, Using Variables with Beeline and Impala Shell, Calling Beeline and Impala Shell from Scripts, Querying Hive and Impala in Scripts and Applications, Data Reference, (Optional) Unicode Characters, Working with Literal Strings, Missing Values with Logical Operators, Missing Values in String Columns, (Optional Exercise) Change VM Desktop Color, Week 3 Core Quiz, Week 3 Honors Quiz, Filtering Examples

Introduction, Introduction to Aggregation, Common Aggregate Functions, Using Aggregate Functions in the SELECT Statement, Introduction to the GROUP BY Clause, Choosing an Aggregate Function and Grouping Column, Grouping Expressions, Grouping and Aggregation, Together and Separately, NULL Values in Grouping and Aggregation, The COUNT Function, Tips for Applying Grouping and Aggregation, Filtering on Aggregates, The HAVING Clause, Understanding Hive and Impala Version Differences, Understanding Hue Version Differences, COUNT(*) and SUM(1), Interpreting Aggregates: Populations and Samples, The least and greatest Functions, Why Aggregate Expressions Ignore NULL Values, (Optional) Shortcuts for Grouping, How Grouping and Aggregation Can Mislead, Week 4 Core Quiz, Week 4 Honors Quiz, Grouping and Aggregation Examples, The Analytic Journey

Introduction, Introduction to the ORDER BY Clause, Controlling Sort Order, Ordering Expressions, Missing Values in Ordered Results, Using ORDER BY with Hive and Impala, Introduction to the LIMIT Clause, When to Use the LIMIT Clause, Using LIMIT with ORDER BY, Using LIMIT for Pagination, Review, How to Effectively Use the Hive and Impala Documentation, Tips for Using the Hive Documentation, Tips for Using the Impala Documentation, Ordering by String Columns, Week 5 Core Quiz, Week 5 Honors Quiz, Questions?

Introduction, Combining Query Results with the UNION Operator, Using ORDER BY and LIMIT with UNION, Introduction to Joins, Join Syntax, Inner Joins, Outer Joins, Conclusion, Handling NULL Values in Join Key Columns, Non-Equijoins, Cross Joins, Left Semi-Joins, Missing or Truncated Values from Type Conversion, Using UNION to Combine Three or More Results, Alternative Join Syntax, Joining Three or More Tables, Specifying Two or More Join Conditions, Week 6 Core Quiz, Week 6 Honors Quiz, Analyzing Big Data with SQL, Get Excited!