SEBI Grade A - Information Technology

SEBI Grade A - Information Technology - Phase I

Phase I Information Technology syllabus for SEBI Grade A.

Course content is locked
Explore the syllabus below. Unlock the course to access study material and mock tests.
Get Started

Phase I

Information Technology preparation.

Database Concepts

ER-model, relational model, relational algebra, tuple calculus, integrity constraints, normal forms, file organization, indexing, transactions and concurrency.

SQL Queries

SQL queries, joins, aggregate functions, set operations and nested queries.

Programming Concepts (Java / C / C++)

Program control, functions, OOPS concepts, inheritance, classes, objects, constructors and exception handling.

Data Analytics Languages (Python / R)

Regex, slicing, data reshaping, dataframes, dictionaries, sets, file management, classes, functions, data mining and visualization.

Algorithms for Problem Solving

Tree and graph traversals, connected components, spanning trees, shortest paths, hashing, sorting, searching and design techniques.

Networking Concepts

ISO/OSI stack, LAN technologies, TCP/UDP, IP, network devices, application layer protocols and firewalls.

Information & Cyber Security Concepts

Cyber attacks, software development security, network security, authentication, CIA and auditing.

Data Warehousing

Data extraction, data cleaning, transformation, loading, metadata, data cubes, data marts and data models.

Shell Programming

Shell scripting basics, variables, arguments, control statements and basic UNIX commands.

Phase II

Advanced Information Technology preparation.

Algorithms

Sorting, searching, greedy algorithms, dynamic programming, backtracking, divide and conquer and pattern searching.

Data Structure

Array, linked list, stack, queue, binary tree, indexing, binary search tree, heap, hashing, matrix and JSON objects.

String Manipulation

Length, substring, regex and search.

Object Oriented Programming

Abstraction, encapsulation, polymorphism and inheritance.