Analyzing Big Data with SQL

This Specialization teaches the essential skills for working with large-scale data using SQL.Maybe you are new to SQL and you want to learn the basics. Or maybe you already have some experience using SQL to query smaller-scale data with relational databases. Either way, if you are interested in gaining the skills necessary to query big data with modern distributed SQL engines, this Specialization is for you.Most courses that teach SQL focus on traditional relational databases, but today, more and more of the data that's being generated is too big to be stored there, and it's growing too quickl

( 10 Reviews )

Created by: Ian Cook

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 100 / 100

Course Description

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)

Time: 25h

Instructor Details

Ian Cook

5.0 Rating
10 Reviews

Ian Cook is a Senior Curriculum Developer at Cloudera. He has authored several R packages and has worked in data scientist roles at TIBCO Software and Advanced Micro Devices. Ian is cofounder of Research Triangle Analysts, the largest data science meetup group in the Raleigh, North Carolina, area. He received his master's degree in statistics from Lehigh University.

The Data Scientist's Toolbox (2019)

5.0 (792 Reviews)

Provider: Coursera
Time: 8h

Free

Python for Data Science (2017)

4.4 (9 Reviews)

Provider: edX

Free

Python A-Z: Python For Data Science With Real Exercises!

Python A-Z: Python For Data Science With Real Exercises! (2021)

4.5 (472 Reviews)

Provider: Udemy
Time: 11h

11.99

More Courses

Reviews

5.0

10 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Hamza a on 10-Nov-19

One of the best course I learned so far on SQL. Comprehensive and Clear in all Terms

By Reuben on 26-Oct-19

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

By Essie R on 20-Oct-19

Another informative course. I feel i learned a lot. I especially like the opportunity to do the honors sections to be more prepared for a Cloudera Certification if I decide to take the test. thank you!

By Amos N on 17-Oct-19

Very informative and educative

By Tau M P on 9-Oct-19

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

By Gianfranco P on 12-Sep-19

i'm enjoyed this course

By Muller H on 11-Sep-19

Great courseVery clear concept

By Santiago J G M on 10-Sep-19

Easy to understand and very well organized all the subjects.

By Emre K on 11-Aug-19

It is a very nice and detailed course and it is completely appropriate for a new starter. The beauty about the course is that it teaches not only the syntax, but also all necessary hints and consideration points. All in all, time well-spent..

By Bashar A on 6-Aug-19