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.
Dieser Kurs ist Teil der Spezialisierung Spezialisierung Modern Big Data Analysis with SQL
Foundations for Big Data Analysis with SQL
von
Über diesen Kurs
72,590 kürzliche Aufrufe
Was Sie lernen werden
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
Kompetenzen, die Sie erwerben
Database (DBMS)Data WarehousingData AnalysisBig DataSQL
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 1 von 3 in
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Stufe „Anfänger“
Ca. 19 Stunden zum Abschließen
Empfohlen: 10 hours/week
Englisch
Untertitel: Englisch
von
Cloudera
At Cloudera, we believe that data can make what is impossible today, possible tomorrow. We empower people to transform complex data into clear and actionable insights. Cloudera delivers an enterprise data cloud for any data, anywhere, from the Edge to AI. Powered by the relentless innovation of the open source community, Cloudera advances digital transformation for the world’s largest enterprises.
Lehrplan - Was Sie in diesem Kurs lernen werden
2 Stunden zum Abschließen
Data and Databases
In this week, you'll get an overview of this Specialization and of Course 1. Then you'll learn about database systems and the distinction between operational and analytic databases.
2 Stunden zum Abschließen
11 Videos (Gesamt 50 min), 4 Lektüren, 1 Quiz
11 Videos
Welcome to the Course and Week 13m
What Is Data?3m
Why Organize Data?5m
What Does a DBMS Do?5m
Relational Databases and SQL6m
The Success of RDBMSs and SQL4m
Operational and Analytic Databases5m
Comparing Operational and Analytic DBs: SELECT Statements2m
Comparing Operational and Analytic DBs: DML Activity4m
Operational and Analytic Databases: Further Comparisons1m
4 Lektüren
Hardware Requirements for the Exercise Environment10m
Data Extraction from Digital Images10m
Three Notes about SQL10m
References10m
1 praktische Übung
Data and Databases30m
3 Stunden zum Abschließen
Relational Databases and SQL
3 Stunden zum Abschließen
15 Videos (Gesamt 80 min), 3 Lektüren, 1 Quiz
15 Videos
Introducing Table Schemas3m
NULL Values3m
Data Types3m
Primary Keys5m
Foreign Keys6m
Two Strategies for Database Design3m
Database Normalization8m
Denormalization5m
Differences6m
Trade-offs4m
Database Transactions6m
ACID6m
Enforcing Business Rules: Constraints and Triggers7m
Business Rules and ACID for Analytics?6m
3 Lektüren
Let There Be Third Normal Form5m
SELECT Statements in Transactions5m
Database Indexes30m
1 praktische Übung
Relational Databases30m
2 Stunden zum Abschließen
Big Data
2 Stunden zum Abschließen
12 Videos (Gesamt 63 min), 1 Lektüre, 1 Quiz
12 Videos
How Big Is Big Data?3m
Distributed Storage6m
Distributed Processing9m
Structured Data4m
Unstructured Data4m
Semi-Structured Data3m
Strengths of Traditional RDBMSs4m
Limitations of Traditional RDBMSs7m
SQL and Structured Data5m
SQL and Semi-structured Data4m
SQL and Unstructured Data7m
1 Lektüre
What about Velocity?15m
1 praktische Übung
Big Data30m
2 Stunden zum Abschließen
SQL Tools for Big Data Analysis
2 Stunden zum Abschließen
12 Videos (Gesamt 53 min), 1 Lektüre, 1 Quiz
12 Videos
Big Data Analytic Databases (Data Warehouses)2m
NoSQL: Operational, Unstructured and Semi-structured4m
Non-transactional, Structured Systems2m
Big Data ACID-Compliant RDBMSs1m
Search Engines4m
Challenges4m
What We Keep3m
What We Give Up5m
What We Add8m
Where to Store Big Data7m
Coupling of Data and Metadata7m
1 Lektüre
Open Source and Apache15m
1 praktische Übung
SQL Tools for Big Data Analysis30m
Bewertungen
Top-Bewertungen von FOUNDATIONS FOR BIG DATA ANALYSIS WITH SQL
von AESep 9, 2019
Awesome foundation to build on skills of query and analysis of big data and to use big data technologies like Hive and Impala\n\nI Really enjoyed the course and the instructor is perfect
von AAAug 14, 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.
von SYMar 3, 2020
Thank you for bringing such a Awesome and High quality course - Cloudera. Course instructors are just exceptional in presenting the course material in a clear, concise manner!
von AKJul 25, 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.
von PKJul 26, 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.
von MOFeb 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.
von RPDec 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.
von JGJan 28, 2020
Great foundational course for somebody who has some experience using SQL but no formal training -- it really fills in the gaps.
von NHApr 1, 2020
Good start of specialization. Great instructor and nicely elaborated difference between RDBMS and Big Data Analytics.
von MDDec 8, 2019
Amazing course! :) Very well introduction to Big Data ecosystem and gold-standard information about SQL.
von EROct 19, 2019
informative background info of Big Data that's good to know about. not too simple or too challenging.
von HAOct 19, 2019
Good course to understand the foundations of big data using good examples and real life problems.
Über den Spezialisierung Modern 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 quickly to be efficiently stored in commercial data warehouses. Instead, it’s increasingly stored in distributed clusters and cloud storage. These data stores are cost-efficient and infinitely scalable.
To query these huge datasets in clusters and cloud storage, you need a newer breed of SQL engine: distributed query engines, like Hive, Impala, Presto, and Drill. These are open source SQL engines capable of querying enormous datasets. This Specialization focuses on Hive and Impala, the most widely deployed of these query engines.
This Specialization is designed to provide excellent preparation for the Cloudera Certified Associate (CCA) Data Analyst certification exam. You can earn this certification credential by taking a hands-on practical exam using the same SQL engines that this Specialization teaches—Hive and Impala.
Häufig gestellte Fragen
Wann erhalte ich Zugang zu den Vorträgen und Aufgaben?
Sobald Sie sich für ein Zertifikat angemeldet haben, haben Sie Zugriff auf alle Videos, Quizspiele und Programmieraufgaben (falls zutreffend). Aufgaben, die von anderen Kursteilnehmern bewertet werden, können erst dann eingereicht und überprüft werden, wenn Ihr Unterricht begonnen hat. Wenn Sie sich den Kurs anschauen möchten, ohne ihn zu kaufen, können Sie womöglich auf bestimmte Aufgaben nicht zugreifen.
Was bekomme ich, wenn ich diese Spezialisierung abonniere?
Wenn Sie sich für den Kurs anmelden, erhalten Sie Zugriff auf alle Kurse der Spezialisierung und Sie erhalten nach Abschluss aller Arbeiten ein Zertifikat. Ihr elektronisches Zertifikat wird zu Ihrer Seite „Errungenschaften“ hinzugefügt – von dort können Sie Ihr Zertifikat ausdrucken oder es zu Ihrem LinkedIn Profil hinzufügen. Wenn Sie nur lesen und den Inhalt des Kurses anzeigen möchten, können Sie kostenlos als Gast an dem Kurs teilnehmen.
Wie erfolgen Rückerstattungen?
Ist finanzielle Unterstützung möglich?
What are the hardware and software requirements for the exercise environment?
• 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)
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..