In this course, you'll get an in-depth look at the SQL SELECT statement and its main clauses. The course focuses on big data SQL engines Apache Hive and Apache Impala, but most of the information is applicable to SQL with traditional RDBMs as well; the instructor explicitly addresses differences for MySQL and PostgreSQL.
This course is part of the Modern Big Data Analysis with SQL Specialization
About this Course
What you will learn
Understand the basics of SELECT statements
Understand how and why to filter results
Explore grouping and aggregation to answer analytic questions
Work with sorting and limiting results
Skills you will gain
- Apache Hive
- Apache Impala
- Data Analysis
- Big Data
Syllabus - What you will learn from this course
Orientation to SQL on Big Data
SQL SELECT Essentials
Grouping and Aggregating Data
- 5 stars88.80%
- 4 stars9.43%
- 3 stars0.78%
- 2 stars0.39%
- 1 star0.58%
TOP REVIEWS FROM ANALYZING BIG DATA WITH SQL
A great course to go over the basic SQL. However, this course doesn't go cover Subquery concept :(
This course helped me a great deal for a job interview as well as for all future querying with Impala and Hive
Great course. Nice assignment at the end.
Maybe you could add a couple of more assignments.
Brilliant course, one of the best I have done on Coursera! The teaching is phenomenal - thanks guys!
About the Modern Big Data Analysis with SQL Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
What are the hardware and software requirements for the exercise environment?
More questions? Visit the Learner Help Center.