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
Ko'proq ko'rsatish📈 Telegram kanali Coding Interview Resources analitikasi
Coding Interview Resources (@crackingthecodinginterview) Ingliz til segmentidagi kanali faol ishtirokchi. Hozirda hamjamiyat 52 237 obunachidan iborat bo'lib, Texnologiyalar & Aralashmalar toifasida 2 482-o'rinni va Hindiston mintaqasida 6 824-o'rinni egallagan.
📊 Auditoriya ko‘rsatkichlari va dinamika
невідомо sanasidan buyon loyiha tez o‘sib, 52 237 obunachiga ega bo‘ldi.
27 Avgust, 2026 dagi oxirgi ma’lumotlarga ko‘ra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 8 ga, so‘nggi 24 soatda esa 1 ga o‘zgardi va umumiy qamrov yuqori darajada qolmoqda.
- Tasdiqlash holati: Tasdiqlanmagan
- Jalb etish (ER): Auditoriya o‘rtacha 1.85% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 0.77% ini tashkil etuvchi reaksiyalarni to‘playdi.
- Post qamrovi: Har bir post o‘rtacha 968 marta ko‘riladi; birinchi sutkada odatda 404 ta ko‘rish yig‘iladi.
- Reaksiyalar va o‘zaro ta’sir: Auditoriya faol: har bir postga o‘rtacha 2 ta reaksiya keladi.
- Tematik yo‘nalishlar: Kontent array, stack, algorithm, programming, sort kabi asosiy mavzularga jamlangan.
📝 Tavsif va kontent siyosati
Muallif resursni shaxsiy fikrni ifoda etish maydoni sifatida ta’riflaydi:
“This channel contains the free resources and solution of coding problems which are usually asked in the interviews.
Managed by: @love_data”
Yuqori yangilanish chastotasi (oxirgi ma’lumot 28 Avgust, 2026 da olingan) sababli kanal doimo dolzarb va katta qamrovli bo‘lib qoladi. Analitika auditoriya kontent bilan faol hamkorlik qilishini, uni Texnologiyalar & Aralashmalar toifasidagi muhim ta’sir nuqtasiga aylantirishini ko‘rsatadi.
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