Backend Developer Fundamentals

Welcome to the Course

This course is designed to help you learn the necessary skills to build backend servers using Postgres and Node.js. I’ve been teaching databases and backend development for over 10 years and I believe this online course to be an effective and fun way to learn these skills. In this course you will learn to build production ready applications.

Intended Audience

This course is intended for people with some minimal experience with Javascript. In addition, some knowledge of HTML and CSS will help. If you have strong skills in another programming language you will be fine. If you are a complete beginner, this course will be doable but may be challenging.

Modules

On the menu bar at the top of this page you will see that the course consists of a number of modules. These modules are designed to introduce you to the key elements of backend development and introduce you to the tools you will need to successfully write backend applications. The only way to proficient with this material is to practice and as such the modules are designed to encourage you in your productive wrangling and exploration of Postgres and Node.js.

What you’ll learn

Postgresql and SQL

  • What are relational and SQL databases
  • What are the prime use cases for SQL databases
  • Under what conditions would you select a noSQL database server
  • How to design and create relational databases
  • How to insert data into a database
  • How to query a database

Javascript and node.js

  • basic fluency with Javascript
  • skills withasynchronous I/O
  • connecting to a database
  • developing a real-time web application backend

Deployment

  • How to deploy to a server
  • How to set up a reverse proxy server

Conceptual Overview of the Architecture of a Web Application

This videos are a few years old but should give you a basic understanding of a few key concepts.

Model View Controller

REST Web Services