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.