Module 2 Course Overview

Module-2

Module-2 covers your back end databases and server programming in Java and SQL.

Section-1 - Intro to tools

• Student Guide - Discover the many ways you'll use the Bootcamp OS platform to learn during the course.
• How do I...? - Learn how to perform common tasks that you'll do during the course.
• Visual Studio - Learn about the Visual Studio integrated development environment (IDE) and its basic features and operation.
• PostgresSQL - Learn about PostgresSQL and use pgAdmin to set up example databases.
• Postman - Learn about Postman and how to use it to test APIs.
• NPM - Learn about NPM packages, and how to install and run them.

Section-2 - Client-Server Programming in Java

• Intro to Databases - Learn the basics of relational databases, and how to retrieve data from them with simple queries.
• Ordering, Limiting, and Grouping - Learn how to order and group SQL queries.
• SQL Joins - Learn how to join tables in SQL.
• Insert, Update, and Delete - Learn how to use SQL to add, update, and delete data to, in, and from databases.
• Database Design - Learn about creating new databases.
• Data Access and DAO - Learn about accessing databases and the DAO pattern.
• DAO Testing - Learn about testing DAO's with integration tests.
• Data Security - Learn about protecting application data from accidental or intentional misuse.
• Networking and HTTP - Learn about how programs communicate across the web.
• Consuming RESTful APIs (Part 1) - Learn how to retrieve data from a web API.
• Consuming RESTful APIs (Part 2) - Learn how to send data to a web API and handle errors.
• Server-Side APIs (Part 1) - Start building REST APIs with the Spring Framework.
• Server-Side APIs (Part 1) - Learn more about creating fully-featured REST APIs.
• Securing APIs - Learn about authentication, authorization, and how to protect your API.

Exercises

You can find the exercise files for this module here. Exercises are separated by category and then by both the original exercise code and then my finished code.