Learn SQL with Databricks

Edureka via Coursera

Go to Course: https://www.coursera.org/learn/learn-sql-with-databricks

Syllabus

Introduction to SQL and Databricks

Explore Databricks' features, understand its role in data science and engineering, and learn SQL basics, emphasizing its importance in data analysis.

SQL Fundamentals

Delve into SQL essentials: data types, database creation, data retrieval with SELECT, and data filtering using WHERE and GROUP BY clauses.

Advanced SQL Queries

Advance to complex SQL queries, covering joins, subqueries, and data modification techniques, alongside transaction management and rollback operations.

Data Manipulation and Optimization

Focus on advanced data manipulation, including altering data structures, optimizing queries with indexes, and utilizing views and stored procedures, supplemented with real-world case studies.

Course Wrap-Up Assessment

Conclude the course with a comprehensive assessment, testing knowledge across all modules, from SQL basics to advanced data manipulation and optimization in Databricks, ensuring a solid understanding and practical application of the learned concepts.