Course module
SQL (IT Specialist) — NIACL AO 2026 IT SPECIALIST
- Lessons
- 47
- Duration
- 4 hr 29 min
- PYQs
- 167
- Practice
- 363
2% of this course's PYQ weight is covered in this module.
Syllabus index
Lessons in this module
SQL
Introduction, Components & Structure
Select, Where, Distinct
Datatypes, Operators & Null
DDL, DML, DCL, TCL & Desc
Order By & Rename Operation (Alias)
Library Functions (Math, Aggregate, String, Date)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Group By Clause
Nested & Correlated Subqueries
Views & PLSQL Basics
Previous-year questions
PYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions18 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions44 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions30 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions22 questionsPYQ collectionPYQ Questions9 questionsPYQ collectionPYQ Questions12 questionsPYQ collectionPYQ Questions167 questionsPYQ collectionPYQ Questions167 questions
Explore the course
- Quantitative Aptitude
- Reasoning Ability
- English Language
- General Awareness
- C Concepts + MCQs (IT Specialist)
- Java (IT Specialist)
- Python (IT Specialist)
- OOPs (IT Specialist)
- DBMS (IT Specialist)
- Software Engineering (IT Specialist)
- Data Structure (IT Specialist)
- Operating System (IT Specialist)
- Compiler Design (IT Specialist)
- Computer Architecture (IT Specialist)
- Data Communication & Networking (IT Specialist)
- Descriptive Test (Main Exam)
Loading lesson…