17 December 2024
30 May 2024
#CoreJava
Last updated - V4 (16-Sep-2025)
Key Concepts
| Topic | Sub-Topics | Basic | Intermediate | Advanced | Expert |
|---|---|---|---|---|---|
| Java Basics | History, Features, JVM, JRE, JDK, Hello World, Data Types, Variables, Operators, Keywords | ✅ | |||
| Control Statements | if-else, switch, loops (for, while, do-while), break, continue, return | ✅ | |||
| OOP Concepts | Class, Object, Constructor, Inheritance, Polymorphism, Encapsulation, Abstraction, Method Overloading | ✅ | ✅ | ||
| String Handling | String class, StringBuffer, StringBuilder, Immutable Strings, String Pool, String methods | ✅ | ✅ | ||
| Arrays | Single-Dimensional, Multi-Dimensional, Array class methods, Copying, Searching, Sorting | ✅ | ✅ | ||
| Wrapper Classes | Autoboxing, Unboxing, Primitive wrappers (Integer, Double, etc.) | ✅ | ✅ | ||
| Exception Handling | try-catch, finally, throw, throws, custom exceptions, exception hierarchy | ✅ | ✅ | ✅ | |
| Collections Framework | List, Set, Map, Queue, Iterator, Generics, Utility classes (Collections, Arrays) | ✅ | ✅ | ✅ | |
| Multithreading | Thread class, Runnable, Synchronization, Inter-thread communication, Executors, Concurrency utilities | ✅ | ✅ | ✅ | |
| Java I/O | Streams, Readers/Writers, File Handling, Serialization, NIO, NIO.2 | ✅ | ✅ | ✅ | |
| Inner Classes | Member, Local, Anonymous, Static nested classes | ✅ | ✅ | ||
| Java 8 Features | Lambda Expressions, Functional Interfaces, Streams API, Optional, Default/Static methods in interfaces | ✅ | ✅ | ✅ | |
| Memory Management | Stack vs Heap, Garbage Collection, Finalization, References (Soft, Weak, Phantom) | ✅ | ✅ | ✅ | |
| Java Reflection API | Class object, Reflection for methods, fields, constructors, Annotations | ✅ | ✅ | ||
| Annotations | Built-in annotations, Custom annotations, Meta-annotations, Processing annotations | ✅ | ✅ | ||
| JDBC | Driver types, Connection, Statement, PreparedStatement, ResultSet, Transactions | ✅ | ✅ | ✅ | |
| Serialization | Serializable interface, transient keyword, Externalizable | ✅ | ✅ | ||
| Java Networking | Socket, ServerSocket, Datagram, URL, HttpURLConnection | ✅ | ✅ | ✅ | |
| Java Security | Access Modifiers, Security Manager, Cryptography APIs, JAAS | ✅ | ✅ | ||
| JVM Internals | ClassLoader, Bytecode, JIT Compiler, Memory Areas, GC algorithms, JVM tuning | ✅ | ✅ | ||
| Design Patterns in Java | Singleton, Factory, Builder, Observer, Strategy, Proxy, DAO | ✅ | ✅ | ||
| Advanced Concurrency | Fork/Join framework, CompletableFuture, Parallel Streams, Locks, Atomic variables | ✅ | ✅ | ||
| Java Modules (Java 9+) | Module system, module-info.java, readability, exports, services | ✅ | ✅ | ||
| New Java Features (10?21) | var keyword, Records, Sealed classes, Switch Expressions, Pattern Matching, Virtual Threads | ✅ | ✅ |
Interview question
Related Topics
| Java_Versions |
| OOP Concepts |
| Collections |
| Exception_Handling |
| String_Class |
| MultiThread |
| Generics |
| JDBC |
| Java_IO |
25 May 2024
#SQL_Server
Last updated - V6 (05-Oct-2025)
Key Concepts
| Topic | SubTopics | Basic | Intermediate | Advanced | Expert |
|---|---|---|---|---|---|
| Introduction & Basics | Overview, Editions, Versions, Features | ✅ | |||
| Installation & Configuration | System Requirements, Installation, Configuration, Services | ✅ | ✅ | ||
| Databases | Creating Databases, Database Properties, Collation, Filegroups | ✅ | ✅ | ||
| Tables & Schemas | Creating Tables, Data Types, Constraints, Schemas | ✅ | ✅ | ||
| Data Types | Numeric, String, DateTime, Binary, XML, JSON | ✅ | ✅ | ||
| Primary & Foreign Keys | PK, FK, Relationships, Referential Integrity | ✅ | ✅ | ||
| Indexes | Clustered, Non-Clustered, Columnstore, Filtered Indexes | ✅ | ✅ | ||
| Views | Simple Views, Indexed Views, Partitioned Views, Security | ✅ | ✅ | ✅ | |
| Stored Procedures | Creating, Executing, Parameters, Error Handling | ✅ | ✅ | ✅ | |
| Functions | Scalar, Table-Valued, Inline, User-Defined | ✅ | ✅ | ✅ | |
| Triggers | DML Triggers, DDL Triggers, INSTEAD OF, AFTER | ✅ | ✅ | ||
| Transactions | ACID, BEGIN/COMMIT/ROLLBACK, Isolation Levels | ✅ | ✅ | ✅ | |
| Locks & Deadlocks | Lock Types, Blocking, Deadlock Detection | ✅ | ✅ | ||
| Constraints | CHECK, DEFAULT, UNIQUE, NOT NULL | ✅ | ✅ | ||
| Normalization & Design | 1NF, 2NF, 3NF, Denormalization, ERD | ✅ | ✅ | ||
| Querying | SELECT, JOINs, WHERE, GROUP BY, HAVING, ORDER BY | ✅ | ✅ | ✅ | |
| Advanced Queries | CTE, Window Functions, Ranking, Pivot/Unpivot | ✅ | ✅ | ||
| Performance Tuning | Index Tuning, Execution Plans, Query Optimization | ✅ | ✅ | ||
| Transactions & Concurrency | Isolation Levels, Locks, Deadlocks, Snapshot Isolation | ✅ | ✅ | ||
| Backup & Restore | Full, Differential, Log Backup, Restore Scenarios | ✅ | ✅ | ✅ | |
| Security | Authentication, Authorization, Roles, Permissions, Encryption | ✅ | ✅ | ✅ | ✅ |
| Replication & Mirroring | Snapshot, Transactional, Merge, Database Mirroring | ✅ | ✅ | ✅ | |
| High Availability | Always On, Failover Cluster Instances, Log Shipping | ✅ | ✅ | ✅ | |
| Monitoring & Maintenance | Performance Monitoring, SQL Agent Jobs, Maintenance Plans | ✅ | ✅ | ✅ | |
| Advanced Topics | Partitioning, Service Broker, Query Store, PolyBase | ✅ | ✅ | ||
| Cloud & Hybrid | Azure SQL, Managed Instance, Synapse Analytics, Migrations | ✅ | ✅ |
Interview question
Related Topics
| Complex_Query |
04 May 2024
#SOAP
Last updated - V6 (03-Oct-2025)
Key Concepts
| Topic | SubTopics | Basic | Intermediate | Advanced | Expert |
|---|---|---|---|---|---|
| SOAP Fundamentals | Definition, Purpose, Characteristics | ✅ | |||
| SOAP Message Structure | Envelope, Header, Body, Fault | ✅ | ✅ | ||
| SOAP Protocols | HTTP, SMTP, JMS, TCP | ✅ | ✅ | ||
| SOAP vs REST | Differences, Advantages, Disadvantages | ✅ | ✅ | ||
| SOAP Elements | Envelope, Namespace, Encoding | ✅ | ✅ | ||
| WSDL | Definition, Structure, Operations, Bindings | ✅ | ✅ | ||
| UDDI | Service Registry, Lookup, Discovery | ✅ | ✅ | ||
| SOAP Binding Styles | Document Style, RPC Style, Encoded, Literal | ✅ | ✅ | ||
| SOAP Fault Handling | Fault Code, Fault String, Detail | ✅ | ✅ | ✅ | |
| SOAP Headers | Authentication, Transaction, Routing | ✅ | ✅ | ✅ | |
| SOAP Attachments | SwA, DIME, MTOM | ✅ | ✅ | ✅ | |
| SOAP Security Basics | SSL, Basic Auth, Token-based | ✅ | ✅ | ||
| WS-Security | Encryption, Signatures, UsernameToken | ✅ | ✅ | ||
| WS-Addressing | Endpoint References, Message Routing | ✅ | ✅ | ||
| WS-ReliableMessaging | Message Ordering, Delivery Assurance | ✅ | ✅ | ||
| WS-Policy | Policy Assertion, Policy Attachment | ✅ | ✅ | ||
| WS-AtomicTransaction | Commit, Rollback, Coordination | ✅ | ✅ | ||
| WS-Federation | Identity Federation, Trust Relationships | ✅ | ✅ | ||
| SOAP Interoperability | Namespaces, Encoding Rules, Standards | ✅ | ✅ | ✅ | |
| SOAP Handlers | Request/Response Processing, Logging | ✅ | ✅ | ✅ | |
| Development Approaches | Contract-first, Code-first | ✅ | ✅ | ✅ | |
| SOAP Tools | SoapUI, Postman, Apache CXF, Axis2 | ✅ | ✅ | ✅ | ✅ |
| SOAP in Java | JAX-WS, Spring-WS, CXF | ✅ | ✅ | ✅ | |
| SOAP in .NET | WCF, ASMX, Visual Studio | ✅ | ✅ | ✅ | |
| SOAP Performance | Optimization, Compression, Scalability | ✅ | ✅ | ||
| SOAP Security Advanced | Replay Attack Prevention, SAML Tokens | ✅ | ✅ | ||
| Monitoring & Debugging | Logging, Tracing, Message Inspection | ✅ | ✅ | ✅ | |
| Testing SOAP | Unit Tests, Integration Tests, Load Tests | ✅ | ✅ | ✅ | ✅ |
| SOAP in ESB | Service Orchestration, Mediation, Routing | ✅ | ✅ | ||
| SOAP in Microservices | Integration, Migration to REST | ✅ | ✅ |
Interview question
Related Topics
Subscribe to:
Comments (Atom)