What is a database?

1. Database is a collection of related data organized in a way that the data can be easily accessed, managed and updated. So the computer program can easily and quickly find access to the needed data.

2. One can organize data into tables, rows, columns, and index it to make it easier to find relevant information.

3. The organized collection of structured data that is stored & accessed electronically to manage a database more efficiently called database.

4. Database handlers create a database.

5. The main purpose of the database is to operate a large amount of information by storing, retrieving, and managing data.

Example of database-

Student details like

1. Name

2. Roll number 

3. Address 

4. Contact 

5. Age 

6. Gender

Elements of database-

1. Character (alphabet or numbers)

2. Fields (stores one type of details)

3. Records (collection of related fields)

4. Files(a collection of related records)

5. Database (a collection files)

What is SQL?

SQL stands for “structured query language” every relational database software interacts with a language SQL, because it is a simple English like language which guidelines are provided by a standard organizational “ANSI” adopted by all database vendors like Oracle, mySQL, microsoft etc.

My SQL is a very complex language to reduce its complexity. 

It can be categorized into 5 sub languages. 

1. DDL (Data definition language)

CREATE, DROP, TRUNCATE, ALTER, RENAME.

2. DML (Data manipulation language)

INSERT, UPDATE,DELETE

3. DQL (Data query language)

SELECT

4. DCL (Data control language)

GRANT, REVOKE

5. TCL (Transaction control language)

COMMIT, ROLLBACK, SAVE POINT

Some basic SQL commands-

1. SELECT- to retrieve data.

2. INSERT- to add new data.

3. UPDATE- to modify existing data.

4. DELETE- to remove data.

5. CREATE- to make new tables or databases.

Example of SQL -

SELECT * FROM students;

This retrieves all records from the students table.

What is MySQL-

1. MySQL is a relational database management system used to manage databases.

2. It is open-source management. This means it is free to use. It is essential for web developers because several applications and the web are built on databases.

3. MySQL is a popular open-source relational database management system(RDBMS) that uses SQL to manage data. It's widely used in web development, often with PHP and Apache in a LAMP stack(linux, Apache, MySQL, PHP)

What does MySQL do?
Here's an illusion-

A movie program such as Netflix, stores and transmits movies, documentaries, TV shows on different devices.

You can search easily for movies by using parameters like movie name, actor, genre etc.

Apps like that need software to manage their SQL database.

Basic MySQL concept-

1. Database- A collection of related tables. 

2. Table- A collection of rows and columns.

3. Row- A single record in a table. 

4. Column- A field in a table.

Example: creating a table in MySQL-

CREATE TABLE students (

    id INT AUTO_INCREMENT,

    name VARCHAR(100),

    age INT,

    PRIMARY KEY (id)

);

MySQL vs SQL

1. SQL is a language.

2. MySQL is a software that implements SQL.