Flashcards
SQL
Flashcards do conjunto (26)
- 1Databasea collection of items that can exist over a long period of time
- 2recordsrepresentations of physical or conceptual objects
- 3record’s attributesmultiple information or data, such as individual name, job title, company name and address, phone number and more
- 4metadatais the information that defines or describes the data’s structure within the given database (defined as a self-describing entity), stored in a region called data dictionary
- 5database categoriespersonal, workgroup or departmental, and enterprise
- 6Personal Databaseconceptualized and designed by a single person on a stand-alone computer.
- 7Workgroup/Departmental Databasedesigned and created by individuals of a single workgroup or department within a certain organization.
- 8Enterprise Databasethis type is conceptualized and created to handle the entire flow of information of very large organizations.
- 9relational databaseis an entity consisting of logical units known as tables, how the tables are related to each other defines their relationships.
- 10common keylinks the tables to one another in a relational database
- 11Database Management Systems (DBMS)important programming tool that consists of a set of programs that define, manage and process databases and all applications associated to them
- 12types of users that work on DBMSconventional user who retrieves or modifies data and the administrator who is responsible for maintaining the structure of the database
- 13Schemaalso called the conceptual view or the complete logical view that defines the entire database structure and provides overall table organization, considered a metadata – stored in tables and part of the database
- 14DomainThis specifies the set of all finite data values you can store in a particular table column or attribute, for example the STATE column can only contain the values “TX”, “NY”, “CA” and “NV”
- 15Constraintthis sets down the rules that identify what data values a specific table attribute can contain, Together with defined table characteristics, column constraints determine its domain.
- 16Categories of SQL Command TypesData Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Data Control Language (DCL) , Transactional Control Commands
- 17Data Definition Language (DDL) commandsCREATE = is responsible for building the database structure, ALTER = “changing the database structure after it has been created, DROP = destroys the database structure
- 18Data Manipulation Language (DML) commandsINSERT =used to insert new data values into a certain table, UPDATE = used to modify or alter pre-existing data values in a table, not add or remove records, DELETE = deletes certain records or even the entire table, not data values from specific columns
- 19Data Query Language (DQL) commandsSELECT
- 20“Data Control Language (DCL) commandsGRANT = provides you with certain privileges, like giving you the permission to access the database, REVOKE = revokes your privileges, like removing your permission to access the database
- 21Transactional Control CommandsCOMMIT = completes a transaction by making the changes you made to the database permanent, or simply saving the transactions, ROLLBACK = restore the database system to its previous state or undo all the actions that took place in the transaction log, SAVEPOINT = works with the ROLLBACK command, wherein it creates sections or points within groups of transactions in which you will be performing the ROLLBACK command.
- 22Data types in SQLnumeric, string, date and time, boolean
- 23numericINTEGER ( -2,147,483,648 to 2,147,483,647), SMALLINT (-32,768 to +32,767), BIGINT (-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807), NUMERIC (p, s) = 'p' specifies the precision while ‘s’ is for the scale. For example, NUMERIC (6, 3) means that the number’s absolute value will only be up to 999.999 (6 total significant digits with 3 digits following the decimal point), DECIMAL (p, s) = the same as NUMERIC but rounds the number, Let us say you entered the number 123.4564, this will be rounded off to 123.456. The allocated storage size for this data type is based on the given precision, REAL, DOUBLE PRECISION (p, s), FLOAT (p, s)
- 24stringCHARACTER (n) or CHAR (n) = n equals the number of characters or the maximum allocated length for the defined field, CHARACTER VARYING (n) or VARCHAR (n) = This is used when the data entries are of different lengths, or not constant, but you don’t want SQL to fill the remaining spaces with blanks, CHARACTER LARGE OBJECT (CLOB) = used to contain unicode character-based information that is too big to be stored as a CHARACTER type, such as large documents
- 25date and timeDATE, TIME, DATETIME, TIMESTAMP = the same as DATETIME but the range of values is from “1970-01-01 00:00:01” UTC to “2038-01-19 03:14:07” UTC.
- 26BooleanThis data type consists of values that are used for data comparison: TRUE, FALSE, or NULL
Informações
- Descrição
- Conceptos básicos de SQL
- Criado por
- Ivan Espinosa
- Visualizações
- 49
- Tags
- Avaliação