100 terms each for SQL & MongoDB

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.