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)
MP
I have used many platforms to get started with SQL but this has been the best by far. Thank you Cloudera.
JC
This course helped me a great deal for a job interview as well as for all future querying with Impala and Hive
M
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
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.
MA
This course was amazing and gave me so much confidence. If you are interested about SQL then this course is a good one.
AM
great 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
AF
Brilliant course, one of the best I have done on Coursera! The teaching is phenomenal - thanks guys!
SA
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.
MZ
Course contents are well laid out and well taught. Extensive coverage of SELECT statement provides good bases to learn advanced SQL topics as well.
RK
This Course was amazing. I have never seen such a well explained MOOC like this . Superb Content and Knoweledge is there.
AS
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
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.
Showing: 20 of 148
This is a great course overall!
Having taken a couple of SQL courses over the years, they are often quite dry. Somehow, this one was much better. I liked the conceptual aspects covered with the syntax & applications. Rounded the education out quite well.
The only thing I would have liked to see more of is more practical assignments, like the one in Week 6. Even that was measured down in difficulty; perhaps the assignment can be made as part of the Honors section.
Also, definitely one of the better monitored forums in Coursera. With regular/periodic/helpful replies from Staff.
In contrast, I have generally found most Coursera courses to be quite poorly monitored comparatively. Its one of my bigger griefs with Coursera, compared to Edx - which generally has a vibrant discussion forum, thanks to the class members & staff/TAs
Such an amazing course, i was able to learn much about big data and sql engine to deal with it. Thank you so much
In depth look at SQL for Impala and Hive. Structured very well and excellent hands on learning with the VM and Hue. The middle section is tedious and you have to pay attention. It does all comes together at the end with real data analysis methods on big data sets. Good course but you have to be committed as a learner to receive the benefits.
Waiting forever to get a grade for the assignment. So disrespectful. You have to chase fellow students in the discussion forums to get reviews and that isn't working either...
It is no common for me to put 5 star score to courses, but this courser was literally comprehensive.
Thanks to all staff and instructor.
More hand-on exercise could have make this course more interesting.
I did not like the way of the quizzes are made, for example the grade that they are asking is to high , usually for beginners the grade is between 70-75%.
Also there is no extra material to check the answers of videos' questions .
Overall Ian explains everything in an understandable way.
I have completed my course, but after 2-3 it is still showing Peer Assignment marks is in the process.
This module is the one where you really dig into SQL syntax and how to use use. The videos are well-paced, though week 3 seems to pretty heavy. The instructor Ian Cook does an excellent job explaining concepts and showing examples for each syntax is a very clear manner. At times it might be too slow or simple for people who know some programing, but it's ok I just put playback at faster speed.
At ttimes he also explained the underlying logic and additional concepts. e.g. I really enjoyed his explanation of how Inner Join conceptually is a Cross Join with filters
If you already know some programing or Pandas/R, then you can skip the first module and just jump right in here. This course also provided some insights and brushed up my understanding of Pandas a bit better, and it's clear Pandas took a lot of cue from SQL.
Thank you for bringing such a Awesome and High quality course - Cloudera . Course instructors are exceptional in presenting the course material in a clear, concise manner. I find this course to be outstanding because the Amount of practice that i've gone through with this course gave me clear insight On "when, where and how to use appropriate SQL clauses". but this course should have included more practice questions on joins.
It is an excellent course! Many thanks to the instructor of this course. All learning materials were presented explicitly and 100% clear. I feel so grateful because I finally understood how to write SQL queries and manipulate data (as I have never learned programming languages and subjects like these). Looking forward to the fourth course where the advanced sql techniques will be presented.
Excellent course! This course, together with the first in this series is arguably the best courses to start with big data 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!
Good course if you know the theoretical part of RDBMS and Data Normalization/Denormalization, data transaction, and basics of querying. It covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT clauses along with UNION and Joins. It also teaches aggregate functions and built-in functions. Great course if you want to learn to retrieve data and ask questions using SQL.
The course of well designed for any beginner to learn how to operate on SQL dor finding out the insights from the data.
I would like to thank, the entire team of the Coursera and Cloudera for bringing this course in my life. It really helps me understand the concepts of database and SQL very well.
Special thanks to the instructor, Ian Cook.
I love how the course is structured to give a solid understanding of SQL queries from the ground up and how each keyword/function is connected to the others. I would have loved to have more practice with the VM or have a wider range of datasets. Nonetheless, I feel much more confident practicing and applying SQL SELECT queries.
Excellent ! Little bit exhaustive but worth it ! Total SQL refreshment course !
Clearly understood JOIN & its types ! Will never forget the Venn-Diagrams !
And the final assignment is a very good food-for-mind !
There was a mention of the 4th course in this specialization but not available; so is it not introduced yet ?
I really enjoyed the course. It’s a great way to get knowledge about the new technology. Attending this will help me to do my job better. Excellent information and format, the course focuses on big data SQL engines Apache Hive and Apache Impala. I especially evaluate experience of the trainer – Ian Cook.
Excelent. It's a really decent course if you want to get more of a background into data engineering mixed with the SQL fundamentals. You'll explore outside of the usual PostgreSQL and MySQL format, learn that SQL can be done in a command line, and the final project was challenging and satisfying.
This was a fantastic course. This was my first time learning about the SQL language and analyzing big data, and the format of the course helped to ease my concerns about learning these concepts. I would highly recommend this course to anyone interested in big data analysis, expert or beginner.
I have to say that it wasn't easy course at all.
I really recommend this course to those who is intrested in learning SQL for Big Data. I feel very confident after completing all the tasks. It is well balanced between theory and practice.
Thank you Ian for this course. 5+ stars