SQL & Python Coding Curriculum

Beginner Level

Module 1: Introduction to Coding

• What is coding?

• Real-life uses of SQL and Python

• Understanding how computers follow instructions

• Introduction to coding environments (simple editors)

Module 2: Python Basics

• What is Python?

• Writing first program (print statements)

• Variables (numbers, text)

• Basic input and output

• Simple math operations

Module 3: Python Logic

• Conditional statements (if / else)

• Comparison operators

• Simple decision-making programs

• Practice with real-life examples

Module 4: Python Loops

• What is a loop?

• For loops and while loops

• Repeating tasks

• Simple pattern exercises

Module 5: Introduction to SQL

• What is a database?

• Tables, rows, and columns

• Understanding data organization

Module 6: Basic SQL Queries

• SELECT statements

• Filtering data (WHERE)

• Sorting results (ORDER BY)

• Viewing specific columns

Module 7: Combining Python & SQL Concepts

• Understanding how Python can work with data

• Simple examples of data handling

• Reading and displaying structured data

Module 8: Beginner Project

• Create a simple data tracker

• Use Python for input/output

• Use SQL concepts to organize information

Advanced Level

Module 1: Advanced Python Concepts

• Functions and reusable code

• Lists and dictionaries

• String manipulation

• Error handling (try/except)

Module 2: Working with Files in Python

• Reading from files

• Writing to files

• Organizing data into structured formats

Module 3: Intermediate SQL

• INSERT, UPDATE, DELETE

• Creating tables

• Data types in SQL

• Primary keys

Module 4: Advanced SQL Queries

• JOIN statements

• Aggregation (COUNT, SUM, AVG)

• GROUP BY and HAVING

• Subqueries

Module 5: Connecting Python to SQL

• Using Python with databases

• Running SQL queries from Python

• Fetching and displaying results

Module 6: Data Analysis Basics

• Cleaning data

• Filtering datasets

• Simple data insights

• Organizing results clearly

Module 7: Project-Based Learning

• Build a mini database system

• Create a user input program in Python

• Store and retrieve data using SQL

Module 8: Final Project

• Design a real-world application (examples: student tracker, inventory system)

• Use Python for logic and interaction

• Use SQL for data storage

• Present completed project

​