❗The content presented here is sourced directly from freeCodeCamp platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [February 21st, 2023]

This course provides an intermediate tutorial on GraphQL server boilerplate with Typescript, PostgreSQL and Redis. It covers topics such as setting up a TypeORM project, creating a TypeORM entity, creating a user login with TypeORM, setting up Jest, setting up a test database with TypeORM, GraphQL schema stitching, handling errors in GraphQL, GraphQL validating input, email confirmation link with Redis, Jest global setup, testing Redis email link, fixing connection error, sending confirmation email with SparkPost, GraphQL login mutation, Express session for login, GraphQL middleware, running Jest tests sequentially, logging or authentication GraphQL middleware, simple logout with GraphQL, building a GraphQL server test client, logout of multiple sessions, forgot password test case, lock user account GraphQL, GraphQL forgot password implementation, rate limiting, Twitter OAuth, OAuth demo with React, getting the Jest tests to run in parallel, merging a modular GraphQL schema, and removing the race conditions from the tests.
Possible Development Paths include becoming a full-stack developer, specializing in GraphQL, becoming a software engineer, specializing in web development, becoming a database administrator, specializing in PostgreSQL, becoming a DevOps engineer, specializing in Redis, and becoming a software architect, specializing in Typescript.
Learning Suggestions for learners include taking courses on web development, database administration, DevOps engineering, software architecture, and software engineering. Learners should also practice coding and build projects to gain experience in GraphQL, PostgreSQL, Redis, Typescript, and other related technologies. Additionally, learners should stay up to date with the latest trends in the industry and network with other professionals in the field.

[Applications]
It is recommended that those who have completed the GraphQL Server Intermediate Tutorial - Boilerplate with Typescript PostgreSQL and Redis course apply their knowledge by creating their own GraphQL server with the same technologies. They should also practice writing tests for their server and use the techniques learned in the course to handle errors, validate input, and implement authentication and authorization. Additionally, they should explore other technologies such as OAuth and rate limiting to further secure their server.

[Career Paths]
1. GraphQL Developer: GraphQL Developers are responsible for designing, developing, and maintaining GraphQL applications. They must have a strong understanding of GraphQL, its syntax, and its capabilities. They must also be familiar with the latest trends in GraphQL development, such as schema stitching, validating input, and rate limiting.

2. Database Administrator: Database Administrators are responsible for managing and maintaining databases. They must have a strong understanding of database technologies, such as PostgreSQL and Redis, and be familiar with the latest trends in database administration, such as setting up a test database with TypeORM and using Jest for testing.

3. Web Developer: Web Developers are responsible for designing, developing, and maintaining web applications. They must have a strong understanding of web technologies, such as HTML, CSS, and JavaScript, and be familiar with the latest trends in web development, such as using GraphQL Yoga and Express Session for login.

4. DevOps Engineer: DevOps Engineers are responsible for managing and maintaining the infrastructure of an application. They must have a strong understanding of DevOps tools and processes, such as setting up a TypeORM project and using SparkPost for email confirmation. They must also be familiar with the latest trends in DevOps, such as running Jest tests sequentially and merging a modular GraphQL schema.