Name: Foundations for Big Data Analysis with SQL
Brand: Cloudera
Availability: OnlineOnly
Rating: 4.7 (273 reviews)

Back to Foundations for Big Data Analysis with SQL

Foundations for Big Data Analysis with SQL

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)

Status: NoSQL

Status: Database Design

BeginnerCourse12 hours

Featured reviews

5.0Reviewed May 10, 2020

I have taken numerous online courses, but I have to say that this instructor and this course truly raise the bar for all. I learned a lot and looked forward to each class.

5.0Reviewed Aug 8, 2020

It's quiet easy to study... Presentation is awesome... I got understand many things that I need to know while selecting the course... Thank you

4.0Reviewed Jul 14, 2021

The first course of this specialization was good and Instructor Sir, Glynn Durham was a good instructor with lot of explanation, examples and acronyms too

4.0Reviewed Dec 2, 2019

Useful concepts for starting to understand and learn how world of big data works. Would have enjoyed to be a bit more practical at last assignment.

4.0Reviewed Jul 2, 2020

It tells you about all the DBMS AND RDBMS stuff and why Big Data is needed and how the changes have occurred but this one is really necessary for one to Know.

4.0Reviewed Jul 31, 2020

Very good Introductory course for getting to know about Big Data . The course structure is well made,I really liked how it took basic Database concepts and then relating that to Big Data.

5.0Reviewed Feb 25, 2020

Excellent course for beginners, that want to get started with big data. This course also help me appreciate traditional RDMS systems while clearing confusions.

5.0Reviewed Dec 25, 2020

Precise and engaging content!Takes a definitive and well-explained approach towards teaching Big Data to you :)Satisfied with the what the content had to offer.

4.0Reviewed Jun 15, 2020

no real hands down, just a bunch of videos, in the end you end up installing a VM with some database samples, but again, no real hands down beyond that, you are on your own to learn...

5.0Reviewed Feb 5, 2021

Superb lecturer, wonderful course. A detailed description of the relational database management system. A good intro for learning hive and impala. Definitely worth taking.

5.0Reviewed Jul 24, 2020

Great course series. Lessons are clear and well made. I learned a great deal about SQL and Database Management and Structure. Highly recommended.

5.0Reviewed Sep 27, 2019

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! :)

All reviews

Showing: 20 of 273

Anoop Bose

5.0

Reviewed Aug 25, 2019

If you are an "absolute" novice with no knowledge about RDBMS and Big Data systems and all help from YouTube videos and other online resources have been of little to no help then you must take this course. It teaches you the very fundamentals of database design and builds your knowledge from ground up. It takes you from "What is DBMS" to a much higher level in a very short span. And Glynn is perhaps the best teacher you've ever met in your life! Give this course a try and you'll be happy and better off for having done so. Good luck and "THANK YOU GLYNN!".

Anas Almoalem

5.0

Reviewed Aug 15, 2019

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.

Anna Chesson

5.0

Reviewed Feb 25, 2020

If you've never had practical working experience with databases, this course gives so much valuable context to anyone pursuing a career working with big data. The material focuses on preparing you with relevant knowledge about database systems (past and present), that supports you in the next courses of the specialization which are more hands-on with coding in SQL-dialects. Initially I did not feel convinced I wanted or needed to understand much database theory covered in this course, and wanted to skip to the hands-on practice. However I've completely changed my mind after completing the course which has drastically improved my understanding of all current big data-base systems, their features, pros/cons, why there are so many variations, and helped me understand which database systems I want to focus learning on next. Unlike googling/studying myself online, I can actually be sure that the information given in this course is relevant and up to date. I highly recommend it, especially to anyone who hasn't had much working experience with databases yet- you'll gain a much better understanding of the current landscape of database technology.

Attila Gulyás

5.0

Reviewed Sep 28, 2019

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! :)

Essie Russ

5.0

Reviewed Oct 20, 2019

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

Abdullah Kassas

5.0

Reviewed Jul 26, 2019

Amazing course, full of useful information, the quiz are good way to test your knowledge and the instructor is an expert in this field and has very good presentation skills.

Hamza Ali

5.0

Reviewed Oct 20, 2019

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

Santiago José Gil Mosquera

4.0

Reviewed Aug 4, 2019

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.

Wei Pei

5.0

Reviewed Aug 16, 2020

This is an introductory foundational course for SQL. You will not actually use the SQL commands. It gives good, clear, and interesting instructions on the concepts and structures of big data and SQL applications. I like the instructor, course format, and level. It makes sense to continue on to the next course in the series to practice SQL commands and the software applications.

Jay Estrela

5.0

Reviewed Apr 2, 2020

Very good introduction to SQL applied to Big Data. The instruction is very clear and the lectures are very relevant. The quizzes and final assignment were mostly appropriate for checking knowledge against subject matter. The VM was also a very effective training aid.

Ahmed Eweed

5.0

Reviewed Sep 10, 2019

Awesome foundation to build on skills of query and analysis of big data and to use big data technologies like Hive and Impala

I Really enjoyed the course and the instructor is perfect

pawan kumar

5.0

Reviewed Jul 27, 2019

Big data is the one of the most emerging technologies in the world and this cloudera course will definitely help us to understand the hive and impala with practical.

Mouhamadou Gueye

5.0

Reviewed Oct 12, 2019

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.

Chandu Sasidharan

5.0

Reviewed Jul 30, 2020

Excellent course! This course, together with the second in this series (which I have already completed) is arguably the best course to start with databases and SQL. Everything is explained from scratch and in a well-organised way so that it's effortless to follow and gain knowledge in a short period. The quizzes are well-drafted and logical, and the course does prepare you for that, unlike in many other courses!

Gary Thomas

5.0

Reviewed Nov 5, 2019

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

Abhinav Singh

5.0

Reviewed Aug 9, 2019

Best course for learning the basic concept about big data and SQL.

Francis Dakubo

5.0

Reviewed Nov 4, 2019

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