100 terms each for SQL & MongoDB
Tags: webdev, javascript, beginners, programming
Published: 2024-02-04 13:21:55

Certainly, here are 100 terms each for SQL (Structured Query Language) and MongoDB (a NoSQL database). These terms cover a range of concepts, commands, and features associated with both types of databases.

### SQL Terms:

1. **Database:** A structured set of data organized for easy retrieval.
2. **Table:** A collection of data stored in rows and columns.
3. **Column:** Represents a single attribute of a record in a table.
4. **Row:** A record in a table containing data values.
5. **Schema:** A blueprint that defines the structure of a database.
6. **Primary Key:** A unique identifier for each record in a table.
7. **Foreign Key:** A field linking to the primary key in another table.
8. **Index:** Improves the speed of data retrieval operations on a database table.
9. **Query:** A request for data or information from a database.
10. **SQL Statement:** A command to perform operations on a database.
11. **Select:** Retrieves data from one or more tables.
12. **Insert:** Adds new records to a table.
13. **Update:** Modifies existing records in a table.
14. **Delete:** Removes records from a table.
15. **Join:** Combines rows from two or more tables based on a related column.
16. **Inner Join:** Retrieves records that have matching values in both tables.
17. **Outer Join:** Retrieves all records when there is a match in one of the tables.
18. **Left Join:** Retrieves all records from the left table and the matched records from the right table.
19. **Right Join:** Retrieves all records from the right table and the matched records from the left table.
20. **Group By:** Groups rows based on the values in specified columns.
21. **Aggregate Functions:** Functions like SUM, AVG, MIN, MAX, COUNT for summarizing data.
22. **Having:** Filters results based on aggregate function conditions.
23. **Subquery:** A query nested within another query.
24. **Transaction:** A sequence of one or more SQL operations treated as a single unit.
25. **View:** A virtual table based on the result of a SELECT query.
26. **Stored Procedure:** A precompiled collection of one or more SQL statements.
27. **Trigger:** A set of instructions that are automatically executed in response to certain events.
28. **Normalization:** Organizing data to reduce redundancy and dependency.
29. **Denormalization:** Intentionally introducing redundancy to improve query performance.
30. **ACID Properties:** Atomicity, Consistency, Isolation, Durability - properties ensuring reliable database transactions.
31. **Data Definition Language (DDL):** Statements for defining and managing database structures.
32. **Data Manipulation Language (DML):** Statements for manipulating data.
33. **Transaction Isolation Levels:** Defines the degree to which one transaction must be isolated from the effects of other concurrent transactions.
34. **Constraint:** Rules to enforce data integrity.
35. **Unique Constraint:** Ensures that a column contains unique values.
36. **Check Constraint:** Ensures that values in a column meet specific conditions.
37. **Foreign Key Constraint:** Enforces referential integrity between tables.
38. **Indexing:** Improves the speed of data retrieval operations.
39. **Database View:** A virtual table based on the result of a SELECT query.
40. **SQL Injection:** A type of attack where malicious SQL statements are inserted into user input.
41. **Database Index:** A data structure to improve the speed of data retrieval operations on a database table.
42. **Relational Database Management System (RDBMS):** A type of DBMS that stores data in tables and enforces relationships between them.
43. **Non-relational Database:** A database that does not use the traditional table-based relational database structure.
44. **NoSQL:** A category of databases that do not strictly adhere to the traditional SQL relational database management system.
45. **Stored Procedure:** A set of SQL statements that can be stored in the database.
46. **Commit:** Permanently saves changes made during a transaction.
47. **Rollback:** Undoes the changes made during a transaction.
48. **Data Warehouse:** A centralized repository for storing large volumes of data from various sources.
49. **OLAP (Online Analytical Processing):** A category of software tools that enable users to interactively analyze multidimensional data.
50. **OLTP (Online Transaction Processing):** A category of software tools that support transaction-oriented applications.

### MongoDB Terms:

1. **Document:** A JSON-like data structure used in MongoDB.
2. **Collection:** A group of MongoDB documents.
3. **Database:** A container for collections in MongoDB.
4. **Field:** A key-value pair in a MongoDB document.
5. **Document ID:** A unique identifier for each document in a collection.
6. **Embedded Document:** A document nested within another document.
7. **Index:** Improves the speed of data retrieval operations in MongoDB.
8. **Query:** A request for data or information from a MongoDB database.
9. **Insert:** Adds new documents to a MongoDB collection.
10. **Update:** Modifies existing documents in a MongoDB collection.
11. **Delete:** Removes documents from a MongoDB collection.
12. **Projection:** Limits the fields returned in the result set.
13. **Cursor:** A pointer to the result set of a query.
14. **Aggregation Pipeline:** A framework for performing data transformations in MongoDB.
15. **Aggregation Stage:** An operation in the aggregation pipeline.
16. **$match:** Filters documents in the aggregation pipeline.
17. **$group:** Groups documents by a specified expression.
18. **$sort:** Orders documents in the aggregation pipeline.
19. **$limit:** Limits the number of documents passed to the next stage.
20. **$skip:** Skips a specified number of documents.
21. **$lookup:** Performs a left outer join to another collection.
22. **$unwind:** Deconstructs an array field from the input documents.
23. **Sharding:** Distributing data across multiple machines.
24. **Replica Set:** A group of MongoDB servers that maintain the same data.
25. **Journaling:** A feature that ensures data consistency in case of a failure.
26. **Mongo Shell:** A command-line interface for interacting with MongoDB.
27. **GridFS:** A specification for storing large files in MongoDB.
28. **Text Index:** Enables text search on string content.
29. **Geospatial Index:** Enables efficient querying of geospatial data.


30. **TTL Index:** Deletes documents from a collection after a specified amount of time.
31. **Connection Pooling:** Managing a pool of database connections to reduce connection overhead.
32. **Write Concern:** Specifies the level of acknowledgment requested from MongoDB for write operations.
33. **Read Concern:** Specifies the consistency guarantee for read operations.
34. **Read Preference:** Specifies from which members of a replica set to read.
35. **Aggregation Framework:** A data processing pipeline used for transforming and filtering documents.
36. **Document Validation:** Enforces data integrity by validating documents.
37. **Database User:** A user account with specific privileges in a MongoDB database.
38. **Role:** Defines a set of permissions for database operations.
39. **Connection String:** A string that specifies how to connect to a MongoDB database.
40. **Change Streams:** Provides a way to listen for changes in a MongoDB collection.
41. **Document Versioning:** Managing different versions of a document.
42. **MongoDB Atlas:** A cloud-based database service for MongoDB.
43. **MongoDB Compass:** An official graphical user interface for MongoDB.
44. **MongoDB Stitch:** A serverless platform for building applications with MongoDB.
45. **Read-Write Concern:** Specifies the acknowledgment level for both read and write operations.
46. **MongoDB Capped Collections:** Fixed-size collections that automatically overwrite old data.
47. **MongoDB Enterprise:** The commercial version of MongoDB with additional features.
48. **Map-Reduce:** A method for processing and reducing large datasets in MongoDB.
49. **Transaction:** A set of one or more operations that must be performed as a single, indivisible unit.
50. **MongoDB Community:** The free, open-source version of MongoDB.
51. **ObjectId:** A 12-byte identifier typically employed as the document ID in MongoDB.
52. **Replica Set Arbiter:** A member in a MongoDB replica set that helps in achieving consensus.
53. **Document Locking:** The mechanism that MongoDB uses to prevent multiple clients from modifying the same document simultaneously.
54. **Data Migration:** The process of transferring data from one database to another.
55. **Data Modeling:** The process of defining the structure and organization of data in a database.
56. **Shard Key:** The field used to determine how data is distributed across shards in a sharded MongoDB cluster.
57. **MongoDB Driver:** A client library or software component that facilitates communication between an application and a MongoDB database.
58. **MongoDB Realm:** A serverless application development platform for MongoDB.
59. **MongoDB Inc.:** The company that develops and maintains MongoDB.
60. **MongoDB GUI:** Graphical User Interface tools designed to interact with MongoDB databases.

These terms cover a wide range of concepts and features for both SQL and MongoDB databases, offering insights into the unique aspects of each type of database system.