Hello everyone 👋

The next iteration of the course starts January. Looking forward to seeing you there!

You can sign up using this link: https://airtable.com/shr6oVXeQvSI5HuWD

Hi everyone!

I started sending emails and there was a mistake: the email said the course already started. It's not correct - the course starts on 16 January 2023 (Monday)

You can find out more about the course in the course repo: https://github.com/DataTalksClub/data-engineering-zoomcamp/

Small change of plans: the kick-off stream on Monday will happen at 18:00 CET instead of 17:00 CET. The course calendar is updated. See you soon!

Also, we're putting the answers to your questions in FAQ.

Check it out: https://docs.google.com/document/d/19bnYs80DwuUimHM65UV3sylsCn2j1vziPOwzBwQrebw/edit#

We're starting in 15 minutes. We will publish the youtube link soon

We will use Slido for asking questions: https://app.sli.do/event/7ybwjhDH4zHpnHhqwzhUpQ

Starting in 10 minutes. Stream: https://www.youtube.com/watch?v=-zpVha7bw5A

Hello everyone!

Homework 1 and the form for submitting the results are now available

https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2023/week_1_docker_sql/homework.md

Have fun!!

We know that the first week is quite difficult for many of you

That's why we prepared an extra (optional) video with a walk-thought of week 1 on WSL (Windows Subsystem Linux)

https://www.youtube.com/watch?v=Mv4zFm2AwzQ

We hope it helps. Thanks Luis for preparing the video!

To make it easier for you to plan the course, we've created a calendar with the course schedule and deadlines:

https://docs.google.com/spreadsheets/d/e/2PACX-1vSm_klXN3BzrRr7EjpEu_TDTZIQRkoEcCJriF3JdZgk6kPEHD1mxDQn8JvpEzCDpndQB-jE8red3NJj/pubhtml

It's linked in the 2023 cohort page in the course repo:

https://github.com/DataTalksClub/data-engineering-zoomcamp/tree/main/cohorts/2023

We forgot to include a terraform exercise to homework 1, so we created another homework form just for it

Here it is: https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2023/week_1_terraform/homework.md

In case you have problems with GCP setup, we have great notes from the students from the previous iteration

E.g. this one from Alvaro:

https://github.com/ziritrion/dataeng-zoomcamp/blob/main/notes/1_intro.md#gcp-initial-setup

More notes here:

https://github.com/DataTalksClub/data-engineering-zoomcamp/tree/main/week_1_basics_n_setup#community-notes

Hello everyone!

Today unfortunate we will have to cancel the office hours stream

But we will still answer your questions. Please ask them here: https://app.sli.do/event/rbNtvscFPbrjtaXeHEhhmT

And we will record a video with the answers. We will also try to pick some of the remaining questions from the launch stream

Also, next week I (Alexey) am on vacation, so we won't have a stream either. We will follow the same approach for office hours

Enjoy learning!

Answers to your questions from the kick-off stream as well as from Monday

https://www.loom.com/share/661784d18c3644fe8239d9092129c4e6

Hi everyone!

We've extended the deadline for homework 1 (both SQL & Terraform) till Monday (30 Jan)

SQL: https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2023/week_1_docker_sql/homework.md
Terraform: https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2023/week_1_terraform/homework.md

Use this time wisely and don't wait till the last moment - there will be no more extensions

Hi everyone!

We hope you're enjoying the course. Don't forget that there are two parts of the homework for module 1 - SQL & Terraform, and the deadline is tomorrow

Tomorrow we don't have live office hours, so please ask your questions using this link: https://app.sli.do/event/rbNtvscFPbrjtaXeHEhhmT

The link for office hours will stay the same throughout the course

Also, there's an awesome video from Shruti Kuber, one of the course students. In this video, she shows how to use GitHub Codespaces to run the course code

Check it out: https://www.youtube.com/watch?v=Jl2_Hkxkbyc&list=PL3MmuxUbc_hJed7dXYoJw8DoCuVHhGEQb

Thanks Shruti for preparing a video about it!

Hi everyone!

Today we start module 2 - workflow orchestration. In this module, we'll use Prefect as the workflow orchestration tool

Materials: https://github.com/DataTalksClub/data-engineering-zoomcamp/tree/main/week_2_workflow_orchestration

Homework: https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2023/week_2_workflow_orchestration/homework.md

Also, a reminder - we won't have office hours today. You can ask your questions using this link (https://app.sli.do/event/rbNtvscFPbrjtaXeHEhhmT) and we'll answer them asynchronously

Enjoy this week!

Hi everyone!

Here's the leaderboard with the scores for the first homework (both parts) - https://docs.google.com/spreadsheets/d/e/2PACX-1vTbL00GcdQp0bJt9wf1ROltMq7s3qyxl-NYF7Pvk79Jfxgwfn9dNWmPD_yJHTDq_Wzvps8EIr6cOKWm/pubhtml

830 people submitted the solution to the first homework. Amazing job, thanks everyone for being a part of it!

You can find the solution to 1a part here - https://www.youtube.com/watch?v=KIh_9tZiroA

The solution to 1b is just applying everything we did in the terraform videos, so we won't record a separate solution for that


Enjoy week 2!

Form for submitting homework 2: https://forms.gle/PY8mBEGXJ1RvmTM97

Answers to the office hours questions this week:

https://www.loom.com/share/91d2655c8a314fb3b0870550d8244f81

Hi everyone!

Tomorrow we have office hours with the Prefect team, so if you have any questions about Prefect, please ask them using the usual link:

https://app.sli.do/event/rbNtvscFPbrjtaXeHEhhmT

We will go live at 18:00 CET (the calendar is updated)

Also we see a lot of activity now during the weekend and unfortunately, we can't always support you outside of working hours. That's why we're extending the deadline for homework #2 by a couple of days - the new due date is Wednesday 8 Feb, 22:00 CET

Have fun! See you tomorrow!

Office hours: https://www.youtube.com/watch?v=a_nmLHb8hzw
Questions: https://app.sli.do/event/rbNtvscFPbrjtaXeHEhhmT