# SQL Interview Practice Challenges > Search results for `sql interview questions with query challenges` on awesome-repositories.com. 113 total matches; showing the first 50. Explore on the web: https://awesome-repositories.com/q/sql-interview-questions-with-query-challenges **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [this search on awesome-repositories.com](https://awesome-repositories.com/q/sql-interview-questions-with-query-challenges).** ## Results - [dotnet/efcore](https://awesome-repositories.com/repository/dotnet-efcore.md) (14,587 ⭐) — Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a sophisticated query translation engine that converts language-integrated queries into optimized, database-specific commands, alongside a robust migration toolset that automates schema evolution by synchronizing the physical database structure with the application model. Beyond its core mapping and query capabilities, the framework provides extensive tooling for database scaffolding, reverse engineering, and automated code generation. It supports complex data modeling requirements, including inheritance hierarchies, owned entity relationships, and custom mapping configurations, while offering built-in mechanisms for transaction management, concurrency control, and connection resiliency. The framework includes comprehensive observability and testing utilities, such as command interception, operation logging, and in-memory database simulation for isolated testing. It is designed for integration with standard dependency injection containers and provides configuration hooks to customize scaffolding and migration logic. - [amitshekhariitbhu/android-interview-questions](https://awesome-repositories.com/repository/amitshekhariitbhu-android-interview-questions.md) (12,341 ⭐) — This repository is a curated study guide and knowledge base designed to assist developers in preparing for software engineering job interviews within the Android ecosystem. It organizes essential programming topics, language-specific features, and mobile architecture patterns into a structured format for professional review and skill assessment. The collection covers a broad range of technical domains, including system design principles, performance optimization, and core development concepts. By categorizing these topics, the resource provides a systematic way for users to practice and improve their technical proficiency for career advancement. The documentation is maintained through a version-controlled system and is structured to support efficient navigation of technical concepts. The content is rendered as a static site, utilizing a responsive layout and search functionality to facilitate quick access to specific interview questions and answers. - [cube-js/cube](https://awesome-repositories.com/repository/cube-js-cube.md) (20,251 ⭐) — Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orchestrates these interactions by mapping questions to the underlying semantic model, ensuring that AI-generated insights remain accurate and context-aware. Furthermore, Cube is designed for multi-tenant environments, offering robust infrastructure isolation, row-level security, and dynamic context injection to ensure that data access is strictly governed and personalized for every user or tenant. Beyond its core modeling and AI features, the platform includes a comprehensive suite of tools for performance optimization, including automated pre-aggregation caching and asynchronous query queuing. It supports a wide range of data sources and deployment models, from self-hosted containers to managed cloud environments. The system also provides extensive programmatic control over report management, dashboard publishing, and user identity synchronization, making it suitable for embedding interactive analytics directly into custom software applications. - [dapperlib/dapper](https://awesome-repositories.com/repository/dapperlib-dapper.md) (18,331 ⭐) — Dapper is a lightweight object-relational mapper for .NET that functions as a high-performance data access library. It operates by extending standard database connection interfaces, allowing developers to execute raw SQL queries while automating the mapping of database results to strongly-typed objects. The library distinguishes itself through its use of runtime code generation, which creates high-performance instructions to map database rows to object properties with minimal overhead. It provides flexible data retrieval options, supporting both memory-buffered loading for speed and row-by-row streaming to minimize memory footprint. By leveraging non-blocking task patterns, it ensures that database operations remain responsive during high-latency input and output tasks. Dapper covers a broad capability surface for database interaction, including support for parameterized queries to ensure security, atomic transaction management, and the execution of stored procedures. It handles complex data scenarios such as multi-result set parsing, bulk operations, and the mapping of related entities into nested object structures. The library is designed to be database-agnostic, maintaining compatibility with diverse database systems through standard provider abstractions. - [advanced-frontend/daily-interview-question](https://awesome-repositories.com/repository/advanced-frontend-daily-interview-question.md) (27,505 ⭐) — This project is an automated code assessment tool and educational platform designed for frontend interview preparation. It provides a curated collection of technical challenges that allow developers to practice JavaScript mechanics, algorithmic problem solving, and core software engineering concepts. The platform utilizes a component-driven interface to organize and present educational content, which is managed through markdown-based modeling. It distinguishes itself by integrating automated evaluation systems that analyze user-submitted logic through abstract syntax tree analysis and sandboxed execution environments, providing immediate feedback on code correctness and performance. The repository covers a broad range of web development skill assessments, including deep dives into asynchronous behavior, closures, and prototype inheritance. The content is processed via static site generation to ensure efficient delivery of technical documentation and practice materials. - [h5bp/front-end-developer-interview-questions](https://awesome-repositories.com/repository/h5bp-front-end-developer-interview-questions.md) (60,886 ⭐) — This project is a curated frontend interview question bank and technical assessment guide. It serves as a web development interview resource for assessing candidates on frontend development, web accessibility, and browser performance. The collection provides a standardized set of questions to evaluate a developer's knowledge of HTML, CSS, JavaScript, and networking. It is designed to assist in the developer hiring process, engineering team recruiting, and personal technical interview preparation. The content is organized as a flat-file knowledge base using markdown-based storage and topic-based categorization. It utilizes git-based content management for updates and delivers information via static document distribution. - [darcyclarke/front-end-developer-interview-questions](https://awesome-repositories.com/repository/darcyclarke-front-end-developer-interview-questions.md) (60,886 ⭐) — This project is a curated repository of specialized technical questions and assessment guides used to evaluate proficiency in core web technologies. It serves as a question bank and assessment guide for testing knowledge of browser APIs, CSS, JavaScript, and HTTP protocols. The repository provides a technical skill evaluation framework consisting of open-ended prompts. These are used for front-end candidate evaluation, standardizing technical hiring workflows, and facilitating interview preparation for web developers. The content is organized via a category-driven information architecture and stored as markdown files. It utilizes static document generation and a flat-file data structure to present the question sets. - [bregman-arie/devops-exercises](https://awesome-repositories.com/repository/bregman-arie-devops-exercises.md) (82,879 ⭐) — This project is a comprehensive educational curriculum designed to build proficiency across modern infrastructure, cloud-native technologies, and systems administration. It functions as a reference library and interview preparation resource, offering a structured collection of conceptual questions, practical coding challenges, and hands-on scenarios that cover the full spectrum of software delivery and operational workflows. The repository distinguishes itself through a modular, domain-specific structure that links instructional problem statements with verified implementation examples. By employing a standardized documentation schema, it provides a predictable learning path for mastering complex technical concepts, ranging from infrastructure-as-code patterns and container orchestration to cloud platform administration and security best practices. The content spans a wide array of technical domains, including automated configuration management, distributed system monitoring, database operations, and version control. It provides deep dives into specific tooling for cloud provisioning, container networking, and service deployment, ensuring that learners can validate their technical skills through isolated, practical exercises. All instructional materials are organized into a unified taxonomy of markdown-based documents, allowing users to navigate and study specific technical topics at their own pace. - [roseperrone/interview-questions](https://awesome-repositories.com/repository/roseperrone-interview-questions.md) (120 ⭐) — Interview questions solved in python - [donnemartin/system-design-primer](https://awesome-repositories.com/repository/donnemartin-system-design-primer.md) (353,387 ⭐) — This project is a comprehensive educational resource and study guide focused on distributed systems architecture and backend infrastructure design. It provides a structured curriculum for mastering the principles of scalability, reliability, and performance required to design complex software systems. The repository distinguishes itself by offering a methodical approach to technical interview preparation, incorporating design patterns, architectural trade-offs, and spaced repetition tools to help users retain complex concepts. It emphasizes constraint-driven analysis, teaching users how to evaluate competing requirements like latency, consistency, and availability when drafting architectural designs. The content covers a broad spectrum of system design capabilities, including strategies for database scaling, traffic management, and infrastructure optimization. It details techniques for horizontal scaling, multi-layered caching, asynchronous communication, and service discovery, while also providing frameworks for performing resource estimations and capacity planning. The documentation is organized as a study guide, offering a systematic path through the fundamentals of backend engineering and large-scale system design. - [enhorse/java-interview](https://awesome-repositories.com/repository/enhorse-java-interview.md) (6,036 ⭐) — This is a structured collection of interview preparation materials organized as a question bank covering multiple technology domains. The content is stored as plain Markdown files arranged in a topic-based directory hierarchy, delivered as static HTML without any JavaScript framework or build pipeline. The material focuses on Java ecosystem topics including core language features, collections, multithreading, JVM internals, Java 8 features, I/O, serialization, OOP principles, JDBC, servlets and JSP, logging, reactive programming, and testing. It also covers relational databases and SQL, web development fundamentals including HTML, CSS, HTTP, and web servers, as well as design patterns, Apache Kafka, UML, and XML. Each technology area is divided into independent modules with discrete question-and-answer units, allowing focused study on specific topics. The content is pre-written and static, requiring no server-side processing or dynamic generation. - [kansiris/sql-interview-questions](https://awesome-repositories.com/repository/kansiris-sql-interview-questions.md) (681 ⭐) - [mohsenoid/android-interview-questions](https://awesome-repositories.com/repository/mohsenoid-android-interview-questions.md) (223 ⭐) — Android Interview Questions - [jeremyevans/sequel](https://awesome-repositories.com/repository/jeremyevans-sequel.md) (5,076 ⭐) — Sequel is a relational database toolkit for Ruby that provides object-relational mapping, a fluent SQL query builder, and schema migration capabilities. It maps database tables to Ruby classes with support for associations, validations, lifecycle hooks, and eager loading, offering a comprehensive ORM layer for building data-centric applications. Sequel distinguishes itself through a plugin-based extension architecture that allows composable customization of models, databases, and datasets without relying on deep inheritance hierarchies. It includes a thread-safe connection pool with support for database sharding, read/write splitting across replicas, and nested transactions with savepoint rollback. The library also provides a schema migration DSL with reversible steps, automation tools for database content copying and an interactive shell, and fine-grained control over connection management for multi-server setups. Beyond its core ORM and query capabilities, Sequel includes a data validation framework with built-in helpers and schema-driven validation generation, a lifecycle callback system covering create, update, destroy, and transaction events, and serialization support for CSV, JSON, XML, and other formats. It offers model instance caching, prepared statement execution, and testing utilities such as transaction-based test isolation and truncation-based cleanup. The library also provides logging, structured error details, and mass assignment protection for security. - [ryanburgess/manager-interview-questions](https://awesome-repositories.com/repository/ryanburgess-manager-interview-questions.md) (0 ⭐) — A list of interview questions for manager roles. - [memgraph/memgraph](https://awesome-repositories.com/repository/memgraph-memgraph.md) (4,163 ⭐) — Memgraph is an in-memory, distributed graph database designed for high-performance labeled property graph management. It utilizes a Cypher query engine for declarative data retrieval and manipulation, providing a scalable knowledge graph backend that integrates vector search and graph traversals. The system distinguishes itself as a real-time graph analytics platform, employing native C++ and CUDA implementations to execute complex network analysis and dynamic community detection on streaming data. It provides specialized support for AI integration, including GraphRAG capabilities, the construction of knowledge graphs from unstructured text, and the orchestration of AI agents with long-term memory storage. The platform covers a broad range of capabilities, including advanced graph analytics for path discovery, node centrality, and topology analysis. It also features machine learning workflows for graph neural networks, hybrid indexing for semantic and geospatial search, and comprehensive data migration tools for importing relational and flat-file data. Deployment is supported across containerized environments, Kubernetes, and managed cloud instances, with high availability ensured via the Raft consensus protocol. - [kamranahmedse/developer-roadmap](https://awesome-repositories.com/repository/kamranahmedse-developer-roadmap.md) (357,434 ⭐) — Developer Roadmap is a community-driven platform that provides structured, graph-based learning paths for software engineering. It serves as a comprehensive knowledge repository where technical domains are organized into visual sequences to guide professional skill acquisition and career growth. The project distinguishes itself through a collaborative ecosystem that enables users to contribute roadmaps, curate industry best practices, and maintain professional profiles. It integrates diagnostic assessment frameworks to evaluate technical proficiency, helping developers identify knowledge gaps and prepare for professional interviews through targeted learning sequences. Beyond its core mapping capabilities, the platform offers practical project ideas and interactive tutoring to reinforce engineering concepts. It provides a centralized space for the community to share resources, track progressive skill development, and navigate complex technical landscapes. - [sudheerj/vuejs-interview-questions](https://awesome-repositories.com/repository/sudheerj-vuejs-interview-questions.md) (2,709 ⭐) — List of 300 VueJS Interview Questions And Answers - [drizzle-team/drizzle-orm](https://awesome-repositories.com/repository/drizzle-team-drizzle-orm.md) (34,835 ⭐) — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore. - [victoriametrics/victoriametrics](https://awesome-repositories.com/repository/victoriametrics-victoriametrics.md) (16,343 ⭐) — VictoriaMetrics is a high-performance, scalable time series database and observability platform designed for long-term storage and analysis of metric, log, and trace data. It functions as a unified backend for monitoring ecosystems, offering full compatibility with industry-standard protocols and query languages. The system is built to handle massive data volumes through a distributed architecture that supports horizontal scaling and efficient data lifecycle management. The platform distinguishes itself through a storage engine that utilizes consistent hashing for data sharding and log-structured merge trees to optimize write throughput and disk space. It provides robust multi-tenant isolation, allowing organizations to segment data and alerting configurations by account or project while maintaining secure, partitioned access. By offloading long-term data to object storage while retaining local caching, it balances cost-effective persistence with high-performance query execution. The system covers the entire observability lifecycle, including automated metric scraping, log aggregation, and distributed tracing. It features a sophisticated alerting and recording engine that supports dynamic rule evaluation and high-availability execution. Additionally, the project includes a Kubernetes operator that automates the deployment, configuration, and lifecycle management of monitoring components, ensuring consistent observability across containerized environments. VictoriaMetrics is distributed as a set of container-native services and can be managed via declarative resource definitions within Kubernetes clusters. - [letsdefend/soc-interview-questions](https://awesome-repositories.com/repository/letsdefend-soc-interview-questions.md) (0 ⭐) — Let's make this repository full of interview questions! - [avelino/awesome-go](https://awesome-repositories.com/repository/avelino-awesome-go.md) (175,576 ⭐) — This project serves as a comprehensive language ecosystem index, functioning as a centralized, community-curated directory for the Go programming language. It organizes a vast landscape of software components, libraries, and development tools into a structured, navigable hierarchy, enabling developers to efficiently discover resources tailored to specific functional domains. The repository distinguishes itself through a decentralized contribution model, where community-driven updates ensure the index remains current with the rapidly evolving software landscape. Beyond simple resource listing, it acts as a technical knowledge repository, aggregating professional literature, style guides, and best practices to support developer onboarding and professional growth across the entire software development lifecycle. The directory covers a broad capability surface, including essential utilities for distributed systems engineering, application security, data processing, and development productivity. It provides access to specialized tools for database management, web framework integration, testing, and build automation, alongside educational materials that help developers master language-specific architectural patterns. The project is maintained as a static resource aggregation, providing a holistic view of external links and documentation to orient developers within the Go ecosystem. - [typeorm/typeorm](https://awesome-repositories.com/repository/typeorm-typeorm.md) (36,540 ⭐) — TypeORM is an object-relational mapper for TypeScript and JavaScript that bridges the gap between object-oriented application code and relational database tables. It provides a comprehensive data persistence layer that allows developers to define database entities using class decorators or configuration objects, enabling seamless interaction with data through object-oriented patterns. The project distinguishes itself through a flexible architecture that supports both the data mapper and repository patterns, alongside a fluent query builder that translates high-level method calls into platform-specific SQL. It includes a robust schema synchronization engine that automatically generates and applies migrations, ensuring that database structures remain consistent with application models. Furthermore, it offers specialized support for hierarchical data modeling, vector similarity search, and cross-database querying, allowing for sophisticated data management across diverse storage engines. Beyond its core mapping capabilities, the framework provides extensive tools for managing database connections, including support for replication, multi-database routing, and atomic transaction management. It also features a lifecycle event system for executing custom logic during data operations, as well as comprehensive performance optimization utilities like relation loading strategies, result caching, and query analysis. The project is designed for cross-platform compatibility, supporting various relational and document-based database drivers in environments ranging from Node.js servers to browser and mobile applications. - [electric-sql/electric](https://awesome-repositories.com/repository/electric-sql-electric.md) (9,909 ⭐) — Electric is a Postgres data synchronization engine and replication proxy designed to enable local-first software. It replicates data from Postgres databases to client-side stores in real time using logical replication, allowing applications to maintain a local embedded database for offline access and low-latency updates. The system distinguishes itself by using shapes to filter and authorize specific subsets of database rows and columns before streaming them to clients or edge workers. It further supports multi-user collaboration by integrating a conflict-free replicated data type framework to ensure consistent state synchronization across different users. The project covers a broad range of capabilities, including reactive state management and real-time data streaming to client interfaces and server-side renders. It provides tools for data shaping and transformation, database integration across various cloud and serverless Postgres providers, and security primitives such as token-based authorization and end-to-end encryption. The service can be deployed as a containerized web service on cloud platforms with support for rolling deployment management. - [yonet/angular-interview-questions](https://awesome-repositories.com/repository/yonet-angular-interview-questions.md) (1,183 ⭐) — A list of helpful Angular interview questions you can use to interview potential candidates, test yourself or completely ignore. - [arialdomartini/back-end-developer-interview-questions](https://awesome-repositories.com/repository/arialdomartini-back-end-developer-interview-questions.md) (16,574 ⭐) — This project is an open-source knowledge repository that serves as a comprehensive technical interview question bank for backend engineering roles. It provides a structured resource for hiring managers and candidates to evaluate proficiency in software design, architectural patterns, and core engineering principles through a curated collection of discussion topics and coding challenges. The repository functions as a programming paradigm evaluation tool, enabling the assessment of a candidate's understanding of object-oriented, functional, and procedural techniques. It distinguishes itself by focusing on the practical application of design principles and architectural trade-offs, allowing interviewers to measure how well a candidate structures systems for long-term maintainability and scalability. The content covers a broad range of software engineering domains, including system design, coding standards, and the evaluation of architectural patterns. By organizing these concepts into a hierarchical taxonomy, the project facilitates the standardization of technical interviews and the preparation process for backend development roles. All information is stored as static, version-controlled markdown files, allowing the community to maintain the accuracy and relevance of the material through a collaborative pull-request workflow. - [styopdev/webpack-interview-questions](https://awesome-repositories.com/repository/styopdev-webpack-interview-questions.md) (244 ⭐) — Webpack questions/answers you can use to prepare for interviews or test your knowledge. - [prestodb/presto](https://awesome-repositories.com/repository/prestodb-presto.md) (16,711 ⭐) — Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing model that coordinates tasks across worker nodes. It incorporates cost-based query optimization to rewrite execution paths based on table statistics and historical data, ensuring efficient resource utilization. To maintain stability during large-scale operations, the system features a memory-spilling execution engine that offloads intermediate results to disk when memory thresholds are exceeded. The platform provides extensive capabilities for multi-tenant resource management, allowing administrators to enforce concurrency, memory, and CPU limits through hierarchical resource grouping. It supports a wide range of analytical operations, including advanced windowing, geospatial processing, and probabilistic data structures for approximate statistics. Security is integrated through granular access control policies, role-based authentication, and encrypted communication across the cluster. Presto is implemented in Java and supports deployment via containerized instances or distributed cluster orchestration in Kubernetes environments. - [clickhouse/clickhouse](https://awesome-repositories.com/repository/clickhouse-clickhouse.md) (48,229 ⭐) — ClickHouse is a high-performance, columnar analytical database designed for real-time query execution and large-scale data aggregation. It functions as a distributed data warehouse capable of processing petabytes of information, while also providing an embedded engine that integrates directly into applications for native query capabilities without external dependencies. The system is built to handle high-throughput ingestion and complex analytical workloads, delivering millisecond-level latency for interactive dashboards and operational monitoring. The platform distinguishes itself through advanced storage and execution techniques, including vectorized query processing and a merge tree storage engine that maintains performance during massive insertions. It features adaptive subcolumn mapping for semi-structured data and supports native vector search for machine learning and generative AI applications. To facilitate efficient data movement, the engine utilizes zero-copy shared memory buffers, minimizing overhead when interacting with external analytical tools or processing diverse file formats like Parquet, JSON, and Arrow. Beyond its core storage and processing capabilities, the project provides a comprehensive suite of tools for observability, security, and data integration. It includes built-in support for natural language querying, automated workflow orchestration for AI agents, and extensive diagnostic features for query plan inspection. The platform also offers robust cloud infrastructure management, including support for private networking, compliant deployment strategies, and integrated billing consolidation. - [linkedin/school-of-sre](https://awesome-repositories.com/repository/linkedin-school-of-sre.md) (8,093 ⭐) — This project is a comprehensive educational resource and curriculum focused on site reliability engineering, distributed systems, and infrastructure operations. It provides technical guides, a systems engineering course, and instructional manuals designed to teach the principles of managing large-scale computing environments. The curriculum covers high-level architectural design for scalability and resilience, including fault-tolerant infrastructure, high-availability patterns, and microservices decomposition. It emphasizes the practical application of site reliability engineering through the study of system design, resource estimation, and the elimination of single points of failure. The material extends into broad operational capabilities, including container orchestration, continuous integration and delivery pipelines, layered observability, and network routing. It also provides detailed instruction on Linux system administration, database management, security auditing, and the implementation of service level indicators and objectives. - [jarlakxen/scala-interview-questions](https://awesome-repositories.com/repository/jarlakxen-scala-interview-questions.md) (504 ⭐) — A list of helpful Scala related questions you can use to interview potential candidates. - [aishwaryanr/awesome-generative-ai-guide](https://awesome-repositories.com/repository/aishwaryanr-awesome-generative-ai-guide.md) (24,755 ⭐) — This project is a community-driven knowledge repository and technical learning resource focused on the field of generative artificial intelligence. It serves as a centralized hub for developers and practitioners to access curated research, tutorials, and foundational concepts necessary for building and deploying modern artificial intelligence applications. The platform distinguishes itself through a collaborative, distributed contribution model that aggregates diverse learning materials into a structured, searchable knowledge base. It covers a wide range of specialized topics, including retrieval-augmented generation, large language model training, fine-tuning techniques, and agentic workflows. Beyond technical skill development, the repository functions as a professional development hub, offering interview preparation resources and guidance for those pursuing careers in the artificial intelligence industry. The content is organized through a hierarchical taxonomy, allowing users to navigate complex subjects such as system evaluation, multimodal models, and security tools. The repository provides access to comprehensive code notebooks and structured tutorials, all maintained as static documentation within a version control system to ensure accessibility and ease of discovery. - [collabnix/dockerlabs](https://awesome-repositories.com/repository/collabnix-dockerlabs.md) (8,008 ⭐) — dockerlabs is a collection of educational labs and technical tutorials designed to teach the fundamentals of containerization and microservice architecture. It provides instructional material and hands-on exercises covering image optimization, security training, infrastructure setup, and cluster orchestration. The project features specific courses and guides focused on reducing image size through multi-stage builds, securing workloads via vulnerability scanning and encrypted networks, and deploying multi-node clusters with high availability using Swarm orchestration. The materials cover a broad range of operational capabilities, including container lifecycle management, persistent data storage, and complex networking configurations. It also includes guidance on implementing observability stacks for monitoring and logging, as well as the administration of private image registries. - [gyoogle/tech-interview-for-developer](https://awesome-repositories.com/repository/gyoogle-tech-interview-for-developer.md) (17,417 ⭐) — This project is a comprehensive technical interview preparation resource and computer science interview guide. It serves as an educational reference for developers to study core software engineering fundamentals and common coding patterns required for employment screenings. The repository provides detailed guides and references covering data structures and algorithms, networking and security, operating systems, and web development. It specifically focuses on the implementation and complexity analysis of sorting, searching, and graph algorithms. The material encompasses a wide breadth of computer science domains, including software engineering principles like SOLID and design patterns, language fundamentals across Java, C, and C++, and system architecture. It also covers database design and scaling, concurrency and multithreading, and frontend development lifecycles. The project is primarily written in Java and is structured as a knowledge base for mastering technical interviews. - [maximabramchuck/awesome-interview-questions](https://awesome-repositories.com/repository/maximabramchuck-awesome-interview-questions.md) (83,140 ⭐) — :octocat: A curated awesome list of lists of interview questions. Feel free to contribute! :mortar_board: - [whatsupcoders/flutter-interview-questions](https://awesome-repositories.com/repository/whatsupcoders-flutter-interview-questions.md) (371 ⭐) — This repo contains a list of helpful Flutter related questions you can use to interview potential candidates. - [seaql/sea-orm](https://awesome-repositories.com/repository/seaql-sea-orm.md) (9,410 ⭐) — Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema changes. The toolkit covers broad capability areas including relational data modeling and schema management, where it supports the automatic generation of entities from existing database schemas. It further provides advanced query building features such as aggregate value computation, partial model projection, and linked entity fetching, all executed within non-blocking asynchronous runtimes. The project includes a command-line interface for database entity generation and GraphQL server bootstrapping. - [rstacruz/cheatsheets](https://awesome-repositories.com/repository/rstacruz-cheatsheets.md) (14,429 ⭐) — This project is a comprehensive collection of web development reference guides and technical cheat sheets. It provides a curated set of markdown-based documentation designed to help developers quickly locate syntax patterns and API examples for common web technologies and programming languages. The repository serves as a specialized reference library covering several distinct technical domains. It includes extensive guides for CSS, focusing on selectors, Flexbox, Grid, and responsive layout properties, as well as a DevOps command reference for Docker, Kubernetes, AWS, Ansible, and general shell operations. Additionally, it provides programming language cheat sheets that detail language features, functional logic patterns, and metaprogramming syntax. The broader capability surface includes technical references for API syntax, including GraphQL schemas and HTTP request patterns, and detailed guides for JavaScript asynchronous patterns such as promises and generators. It also covers infrastructure automation and system administration commands. - [chassing/linux-sysadmin-interview-questions](https://awesome-repositories.com/repository/chassing-linux-sysadmin-interview-questions.md) (5,315 ⭐) — Collection of Linux Sysadmin/DevOps interview questions - [beekeeper-studio/beekeeper-studio](https://awesome-repositories.com/repository/beekeeper-studio-beekeeper-studio.md) (22,030 ⭐) — Beekeeper Studio is a cross-platform desktop application designed for database management and SQL development. It provides a unified graphical interface to connect to, query, and modify data across a wide range of relational and NoSQL database systems. The application functions as a comprehensive workspace, integrating tools for schema design, record editing, and data visualization. The project distinguishes itself through a focus on secure, flexible connectivity and AI-assisted workflows. It supports advanced authentication methods, including enterprise single sign-on, multi-factor authentication, and token-based access, alongside secure traffic routing via SSH tunneling and SSL encryption. Users can leverage AI-driven query generation to translate natural language into executable SQL, while the interface allows for direct, spreadsheet-like data editing and transactional staging to ensure data integrity. The platform covers a broad capability surface, including robust import and export management, schema inspection, and visual entity relationship diagram generation. It also offers extensive customization options, such as editor behavior settings, native extension loading for SQLite, and third-party add-on integration. The application is distributed as a native desktop installer for Windows, Linux, and MacOS, with support for portable execution and offline-only operation modes. - [codeigniter4/codeigniter4](https://awesome-repositories.com/repository/codeigniter4-codeigniter4.md) (5,924 ⭐) — CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools for common development tasks. It offers a complete CLI toolkit called Spark for code generation, database migrations, and task scheduling without external dependencies. For API development, CodeIgniter provides pre-built RESTful controllers with auto-routing, content negotiation for JSON and XML responses, and a full HTTP client for outbound requests. Security features include token-based CSRF protection, input validation and filtering, XSS prevention through context-aware escaping, and configurable Content Security Policy headers. CodeIgniter includes a robust database abstraction layer with support for multiple drivers, schema management through migrations and seeding, and entity classes with automatic type casting and change detection. The framework provides session management with multiple storage backends, caching mechanisms for pages and data, and an event-driven lifecycle hook system. Additional capabilities cover email sending via multiple protocols, image manipulation, pagination, localization, and a debug toolbar for performance monitoring and request inspection. The framework ships with a built-in testing toolkit that supports simulating HTTP requests, asserting responses, generating fake test data, and mocking application services. It can be installed via Composer or downloaded manually, and includes a development server command for local testing without a full web server setup. - [devinterview-io/angular-interview-questions](https://awesome-repositories.com/repository/devinterview-io-angular-interview-questions.md) (28 ⭐) — 🟣 Angular interview questions and answers to help you prepare for your next technical interview in 2026. - [ganqqwerty/123-essential-javascript-interview-questions](https://awesome-repositories.com/repository/ganqqwerty-123-essential-javascript-interview-questions.md) (5,241 ⭐) — JavaScript interview Questions - [donnemartin/interactive-coding-challenges](https://awesome-repositories.com/repository/donnemartin-interactive-coding-challenges.md) (31,529 ⭐) — This project is a comprehensive curriculum for mastering computer science fundamentals and preparing for technical interviews. It provides over 120 interactive Python coding challenges that focus on algorithmic skill development, data structure implementation, and logical problem solving. The learning experience is delivered through a series of executable notebooks that combine instructional content with hands-on coding exercises. Each challenge is self-contained and relies on automated unit tests to verify the correctness of user-implemented solutions against predefined constraints and edge cases. To support long-term retention, the repository also includes a set of digital flashcards designed for spaced-repetition study of core programming concepts and design patterns. The curriculum covers a broad range of topics, including arrays, strings, linked lists, stacks, queues, graphs, trees, recursion, dynamic programming, and bit manipulation. All solutions are implemented using the Python standard library to ensure portability and focus on fundamental language features. - [nishant8bits/123-essential-javascript-interview-question](https://awesome-repositories.com/repository/nishant8bits-123-essential-javascript-interview-question.md) (5,240 ⭐) — JavaScript interview Questions - [pubkey/rxdb](https://awesome-repositories.com/repository/pubkey-rxdb.md) (23,048 ⭐) — This project is a reactive, offline-first NoSQL database engine designed for JavaScript applications. It provides a robust framework for managing application state by synchronizing data across browsers, mobile devices, and server-side runtimes. By treating local storage as the primary source of truth, it enables applications to remain functional without network connectivity, automatically reconciling changes with remote backends once a connection is restored. The database distinguishes itself through a modular architecture that supports cross-environment synchronization and high-performance data management. It features a bidirectional replication protocol that handles conflict resolution and state convergence, alongside a pluggable storage abstraction that allows developers to swap between engines like IndexedDB, SQLite, or in-memory stores without altering application logic. To ensure responsiveness, the system offloads storage operations to background worker threads and coordinates database access across multiple browser tabs through a leader election mechanism. The platform offers a comprehensive suite of capabilities for data integrity, performance, and security. It enforces strict data validation through schema-based definitions and optimizes storage footprints using transparent key compression. Developers can bind database query results directly to user interface components, enabling reactive state management where the UI automatically updates in response to local or remote data changes. The project is built for extensibility, offering a wide range of plugins for encryption, full-text search, and integration with various backend protocols including GraphQL, REST, and peer-to-peer channels. It provides extensive documentation and standardized interfaces to facilitate integration into diverse application architectures. - [diesel-rs/diesel](https://awesome-repositories.com/repository/diesel-rs-diesel.md) (14,021 ⭐) — This project is a type-safe database toolkit and object-relational mapper designed to enforce structural consistency between database schemas and application code. By leveraging compile-time validation, it ensures that SQL queries and data structures remain synchronized, preventing common errors before the application executes. It provides a comprehensive framework for relational data modeling, allowing developers to define table associations and map database results directly into strongly-typed language objects. The library distinguishes itself through its focus on compile-time safety and automated schema management. It utilizes procedural macros to inspect database tables and generate corresponding code structures, eliminating the need for manual type definitions. Its expression-based query builder allows for the construction of complex, modular SQL statements that are automatically parameterized to mitigate security risks like SQL injection. Furthermore, the system supports extensive customization, enabling developers to register custom functions and operators or extend the query builder interface to accommodate specific database requirements. Beyond its core mapping and validation capabilities, the toolkit provides a full suite of operations for managing data persistence. This includes support for batch insertions, relational joins, upsert operations, and the retrieval of related records. The library also handles the bidirectional transformation of data, automatically mapping application structures to database columns for updates and insertions while inferring return types for query results. Comprehensive documentation and tooling are provided to assist with schema synchronization, ensuring that local code representations remain aligned with the underlying database throughout the development lifecycle. - [kennymkchan/interview-questions-in-javascript](https://awesome-repositories.com/repository/kennymkchan-interview-questions-in-javascript.md) (3,627 ⭐) — A mostly reasonable collection of technical software development interview questions solved in Javascript - [huihut/interview](https://awesome-repositories.com/repository/huihut-interview.md) (37,972 ⭐) — This project is a comprehensive technical knowledge base designed to support developers in mastering systems programming and preparing for technical assessments. It provides a structured collection of fundamental computer science concepts, mapping high-level language constructs to low-level hardware memory layouts, runtime object lifecycles, and system-level operations. The repository distinguishes itself through a hierarchical approach that bridges the gap between theoretical principles and practical implementation. It offers detailed guidance on C++ language mechanisms, standard library usage, and cross-platform library development, including insights into binary interface stability and dynamic linking. By demonstrating how to implement complex patterns using primitive language features, the resource helps developers build a deep understanding of memory management and hardware-level execution. Beyond core language mastery, the project covers a broad capability surface including data structures, algorithm training, database theory, and network protocol implementation. It provides systematic explanations of operating system primitives, such as process synchronization and resource management, alongside industry-standard coding conventions and architectural design patterns. - [starandtina/backend-interview-questions](https://awesome-repositories.com/repository/starandtina-backend-interview-questions.md) (295 ⭐) — Hiring is extremely hard, and figuring out if someone is a good fit within 45 minutes is a demanding task. Here are some simple questions to interview potential backend candidates.