Click ⭐ if you like the project.
Feel free to make contribution. Pull Requests are highly appreciated.
Follow me @nokha_db for technical updates.
Link to learn SQL commands 👉 Click Here
- What is SQL?
- What is DBMS?
- Difference between SQL and DBMS.
- What is DML and name some DML commands?
- What is database sharding?
- What is database replication?
- What are constraints?
- What is aggregation?
- What is indexing?
- What is clusters in dbms?
- How indexing works internally?
- Explain ACID properties in details.
- What is normalization?
- What is denormalization?
- Difference between SQL and NoSQL databases.
- Explain different forms of normalization.
- When to use SQL based database?
- When to use NoSQL based database?
- Explain different types of NoSQL database.
- What is column oriented database?
- What is BCNF normalization?
- Explain BCNF normalization with examples.
- What are joins in DBMS?
- What is data warehousing?
- What is OLTP in dbms?
- What is OLAP in dbms?
- Difference between OLTP and OLAP.
- What are advantages of DBMS.
- Difference between DBMS and filesystem.
- What is primary key?
- What is foreign key?
- What are different types of keys in dbms?
- What is referential integrity?
- What is View in dbms?
- What are advantages of View?
- Difference between Table and View?
- What is schema in dbms?
- What are DBMS languges?
- Difference between HAVING and WHERE clause.
- What is join?
- What is Trigger?
- What is stored procedure?
- What is the difference between trigger and stored procedure?
- What is transaction in dbms?
- Difference between clustered and non-clustered indexes.
- What is cursor in sql?
- What is the use of cursor in sql?
- Difference between primary key and unique key.
- What to you understand by sub-query in sql?
- What is the differences between DROP, TRUNCATE and DELETE commands?
- What is UNION?
- Difference between UNION and UNION ALL.
- What is entity in dbms?
- What are attributes in dbms?
- What is ER model in dbms?
- What is functional dependency in dbms?
- Different type of joins in sql.
- Are NULL values in sql same as blank space or zero?
- What happens when NULL is compared with NULL?
- What are the problems with Concurrent Execution in dbms?
- Different technique for concurrency control in dbms.
- What is the difference between COMMIT vs ROLLBACK in sql?
- What is CTE in sql.
- What are advantages of NoSQL over RDBMS?
- Difference between horizantal scaling and vertical scaling.
- What is self referencing foreign key?
More questions will be added soon...