We may earn an affiliate commission when you visit our partners.
Udacity logo

Creating an API with PostgreSQL and Express

Andrew Wong, Rachel Manning, Guillaume Bibeau Laviolette, and Alyssa Hope
This course covers the primary skills required for API development. Students will build a RESTful JSON API with Node and Postgres. Along the way, you will cover essential topics like databases and querying, API architecture, database migrations, REST, CRUD,...
Read more
This course covers the primary skills required for API development. Students will build a RESTful JSON API with Node and Postgres. Along the way, you will cover essential topics like databases and querying, API architecture, database migrations, REST, CRUD, creating a testing environment, password hashing and route authorization via JWTs. By completing the exercises and course content, students will gain the knowledge to create a secure, well organized API from scratch and learn skills JavaScript developers use every day.

What's inside

Syllabus

Welcome to the very beginning of the APIs with Postgres course! In this lesson we will kick things off by talking about the course contents and requirements, and all get on the same page with APIs.
Read more
This lesson will focus solely on databases. We'll cover various types of databases, each with their own strengths and then hone our attention in on SQL and the relational database Postgres.
You know some Postgres and Node. This lesson is all about getting them to talk to each other. We will cover many vital web development concepts and create a clean and dependable API structure.
Making the data in our database accessible to the outside world is the whole job of our API. In this lesson we cover the libraries and logic needed to make our API able to respond to outside requests.
No API is complete without offering adequate protection and privacy. This lesson is all about industry standard methods for protecting information and requiring authorization for private pages
Now that you've seen the bigger picture for utilizing Postgres and Node to create an API, we circle back around to explore some new Postgres syntax and apply it in the API.
Imagine yourself as a developer at a small company where you and your coworker are building a shopping app. Your task is to use the skills and knowledge from this course to create the API.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Well-suited for aspiring or early career web developers or those seeking industry standards
Taught by recognized professionals in their field
Takes a hands-on approach by building out an API from scratch
Develops core skills used daily by practicing JavaScript developers
May require additional knowledge to follow, but strong foundational concepts
Requires students to come in with a strong foundation in node.js

Save this course

Save Creating an API with PostgreSQL and Express to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Creating an API with PostgreSQL and Express. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Creating an API with PostgreSQL and Express will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Creating an API with PostgreSQL and Express.
An in-depth look at the architectural considerations and challenges of designing and building data-intensive applications. Provides valuable insights into data modeling, storage, and processing.
A practical guide to securing APIs. Covers a wide range of security threats and vulnerabilities, and provides best practices and techniques for protecting APIs from unauthorized access and malicious attacks.
Valuable source of recipes and examples for creating RESTful web services. Includes plenty of real-world examples of API design and implementation in various programming languages.
A collection of design patterns commonly used in Node.js development. Provides valuable insights into best practices and architectural patterns for building scalable and maintainable applications. Can be helpful in understanding the design considerations and patterns used in API development.
The official tutorial for PostgreSQL. Provides a comprehensive overview of PostgreSQL, including installation, configuration, SQL syntax, and database administration. Serves as a valuable reference for Postgres-specific concepts and techniques.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Creating an API with PostgreSQL and Express.
Next JS and Google Maps API : Location-Based Ride Requests
AI Applications and Prompt Engineering
Azure API Management
REST API Design, Development & Management
gRPC [Golang] Master Class: Build Modern API &...
APIs in Java: Call and Integrate an API
gRPC [Java] Master Class: Build Modern API & Micro...
Software testing and Automation of APIs with UFT/QTP
WebServices/Rest API Testing with SoapUI +Real time...
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser