Database Application and SQL Fundamentals
1. Database Application: Software enabling user interaction with databases.
2. Database Administrator: Secures database against unauthorized access.
3. Authorization: Limits user access to specific database elements.
4. Data Consistency Rules: Ensure synchronized data across multiple storage locations.
5. Query Processor: Interprets queries and optimizes execution plans.
6. Storage Manager: Translates instructions into file-system commands.
7. Transaction Manager: Ensures proper execution of database transactions.
8. MongoDB: Open-source NoSQL database management system.
9. INSERT: Command to add rows to a table.
10.SELECT: Command to retrieve data from a table.
11.UPDATE: Command to modify existing data in a table.
12.DELETE: Command to remove rows from a table.
13.CREATE TABLE: SQL statement to define a new table structure.
14.Data Types: Defines format for column values in tables.
15.INT: Data type for storing integer values.
16.VARCHAR: Data type for variable-length textual values.
17.DATE: Data type for year, month, and day values.
18.Logical Design: Implements requirements into specific database structures.
19.Physical Design: Specifies table organization and indexing for performance.
20.Data Independence: Physical design changes do not affect query results.
21.API: Interface for SQL integration with programming languages.
22.Tuple: Ordered collection of elements in parentheses.
23.Table: Structure with fixed columns and variable rows.
24.Row: Unnamed tuple of values corresponding to columns.
25.Cell: Single value at the intersection of row and column.
26.Literals: Explicit values like strings or numbers in SQL.
27.Keywords: Reserved words with special meaning in SQL.
28.Identifiers: Names for database objects like tables and columns.
29.Comments: Non-executable text for human readability in SQL.
30.Data Definition Language (DDL): Defines database structure and schema.
31.Data Query Language (DQL): Retrieves data from the database.
32.Data Manipulation Language (DML): Manipulates data within the database.
33.Data Control Language (DCL): Manages user access and permissions.
34.Data Transaction Language (DTL): Handles transactions in the database.
35.ALTER TABLE: Modifies existing table structure in SQL.
36.DROP TABLE: Deletes a table and its data from database.
37.TINYINT: 1 byte; Signed range: -128 to 127; Unsigned range: 0 to 255
1/
1. Database Application: Software enabling user interaction with databases.
2. Database Administrator: Secures database against unauthorized access.
3. Authorization: Limits user access to specific database elements.
4. Data Consistency Rules: Ensure synchronized data across multiple storage locations.
5. Query Processor: Interprets queries and optimizes execution plans.
6. Storage Manager: Translates instructions into file-system commands.
7. Transaction Manager: Ensures proper execution of database transactions.
8. MongoDB: Open-source NoSQL database management system.
9. INSERT: Command to add rows to a table.
10.SELECT: Command to retrieve data from a table.
11.UPDATE: Command to modify existing data in a table.
12.DELETE: Command to remove rows from a table.
13.CREATE TABLE: SQL statement to define a new table structure.
14.Data Types: Defines format for column values in tables.
15.INT: Data type for storing integer values.
16.VARCHAR: Data type for variable-length textual values.
17.DATE: Data type for year, month, and day values.
18.Logical Design: Implements requirements into specific database structures.
19.Physical Design: Specifies table organization and indexing for performance.
20.Data Independence: Physical design changes do not affect query results.
21.API: Interface for SQL integration with programming languages.
22.Tuple: Ordered collection of elements in parentheses.
23.Table: Structure with fixed columns and variable rows.
24.Row: Unnamed tuple of values corresponding to columns.
25.Cell: Single value at the intersection of row and column.
26.Literals: Explicit values like strings or numbers in SQL.
27.Keywords: Reserved words with special meaning in SQL.
28.Identifiers: Names for database objects like tables and columns.
29.Comments: Non-executable text for human readability in SQL.
30.Data Definition Language (DDL): Defines database structure and schema.
31.Data Query Language (DQL): Retrieves data from the database.
32.Data Manipulation Language (DML): Manipulates data within the database.
33.Data Control Language (DCL): Manages user access and permissions.
34.Data Transaction Language (DTL): Handles transactions in the database.
35.ALTER TABLE: Modifies existing table structure in SQL.
36.DROP TABLE: Deletes a table and its data from database.
37.TINYINT: 1 byte; Signed range: -128 to 127; Unsigned range: 0 to 255
1/
