LAP 2

In LAP 2 we look at databases, both relational and non-relational. You'll learn to work with them, as well as connect them to apps by starting to build some APIs of your own. We'll also cover some important Computer Science concepts here by discussing Systems Architecture, Performance.

Topics

Topic	Description	Technologies
Intro to System Architecture	Overview of application scaling, architecture and design patterns.	N/A
Intro to Databases	High level discussion of the different types of databases, relational and non-relational, as well as key considerations when using one.	N/A
Internet Protocols & API Design	Considering SOAP and REST protocals, as well as the principles of good API design.	N/A
NoSQL	Building a NoSQL database with MongoDB.	Node.js - MongoDB - Docker
SQL	Building a SQL database with PostgreSQL.	SQL - PostgreSQL - Docker
Connecting WebApps to Databases	Adding databases to web applications.	Node.js - MongoDB - PostgreSQL
Authentication and Authorisation	Discussion of popular approaches as well as how to implement authentication and authorisation in web applications.	JavaScript - Node.js - Express.js - Bcrypt - JSON Web Tokens
Performance	Application performance considerations, algorithms and Big-O notation.	JavaScript
Intro to Cybersecurity	High level discussion of hackers, attack vectors and threat modelling.	N/A

Additional Resources

• PRG Pattern
• Docker 101
• Docker Compose 101
• Azure Docs
• AWS Deployment
• Deploying a Database