Home / Courses / Syllabus
COURSE SYLLABUS · SARASWATI INFOTECH (SIIT)

Learn What Matters. Master What You Use.

Explore a structured, practical syllabus covering computer fundamentals, operating systems, MS Office 2024, DOS, networking, TallyPrime, Photoshop, CorelDRAW X7, programming, web development, databases, digital marketing, hardware and more.

SIITComputer Skills
• Practice • Projects
← Back to Subjects SUBJECT SYLLABUS

SQL Programming

SIIT-DB12-03 · Database Management – SQL & MySQL
Detailed Syllabus
  • Unit 1: SQL Fundamentals
  • Unit 2: Data Definition & Manipulation
  • Unit 3: Queries
  • Joins & Subqueries
  • Unit 4: Views
  • Functions & Procedures
  • Unit 5: Advanced SQL Programming
SOFTWARE & TECHNOLOGY TRACK

Core Software Skills Covered at SIIT

The syllabus is designed around software and technology areas commonly used for office work, accounting, design, programming, web development and computer operations.

OFFICE PRODUCTIVITY

MS Office 2024

Word, Excel, PowerPoint, Outlook and Access concepts, document formatting, spreadsheets, presentations, data handling, formulas, charts, mail and office automation.

ACCOUNTING

TallyPrime + GST

Company setup, ledgers, vouchers, sales and purchase, inventory, banking, reports, GST workflows, e-invoicing, e-way bills and practical accounting.

GRAPHIC DESIGN

Photoshop

Layers, selections, masks, retouching, colour correction, typography, image composition, background work, export and practical design projects.

VECTOR DESIGN

CorelDRAW X7

Vector drawing, shapes, curves, text, fills, outlines, page layout, logo work, print design, banners and practical DTP projects.

OPERATING SYSTEM

DOS & Windows

DOS commands, file and directory management, paths, system basics, Windows installation concepts, configuration, utilities and troubleshooting.

NETWORKING

Computer Networking

LAN/WAN, network topologies, IP addressing, TCP/IP, switches, routers, Wi-Fi, sharing, basic security, troubleshooting and practical network setup.

PROGRAMMING

C, Python & Logic

Programming fundamentals, variables, operators, conditions, loops, functions, data structures, problem solving, files, OOP concepts and projects.

WEB TECHNOLOGY

HTML, CSS, JS, PHP & MySQL

Responsive web design, front-end structure, JavaScript basics, PHP, databases, forms, CRUD concepts, hosting and practical website projects.

PRACTICAL LEARNING

Not Just Topics. Skills + Practice + Projects.

Where appropriate, course modules are supported by hands-on exercises, assignments, software practice, troubleshooting, document creation, accounting entries, design work, networking practice, coding tasks and project work. The exact course structure can be maintained from the admin panel instead of hard-coding the public page.

Find the right computer course for you.

Explore course details, duration, fees and admission options at Saraswati Infotech (SIIT).