Cracking the Data Engineering Interview

Focused View

3:55:20

0 View

1 - Introduction

1 -Course Overview.mp4

01:17

2 -Who am I.mp4

00:32

3 -Why make this course.mp4

01:01

4 -Course Content.mp4

00:49

5 -Required Knowledge.mp4

01:19

6 -What is a Data Engineer.mp4

02:39

7 -Why be a Data Engineer.mp4

02:15

2 - Data Modelling 101

1 -What is Data Modelling.mp4

02:35

2 -What is the Data Modelling Interview.mp4

01:34

3 -Keys and Data Models.mp4

02:57

4 -Facts vs. Dimension Tables.mp4

03:07

5 -Normalisation.mp4

04:04

6 -The Entity-Relationship Diagram.mp4

03:11

7 -Star vs. Snowflake Schema.mp4

03:38

8 -Star vs. Snowflake Schema Example.mp4

01:21

9 -Slowly Changing Dimensions.mp4

02:13

10 -Indexing.mp4

04:13

11 -Continue your Journey.mp4

02:54

3 - SQL Mastery

1 -Course Contents.mp4

00:43

2 -What is a Database.mp4

04:49

3 -Data Warehouse analogy.mp4

01:36

4 -What is SQL.mp4

02:45

5 -What is the SQL interview.mp4

01:25

6 -Coding section format.mp4

00:36

7 -Creating an Account.mp4

00:56

8 -UI Explanation.mp4

00:38

9 -How to create your Database.mp4

01:15

10 -Select.mp4

02:22

11 -Data Types.mp4

02:13

12 -Selecting and Filtering.mp4

02:40

13 -Selecting and Filtering Example.mp4

00:41

14 -Ordering.mp4

02:37

15 -Ordering Example.mp4

00:44

16 -Selecting and Filtering on multiple conditions.mp4

01:44

17 -Selecting and Filtering on multiple conditions Example.mp4

00:53

18 -Ordering and Filtering Example.mp4

01:39

19 -Limiting.mp4

01:01

20 -Limiting Example.mp4

00:26

21 -Limiting and Ordering Example.mp4

01:24

22 -Advanced Filtering using Like.mp4

03:10

23 -Advanced Filtering using Like Example.mp4

01:08

24 -Aggregations.mp4

03:25

25 -Aggregations Example.mp4

01:43

26 -Filtering on Aggregations.mp4

02:01

27 -Filtering on Aggregations Example.mp4

01:33

28 -Joining Theory.mp4

03:19

29 -Joining Tables.mp4

03:47

30 -Case Statements.mp4

04:04

31 -Case Statements Example.mp4

02:28

32 -Set Operations.mp4

04:21

33 -Set Operations Example.mp4

01:31

34 -Formatting SQL commands.mp4

05:08

35 -SQL Strategy.mp4

02:56

36 -Continue your Journey.mp4

01:35

4 - Know your Projects

1 -What is the Projects Interview.mp4

02:29

2 -Stack Alignment.mp4

02:27

3 -Engineering Practices.mp4

03:18

4 -Engineering Practices Example.mp4

02:08

5 -Engineering Practices Strategy.mp4

01:05

6 -Interpersonal Skills.mp4

02:41

7 -First Impressions.mp4

04:57

8 -Preparation.mp4

01:32

5 - Demystifying Python

1 -What is Python.mp4

01:05

2 -What is the Python Interview.mp4

01:24

3 -Coding section format.mp4

00:53

4 -Opening Notebook.mp4

00:58

5 -Colab User Interface.mp4

03:01

6 -Floats.mp4

04:16

7 -Floats Example.mp4

01:42

8 -Integers.mp4

01:54

9 -Integers Example.mp4

01:49

10 -Strings.mp4

08:07

11 -Strings Example.mp4

02:50

12 -Booleans.mp4

04:11

13 -Booleans Example.mp4

00:52

14 -Arithmetic.mp4

03:19

15 -Arithmetic Example.mp4

00:47

16 -Comparison Operators.mp4

01:28

17 -Comparison Operators Example.mp4

00:36

18 -Logical Operators.mp4

02:28

19 -Logical Operators Example.mp4

00:33

20 -Assignment.mp4

02:28

21 -Assignment Example.mp4

00:27

22 -Lists.mp4

07:05

23 -Lists Example.mp4

01:10

24 -Lists Example 2.mp4

00:49

25 -Tuples.mp4

02:00

26 -Tuples Example.mp4

00:27

27 -Dictionaries.mp4

05:13

28 -Dictionaries Example.mp4

01:46

29 -Sets.mp4

03:36

30 -Sets Example.mp4

00:39

31 -Conditional Logic.mp4

04:22

32 -Conditional Logic Example.mp4

03:03

33 -While and For Loops.mp4

08:32

34 -For Loops Example.mp4

01:03

35 -While Loops Example.mp4

02:17

36 -Advanced Loop Logic.mp4

02:41

37 -Advanced Loop Logic Example.mp4

01:02

38 -Functions.mp4

03:41

39 -Functions Example.mp4

01:12

40 -Continue Your Journey.mp4

02:02

Description

Use SQL, Python, Data Modelling and Project Interview preparation to land your first job in Data Engineering!

What You'll Learn?

To query Data in a Database
To write your own scripts in Python
The most powerful SQL transformations
Python's control flow and conditional logic
To sell your project experience effectively
To navigate AI's role in Data
Strategies for modelling Data in a Database
How problems are posed in industry
Navigate live-coding interviews calmly
Write scalable, professional code
Know what role a Data Engineer performs
Gain confidence in yourself and experience
Set Theory's relation to Data
What hiring managers really look for

Who is this for?

This course is designed for programming beginners looking to get their first job in Data Engineering! The most common types are people looking for a career change, graduate students, professionals in related fields, or even Data Engineers looking to round out their experience.

What You Need to Know?

No programming experience required, all you need is an email address and an internet connection. All of the tools used can be accessed from your browser.

More details

Description
Ready to Launch Your Career in Data Engineering?
Whether you're curious about the world of data, a student, looking to change up your career, in a related field, or just looking to sharpen up your skills this course is designed just for you! Cracking the Data Engineering Interview is your gateway to landing a job in one of the fastest-growing, high-demand fields in tech today.

Course Overview
Cracking the Data Engineering Interview is a beginner-friendly course that takes you step-by-step through everything you need to succeed in your data engineering job hunt. We start with the basics and gradually build your skills, ensuring youâ€™re fully equipped to crack any interview.
Throughout the course, you'll find loads of bite-sized coding example questions designed to test your skills and remove the scare factor. These exercises are not just practiceâ€”theyâ€™re a built-in study plan, helping you focus on key concepts without the extra effort of planning your own study sessions.

What this course DOESN'TÂ include:
Downloading any software
Confusing terminology
Writing code in your terminal
Lengthy hard to digest lectures

Course Content
Introduction | Weâ€™ll kick off with an overview of the data engineering landscape, what the role entails, and why itâ€™s such a critical function in the age of big data and AI.
Data Modelling | Learn the fundamentals of data modelling, including how to structure and organise data in ways that make it accessible, reliable, and easy to analyse.
SQL |Â SQL is the backbone of data engineering. In this module, youâ€™ll master the art of writing efficient queries, understanding joins, and optimising databases. Youâ€™ll also get hands-on practice with exercises that mimic real-world scenarios youâ€™ll face in a data engineering role.
Projects | This section also teaches you how to effectively present and sell your project experience to hiring managers. You'll learn how to highlight your contributions, explain the impact of your work, and showcase your skills in a way that makes you stand out in interviews.
Python | Python is a key tool in the data engineerâ€™s toolkit. Weâ€™ll start from the basics and move into more advanced concepts like data manipulation, scripting, and automation.

Start Learning Today!
This course is structured to make learning easy and accessible, with no need for complex installations or deep technical know-how to get started. We believe that the best way to learn is by doing, and weâ€™re here to support you every step of the way.
Get ready to ace your data engineering interview and step into a rewarding career with confidence. Enrol now and take the first step towards your new future!
If you have any questions about the content of the course or need any support during the course feel free to reach out to me by email.
Who this course is for:
This course is designed for programming beginners looking to get their first job in Data Engineering! The most common types are people looking for a career change, graduate students, professionals in related fields, or even Data Engineers looking to round out their experience.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.