Basic Queries:
SELECT statements, WHERE clause, ORDER BY, GROUP BY
Joins (INNER, LEFT, RIGHT, FULL)
Aggregation functions (SUM, COUNT, AVG, MIN, MAX)
Subqueries and nested queries
Advanced Queries:
Window functions (ROW_NUMBER, RANK, DENSE_RANK)
Common Table Expressions (CTEs)
Transactions and isolation levels
Indexes and performance tuning
Stored procedures and triggers
Data Manipulation:
INSERT, UPDATE, DELETE statements
MERGE statement
Handling NULL values and constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK)
Database Design:
Normalization and denormalization
ER diagrams
Relational vs. non-relational databases
Python:
Basic Syntax and Data Types:
Variables, data types (int, float, string, list, tuple, set, dictionary)
Control structures (if, for, while, try-except)
Functions and Modules:
Defining and calling functions
Lambda functions
Importing and using modules (math, datetime, random, etc.)
Object-Oriented Programming:
Classes and objects
Inheritance, polymorphism, encapsulation
Magic methods and operator overloading
Libraries and Frameworks:
Numpy and Pandas for data manipulation
Flask/Django for web development (basic understanding)
Requests for HTTP requests
Unittest and Pytest for testing
File Handling:
Reading and writing files (text, CSV, JSON)
Working with file paths and directories
Data Structures and Algorithms:
Lists, stacks, queues, trees, graphs
Searching and sorting algorithms
Time and space complexity analysis
2nd Round: Computer Networks
Network Fundamentals:
OSI and TCP/IP models
IP addressing (IPv4 and IPv6)
Subnetting and CIDR notation
MAC addressing
Protocols and Services:
HTTP/HTTPS, FTP, SMTP, DNS, DHCP
TCP vs. UDP
Routing protocols (RIP, OSPF, BGP)
Switching and VLANs
Network Devices:
Routers, switches, hubs, bridges
Firewalls, load balancers, gateways
Wireless and Wired Networks:
Ethernet standards (10/100/1000 Mbps)
Wi-Fi standards (802.11 a/b/g/n/ac/ax)
Bluetooth, NFC
Network Security:
Encryption (SSL/TLS, VPNs)
Firewalls and intrusion detection/prevention systems
Security protocols (WPA/WPA2, IPSec)
Network Troubleshooting and Tools:
Ping, Traceroute, nslookup, netstat
Wireshark for packet analysis
Network performance monitoring tools (Nagios, Zabbix)
Preparation Tips:
Practice Coding: Use online platforms like LeetCode, HackerRank, or CodeSignal to practice SQL and Python problems.
Mock Interviews: Participate in mock interviews to get comfortable with the interview format and to receive feedback.
Review Key Concepts: Regularly review and reinforce key concepts in SQL, Python, and computer networks.
Hands-On Experience: Set up personal projects or labs to gain practical experience, especially for network configurations and coding exercises.
