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
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | Introduction | 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 |
Books
Read Book Computer Science Fundamentals
| # | Title |
|---|---|
| 1 | Computer Networking Links |
| 2 | Linux Links |
| 3 | Software Development Links |
Comments
0 commentsSimilar courses
Building an Interpreter from scratch
Sources: udemy, Dmitry Soshnikov
How programming languages work under the hood? What’s the difference between compiler and interpreter? What is a virtual machine, and JIT-compiler? And what abo
2 hours 59 minutes 53 seconds
OpenSSL Training
Sources: Practical Networking (practicalnetworking.net)
The course "Практическое руководство по OpenSSL" offers comprehensive training on using OpenSSL for analyzing, diagnosing, and solving issues related...
1 hour 46 minutes 2 seconds
The Complete Basic Electricity & Electronics Course
Sources: udemy
Knowledge of Electricity and Electronics is extremely valuable nowadays! Electronic circuits are everywhere, from computers and smartphones, to home appliances
6 hours 39 minutes 38 seconds
Garbage Collection Algorithms
Sources: udemy, Dmitry Soshnikov
Memory leaks and dangling pointers are the main issues of the manual memory management. You delete a parent node in a linked list, forgetting to delete all its
2 hours 13 minutes 20 seconds
Want to join the conversation?
Sign in to comment