[MySQL] 1. DBMS, MySQL, Database, SQL

DBMS

• MySQL

• MariaDB

• PostgreSQL

• Oracle

• SQL Server

• DB2

• Access

• SQLite

  🤩 Our Amazing Sponsors 👇

  View Website

  DigitalOcean offers a simple and reliable cloud hosting solution that enables developers to get their website or application up and running quickly.

  View Website

  Laravel News keeps you up to date with everything Laravel. Everything from framework news to new community packages, Laravel tutorials, and more.

  View Website

  A Laravel Starter Kit that includes Authentication, User Dashboard, Edit Profile, and a set of UI Components. Learn more about the DevDojo sponsorship program and see your logo here to get your brand in front of thousands of developers.

MySQL

• A type of DBMS software developed by Oracle.

Database

• A collection of data that is accessed and used by multiple users simultaneously.

Characteristics of DBMS and Databases

• Data integrity

• Data independence

• Security

• Minimization of data redundancy

• Ease of application development and modification

• Improved data stability

Evolution of Databases

• Offline management

• Use of file systems

• Database management systems

Classification of DBMS

• Hierarchical DBMS

• Network DBMS

• Relational DBMS

• Object-oriented DBMS

• Object-relational DBMS

SQL

• A language used in relational databases.

Running MySQL via terminal

/usr/local/mysql/bin/mysql -u root -p

Executing SQL files

source employees.sql

Checking databases

show databases;