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.