📄️ Introduction
MySQL is an open-source Relational Database Management System (RDBMS).
📄️ Installation
When starting with MySQL, you have two main options for installation:
📄️ MySQL Workbench
MySQL Workbench is a graphical user interface (GUI) tool provided by Oracle for interacting with MySQL databases. Instead of typing all SQL commands in the command line, It gives you a visual environment to:
📄️ MySQL Server Connection
The MySQL server runs as a service (daemon) in the background.
📄️ MySQL Client Tools
When you install MySQL, you get access to different client tools that allow you to interact with the MySQL server.
📄️ Core Concepts
- Database: A database is an organized collection of structured data, stored and managed so that it can be efficiently accessed, retrieved, and updated.
📄️ Data Types
Numeric
📄️ Constraints
Constraints are rules applied to table columns to enforce data integrity and consistency. They ensure that the data stored in a table adheres to certain rules.
📄️ Tables
Creating tables
📄️ SQL Statements
Categories
📄️ Advanced SQL Statements
SQL processes queries in this logical order:
📄️ Indexing
An index in a database is like the index of a book — instead of reading the whole book to find a topic, you can go directly to the page numbers listed.
📄️ Stored Procedure
A Stored Procedure in MySQL is a set of SQL statements that are stored in the database and can be executed later by calling its name.
📄️ Stored Function
It’s similar to a function in programming languages:
📄️ Triggers
A Trigger in MySQL is a database object that is automatically executed (“fired”) when a specific event (INSERT, UPDATE, DELETE) occurs on a table.
📄️ Events
A MySQL Event is like a scheduled task (cron job) that runs SQL statements at specific times or intervals.
📄️ Transaction
A transaction in MySQL is a sequence of one or more SQL statements that are executed as a single unit of work.
📄️ ACID Properties
A transaction in MySQL must follow the ACID principles to ensure data correctness and reliability:
📄️ Isolation Levels
Isolation levels in MySQL are one of the most important (but often confusing) parts of transactions. They directly control how multiple transactions interact with each other and what concurrency issues can occur.
🗃️ Database Security
3 items
📄️ Data Backup
mysqldump
🗃️ Advance Features
4 items
📄️ Replication
Replication in MySQL is the process of copying data from one database server (the master / primary) to one or more other servers (slaves / replicas).
🗃️ Large Datasets
3 items