Coding Interview Resources
This channel contains the free resources and solution of coding problems which are usually asked in the interviews. Managed by: @love_data
Mostrar más📈 Análisis del canal de Telegram Coding Interview Resources
El canal Coding Interview Resources (@crackingthecodinginterview) en el segmento lingüístico de Inglés es un actor destacado. Actualmente la comunidad reúne a 52 132 suscriptores, ocupando la posición 2 574 en la categoría Tecnologías y Aplicaciones y el puesto 7 288 en la región India.
📊 Métricas de audiencia y dinámica
Desde su creación el невідомо, el proyecto ha mostrado un crecimiento acelerado, reuniendo a 52 132 suscriptores.
Según los últimos datos del 04 junio, 2026, el canal mantiene una actividad estable. En los últimos 30 días la variación de miembros fue de 183, y en las últimas 24 horas de 8, conservando un alto alcance.
- Estado de verificación: No verificado
- Tasa de interacción (ER): El promedio de interacción de la audiencia es 1.84%. Durante las primeras 24 horas tras publicar, el contenido suele obtener 0.82% de reacciones respecto al total de suscriptores.
- Alcance de las publicaciones: Cada publicación recibe en promedio 960 visualizaciones. En el primer día suele acumular 425 visualizaciones.
- Reacciones e interacción: La audiencia responde de forma activa: el promedio de reacciones por publicación es 2.
- Intereses temáticos: El contenido se centra en temas clave como array, stack, algorithm, programming, sort.
📝 Descripción y política de contenido
El autor describe el recurso como un espacio para expresar opiniones subjetivas:
“This channel contains the free resources and solution of coding problems which are usually asked in the interviews.
Managed by: @love_data”
Gracias a la alta frecuencia de actualizaciones (últimos datos recibidos el 05 junio, 2026), el canal mantiene la vigencia y un amplio alcance. La analítica demuestra que la audiencia interactúa activamente con el contenido, lo que lo convierte en un punto de referencia dentro de la categoría Tecnologías y Aplicaciones.
WHERE filters rows before grouping (used with SELECT, UPDATE).
⦁ HAVING filters groups after aggregation (used with GROUP BY), e.g., filtering aggregated results like sums or counts.
5. Write a SQL query to find the second highest salary in a table.
Using a subquery:
SELECT MAX(salary) FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
Or using DENSE_RANK():
SELECT salary FROM (
SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rnk
FROM employees) t
WHERE rnk = 2;
6. What is a JOIN? Explain different types of JOINs.
A JOIN combines rows from two or more tables based on a related column:
⦁ INNER JOIN: returns matching rows from both tables.
⦁ LEFT JOIN (LEFT OUTER JOIN): all rows from the left table, matched rows from right.
⦁ RIGHT JOIN (RIGHT OUTER JOIN): all rows from right table, matched rows from left.
⦁ FULL JOIN (FULL OUTER JOIN): all rows when there’s a match in either table.
⦁ CROSS JOIN: Cartesian product of both tables.
7. How do you optimize slow-performing SQL queries?
⦁ Use indexes appropriately to speed up lookups.
⦁ Avoid SELECT *; only select necessary columns.
⦁ Use joins carefully; filter early with WHERE clauses.
⦁ Analyze execution plans to identify bottlenecks.
⦁ Avoid unnecessary subqueries; use EXISTS or JOINs.
⦁ Limit result sets with pagination if dealing with large datasets.
8. What is a primary key? What is a foreign key?
⦁ Primary Key: A unique identifier for records in a table; it cannot be NULL.
⦁ Foreign Key: A field that creates a link between two tables by referring to the primary key in another table, enforcing referential integrity.
9. What are indexes? Explain clustered and non-clustered indexes.
⦁ Indexes speed up data retrieval by providing quick lookups.
⦁ Clustered Index: Sorts and stores the actual data rows in the table based on the key; a table can have only one clustered index.
⦁ Non-Clustered Index: Creates a separate structure that points to the data rows; tables can have multiple non-clustered indexes.
10. Write a SQL query to fetch the top 5 records from a table.
In SQL Server and PostgreSQL:
SELECT * FROM table_name
ORDER BY some_column DESC
LIMIT 5;
In SQL Server (older syntax):
SELECT TOP 5 * FROM table_name
ORDER BY some_column DESC;
React ♥️ for Part 2<article>, <section>, <nav>, <header>). Improves accessibility and SEO.
4. What is the DOM
Document Object Model — a tree-like structure representing HTML elements. JavaScript can manipulate it to update content dynamically.
5. What is the difference between GET and POST methods
• GET: Sends data via URL, used for fetching
• POST: Sends data in body, used for submitting forms securely
6. What is the box model in CSS
Every HTML element is a box:
Content → Padding → Border → Margin
7. What is the difference between relative, absolute, and fixed positioning in CSS
• Relative: Moves element relative to its normal position
• Absolute: Positions element relative to nearest positioned ancestor
• Fixed: Stays in place even when scrolling
8. What is the difference between == and === in JavaScript
• ==: Compares values with type coercion
• ===: Strict comparison (value and type)
9. What is event bubbling in JavaScript
Events propagate from child to parent elements. Can be controlled using stopPropagation().
10. What is the difference between localStorage and sessionStorage
• localStorage: Persistent across sessions
• sessionStorage: Cleared when tab is closed
11. What is a RESTful API
An architectural style for designing networked applications using HTTP methods (GET, POST, PUT, DELETE) and stateless communication.
12. What is the difference between frontend and backend development
• Frontend: Client-side (UI/UX, HTML/CSS/JS)
• Backend: Server-side (databases, APIs, authentication)
13. What are common HTTP status codes
• 200 OK
• 404 Not Found
• 500 Internal Server Error
• 403 Forbidden
• 301 Moved Permanently
14. What is a promise in JavaScript
An object representing the eventual completion or failure of an async operation.
States: pending, fulfilled, rejected
15. What is the difference between synchronous and asynchronous code
• Synchronous: Executes line by line
• Asynchronous: Executes independently, doesn’t block the main thread
16. What is a CSS preprocessor
Tools like SASS or LESS that add features to CSS (variables, nesting, mixins) and compile into standard CSS.
17. What is the role of frameworks like React, Angular, or Vue
They simplify building complex UIs with reusable components, state management, and routing.
18. What is the difference between SQL and NoSQL databases
• SQL: Structured, relational (e.g., MySQL)
• NoSQL: Flexible schema, document-based (e.g., MongoDB)
19. What is version control and why is Git important
Version control tracks changes in code. Git allows collaboration, branching, and rollback. Platforms: GitHub, GitLab, Bitbucket
20. How do you optimize website performance
• Minify CSS/JS
• Use lazy loading
• Compress images
• Use CDN
• Reduce HTTP requests
👍 React for more Interview Resources
¡Ya disponible! Investigación de Telegram 2025 — los principales insights del año 
