{ "summary": { "verified": 104, "unavailable": 139, "total": 243 }, "topics": { "verified": [ { "id": "what-is-sql", "title": "What is SQL?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-does-sql-stand-for", "title": "What does SQL stand for?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-are-databases", "title": "What are databases?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-is-rdbms", "title": "What is RDBMS?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-are-tables-in-sql", "title": "What are tables in SQL?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-are-rows-and-columns", "title": "What are rows and columns?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-is-a-primary-key", "title": "What is a primary key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-a-foreign-key", "title": "What is a foreign key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-a-unique-key", "title": "What is a unique key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-a-composite-key", "title": "What is a composite key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-a-candidate-key", "title": "What is a candidate key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-a-super-key", "title": "What is a super key?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-normalization", "title": "What is normalization?", "category": "Database Design", "sources": [ "https://www.postgresql.org/docs/current/ddl.html", "https://www.postgresql.org/docs/current/ddl-constraints.html", "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-are-normal-forms", "title": "What are normal forms?", "category": "Database Design", "sources": [ "https://www.postgresql.org/docs/current/ddl.html", "https://www.postgresql.org/docs/current/ddl-constraints.html", "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-denormalization", "title": "What is denormalization?", "category": "Database Design", "sources": [ "https://www.postgresql.org/docs/current/ddl.html", "https://www.postgresql.org/docs/current/ddl-constraints.html", "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-select-statement", "title": "What is SELECT statement?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-where-clause", "title": "What is WHERE clause?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-order-by", "title": "What is ORDER BY?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-group-by", "title": "What is GROUP BY?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-having-clause", "title": "What is HAVING clause?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "difference-between-where-and-having", "title": "Difference between WHERE and HAVING?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-distinct-keyword", "title": "What is DISTINCT keyword?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-offset", "title": "What is OFFSET?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-insert-statement", "title": "What is INSERT statement?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-update-statement", "title": "What is UPDATE statement?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-delete-statement", "title": "What is DELETE statement?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-create-table", "title": "What is CREATE TABLE?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-alter-table", "title": "What is ALTER TABLE?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-drop-table", "title": "What is DROP TABLE?", "category": "Data and Schema Statements", "sources": [ "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-join-in-sql", "title": "What is JOIN in SQL?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "types-of-joins-in-sql", "title": "Types of JOINs in SQL?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "difference-between-inner-join-and-outer-join", "title": "Difference between INNER JOIN and OUTER JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-left-join", "title": "What is LEFT JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-right-join", "title": "What is RIGHT JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-full-outer-join", "title": "What is FULL OUTER JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-self-join", "title": "What is SELF JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-cross-join", "title": "What is CROSS JOIN?", "category": "Joins", "sources": [ "https://www.postgresql.org/docs/current/queries.html" ] }, { "id": "what-is-union", "title": "What is UNION?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "difference-between-union-and-union-all", "title": "Difference between UNION and UNION ALL?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-is-null-in-sql", "title": "What is NULL in SQL?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-coalesce", "title": "What is COALESCE?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-is-null", "title": "What is IS NULL?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-are-constraints-in-sql", "title": "What are constraints in SQL?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-index-in-sql", "title": "What is index in SQL?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/indexes.html" ] }, { "id": "what-is-composite-index", "title": "What is composite index?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/indexes.html" ] }, { "id": "what-is-unique-index", "title": "What is unique index?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/indexes.html" ] }, { "id": "what-is-query-optimization", "title": "What is query optimization?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-execution-plan", "title": "What is execution plan?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-subquery", "title": "What is subquery?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-is-correlated-subquery", "title": "What is correlated subquery?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-are-aggregate-functions", "title": "What are aggregate functions?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-count", "title": "What is COUNT()?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-sum", "title": "What is SUM()?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-avg", "title": "What is AVG()?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-max", "title": "What is MAX()?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-min", "title": "What is MIN()?", "category": "Aggregate Functions", "sources": [ "https://www.postgresql.org/docs/current/functions-aggregate.html" ] }, { "id": "what-is-case-statement", "title": "What is CASE statement?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-ifnull", "title": "What is IFNULL?", "category": "Vendor-Specific SQL", "sources": [ "https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html" ] }, { "id": "what-is-exists-clause", "title": "What is EXISTS clause?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-is-in-operator", "title": "What is IN operator?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "difference-between-exists-and-in", "title": "Difference between EXISTS and IN?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-is-between-operator", "title": "What is BETWEEN operator?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-like-operator", "title": "What is LIKE operator?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-are-wildcards-in-sql", "title": "What are wildcards in SQL?", "category": "Filtering and Grouping", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/queries.html", "https://www.postgresql.org/docs/current/functions-conditional.html" ] }, { "id": "what-is-view-in-sql", "title": "What is VIEW in SQL?", "category": "Database Objects", "sources": [ "https://www.postgresql.org/docs/current/sql-createview.html", "https://www.postgresql.org/docs/current/sql-creatematerializedview.html", "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-materialized-view", "title": "What is materialized view?", "category": "Database Objects", "sources": [ "https://www.postgresql.org/docs/current/sql-createview.html", "https://www.postgresql.org/docs/current/sql-creatematerializedview.html", "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-are-transactions", "title": "What are transactions?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-commit", "title": "What is COMMIT?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-rollback", "title": "What is ROLLBACK?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-savepoint", "title": "What is SAVEPOINT?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-acid-property", "title": "What is ACID property?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-deadlock", "title": "What is deadlock?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-locking", "title": "What is locking?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-database-schema", "title": "What is database schema?", "category": "SQL Fundamentals", "sources": [ "https://www.postgresql.org/docs/current/sql.html", "https://www.postgresql.org/docs/current/ddl.html" ] }, { "id": "what-is-cardinality", "title": "What is cardinality?", "category": "Database Design", "sources": [ "https://www.postgresql.org/docs/current/ddl.html", "https://www.postgresql.org/docs/current/ddl-constraints.html", "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-referential-integrity", "title": "What is referential integrity?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-cascade-delete", "title": "What is cascade delete?", "category": "Keys and Constraints", "sources": [ "https://www.postgresql.org/docs/current/ddl-constraints.html" ] }, { "id": "what-is-auto-increment", "title": "What is auto increment?", "category": "Vendor-Specific SQL", "sources": [ "https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html" ] }, { "id": "what-is-sequence", "title": "What is sequence?", "category": "Database Objects", "sources": [ "https://www.postgresql.org/docs/current/sql-createview.html", "https://www.postgresql.org/docs/current/sql-creatematerializedview.html", "https://www.postgresql.org/docs/current/sql.html" ] }, { "id": "what-is-indexing-strategy", "title": "What is indexing strategy?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/indexes.html" ] }, { "id": "what-are-window-functions", "title": "What are window functions?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-row-number", "title": "What is ROW_NUMBER()?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-rank", "title": "What is RANK()?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-dense-rank", "title": "What is DENSE_RANK()?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-lead", "title": "What is LEAD()?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-lag", "title": "What is LAG()?", "category": "Window Functions", "sources": [ "https://www.postgresql.org/docs/current/tutorial-window.html" ] }, { "id": "what-is-cte", "title": "What is CTE?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "what-is-recursive-cte", "title": "What is recursive CTE?", "category": "Set Operations and Subqueries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-subquery.html", "https://www.postgresql.org/docs/current/queries-with.html" ] }, { "id": "normalization-vs-denormalization", "title": "What is normalization vs denormalization?", "category": "Database Design", "sources": [ "https://www.postgresql.org/docs/current/ddl.html", "https://www.postgresql.org/docs/current/ddl-constraints.html", "https://www.postgresql.org/docs/current/using-explain.html" ] }, { "id": "what-is-indexing-performance", "title": "What is indexing performance?", "category": "Indexes and Optimization", "sources": [ "https://www.postgresql.org/docs/current/indexes.html" ] }, { "id": "what-is-isolation-level", "title": "What is isolation level?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "types-of-isolation-levels", "title": "Types of isolation levels?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-phantom-read", "title": "What is phantom read?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-dirty-read", "title": "What is dirty read?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "what-is-non-repeatable-read", "title": "What is non-repeatable read?", "category": "Transactions and Concurrency", "sources": [ "https://www.postgresql.org/docs/current/tutorial-transactions.html", "https://www.postgresql.org/docs/current/transaction-iso.html" ] }, { "id": "find-second-highest-salary", "title": "Find second highest salary", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "find-duplicate-records", "title": "Find duplicate records", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "count-employees-by-department", "title": "Count employees by department", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "find-customers-without-orders", "title": "Find customers without orders", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "find-highest-salary-per-department", "title": "Find highest salary per department", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "find-average-salary-by-department", "title": "Find average salary by department", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "find-latest-order-by-customer", "title": "Find latest order by customer", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "write-pagination-query", "title": "Write pagination query", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] }, { "id": "write-ranking-query", "title": "Write ranking query", "category": "Coding Queries", "sources": [ "https://www.postgresql.org/docs/current/sql-select.html", "https://www.postgresql.org/docs/current/functions-aggregate.html", "https://www.postgresql.org/docs/current/tutorial-window.html", "https://www.postgresql.org/docs/current/functions-subquery.html" ] } ], "unavailable": [ { "id": "difference-between-sql-and-mysql", "title": "Difference between SQL and MySQL?", "category": "Unverified", "sources": [] }, { "id": "what-is-ddl", "title": "What is DDL?", "category": "Unverified", "sources": [] }, { "id": "what-is-dml", "title": "What is DML?", "category": "Unverified", "sources": [] }, { "id": "what-is-dcl", "title": "What is DCL?", "category": "Unverified", "sources": [] }, { "id": "what-is-tcl", "title": "What is TCL?", "category": "Unverified", "sources": [] }, { "id": "what-is-limit-clause", "title": "What is LIMIT clause?", "category": "Unverified", "sources": [] }, { "id": "difference-between-delete-drop-and-truncate", "title": "Difference between DELETE, DROP, and TRUNCATE?", "category": "Unverified", "sources": [] }, { "id": "types-of-indexes", "title": "Types of indexes?", "category": "Unverified", "sources": [] }, { "id": "what-is-clustered-index", "title": "What is clustered index?", "category": "Unverified", "sources": [] }, { "id": "what-is-non-clustered-index", "title": "What is non-clustered index?", "category": "Unverified", "sources": [] }, { "id": "what-are-string-functions", "title": "What are string functions?", "category": "Unverified", "sources": [] }, { "id": "what-are-date-functions", "title": "What are date functions?", "category": "Unverified", "sources": [] }, { "id": "what-is-stored-procedure", "title": "What is stored procedure?", "category": "Unverified", "sources": [] }, { "id": "what-is-function-in-sql", "title": "What is function in SQL?", "category": "Unverified", "sources": [] }, { "id": "difference-between-procedure-and-function", "title": "Difference between procedure and function?", "category": "Unverified", "sources": [] }, { "id": "what-are-triggers", "title": "What are triggers?", "category": "Unverified", "sources": [] }, { "id": "what-is-concurrency-control", "title": "What is concurrency control?", "category": "Unverified", "sources": [] }, { "id": "what-is-er-diagram", "title": "What is ER diagram?", "category": "Unverified", "sources": [] }, { "id": "what-is-pagination-in-sql", "title": "What is pagination in SQL?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-backup", "title": "What is database backup?", "category": "Unverified", "sources": [] }, { "id": "what-is-restore-operation", "title": "What is restore operation?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-partitioning", "title": "What is database partitioning?", "category": "Unverified", "sources": [] }, { "id": "what-is-sharding", "title": "What is sharding?", "category": "Unverified", "sources": [] }, { "id": "what-is-replication", "title": "What is replication?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-clustering", "title": "What is database clustering?", "category": "Unverified", "sources": [] }, { "id": "what-is-query-execution-engine", "title": "What is query execution engine?", "category": "Unverified", "sources": [] }, { "id": "what-is-optimizer-in-sql", "title": "What is optimizer in SQL?", "category": "Unverified", "sources": [] }, { "id": "what-is-cost-based-optimization", "title": "What is cost-based optimization?", "category": "Unverified", "sources": [] }, { "id": "what-is-pivot-table", "title": "What is pivot table?", "category": "Unverified", "sources": [] }, { "id": "what-is-unpivot", "title": "What is unpivot?", "category": "Unverified", "sources": [] }, { "id": "what-is-cap-theorem", "title": "What is CAP theorem?", "category": "Unverified", "sources": [] }, { "id": "what-is-oltp", "title": "What is OLTP?", "category": "Unverified", "sources": [] }, { "id": "what-is-olap", "title": "What is OLAP?", "category": "Unverified", "sources": [] }, { "id": "what-is-data-warehouse", "title": "What is data warehouse?", "category": "Unverified", "sources": [] }, { "id": "what-is-etl", "title": "What is ETL?", "category": "Unverified", "sources": [] }, { "id": "what-is-data-lake", "title": "What is data lake?", "category": "Unverified", "sources": [] }, { "id": "what-is-nosql", "title": "What is NoSQL?", "category": "Unverified", "sources": [] }, { "id": "difference-between-sql-and-nosql", "title": "Difference between SQL and NoSQL?", "category": "Unverified", "sources": [] }, { "id": "what-is-mongodb", "title": "What is MongoDB?", "category": "Unverified", "sources": [] }, { "id": "what-is-redis", "title": "What is Redis?", "category": "Unverified", "sources": [] }, { "id": "what-is-cassandra", "title": "What is Cassandra?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-scaling", "title": "What is database scaling?", "category": "Unverified", "sources": [] }, { "id": "what-is-connection-pooling", "title": "What is connection pooling?", "category": "Unverified", "sources": [] }, { "id": "what-is-query-caching", "title": "What is query caching?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-tuning", "title": "What is database tuning?", "category": "Unverified", "sources": [] }, { "id": "what-is-execution-plan-analysis", "title": "What is execution plan analysis?", "category": "Unverified", "sources": [] }, { "id": "what-is-distributed-database", "title": "What is distributed database?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-failover", "title": "What is database failover?", "category": "Unverified", "sources": [] }, { "id": "what-is-high-availability", "title": "What is high availability?", "category": "Unverified", "sources": [] }, { "id": "sql-injection", "title": "What is SQL injection?", "category": "Unverified", "sources": [] }, { "id": "how-to-prevent-sql-injection", "title": "How to prevent SQL injection?", "category": "Unverified", "sources": [] }, { "id": "what-is-database-security", "title": "What is database security?", "category": "Unverified", "sources": [] }, { "id": "what-is-encryption-in-sql", "title": "What is encryption in SQL?", "category": "Unverified", "sources": [] }, { "id": "what-is-audit-logging", "title": "What is audit logging?", "category": "Unverified", "sources": [] }, { "id": "what-is-future-of-databases", "title": "What is future of databases?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-optimize-slow-queries", "title": "How do you optimize slow queries?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-improve-database-performance", "title": "How do you improve database performance?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-design-scalable-databases", "title": "How do you design scalable databases?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-handle-millions-of-records", "title": "How do you handle millions of records?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-optimize-indexes", "title": "How do you optimize indexes?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-normalize-a-database", "title": "How do you normalize a database?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-avoid-deadlocks", "title": "How do you avoid deadlocks?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-secure-databases", "title": "How do you secure databases?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-implement-backup-strategies", "title": "How do you implement backup strategies?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-monitor-database-performance", "title": "How do you monitor database performance?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-implement-sharding", "title": "How do you implement sharding?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-scale-databases-horizontally", "title": "How do you scale databases horizontally?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-debug-sql-issues", "title": "How do you debug SQL issues?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-optimize-joins", "title": "How do you optimize joins?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-handle-transactions", "title": "How do you handle transactions?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-implement-auditing", "title": "How do you implement auditing?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-migrate-databases", "title": "How do you migrate databases?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-implement-replication", "title": "How do you implement replication?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-optimize-reporting-queries", "title": "How do you optimize reporting queries?", "category": "Unverified", "sources": [] }, { "id": "how-do-you-design-enterprise-databases", "title": "How do you design enterprise databases?", "category": "Unverified", "sources": [] }, { "id": "remove-duplicate-records", "title": "Remove duplicate records", "category": "Unverified", "sources": [] }, { "id": "find-nth-highest-salary", "title": "Find nth highest salary", "category": "Unverified", "sources": [] }, { "id": "find-employees-without-department", "title": "Find employees without department", "category": "Unverified", "sources": [] }, { "id": "find-top-5-highest-salaries", "title": "Find top 5 highest salaries", "category": "Unverified", "sources": [] }, { "id": "find-missing-records", "title": "Find missing records", "category": "Unverified", "sources": [] }, { "id": "find-consecutive-records", "title": "Find consecutive records", "category": "Unverified", "sources": [] }, { "id": "find-duplicate-emails", "title": "Find duplicate emails", "category": "Unverified", "sources": [] }, { "id": "find-employees-joined-in-last-month", "title": "Find employees joined in last month", "category": "Unverified", "sources": [] }, { "id": "write-recursive-query", "title": "Write recursive query", "category": "Unverified", "sources": [] }, { "id": "write-stored-procedure", "title": "Write stored procedure", "category": "Unverified", "sources": [] }, { "id": "create-trigger-example", "title": "Create trigger example", "category": "Unverified", "sources": [] }, { "id": "sql-fundamentals-191-260", "title": "SQL Fundamentals (191–260)", "category": "Unverified", "sources": [] }, { "id": "database-optimization-questions-261-340", "title": "Database Optimization Questions (261–340)", "category": "Unverified", "sources": [] }, { "id": "advanced-database-systems-341-420", "title": "Advanced Database Systems (341–420)", "category": "Unverified", "sources": [] }, { "id": "enterprise-sql-questions-421-500", "title": "Enterprise SQL Questions (421–500)", "category": "Unverified", "sources": [] }, { "id": "expert-level-questions-501-580", "title": "Expert-Level Questions (501–580)", "category": "Unverified", "sources": [] }, { "id": "sql-mcqs", "title": "SQL MCQs", "category": "Unverified", "sources": [] }, { "id": "sql-rapid-fire-questions", "title": "SQL Rapid Fire Questions", "category": "Unverified", "sources": [] }, { "id": "sql-tricky-interview-questions", "title": "SQL Tricky Interview Questions", "category": "Unverified", "sources": [] }, { "id": "sql-viva-questions", "title": "SQL Viva Questions", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-freshers", "title": "SQL Interview Questions for Freshers", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-experienced", "title": "SQL Interview Questions for Experienced", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-2-years-experience", "title": "SQL Interview Questions for 2 Years Experience", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-5-years-experience", "title": "SQL Interview Questions for 5 Years Experience", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-database-developers", "title": "SQL Interview Questions for Database Developers", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-for-backend-developers", "title": "SQL Interview Questions for Backend Developers", "category": "Unverified", "sources": [] }, { "id": "sql-interview-questions-with-answers-pdf", "title": "SQL Interview Questions with Answers PDF", "category": "Unverified", "sources": [] }, { "id": "sql-cheat-sheet", "title": "SQL Cheat Sheet", "category": "Unverified", "sources": [] }, { "id": "sql-notes-pdf", "title": "SQL Notes PDF", "category": "Unverified", "sources": [] }, { "id": "sql-resume-questions", "title": "SQL Resume Questions", "category": "Unverified", "sources": [] }, { "id": "sql-project-interview-questions", "title": "SQL Project Interview Questions", "category": "Unverified", "sources": [] }, { "id": "sql-practical-questions", "title": "SQL Practical Questions", "category": "Unverified", "sources": [] }, { "id": "sql-mini-projects", "title": "SQL Mini Projects", "category": "Unverified", "sources": [] }, { "id": "sql-major-projects", "title": "SQL Major Projects", "category": "Unverified", "sources": [] }, { "id": "sql-debugging-questions", "title": "SQL Debugging Questions", "category": "Unverified", "sources": [] }, { "id": "sql-output-based-questions", "title": "SQL Output-Based Questions", "category": "Unverified", "sources": [] }, { "id": "sql-scenario-questions", "title": "SQL Scenario Questions", "category": "Unverified", "sources": [] }, { "id": "sql-architecture-questions", "title": "SQL Architecture Questions", "category": "Unverified", "sources": [] }, { "id": "sql-security-questions", "title": "SQL Security Questions", "category": "Unverified", "sources": [] }, { "id": "sql-coding-test-questions", "title": "SQL Coding Test Questions", "category": "Unverified", "sources": [] }, { "id": "sql-certification-questions", "title": "SQL Certification Questions", "category": "Unverified", "sources": [] }, { "id": "sql-quiz", "title": "SQL Quiz", "category": "Unverified", "sources": [] }, { "id": "sql-online-test", "title": "SQL Online Test", "category": "Unverified", "sources": [] }, { "id": "sql-exercises", "title": "SQL Exercises", "category": "Unverified", "sources": [] }, { "id": "sql-practice-queries", "title": "SQL Practice Queries", "category": "Unverified", "sources": [] }, { "id": "sql-interview-preparation-roadmap", "title": "SQL Interview Preparation Roadmap", "category": "Unverified", "sources": [] }, { "id": "sql-study-plan", "title": "SQL Study Plan", "category": "Unverified", "sources": [] }, { "id": "sql-learning-path", "title": "SQL Learning Path", "category": "Unverified", "sources": [] }, { "id": "sql-best-practices", "title": "SQL Best Practices", "category": "Unverified", "sources": [] }, { "id": "sql-common-mistakes", "title": "SQL Common Mistakes", "category": "Unverified", "sources": [] }, { "id": "sql-security-best-practices", "title": "SQL Security Best Practices", "category": "Unverified", "sources": [] }, { "id": "sql-query-optimization-best-practices", "title": "SQL Query Optimization Best Practices", "category": "Unverified", "sources": [] }, { "id": "sql-coding-standards", "title": "SQL Coding Standards", "category": "Unverified", "sources": [] }, { "id": "sql-database-architecture", "title": "SQL Database Architecture", "category": "Unverified", "sources": [] }, { "id": "sql-optimization-techniques", "title": "SQL Optimization Techniques", "category": "Unverified", "sources": [] }, { "id": "sql-performance-tips", "title": "SQL Performance Tips", "category": "Unverified", "sources": [] }, { "id": "sql-career-roadmap", "title": "SQL Career Roadmap", "category": "Unverified", "sources": [] }, { "id": "sql-remote-jobs-guide", "title": "SQL Remote Jobs Guide", "category": "Unverified", "sources": [] }, { "id": "sql-portfolio-ideas", "title": "SQL Portfolio Ideas", "category": "Unverified", "sources": [] }, { "id": "sql-vs-code-extensions", "title": "SQL VS Code Extensions", "category": "Unverified", "sources": [] }, { "id": "sql-developer-tools", "title": "SQL Developer Tools", "category": "Unverified", "sources": [] }, { "id": "sql-mock-interviews", "title": "SQL Mock Interviews", "category": "Unverified", "sources": [] }, { "id": "complete-sql-mastery-roadmap", "title": "Complete SQL Mastery Roadmap", "category": "Unverified", "sources": [] }, { "id": "become-a-database-engineer", "title": "Become a Database Engineer", "category": "Unverified", "sources": [] } ] } }