Big data - data science topics Page

Big Data - Data Science Topics



Compare and sync with Database topics

Return to Data Science Bibliography, IT Topics, Database Topics, Topics, Big Data, Data Science or Databases




A


* Algorithmics

=AWS

=
* AWS Big Data
** AWS Big Data Course Path
* AWS databases - Amazon database technology and databases in AWS
** https://app.pluralsight.com/paths/skill/aws-databases
* Amazon DynamoDB
* Amazon RDS
* Amazon Web Services (AWS)

=Apache


* Apache Hive
* Apache Kafka
* Apache Spark


=Azure

=
* Azure Databases - See M section for Microsoft database technology and databases in Azure
* Azure Blob Storage
* Azure Cosmos DB
* Azure Databricks
* Azure Machine Learning
* Azure NoSQL
* Azure SQL
* Azure Stream Analytics


B


* Big data - Bigdata



C


* Cassandra
* CRUD


D


* D3


Data (computing)|Data

* Data augmentation|Augmentation
* Data analysis|Analysis
* Data archaeology|Archaeology
* Data cleansing|Cleansing
* Data collection|Collection
* Data compression|Compression
* Data corruption|Corruption
* Data curation|Curation
* Data degradation|Degradation
* Data editing|Editing
* Extract, transform, load|ETL/Extract, load, transform|ELT
**Data extraction|Extract
**Data transformation|Transform
**Data loading|Load
* Data farming|Farming
* Data format management|Format management
* Data fusion|Fusion
* Data integration|Integration
* Data integrity|Integrity
* Data library|Library
* Data loss|Loss
* Data management|Management
* Data migration|Migration
* Data mining|Mining
* Data pre-processing|Pre-processing
* Data preservation|Preservation
* Information privacy|Protection (privacy)
* Data recovery|Recovery
* Data reduction|Reduction
* Data retention|Retention
* Data quality|Quality
* Data science|Science
* Data scraping|Scraping
* Data scrubbing|Scrubbing
* Data security|Security
* Data steward|Stewardship
* Data storage|Storage
* Data validation|Validation
* Data warehouse|Warehouse
* Data wrangling|Wrangling/munging


* 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

* Database as a Service (DBaaS)

* DAX


* Deep Learning

E


* ElasticSearch
* ELK - ELK Stack - ElasticSearch-Kibana-LogStash
* ELT
* ETL

F




G


* General Big Data Principles
* General Data Science Principles
* General Data Warehousing Practices
* General Relational Database Principles
* Google Analytics
* Google BigQuery
* Google Cloud Platform

H


* Hadoop


I




J




K


* KQL


L




M


* Machine Learning Literacy
* MapReduce
* Microsoft Azure Data Lake
* Microsoft Excel
* Microsoft Power BI
* Microsoft SQL Server
* Microsoft SQL Server Exam 70-461
* Microsoft SQL Server Exam 70-462
* Microsoft SSIS

* 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


* 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

* SQL Server Reporting Services (SSRS)

=MySQL

=
* MySQL


N


* NoSQL - MongoDB, Azure Cosmos DB, Cassandra,



O


* Oracle Database - Oracle DBMS
* ORM - Object Relational Mapper
** Entity Framework

P


* pandas
* PostgreSQL
* Python
* PyTorch

R


* R

S


* Scikit-Learn
* SQL
* SQL Server - See M section for Microsoft SQL database technology and SQL databases in Azure
* SQL Server Reporting Services (SSRS)
* SSAS
* SSIS

T


* T-SQL
* Tableau
* Tensorflow



Fair Use Sources


Fair Use Sources:
* https://app.pluralsight.com/library/browse-role/data-professional/recent

{{navbar_datascience}}

{{navbar_footer}}