返回到 Analyzing Big Data with SQL
Cloudera

Analyzing Big Data with SQL

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. By the end of the course, you will be able to • explore and navigate databases and tables using different tools; • 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; and • combine multiple tables in different ways. To use the hands-on environment for this course, you need to download and install a virtual machine and the software on which to run it. Before continuing, be sure that you have access to a computer that meets the following hardware and software requirements: • Windows, macOS, or Linux operating system (iPads and Android tablets will not work) • 64-bit operating system (32-bit operating systems will not work) • 8 GB RAM or more • 25GB free disk space or more • Intel VT-x or AMD-V virtualization support enabled (on Mac computers with Intel processors, this is always enabled; on Windows and Linux computers, you might need to enable it in the BIOS) • For Windows XP computers only: You must have an unzip utility such as 7-Zip or WinZip installed (Windows XP’s built-in unzip utility will not work)

状态:Virtual Machines
状态:Databases
初级课程小时

精选评论

JC

5.0评论日期:Apr 15, 2020

Excellent course even if you have an sql knowledge with a bachelor. Especially the part where it explains the handling of NULLs which is not obvious and I didn't know about.

RJ

5.0评论日期:Oct 25, 2019

Good course to understand the need of SQL in data analysis/big data using good examples and real life data and problem sets.

MP

5.0评论日期:Oct 8, 2019

I have used many platforms to get started with SQL but this has been the best by far. Thank you Cloudera.

M

5.0评论日期:Aug 5, 2020

How amazing the course was! From the video lectures, the reading materials, to the practical exercises and the teachers as well, everything was fantastic in this course. Highly recommended!

JC

5.0评论日期:May 4, 2020

This course helped me a great deal for a job interview as well as for all future querying with Impala and Hive

AF

5.0评论日期:Dec 29, 2020

Brilliant course, one of the best I have done on Coursera! The teaching is phenomenal - thanks guys!

MA

5.0评论日期:Jul 18, 2020

This course was amazing and gave me so much confidence. If you are interested about SQL then this course is a good one.

AS

5.0评论日期:Dec 9, 2020

Great course!I would just add 1 more full business task for practicing before the final one. Anyway, I find the course very useful with clear and understandable explanation.Thank you!

FT

5.0评论日期:Jul 9, 2020

I have took many SQL courses but this is one of the best ,I highly recommend this course to beginners, It takes you from zero to hero.

SA

5.0评论日期:Feb 10, 2021

The course is really informative and laconic. It covers everything you need to analyze data using SQL. Would recommend everyone who wants to learn SQL.

AM

5.0评论日期:Oct 24, 2022

g​reat course even if you know SQL it's quite a fresh reminder and writing the Query on the VMs makes you gain much deaper understanding of the data

MZ

5.0评论日期:Nov 4, 2021

Course contents are well laid out and well taught. Extensive coverage of SELECT statement provides good bases to learn advanced SQL topics as well.

所有审阅

显示:20/148

Navish Agarwal
5.0
评论日期:Aug 13, 2020
Muh Wahyu Setiawan
5.0
评论日期:May 14, 2023
Warren Paterson
4.0
评论日期:Feb 20, 2020
Ingrid cabrera Barrueta
1.0
评论日期:Dec 17, 2022
Hossein Djahedi
5.0
评论日期:Jun 13, 2020
Harshadkumar Dhanji Patel
4.0
评论日期:Feb 25, 2021
J V
3.0
评论日期:Dec 3, 2020
Vikash Kumar Singh
1.0
评论日期:May 19, 2021
Jun-Hoe Lee
5.0
评论日期:Mar 2, 2021
Sai kumar
5.0
评论日期:Mar 4, 2020
Ekaterina Stulova
5.0
评论日期:Apr 5, 2020
Chandu Sasidharan
5.0
评论日期:Jul 30, 2020
Arya Datta 18JE0162
5.0
评论日期:May 28, 2021
Tarun Kumar
5.0
评论日期:Apr 5, 2020
Robby Sim
5.0
评论日期:Mar 22, 2021
Gaurav Mhatre
5.0
评论日期:Jul 1, 2020
Andrey Maltsev
5.0
评论日期:Sep 21, 2020
Nathen Miranda
5.0
评论日期:Jun 5, 2022
Christian Dwyer
5.0
评论日期:Sep 26, 2020
Alex E
5.0
评论日期:May 6, 2021