К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Databricks Certified Data Analyst Associate Exam Prep · LearnSpace
Назад в каталог
courseraIT и технологии

Databricks Certified Data Analyst Associate Exam Prep

Курс от Packt
Средний≈ 15.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Prepare for the Databricks Certified Data Analyst Associate Exam with this comprehensive course. You'll master essential tools like Delta Lake, Unity Catalog, and Databricks SQL, while learning data management, SQL querying, and advanced techniques like AI-enhanced dashboards and data modeling. The course guides you from the basics of Databricks, data import, and analysis to more complex concepts like Medallion Architecture and Data Vault Modeling. You'll gain hands-on experience in building dashboards, optimizing queries, and securing data. The curriculum also covers managing data with Unity Catalog, designing visualizations, and analyzing query performance. Ideal for anyone looking to become a certified Databricks Data Analyst, this course will ensure you're well-prepared for both the exam and real-world data analysis. By the end, you'll be able to analyze data in Databricks, develop optimized queries, create dynamic dashboards, and apply advanced data modeling techniques. You'll also be fully prepared for the exam.

Навыки, которые вы освоите

DatabricksData GovernanceSQLDashboard CreationStar SchemaInteractive Data VisualizationSnowflake SchemaExtract, Transform, LoadQuery LanguagesData SecurityData ArchitectureData WarehousingData ModelingDashboardBusiness IntelligenceDatabase AdministrationData AnalysisData LakesData AccessData Import/Export

Программа курса

12 модулей · 99 учебных материалов

01Course Introduction5 материалов

Course Introduction

Course IntroductionВидеоFull Course ResourcesЧтениеData Story (Data Warehouse, Data Lake, Data Lakehouse)ВидеоWhat is Delta Lake?Видео

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Databricks Certified Data Analyst Associate Exam Prep
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 15.2 ч

12 модулей

Язык: Английский

Часть программы вашего университета
Databricks (High Level Overview)Видео
02Getting Started with Databricks8 материалов

Getting Started with Databricks

Cloud Service ProviderВидеоDatabricks Account and WorkspacesВидеоUnity CatalogВидеоSign up on Databricks PlatformВидеоUnderstand Databricks Account ConsoleВидеоWorkspace UI WalkthroughВидеоCore Concepts of Databricks: Accounts, Workspaces, and Unity CatalogDIALOGUEGetting Started with DatabricksЗадание
03Importing Data14 материалов

Importing Data

Upload a local File as a Table using the UIВидеоWriting Basic Queries in DatabricksВидеоUpload a local CSV File to a Volume using the UIВидеоCreating a Delta Table from a CSV File Using read_files()ВидеоMoving Delta Table to another SchemaВидеоLoading Data into a Delta Table Using COPY INTOВидеоUsing INSERT INTO to Add Data to a Delta TableВидеоExploring Delta Table features in PracticeВидеоManaged Vs External TablesВидеоIngesting Data from Amazon S3 into DatabricksВидеоDelta SharingВидеоDatabricks MarketplaceВидеоUploading Files and Creating Delta Tables in DatabricksDIALOGUEImporting DataЗадание
04Master SQL in Databricks13 материалов

Master SQL in Databricks

Sorting Query Results using ORDER BYВидеоWorking with Aggregate Functions – update to add STDEVВидеоGrouping and Filtering Data Using GROUP BY and HAVINGВидеоWorking with String, Date, and Data Conversion FunctionsВидеоCombining Tables Using Joins in Databricks SQLВидеоCombining Result Sets Using Set Operators in Databricks SQLВидеоHandling NULL Values Using IS NULL, COALESCE, and IFNULLВидеоUsing CASE Expression for Conditional LogicВидеоUsing Subqueries in Databricks SQLВидеоCommon Table Expressions (CTE) in Databricks SQLВидеоWindow Functions in Databricks SQLВидеоDeep Dive into SQL Sorting, Aggregation, Joins, and Advanced QueriesDIALOGUEMaster SQL in DatabricksЗадание
05Views in Databricks6 материалов

Views in Databricks

Standard ViewsВидеоTemporary ViewsВидеоMaterialized ViewsВидеоDynamic ViewsВидеоExploring View Types in Databricks SQLDIALOGUEViews in DatabricksЗадание
06Modern SQL Development with AI in Databricks6 материалов

Modern SQL Development with AI in Databricks

AI for Writing & Explaining SQLВидеоDebugging & Optimization with AIВидеоBest Practices: AI + Analyst WorkflowВидеоBonus: Using AI to Convert SQL to PySparkВидеоApplying Databricks AI Assistant for Data Analysis and DebuggingDIALOGUEModern SQL Development with AI in DatabricksЗадание
07Managing & Securing Data (Unity Catalog)8 материалов

Managing & Securing Data (Unity Catalog)

Unity Catalog Fundamentals – Explained SimplyВидеоUnity Catalog in Practice – Workspace Binding and PermissionsВидеоApplying Tags in Unity Catalog Using the UIВидеоApplying and Discovering Tags in Unity Catalog Using SQLВидеоUnderstanding and Viewing Data Lineage in Unity CatalogВидеоUnity Catalog Security: Roles, Permissions, Sharing, and Best PracticesВидеоCentralized Data Governance with Unity CatalogDIALOGUEManaging & Securing Data (Unity Catalog)Задание
08Working with Dashboards and Visualizations in Databricks14 материалов

Working with Dashboards and Visualizations in Databricks

What is an AI/BI Dashboard?ВидеоDesigning Datasets for DashboardsВидеоWorking with Visualization Types in Databricks SQL Dashboards (Part 1)ВидеоWorking with Visualization Types in Databricks SQL Dashboards (Part 2)ВидеоEnhancing Databricks Dashboards with Counters, Text Widget, and ImageВидеоAI Enhanced FeaturesВидеоDashboard Filtering: Local, Global, and Cross FilteringВидеоWorking with Parameters in SQL Queries and DashboardsВидеоSharing and Managing Dashboard Permissions in DatabricksВидеоSchedule an automatic dashboard refreshВидеоCreate visualizations in notebooks and the SQL editorВидеоCreating and Configuring Alerts in Databricks SQLВидеоDesigning Effective Dashboards and Visualizations in DatabricksDIALOGUEWorking with Dashboards and Visualizations in DatabricksЗадание
09Developing, Sharing, and Maintaining AI/BI Genie spaces6 материалов

Developing, Sharing, and Maintaining AI/BI Genie spaces

Introduction to AI/BI Genie and Genie SpacesВидеоCreating an AI/BI Genie Space in DatabricksВидеоOptimizing AI/BI Genie Spaces: Monitoring, Feedback, Instructions, BenchmarksВидеоManaging Permissions and Sharing AI/BI Genie SpacesВидеоEmpowering Self-Service Analytics with Genie SpacesDIALOGUEDeveloping, Sharing, and Maintaining AI/BI Genie spacesЗадание
10Data Modeling with Databricks SQL8 материалов

Data Modeling with Databricks SQL

Understanding Fact and Dimension Tables in Data ModelingВидеоDesigning Star and Snowflake SchemasВидеоData Vault Modeling: Hubs, Links, and SatellitesВидеоMedallion Architecture: Bronze, Silver, and Gold LayersВидеоBuilding Streaming Tables with the Medallion ArchitectureВидеоLast Mile ETL ExplainedВидеоUnderstanding Data Modeling: Fact & Dimension Tables, Star vs Snowflake Schemas, and Medallion ArchitectureDIALOGUEData Modeling with Databricks SQLЗадание
11Analyzing Queries8 материалов

Analyzing Queries

Introduction to Photon in DatabricksВидеоAnalyzing Query Performance with Query History and Query ProfileВидеоUnderstanding CACHE TABLE in DatabricksВидеоLiquid Clustering in DatabricksВидеоData Enhancements ExplainedВидеоDelta Lake VACUUM: Removing Obsolete Data FilesВидеоOptimizing Query Performance in Databricks with Photon and Data Management ToolsDIALOGUEAnalyzing QueriesЗадание
12Summary3 материалов

Summary

SummaryВидеоFull courseЗаданиеFull courseЗадание