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

Watch Online Computer Science Fundamentals

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

Distributed Systems

Distributed Systems

Sources: Oz Nova (csprimer.com)
With the growth in the number of computers, they have not only increased in quantity, but also became distributed. If previously businesses aimed to purchase...
15 hours 35 minutes 10 seconds
Feature Flags: Transform Your Product Development Workflow

Feature Flags: Transform Your Product Development Workflow

Sources: Ben Nadel
My development team constantly deployed critical errors to production. We spent as much time fixing failures and writing reports on...
Become An Open Source Master

Become An Open Source Master

Sources: James Pearce
Open source is the key that can open many doors: incredible learning opportunities, career advantages, and influence on the entire industry.
2 hours 30 minutes 31 seconds
Classic Season 5

Classic Season 5

Sources: destroyallsoftware
In the "What Goes in Active Records" series (part 1 and part 2), we looked at some design constraints for what goes in ActiveRecord models. Sometimes, these con
3 hours 32 minutes 54 seconds