In this video, Dmitry Anoshin from Surfalytics dives deep into DuckDB, exploring its features, use cases, and benefits for data professionals.
He starts with a brief overview of DuckDB and its different editions, then walks you through a practical tutorial on installing and getting started with it. Dmitry demonstrates how to:
* **Interact with DuckDB:** Learn basic commands and how DuckDB simplifies querying compared to traditional SQL.
* **Manage persistent storage:** Understand how to store your data for future sessions and the advantages it offers.
* **Work with external files:** Effortlessly query data directly from CSV, Parquet, and other formats.
* **Leverage display modes:** Output your results in various formats like JSON and Markdown for easy sharing and documentation.
* **Extend functionality:** Explore the world of DuckDB extensions, including those for HTTP resources and Google Sheets.
* **Connect to external data:** Query data from cloud storage like AWS S3 using readily available plugins.
* **Understand OLAP workloads:** Learn about the analytical capabilities of DuckDB and its advantages over traditional OLTP systems.
Throughout the video, Dmitry shares practical tips and tricks, real-world examples, and insightful explanations to help you grasp the concepts effectively. He also provides homework assignments to reinforce your learning and encourages you to join the Surfalytics community for more hands-on practice.
Whether you're a data analyst, data engineer, or analytics engineer, this video will equip you with valuable knowledge and skills to enhance your data processing and analysis capabilities using DuckDB.
Resources used:
github.com/surfalytics/analytics-course/tree/5b6c52f0ba66d63eb46dd508543e88e5f7b2c9df/02_getting_started_with_databases/07_duckdb
duckdb.org/
aws.amazon.com/compare/the-difference-between-olap-and-oltp/
Timecode:
00:00 - Introduction
01:44 - Lesson begins
06:00 - Open DuckDB and create a table
09:45 - Cool features of DuckDB
18:00 - Different settings and configurations of DuckDB
20:00 - A little hand-on with DuckDB
22:00 - API in DuckDB
24:00 - Homework assignment
25:00 - A few use cases
Thank you for watching “Just enough DuckDB for Data Analyst | Module 2 | Surfalytics” on Surfalytics_TV!
Click the link to watch previous videos in Module 2: th-cam.com/video/GxLpe97h0tY/w-d-xo.html&pp=iAQB
Subscribe for more content: www.youtube.com/@SurfalyticsTV?sub_confirmation=1
#duckdb #database #sql #dataanalysis #dataengineering #analyticsengineering #bideveloper #surfalytics #tutorial #learnduckdb #dataprocessing #dataanalytics #etl #olap #datapipeline
=================
What is Surfalytics?
Inspired by West Coast surfing spots 🏖️ and Pacific Ocean vibes 🌊. Created to help you start a new career in the data analytics space, and develop data engineering and analytics skills through coaching. It will teach you not just dry skills, but will keep your focus on delivering significant value to businesses in the analytics realm as well as help you get fair compensation 💰 for the work you’re passionate about ❤️‍🔥.
The goal of Surfalytics is to assist you in achieving one of the following:
🏄‍♂️ Land your first job in the data industry with literally zero experience. I have accomplished this many times across the globe.
🏄 Advance from a middle-level role to a senior position (as an Analyst or Engineer).
🏄‍♀️ Transition from a non-technical Analyst role to a technical Engineer role.
Moreover, we will focus on creating a highly competitive CV and securing top job offers. We will not consider any lowball offers, focusing only on top-tier companies and well-paid opportunities.
Finally, Surfalytics is a results-driven community with a very narrow focus, resulting in a high return on investment (ROI). Here, ‘investment’ does not mean money but your time. I am literally fighting for your attention to encourage you to study and work hard, instead of watching Netflix or playing video games.
This is the best TH-cam channel for Data Analytics and Engineering. You will patch up a lack of knowledge and get new experience and tips to build a Data Analyst roadmap or Data Engineer roadmap for yourself.
Want to be part of our growing community? Join on Surfalytics.com
#surfalytics #dmitryanoshin #datacommunity #freecourses #dataanalysis #dataengineering #roadmap #careerpath #mindmaps #tools #overview #dataanalysttips