Ultimate Data Engineering Bootcamp: SQL & Python Mastery 2024
Focused View
3:55:20
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
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
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
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
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
More details
Course Overview
This comprehensive bootcamp teaches you essential data engineering skills, from SQL transformations to Python scripting, preparing you to ace technical interviews and land your first data engineering job.
What You'll Learn
- Master SQL queries, joins, and set operations for database management
- Build Python scripts with control flow, functions, and data structures
- Design efficient data models with star/snowflake schemas and normalization
Who This Is For
- Career changers entering tech fields
- Graduate students building data skills
- Professionals in related fields upskilling
Key Benefits
- No prior programming experience required
- Browser-based tools - learn anywhere
- Interview strategies for technical and project questions
Curriculum Highlights
- Data Modeling 101: ER diagrams to schema design
- SQL Mastery: From basics to advanced transformations
- Python Demystified: Core programming concepts
Focused display
Category
- language english
- Training sessions 102
- duration 3:55:20
- English subtitles has
- Release Date 2025/06/10
