Skip to main content

Computer Science Fundamentals

1h 30m 17s
English
Paid

Building a solid foundation in computer science is crucial for advancing in the technology sector, especially if you're aiming to become a Data Engineer. This course is designed to be your first guiding step in this journey.

Course Overview

This course offers an in-depth guide to the essential topics and resources in computer science that are particularly important for Data Engineers. We primarily focus on software development and relational databases.

Software Development

Key Learning Outcomes

  • Understanding how to write code and design program architecture.
  • Learning to model databases using UML, sequence diagrams, and other tools.
  • Mastering the effective use of Git for team collaboration.
  • Exploring the advantages of agile development and the connection between development and operations (DevOps).

Relational Databases

Core Concepts

  • Understanding the differences between OLTP and OLAP databases.
  • Grasping the basics of data modeling and normalization.
  • Mastering key SQL queries essential for every Data Engineer.

Additional Topics

At the end of the course, useful resources and recommendations are available on the following topics:

  • Fundamentals of computer networking.
  • Linux operating system.
  • REST API essentials.

Feeling overwhelmed? Don't worry! Each section is broken down step-by-step with plenty of examples. For each tool mentioned, you'll find links to resources where you can either learn how to use them or deepen your existing knowledge.

About the Author: Andreas Kretz

Andreas Kretz thumbnail

I am a senior data engineer and trainer, a tech enthusiast, and a father. For more than ten years, I have been passionate about Data Engineering. Initially, I became a self-taught data engineer and then led a team of data engineers at a large company. When I realized the great demand for education in this field, I followed my passion and founded my own Data Engineering Academy. Since then, I have helped over 2,000 students achieve their goals.

Watch Online 16 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 16 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction
All Course Lessons (16)
#Lesson TitleDurationAccess
1
Introduction Demo
05:00
2
Coding
08:15
3
UML Diagrams
08:14
4
Git
05:46
5
Agile Roles
05:11
6
Agile Process & Tools
05:07
7
Azure DevOps
07:18
8
DevOps
05:38
9
OLTP vs OLAP
08:29
10
Why Relational DBs and SQL is so important
02:36
11
Data Modeling
05:59
12
ER Model
04:16
13
Normalization
07:32
14
Primary & Foreign Keys
02:46
15
Building your DB with dbdiagram.io
03:57
16
Important SQL Queries
04:13
Unlock unlimited learning

Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Books

Read Book Computer Science Fundamentals

#Title
1Computer Networking Links
2Linux Links
3Software Development Links