SDE201 : Designing REST APIs and SQL Database Schemas for web applications
Learn with Arnav Gupta
3 modules
English
Certificate of completion
Lifetime access
Learn to design entity schema, model SQL tables and generate a REST API for trivial projects like blogging app, ecommerce website etc.
Overview
In this course we will learn to build REST APIs to power two basic apps
- A blogging app
- A shopping website
We will be using the following methodolgies
- Modelling database as a classical SQL-based RDBMs (like PostgreSQL/MySQL)
- Modelling APIs as standard REST API with JSON responses
- Entities, and relationships between them
Who is it for ?
- Someone with 1+ years of production SDE experience should be able to design APIs and model db schema for trivial apps like these ones
- If you are an SDE1 and looking forward to becoming a good SDE2 soon (promotion/job whatever way) - this might be useful for you
- If you are someone who already designs APIs and manages DBs in production for thousands of users or more, you may not need this :)
Key Highlights
Understand principles of RESTful API design
Learn to design efficient SQL database schemas
Implement best practices for web application APIs
Hands-on experience with API and schema design
Strategies for scalability and security in web apps
What you will learn
Designing REST APIs
Learn how to design REST APIs for web applications following best practices and industry standards.
Creating SQL Database Schemas
Understand how to create efficient SQL database schemas that support the application requirements and ensure data integrity.
Modules
Introduction to REST APIs
5 attachments • 10 mins
What are REST APIs?
Designing a REST API: Exercise 1 - Blogging App
Designing a REST API: Exercise 2 - Shopping Website
Designing Database Schema and Queries - Exercise 1 : Blogging App
Designing Database Schema and Queries: Exercise 2 - Shopping Website
Project 01: Blogging Website
5 attachments • 1 hrs
Blogging Website: 01 Project Overview
Blogging Website: 02 Defining Entities
Blogging Website: 03 Database Schema and Create SQL
Blogging Website: 04 Basic API Endpoints
Blogging Website: 05 Api Response Codes
Project 02: Shopping Site
4 attachments • 48.41 mins
Shopping Site: 01: Project Overview
Shopping Site: 02: Defining Entities
Shopping Site: 03: Creating Functional Requirements
Shopping Site: 04: Table and Column Definitions
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with Arnav Gupta
Rate this Course
₹ 199.00
₹999
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
