Course module
SQL (IT Specialist) — NIACL AO 2026 IT SPECIALIST
- Lessons
- 47
- Duration
- 4 hr 29 min
- PYQs
- 111
- Practice
- 280
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 Questions2 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions37 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions23 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions18 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions111 questionsPYQ collectionPYQ Questions111 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…