LernX – SQL & Database Foundations Internship

Duration: 4 Weeks
Level: Beginner to Intermediate

Module 1 – Database Foundations

• What is DBMS?

• Types of Databases

• RDBMS Concepts

• Tables, Rows, Columns

• Primary Keys & Foreign Keys

• Installing Oracle SQL Developer

• Database Connections

Module 2 – SQL Fundamentals

• SELECT Statement

• WHERE Clause

• ORDER BY

• DISTINCT

• LIKE

• BETWEEN

• IN Operator

• LIMIT / FETCH

Module 3 – Working with Data

• INSERT

• UPDATE

• DELETE

• CREATE TABLE

• ALTER TABLE

• DROP TABLE

• Constraints

• Data Types

Module 4 – Relational SQL

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• UNION

• GROUP BY

• HAVING

• Aggregate Functions

Module 5 – Mini Project

Students build:

• Student Management Database
  OR

• Inventory Management System

Project Includes:

• Table Design

• Relationships

• Data Insertion

• Query Reports

• Join Queries

• Analytics Queries

Live Session Activities

• Query Debugging

• SQL Practice Challenges

• Database Design Discussion

• Mini Project Reviews

Internship Outcome

Students will:

• understand relational databases

• write SQL queries confidently

• build mini database systems

• perform joins and reporting

• understand practical business data handling