Computer Science Fundamentals

1h 30m 17s
English
Paid

Course description

As in any field, solid foundational knowledge is the basis for everything else. That is why this course is your first step on the path to becoming a Data Engineer. This course is a guide to the key topics and resources in the field of computer science that are particularly important for Data Engineers. The course focuses mainly on **software development** and **relational databases**.
Read more about the course

Software Development

You will learn:

  • How to write code and design program architecture
  • How to model databases using UML, sequence diagrams, and other tools
  • How to effectively use Git for team collaboration
  • The advantages of agile development and the connection between development and operations (DevOps)

Relational Databases

In this section, you will master:

  • The differences between OLTP and OLAP databases
  • The basics of data modeling and normalization
  • Key SQL queries that every data engineer should know

Additional Topics

At the end of the course, you will find useful links and recommendations on the following topics:

  • Fundamentals of computer networking
  • Linux
  • REST API

Sounds like a lot? Don't worry! We will go through each section step-by-step, with plenty of examples. For each mentioned tool, I have prepared links to resources where you can learn how to use them or deepen your knowledge.

Watch Online

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Understanding Cognitive Biases

Understanding Cognitive Biases

Sources: Wondrium by The Great Courses, Alexander B. Swan
Understand how your brain’s efficiency shortcuts can leave you with a biased view of the world and learn how to combat these tendencies in your everyday life. A
10 hours 51 minutes 35 seconds
Learn Hugging Face by Building a Custom AI Model

Learn Hugging Face by Building a Custom AI Model

Sources: zerotomastery.io
Explore the Hugging Face ecosystem from scratch, including Transformers, Datasets, Hub/Spaces, and much more by creating and customizing your own AI model...
6 hours 32 minutes 55 seconds
DNS course for developers

DNS course for developers

Sources: Ruurtjan Pul
Learn DNS once and for all. They say you should learn the fundamentals, and the rest will fall into place. DNS is right at the foundation of the internet. Having a clear underst...
2 hours 44 minutes 2 seconds
Great Thinkers, Great Theorems

Great Thinkers, Great Theorems

Sources: Wondrium by The Great Courses, Dr. William Dunham
Delve into the mechanics of some of math's greatest and most awe-inspiring achievements. Explore the most awe-inspiring theorems in the 3,000-year history of ma
12 hours 14 minutes 35 seconds
Complete Guide to Protocol Buffers 3 [Java, Golang, Python]

Complete Guide to Protocol Buffers 3 [Java, Golang, Python]

Sources: udemy
Protocol Buffers (protobuf) is a fundamental data serialization format that every Data Engineer should know about. It is leveraged by many top tech companies su
3 hours 53 minutes 59 seconds