LAP 2

In LAP 2 we look at databases, both relational and non-relational. You’ll get stuck into the back end by learning all about databases. Picking up SQL and NoSQL, you’ll be a pro at storing and managing data. You’ll even connect your databases to your front end via your own APIs. We’ll also cover off three more vital topics to any developer: containerisation, security and architecture.

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