Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
End-to-End Java Development Bootcamp
·
Module 7
SQL and Database Fundamentals
1
Retrieving and Sorting Data with SQL
Write SQL queries to retrieve and sort data using SELECT, WHERE, and ORDER BY.
2
Designing Tables with Keys and Data Types
Create tables with primary keys, foreign keys, and appropriate data types.
3
SQL Aggregation with GROUP BY
Write SQL queries using GROUP BY and aggregate functions (COUNT, SUM, AVG).
4
Mastering SQL Joins: INNER and LEFT
Combine data from multiple tables using INNER JOIN and LEFT JOIN.
5
Database Normalization: Purpose and 3NF Example
Explain the purpose of database normalization (up to 3NF) with an example.
6
Connecting Java to Databases with JDBC
Connect a Java application to a database using JDBC.
7
PreparedStatement for Secure Queries
Execute parameterized queries using PreparedStatement to prevent SQL injection.
Previous module
Modern Java: Lambdas and Streams
Next module
Building REST APIs with Spring Boot