Skip to content
CourseraData ScienceFree courseCertificate

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

Created by: Glynn Durham

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 98 / 100

icon
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)

icon
Instructor Details

placeholder

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.

icon
Reviews

4.9

27 reviews in total

Select a bar to show only those reviews.Select the bar again to show every rating.

By Alma A on 13-Nov-19

Great to establish foundations.

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 Nikita C on 12-Nov-19

Great course!

By Naveen A on 12-Nov-19

Very well taught - clear and concise.

By Gary T on 5-Nov-19

I learned so much. I intended to continual review the entire material in this course. Thanks All.

By Francis D on 4-Nov-19

Excellent class, earned a lot from the lecturer. Thank you.

By Hamza a on 20-Oct-19

Good course to understand the foundations of big data using good examples and real life problems.

By Essie R on 20-Oct-19

informative background info of Big Data that's good to know about. not too simple or too challenging.

By Adriano S on 16-Oct-19

great course

By GUEYE M on 12-Oct-19

This course was great, I have two years of experience with SQL since I am using SQL in my role of software developer. I've have taken this course in order to initiate myself to big data a field in which I am interested. This course was great experience, it has allowed me to really undestand SQL, RDMBS concepts, learn fundamental concepts of big data and be aware of big data tools used for analyzing huge datasets such Apache HIve and Apache Impala.

By Ditya O on 2-Oct-19

d

By Attila G on 28-Sep-19

The course is an excellent overview of database technologies and introduction into big data. Useful also for those who already worked with a few SQL engines. MIllion thanks to the creators! :)

Showing 12 of 27 reviews