Foundations for Big Data Analysis 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

( 27 Reviews )

Created by: Glynn Durham

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 98 / 100

Course Description

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.By the end of the course, you will be able to- distinguish operational from analytic databases, and understand how these are applied in big data;- understand how database and table design provides structures for working with data;- appreciate how differences in volume and variety of data affects your choice of an appropriate database system;- recognize the features and benefits of SQL dialects designed to work with big data systems for storage and analysis; and -explore databases and tables in a big data platform.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: 19h

Instructor Details

Glynn Durham

4.9 Rating
27 Reviews

Glynn Durham was born in Louisiana. He earned his Master's Degree in Computer Science at Louisiana State University, where his studies included work with Peter Chen, the developer of entity-relationship modeling, part of a methodology for relational database design. Glynn's work life has been primarily as a technical instructor, and he has been employed for over 5 years each at Oracle, MySQL, Sun Microsystems, and Cloudera.

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

4.9

27 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Feng H on 12-Nov-19

I thought this gave me a very good understanding of the fundamentals of databases and how they interact, update, and store data. This will absolutely help me later on as I had no idea about any of this information.

By Alma A on 13-Nov-19

Great to establish foundations.

By Nikita C on 12-Nov-19

Great course!

By Naveen A on 12-Nov-19

Very well taught - clear and concise.

By Muller H on 21-Aug-19

Best course I have ever taken

By Gianfranco P on 17-Aug-19

good course!!!

By Anas on 15-Aug-19

If you don't have any background about SQL and you don't know where to start, I think this is the best course to start. It simplifies the concepts into easy ideas to be understandable.

By Voleti L on 18-Jul-19

Its really a good start for beginners

By YipengSong on 11-Jul-19

very well explained.

By CHETAN N on 29-Jun-19

Amazing

By Santiago J G M on 4-Aug-19

It was a productive experience overall and a good introduction to the world of big data. A good way to understand the difference between some SLQ engines and how to organize huge amount of data. I'm looking forward to begin the second one.

By Ditya O on 2-Oct-19