SQL - Structured Query Language (DataBase)
Database is collection of data
Structured Query Language(Sql) is commonly used for CRUD operations-Create/Read/Update/Delete on a Database.
Database Management System (DBMS)is a Software interface between database and end user .
It's responsible for authentication,concurrency,logging,backup, optimization etc.,
TYPES OF DATABASE:
EXAMPLES OF RDBMS:-
How to install MySQL:
Search on google -MySQL download
MySQL Installer for Windows
Follow these steps as above images to instal MySQL ☝🏻
char-eg:char(5) stores fixed length string of length 5. Max 255 bytes.
varchar-eg: varchar(5) stores variable length of length 5. Max 65535 bytes .
SHOW CHARACTER SET; --shows various character sets that are supported .
/* sql is not case sensitive.Every query Ends with semicolon.*/
latin1 is the default character set. We can also choose a specific character set like below,
varchar(10) character set utf8 --the particular column is set utf8
create database foregin_sales character set utf8; -- entire database is set to utf8.
All images in the section are from Learning SQL by Alan Beaulieu
BLOB-Binary Large Object File:-
3 . Numeric DataType:-
Tinyint is used to store Bool or Boolean
Thanks for reading. Hope it will be useful to you. I will post some basic SQL queries in my next Blog.