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.77%
- 4 stars9.44%
- 3 stars0.78%
- 2 stars0.39%
- 1 star0.59%
TOP REVIEWS FROM ANALYZING BIG DATA WITH SQL
Course contents are well laid out and well taught. Extensive coverage of SELECT statement provides good bases to learn advanced SQL topics as well.
Awesome course. Lots of practical use of analyzing big data with SQL. Thanks Ian for teaching the course. Highly recommend this course if you would like to improve/refresh your SQL skills.
Great overview of SQL. Some decent hands-on and well thought-of quiz questions. Recommended even for people who might know SQL somewhat, but never had a structured overview of it.
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.