![]() ![]() The course begins with an introduction to Indexing, which is one of the most important tools for tuning queries. The "Advanced SQL for Query Tuning and Performance Optimization" course will teach you everything you need to know about writing optimized queries. So while there may be many ways to execute a query, some are more efficient than others. When you get down to writing SQL queries in the real world, you don’t just want the correct result, you also want to ensure your queries are efficient. While you can find many courses on SQL, there are very few that focus on query optimization. If you need to brush up on the concepts and vocabulary associated with the big data, you can take the earlier course that can also be audited for free. This course is the second in a three-part specialization. The VM has specific hardware requirements so make sure you review these before you enroll in the program. ![]() The course provides a virtual machine (VM) that includes everything you need to follow the course. The instructor focuses on two distributed big data SQL engines, specifically Apache Hive and Apache Impala, though you can apply the learning on traditional RDBMS as well. The course assumes you have basic working knowledge of SQL and builds on top of that to help you write SQL SELECT statements geared towards data analysis. The course is provided by Cloudera and can be audited for free. If you are already familiar with SQL and want to put your skills to handle big data, then the "Analysing Big Data with SQL" course is designed for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |