Full Stack Web Development_ FS105: Backend and Database Architecture

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Welcome to the “Backend and Database Architecture” course! In this comprehensive journey through the heart of modern web development, you’ll delve into the intricate world of backend systems and databases. From understanding the core principles of backend architecture to mastering SQL and NoSQL databases, you’ll learn how to design, build, and scale robust web applications. Whether you’re a seasoned developer looking to strengthen your backend skills or an aspiring architect aiming to craft efficient, data-driven systems, this course equips you with the knowledge and practical expertise to excel in the dynamic realm of backend and database architecture

What Will You Learn?

  • Comprehensive Backend Knowledge: Acquire a deep understanding of backend architecture, server-side programming languages, and frameworks, enabling you to design and develop efficient backend systems for web applications.
  • Database Mastery: Gain expertise in relational (SQL) and NoSQL databases, including data modeling, query optimization, and database management, allowing you to choose the right database solution for various application requirements.
  • API Development Proficiency: Learn to create robust and secure RESTful and GraphQL APIs, covering everything from routing and authentication to implementing data retrieval and modification operations.
  • Scalability and Performance: Explore strategies for scaling backend systems and databases to handle high traffic loads, and master performance optimization techniques to ensure responsive and efficient applications.
  • Real-World Application: Apply your knowledge through hands-on projects, including designing, building, and deploying a fully functional web application, gaining practical experience in backend and database architecture.

Course Content

Module I

  • Topic 1: Introduction to Backend and Databases
    00:00
  • LO1: Define the key components of a Backend System and the role of Databases in Web applications
    00:00
  • LO2: Explain the difference between Backend development and Frontend development
    00:00
  • LO3: Demonstrate the basic structure and functions of a Relational Database System
    00:00
  • LO4: Compare different types of Databases (relational, NoSQL)
    00:00
  • LO5: Knowledge Check
  • Case Study: Introduction to Backend and Databases
  • Topic 2: Backend Technologies and Frameworks
    00:00
  • LO1: List popular Backend Technologies and Frameworks used in Web development
    00:00
  • LO2: Describe the Architecture of a Backend Framework and its role in facilitating application development
    00:00
  • LO3: Explain how to build a Simple Backend application
    00:00
  • LO4: Evaluate the advantages and disadvantages of different Backend Frameworks
    00:00
  • LO5: Knowledge Check
  • Case Study: Backend Technologies and Frameworks
  • Topic 3: Relational Database Management Systems (RDBMS)
    00:00
  • LO1: Define key concepts of Relational Databases Management Systems
    00:00
  • LO2: Explain how Data Normalization improves the efficiency of an RDBMS
    00:00
  • LO3: Describe how to create a Relational Database schema and write basic SQL queries to manipulate data
    00:00
  • LO4: Knowledge Check
  • Case Study: Relational Database Management Systems (RDBMS)
  • Topic 4: NoSQL Databases
    00:00
  • LO1: Identify different types of NoSQL Databases
    00:00
  • LO2: Explain the concept of Horizontal Scaling in NoSQL Databases
    00:00
  • LO3: Compare the performance and scalability of NoSQL Databases with Relational Databases
    00:00
  • LO4: Knowledge Check
  • Case Study: NoSQL Databases
  • Topic 5: RESTful API Development
    00:00
  • LO1: Define REST and describe the basic principles behind RESTful API design
    00:00
  • LO2: Explain how HTTP methods are used in RESTful APIs to perform CRUD operations
    00:00
  • LO3: Describe how to Develop a Simple RESTful API using a Backend Framework
    00:00
  • LO4: Knowledge Check
  • Case Study: RESTful API Development
  • Topic 6: GraphQL API Development
    00:00
  • LO1: Define GraphQL and describe how it differs from RESTful APIs
    00:00
  • LO2: Explain how GraphQL Queries are structured and the concept of a schema
    00:00
  • LO3: Describe how to Implement a basic GraphQL API with queries and mutations
    00:00
  • LO4: Compare the use of GraphQL and REST in terms of efficiency and data retrieval
    00:00
  • LO5: Knowledge Check
  • Case Study: GraphQL API Development
  • Topic 7: Data Security and Authentication
    00:00
  • LO1: Identify common Data Security Threats and describe methods for securing Backend Systems
    00:00
  • LO2: Explain how Authentication and Authorization mechanisms work in Securing APIs
    00:00
  • LO3: Describe how to Implement Secure User Authentication in a Backend system
    00:00
  • LO4: Knowledge Check
  • Case Study: Data Security and Authentication
  • Topic 8: Scaling and Load Balancing
    00:00
  • LO1: Define Scaling and explain its types
    00:00
  • LO2: Describe the benefits of Scaling to manage resource demands
    00:00
  • LO3: Define the purpose and functionality of a Load Balancer
    00:00
  • LO4: Describe how Load Balancing Works
    00:00
  • LO5: Knowledge Check
  • Case Study: Scaling and Load Balancing
  • Topic 9: Microservices Architecture
    00:00
  • LO1: Define Microservices Architecture and its core principles
    00:00
  • LO2: Explain the advantages and challenges of implementing a Microservices Architecture in Backend development
    00:00
  • LO3: Describe how to design a simple Microservices-based system for a real-world application
    00:00
  • LO4: Knowledge Check
  • Case Study: Microservices Architecture
  • Topic 10: Serverless Computing
    00:00
  • LO1: Define Serverless Computing and explain its key characteristics
    00:00
  • LO2: Describe how Serverless Computing Models differ from traditional Server-based Architectures
    00:00
  • LO3: Explain how to build a Serverless application using a Cloud provider
    00:00
  • LO4: Knowledge Check
  • Case Study: Serverless Computing
  • Topic 11: Database Management and Administration
    00:00
  • LO1: Identify the key responsibilities of a Database Administrator
    00:00
  • LO2: Explain the importance of Backup, Recovery, and Indexing in Database Management
    00:00
  • LO3: Evaluate the performance of a database system and propose improvements based on monitoring tools
    00:00
  • LO4: Knowledge Check
  • Case Study: Database Management and Administration
  • Module Based Quiz

Final Exam

Eton College

Learning often happens in classrooms
but it doesn’t have to.

+1 (604) 677-3866
info@etoncollege.ca