Skip to content

SQL, JDBC, and MongoDB tasks with MySQL queries, Java database operations, and MongoDB dataset queries. Includes screenshots, automation workflows, and clean project structure.

License

Notifications You must be signed in to change notification settings

TheComputationalCore/sql-jdbc-mongodb-tasks

Repository files navigation

SQL + JDBC + MongoDB Tasks

Java Build Markdown Lint Prettier Format License

A structured repository containing SQL queries, JDBC operations and MongoDB tasks.
The project demonstrates backend fundamentals using MySQL, Java, and MongoDB.


Project Structure

sql-jdbc-mongodb-tasks/
├── .github/workflows/
├── screenshots/
├── 1.sql
├── MyDatabaseConnection.java
├── QuestionTwo.java
├── MONGODB TASK.docx
├── README.md
└── LICENSE

Task 1 – SQL Queries

These SQL queries run on the Empl table.

Screenshots

Full Table
Salary ≥ 2200
NULL Commission
Not Between 2500 and 4000
No Manager
Third Letter A
Ends With T
SQL Script


Task 2 – JDBC (Java)

Database Connection

JDBC Connection

Output

Connection Created


Task 3 – MongoDB Queries

Queries performed on a product dataset.
See MONGODB TASK.docx.


Run Instructions

SQL

mysql -u root -p
use tasks;
source 1.sql;

Java

javac MyDatabaseConnection.java QuestionTwo.java
java MyDatabaseConnection
java QuestionTwo

MongoDB

mongoimport --db mydatabase   --collection products   --file product.json   --jsonArray

License

MIT License

About

SQL, JDBC, and MongoDB tasks with MySQL queries, Java database operations, and MongoDB dataset queries. Includes screenshots, automation workflows, and clean project structure.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages