Basic Python Syllabus:
Introduction to Python:
Setting up the Python environment (installation, IDEs like VS Code or PyCharm).
Basic syntax, variables, data types (integers, floats, strings, booleans).
Operators (arithmetic, comparison, logical).
Control Flow:
Conditional statements (if, elif, else).
Looping constructs (for, while loops).
Break and continue statements.
Data Structures:
Lists, tuples, dictionaries, sets – creation, manipulation, and common methods.
Functions and Modules:
Defining and calling functions.
Parameters and return values.
Introduction to built-in functions and external modules.
File Handling:
Reading from and writing to files.
Error handling with try-except blocks.
Object-Oriented Programming (OOP) Fundamentals:
Classes, objects, attributes, and methods (introduction).
Basic SQL Syllabus:
Introduction to Databases and SQL:
Relational database concepts.
Introduction to SQL and its purpose.
SQL sublanguages (DDL, DML, DCL, TCL).
Data Definition Language (DDL):
CREATE TABLE, ALTER TABLE, DROP TABLE.
Data types in SQL.
Constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE).
Data Manipulation Language (DML):
INSERT (adding data).
SELECT (retrieving data) – basic queries, WHERE clause, ORDER BY, LIMIT.
UPDATE (modifying data).
DELETE (removing data).
Advanced SQL Concepts (Basic Level):
Aggregate functions (COUNT, SUM, AVG, MIN, MAX).
GROUP BY and HAVING clauses.
Introduction to Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).