• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Summary

Summary Database Application and SQL Fundamentals

Document preview thumbnail
Preview 1 out of 4 pages

Database Application and SQL Fundamentals

Content preview

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/

Document information

Uploaded on
November 25, 2024
Number of pages
4
Written in
2024/2025
Type
Summary
$9.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
smartchoices
4.8
(9)
Sold
39
Followers
5
Items
4500
Last sold
1 month ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions