Database Concepts | ER‐model. Relational model: relational algebra, tuple calculus, Integrity constraints, normal forms. File organization, indexing (e.g., B and B+ trees), Transactions and concurrency control. |
SQL Queries | Select, view, truncate, delete, update, alter, Inner join, different types of outer joins, use of aggregate functions, Union, intersection, except, in and exist clauses, nested queries |
Programming Concepts (Java /C C++) | Program control (iteration, recursion, Functions), Scope of variables, Binding of variables & functions, Parameter passing, Functional and Logic Programming, OOPS Concepts, Inheritance, Class and object, Constructors, Functions, Exception Handling |
Data Analytics Languages (Python / R) | Regex, Slicing, Data reshaping, Data frames, Dictionaries and Sets, File Management, Classes and Functions, Data Mining, Lists, Importing and exporting data, charts, and graphs |
Algorithms for problem-solving | Tree and graph traversals, connected components, Spanning trees, shortest paths, hashing, Sorting, Searching; Design techniques (Greedy, Dynamic Programming, Divide- and-conquer) |
Networking Concepts | ISO/OSI stack, LAN Technologies (Ethernet, Token ring), TCP/UDP, IP, Basic concepts of switches, gateways, and routers, Application layer protocols (DNS, SMTP, POP, FTP, HTTP), Firewalls |
Information & Cyber Security Concepts | Cyber Attacks, Software Development Security, Network Security, Authentication, CIA - Confidentiality, Integrity and Availability, Network Audit, Systems Audit |
Data warehousing | Data Extraction, Data Cleaning, Data Transformation, Data Loading, Metadata, Data Cube, Data Mart, Data Models, |
Shell Programming | Shell Scripting Basics, Shell Variables, Shell Script Arguments, If Statement, Loop, Return, Basic UNIX commands |