database_topics

Table of Contents

Database Topics
A
B
C
D
G
H
J
M
N
O
P
S

Database Topics

Compare and sync with Data science topics

Return to IT Topics, Cloud Computing Topics, GubDB, PostgreSQL courses, Managing PostgreSQL, Installing PostgreSQL, PostgreSQL FAQ, SQL

Return to Big Data topics for the most detailed list of Data topics. Return to Computer science topics

A

Ad hoc

AWS databases - Amazon database technology and databases in AWS
- https://app.pluralsight.com/paths/skill/aws-databases

Azure Databases - See M section for Microsoft database technology and databases in Azure

B

Big data

C

D

Data Manipulation Language - DML
- SQL SELECT - Retrieve Data - Retrieves database rows from an SQL database and enables selection of one or many rows to an SQL table or SQL view
- SQL INSERT - Insert Data - Adds one or more rows to an SQL table or SQL view
- SQL UPDATE - Update Data - Change Data - Changes existing data in an SQL table or SQL view
- SQL DELETE - Delete Data - Removes one or more rows from an SQL table or SQL view
- SQL MERGE - Importing Data File, Introduced in SQL Server 2008
  - SQL MERGE performs an INSERT, UPDATE, or DELETE on a target SQL Table based on the results of a SQL JOIN with a source table.
- SQL BULK INSERT - Data
- Future Deprecated: SQL WRITETEXT, SQL READTEXT, SQL UPDATETEXT

Data Definition Language - DDL - Defines data objects
- SQL CREATE - Enables creating an item in SQL Server. e.g. SQL database, SQL table, SQL view, SQL users, SQL index, and more
- SQL ALTER - Enables modifying an existing SQL data object. e.g. SQL database, SQL table, SQL view, and more
- SQL DROP - Removes an existing SQL data object
- SQL Collations - Defines the collation of an SQL database or SQL table column, or a SQL collation case operation when applied to an SQL character string expression
- SQL ENABLE TRIGGER - Enables an SQL trigger such as a DML trigger], [[DDL trigger, or SQL login trigger. an SQL trigger is an SQL stored procedure that automatically runs when an SQL event occurs in the server.
- SQL DISABLE TRIGGER - Disables an SQL trigger
- SQL RENAME - Renames a user-created SQL table in Azure SQL Data Warehouse or a user-created SQL table or SQL database in Parallel Data Warehouse
- SQL UPDATE STATISTICS - SQL Server Query Optimizer - updates SQL query optimization SQL statistics on an [[SQL table an SQL indexed view.
- SQL USE - Changes the SQL database context to the specified SQL database or SQL database snapshot in the SQL Server. This does not apply to Azure SQL Database or Azure SQL Data Warehouse

Data science

DevOps

G

GunDB - The NoDB - no master, no servers, no “single source of truth”, not built with a real programming language or real hardware, no DevOps, no locking, not just SQL or NoSQL but both (all - graphs, documents, tables, key/value). https://gun.eco/docs - https://github.com/amark/gun

H

Hibernate ORM

J

Java database library

M

mySQL

Microsoft database technology

Microsoft databases

Microsoft Azure SQL - Azure SQL:

Microsoft Azure NoSQL - Azure NoSQL:
- Microsoft Azure Cosmos DB - Azure Cosmos DB

** Microsoft Azure Cosmos DB - Azure Cosmos DB

** Entity Framework - ORM ** Microsoft SQL Server **

Microsoft SQL Server 2019

MongoDB

N

NoSQL - MongoDB, Azure Cosmos DB, Cassandra

O

ORM - Object-relational mapping - Object relational mapping
- Entity Framework

P

PostgreSQL - https://hub.docker.com/_/postgres

S

SQL
SQL Server - See M section for Microsoft SQL database technology and SQL databases in Azure