Data and Databases
How data is stored, queried, moved and governed, from one table to a lakehouse. Thirteen lessons go from tables and SQL through table design, indexes and transactions, to NoSQL, column stores, lakehouses, pipelines, Spark and streams, and end with how a company keeps its data trustworthy. Taught to the depth of the AWS Data Engineer, Databricks and SnowPro exams; Azure DP-900 sits comfortably inside it. A worked case at the end puts the whole course to work on one realistic problem.
After this course you can
- Design a normalised schema, write the SQL to question it, and explain what a transaction, an isolation level and an index each do.
- Choose between a relational database, a NoSQL store, a warehouse and a lakehouse for a given workload, and say why.
- Build the shape of a modern data platform: batch and streaming ingestion, ELT into bronze, silver and gold, Spark jobs that run fast, and the controls that keep the data correct and private.
Lessons
14 lessonsCertifications
4 examsWhen you have finished the lessons, take the exam course for the certification you want. This course teaches the subject to the depth of the hardest exam below; each exam course adds only what its exam asks on top: the vendor's own names, services and limits, and how the questions are built.
Sources and credit
42 sourcesThe chapters and drawings are written by NeuroqAI from these sources. Each lesson lists its own at the end of its chapter, and figures on the pages are taken from them or computed from them.