Final Exam: Full Stack Developer

WHAT YOU WILL LEARN

• 

  add Angular Material design components to an Angular project
  

  add a Node and Express backend server for a MEAN application
  

  build API routes with Express to handle interaction with a MEAN app
  

  build data models for a MERN application using MongoDB and Mongoose
  

  configure a Redux store for a MERN application
  

  configure React Router to handle various routes for a MERN application
  

  configure Registration and Login forms for a MERN application
  

  connect to MongoDB and handle errors gracefully using a try/catch block
  

  connect to MongoDB with Mongoose
  

  create a home page and nav components for a MERN application
  

  create and execute unit tests using the Jest unit testing framework
  

  create a new project with the Angular CLI
  

  create a working mockup with Angular components and templates
  

  demonstrate how to configure Azure SQL database auditing using the Azure Portal
  

  demonstrate how to enable Advanced Data Security and start classifying data, tracking vulnerabilities and investigating threat alerts
  

  demonstrate how to explore Advanced Threat Protection alerts for the Azure SQL database using the Azure Portal
  

  demonstrate how to run a Vulnerability Assessment scan using the Azure Portal and analyze the results and setting a baseline
  

  demonstrate the steps to configure and manage Azure Active Directory authentication with the Azure SQL database
  

  demonstrate the steps to configure and test an Azure SQL database
  

  demonstrate the steps to control and grant database access to the MS Azure SQL database
  

  deploy a MERN application to Heroku cloud-based platform as a service
  

  describe the best practices one should use when working with SQL code
  

  describe the difference between DDL and DML statements in SQL and identify some of the more common commands for each category
  

  describe the reasons to use either SQL or and NoSQL databases in FSD
  

  describe what SQL is and identify the role SQL plays when using a relational database in FSD development
  

  differentiate between relational and non-relational databases and recognize their basic structure
  

  differentiate between relational and non-relational (NoSQL) databases
  

  discuss the OWASP security list and the benefits of using this list during software development and deployment
  

  identify areas for enhancing performance when using NoSQL databases
  

  identify available NoSQL databases and the advantages of using them
• 

  identify security issues when using NoSQL databases and methods to prevent these security issues
  

  identify security planning methods and common database security and data breach concerns
  

  identify situations when a relational database should be used in FSD development
  

  identify the advanced security options when using the MS Azure SQL database
  

  identify the available data platforms and the strengths and weaknesses of each platform
  

  identify the available data platforms and the strengths and weaknesses of each platform
  

  identify the cloud options for NoSQL database and how to choose the best one for your project
  

  identify the reasons to use either SQL or and NoSQL databases in FSD
  

  identify the steps for installing and configuring the MongoDB database locally
  

  identify the steps for installing and configuring the MS SQL Server database locally
  

  identify the steps for installing and configuring the MySQL database locally
  

  identify the steps for installing and configuring the PostgreSQL database locally
  

  install and configure the PostgreSQL relational database system for use in FSD development
  

  install Node, Express and dependencies for a full-stack Angular application
  

  prepare a MEAN application for deployment to Heroku cloud-based platform as a service
  

  prepare the dependencies for developing the back end of a MERN application
  

  prepare the dependencies for developing the front end of a MERN application
  

  recognize key considerations when beginning a MERN application
  

  recognize key considerations when planning a MEAN application
  

  recognize the level of SQL programming knowledge required by an FSD developer
  

  recognize unstructured data and how it applies to NoSQL databases
  

  register for a cloud-based MongoDB Atlas account and create a working cluster for a MEAN application
  

  register for a cloud-based MongoDB Atlas account and create a working cluster for a MERN application
  

  review the features of using the MongoDB database system
  

  understand best practices for using DB logs to analyze for security and data breaches
  

  understand how to incorporate data security testing in the CI/CD pipeline
  

  use Alembic to manage a database revision
  

  use JSON web token authentication in an MEAN application
  

  use JSON web token authentication in an MERN application
  

  validate request body payloads for API routes