Description
Modern Big Data Analysis with SQL Specialization course. The Modern Big Data Analytics with SQL course teaches you the skills you need to query big data with modern distributed SQL engines. This course is suitable for people of various levels of experience with SQL, including:
- Beginner SQL Users: If you are new to SQL, this course will teach you the basics.
- Experienced SQL users: If you’ve already used SQL to query small-scale data in relational databases, this course will teach you how to work with big data at massive scales.
Today, the volume of data is increasing exponentially and can no longer be efficiently stored in traditional data warehouses. For this reason, many organizations use distributed SQL engines such as Hive, Impala, Presto, and Drill to store and query their data across distributed clusters and cloud storage. These engines allow you to efficiently query massive data sets and extract the information you need. This specialized course focuses on two popular distributed SQL engines, Hive and Impala, that are widely used in the industry. By completing this course, you will be able to:
- Familiarize yourself with key big data analytics concepts such as volume, velocity, variety, and value.
- Learn how to install and configure Hive and Impala.
- Use these engines to query big data using standard SQL commands and Hive and Impala specific commands.
- Learn various query optimization techniques to improve the performance of your queries.
- Perform complex analytical tasks using Hive and Impala.
The course is taught by academic and industry experts and includes practical projects, exercises and tests to help you apply your skills in the real world.
What you will learn in the training series Modern Big Data Analysis with SQL Specialization
- Key concepts of big data analysis: volume, speed, variety and value
- Introduction to distributed SQL engines: Hive and Impala
- Install and configure Hive and Impala
- Querying big data using SQL: standard SQL commands and Hive and Impala specific commands
- Query Optimization: Various techniques to improve the performance of your queries
- Perform complex analytical tasks using Hive and Impala
Course details
- Publisher: Coursera
- English language
- Duration: 14 hours and 10 minutes
- Number of courses: 3
- teacher : Glynn Durham, Ian Cook
- File format: mp4
- Course Level: Introductory to Advanced
- Provider Institute/University: CLOUDERA
The courses available in the Modern Big Data Analysis with SQL Specialization training series
Prerequisites of Modern Big Data Analysis with SQL Specialization training set
- To use the hands-on environment for the courses in this specialization, 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)
Pictures
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
10.3 GB
Be the first to comment