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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Learn SQL with Databricks · LearnSpace
Назад в каталог
courseraПрограммирование

Learn SQL with Databricks

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

О курсе

This course will teach you how to use SQL, one of the most important tools in data analysis, along with Databricks, a popular platform used by data teams worldwide. Whether you're new to SQL or want to improve your skills, this course will guide you step by step. You'll learn how to manage, analyze, and work with data using real-world examples all in a cloud-based environment that’s used by top companies. By the end of this course, you’ll be able to: - Grasp Databricks' features, architecture, and its role in data science and engineering. - Master SQL basics, querying data, and managing databases within Databricks. - Configure Databricks, optimize SQL processing, and utilize notebooks efficiently. - Learn loading, managing, preparing data, and sharing using Delta Sharing. - Explore joins, subqueries, aggregation, and optimization (indexing, views, procedures). - Apply SQL in Databricks through case studies, emphasizing efficient queries, maintenance, and data security. This course is tailored for individuals seeking to learn SQL with Databricks, providing comprehensive instruction and hands-on experience to master the essential skills for efficient data manipulation, analysis, and management within the Databricks environment. Basic understanding of databases & SQL, familiarity with data concepts, some programming knowledge are recommended for learning SQL with Databricks. Empower your data journey, unleash seamless manipulation, and elevate insights for data-driven success!

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

SQLDatabasesData MaintenanceData ManagementData ArchitectureData ProcessingApache Spark

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

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

01Introduction to SQL and Databricks49 материалов

Introduction to Databricks and SQL

Course IntroductoryВидеоGrasping the Databricks PlatformВидеоExploring Databricks Features and BenefitsВидеоData Science and Data Engineering with DatabricksВидеоIntroduction to SQL: Purpose and Applications

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

Edureka

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

Learn SQL with Databricks
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 15.7 ч

5 модулей

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

Субтитры: Арабский, Французский, Итальянский, Корейский, Немецкий, Индонезийский, Испанский, Японский

Часть программы вашего университета
Видео
Basics of Querying Data with SQLВидео
Importance of SQL in Data AnalysisВидео
Query Cheat sheetЧтение
Your SQL with Databricks Readiness CheckDIALOGUE
Share your initial impressions of the Databricks platform. What features seem most useful?Обсуждение
Knowledge Check: Introduction to Databricks and SQLЗадание
Course OverviewЧтение

Setting Up Databricks Environment

Creating a Databricks AccountВидеоCreating a Databricks Account - DemoВидеоDatabricks on Amazon Web Services (AWS)ЧтениеDatabricks on Google Cloud Platform (GCP)ЧтениеDatabricks on Azure Cloud PlatformЧтениеNavigating the Databricks Workspace - Part IВидеоNavigating the Databricks Workspace - Part IIВидеоConfiguring Clusters for SQL ProcessingВидеоUsing Notebooks for CodingВидеоDatabricks Architecture, Concepts and Functionalities - Part IВидеоDatabricks Architecture, Concepts and Functionalities - Part IIВидеоDescribe your experience in setting up your Databricks account and environment. What challenges did you face?ОбсуждениеKnowledge Check: Setting Up Databricks Environment Задание

Databricks Essentials and Data Loading

Loading and Managing Data in DatabricksВидеоExploring Data in Databricks Environment - Part IВидеоExploring Data in Databricks Environment - Part IIВидеоData Preparation Techniques Using DatabricksВидеоMonitoring Data and AI Assets in DatabricksВидеоApache Spark on DatabricksЧтениеBuilding Efficient Data Pipelines in DatabricksЧтениеSharing Data Using Delta Sharing in DatabricksВидеоShare your strategies for efficient data loading and management in Databricks.ОбсуждениеKnowledge Check: Databricks Essentials and Data LoadingЗадание

Databricks Lakehouse Platform Overview

Exploring Databricks MarketplaceВидеоIntroduction to Databricks RepositoriesЧтениеGrasping Data Engineering in Databricks - Part IВидеоGrasping Data Engineering in Databricks - Part IIВидеоUsing Generative AI and LLMs on DatabricksВидеоIntroduction to Machine Learning with DatabricksВидеоEthical Considerations in Data Science and AIЧтениеData Warehousing Strategies with DatabricksВидеоProficiency in Delta Lake and Developer ToolsВидеоDatabricks Technology Partners ShowcaseВидеоHow does the Databricks Lakehouse architecture innovate data warehousing and engineering?ОбсуждениеKnowledge Check: Databricks Lakehouse Platform OverviewЗадание

Module Wrap-Up Assessment

Module Synopsis: Introduction to SQL and DatabricksЧтениеModule Wrap-Up Assessment: Introduction to SQL and DatabricksЗадание
02SQL Fundamentals29 материалов

Data Types and Databases

Exploring SQL Data TypesВидеоCreating Databases in Databricks - Part IВидеоCreating Databases in Databricks - Part IIВидеоCreating Tables with Specific Data Types ВидеоCreating Tables with Specific Data Types - DemoВидеоManaging Database SchemasВидеоShare your experience in creating and managing databases and tables in Databricks.ОбсуждениеKnowledge Check: Data Types and DatabasesЗадание

Retrieving Data with SELECT Statement

Basics of the SELECT Statement - Part IВидеоBasics of the SELECT Statement - Part IIВидеоFiltering Data with WHERE ClauseВидеоSorting Results with ORDER BYВидеоLimiting Query Results with LIMITВидеоDiscuss the versatility of the SELECT statement in data retrieval. Share an example.Обсуждение

Filtering Data with WHERE Clause

Conditional Operators in WHERE Clause ВидеоUsing Comparison Operators for FilteringВидеоApplying Multiple Conditions in WHERE ClauseВидеоFiltering with NULL and IS NULL ConditionsВидеоDiscuss the importance of precision in using the WHERE clause for data analysis.ОбсуждениеKnowledge Check: Filtering Data with WHERE ClauseЗадание

Aggregating Data with GROUP BY and Aggregate Functions

Introduction to GROUP BY for Data AggregationВидеоUsing Aggregate FunctionsВидеоPerforming Aggregation on Grouped DataЧтениеUsing GROUP BY with HAVING Clause for Filtering Grouped DataЧтениеHow does data aggregation using GROUP BY contribute to data analysis?ОбсуждениеKnowledge Check: Aggregating Data with GROUP BY and Aggregate FunctionsЗадание

Module Wrap-Up Assessment

Module Synopsis: SQL Fundamentals ЧтениеModule Wrap-Up Assessment: SQL FundamentalsЗадание
03Advanced SQL Queries17 материалов

Joins and Relationships

Exploring Different Types of JoinsВидеоRelationships between Tables ВидеоJoining Tables using Multiple ColumnsВидеоUsing Aliases in Joins for Better ReadabilityВидеоKnowledge Check: Joins and RelationshipsЗадание

Subqueries and Nested Queries

Subqueries for Filtering and Data RetrievalВидеоCreating Nested Queries for Complex AnalysisВидеоUsing Subqueries in WHERE and SELECT ClausesВидеоOptimizing Queries with SubqueriesВидеоKnowledge Check: Subqueries and Nested QueriesЗадание

Data Modification with INSERT, UPDATE, DELETE

Inserting Data into Tables using INSERT StatementВидеоUpdating Existing Data with UPDATE StatementЧтениеDeleting Data with DELETE StatementВидеоManaging Transactions and Rollback OperationsВидеоKnowledge Check: Data Modification with INSERT, UPDATE, DELETEЗадание

Module Wrap-Up Assessment

Module Synopsis: Advanced SQL QueriesЧтениеModule Wrap-Up Assessment: Advanced SQL QueriesЗадание
04Data Manipulation and Optimization24 материалов

Modifying Data with ALTER and DROP

Modifying Table Structures with ALTER TABLEВидеоDropping Tables and Databases using DROPВидеоRenaming Columns and Tables with ALTERВидеоManaging Constraints using ALTER TABLEВидеоKnowledge Check: Modifying Data with ALTER and DROPЗадание

Indexes and Optimization

Exploring Indexes and their TypesВидеоCreating and Managing Indexes for Faster QueriesВидеоOptimizing Queries using IndexesВидеоBest Practices for Index ImplementationЧтениеKnowledge Check: Indexes and OptimizationЗадание

Views and Stored Procedures

Creating and Using Views in SQLВидеоImplementing Stored Procedures for Repetitive TasksЧтениеAdvantages of using Views and Stored ProceduresВидеоModifying and Dropping ViewsВидеоKnowledge Check: Views and Stored ProceduresЗадание

Case Studies and Best Practices

Real-world Case Studies of SQL Applications in DatabricksВидеоBest Practices for Writing Efficient SQL QueriesЧтениеDatabase Maintenance and Optimization Strategies - Part IВидеоDatabase Maintenance and Optimization Strategies - Part IIВидеоIntroduction to Data Governance Best PracticesЧтениеData Security Best Practices in Databricks SQL DatabasesВидео

Module Wrap-Up Assessment

Module Synopsis: Data Manipulation and OptimizationЧтениеModule Wrap-Up Assessment: Data Manipulation and OptimizationЗадание
05Course Wrap-Up Assessment4 материалов

Course Wrap-Up

Course Summary ВидеоThe Final Check-In: Turning SQL with Databricks Knowledge into ActionDIALOGUECourse Synopsis: Learn SQL with DatabricksЧтениеEnd Course Assessment: Learn SQL with DatabricksЗадание
Knowledge Check: Retrieving Data with SELECT Statement Задание
Knowledge Check: Case Studies and Best PracticesЗадание