Core Database Concepts

• Database Technologies (DBT)
• Computer, Data-Info
• Information: Database: DBMS; DBMS vs RDBMS ⭐
• DBMS vs RDBMS ⭐
• DBMS vs RDBMS: Distributed database
• Multiple levels of Security in RDBMS
• Various e.g. of RDBMS; Informix; Oracle; Sybase; Server; RDBMS
• DB2, CICS, Single user
• TCL, TDM's RDBMS, MySQL
• How data is stored in RDBMS? ⭐

MySQL Tools & Components

• Various sd/dev tools from MySQL, SQL
• MySQL-PL; MySQL Command line Client; Workbench; Enterprise Backup ⭐
• MySQL Connectors; MySQL for Excel, MySQL Notifier
• MySQL Enterprise Backup, MySQL Enterprise High Availability
• MySQL Enterprise Encryption, MySQL Enterprise Monitor Analyzer
• Instructions to create folders (My-GitData, Sunbeam-GitData)

SQL Language Components

• 4 Sub-divisions of SQL ⭐
  • DDL (Data Definition Language) ⭐
  • DML (Data Manipulation Language) ⭐
  • DTL (Data Transaction Language)
  • TCL (Transaction Control Language) ⭐