Databases

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database

A very basic and nice explanation of the types of DBMS: https://www.youtube.com/watch?v=FR4QIeZaPeM&feature=emb_logo

NoSQL databases:
This is good to start understanding NoSQL databases and the difference with relational databases: https://www.youtube.com/watch?v=uD3p_rZPBUQ

Data Warehouse:
This is a very good explanation of what a Data Warehouse is: https://www.youtube.com/watch?v=k4tK2ttdSDg

• Database design

• Conceptual design

• Entity relationship modelling

• The Enhanced Entity-Relation Model

• Logical design

• Relational Model

• Normalisation

• RDBMS

• MySQL

• Backup and Restore MySQL/MariaDB Databases

• Import a CSV file into a MySQL database

• Reset the MySQL/MariaDB Password

• Authentication and Authorization

• SQL Practice Labs

• Stored Procedures

• Stored Functions

• Triggers

• Events

• Cursors

• Transactions

• Exception Handling

• PostgreSQL

• GUI DB administration tools

• MySQL Workbench

• PhpMyAdmin

• SQLectron