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

  • 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
  • Automata Theory: inside a RegExp machine

    Automata Theory: inside a RegExp machine

    Sources: Dmitry Soshnikov
    State machines — the fundamental concept used today in many practical applications, starting from UI programming like React, automated reply systems, lexical an
    1 hour 48 minutes 5 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
  • Clean Code

    Clean Code

    Sources: udemy, Academind Pro
    As a developer, you should be able to write code which works - of course! Unfortunately, a lot of developers write bad code nonetheless - even though the code works. Because "wo...
    6 hours 41 minutes 15 seconds
  • Communication Masterclass 2.0

    Communication Masterclass 2.0

    Sources: Ganesh Prasad
    This course will help you express your thoughts confidently and clearly in 6 weeks. It includes over 13 hours of pre-recorded video lectures, 26 live sessions w
    11 hours 49 minutes 3 seconds