DEV Community

avinash-repo
avinash-repo

Posted on

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.

Top comments (0)