https://RustRocket.rs -- Cloud Monk Losang Jinpa, Ph.D., MCSE / MCT, https://Rustaceans.rs, Full Stack Cloud Native Rust DevOps Engineer - Rocket Framework Rust Microservices on Kubernetes-AWS-Azure-GCP

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

• 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

• Big data

• Cassandra
• CRUD

• Database
• Database administration
• Database Administrator - DBA

• 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

• 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

• Hibernate ORM

• Java database library

• mySQL

• Microsoft database technology

• Microsoft databases

• Azure databases - Azure database, Databases in Azure
  • Microsoft Azure databases - Microsoft Azure database, Microsoft Databases in Azure
• Azure Data, Azure Big Data, Azure Storage, Azure data science
  • Microsoft Azure Data, Microsoft Azure Big Data, Microsoft Azure Storage, Microsoft Azure data science

• Microsoft Azure SQL - Azure SQL:
  • Microsoft Azure SQL Database - Azure SQL Database
  • Microsoft Azure SQL Data Warehouse - Azure SQL Data Warehouse
  • Microsoft Azure Databricks - Azure Databricks
  • Microsoft Azure Data Factory - Azure Data Factory
    • Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI
    • Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI

• 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
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2005

• MongoDB

• NoSQL - MongoDB, Azure Cosmos DB, Cassandra

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

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

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