24 Mar MySQL Tutorial for Beginners

MySQL is an open-source relational database management system. Initially released on 23rd May 1995, and runs on the following Operating Systems: Linux, Solaris, macOS, Windows, and FreeBSD. Herein, we have provided a complete MySQL Tutorial for Beginners.

MySQL Video Course for Beginners

Buy MySQL Book

Get your copy now:

• Amazon International: https://shorturl.at/XNtbw
• Amazon India: https://shorturl.at/AK0Xs
• Flipkart: https://lnkd.in/gkxSNqEP

Run MySQL Online

-- create
CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL
);

-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accounting');
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales');

-- fetch 
SELECT * FROM EMPLOYEE WHERE dept = 'Sales';

Run it Now ↗️

Viewers

The MySQL tutorial is prepared for students, engineers, and professionals. Beginning with the introduction and installation, you will learn how to create a database and tables, and how to insert records and select them. We have also included operators, clauses, and subquery lessons. With that, step-by-step text and video lessons are provided.

MySQL Tutorial Index

• MySQL Introduction & Features
• How to Install MySQL on Windows 10
• How to Install MySQL on MacOS
  Create, Insert, Select
• Create a database & table in MySQL Workbench
• Create a Database in MySQL
• Create a table in MySQL
• Insert records in a table
• Select Records
  MySQL Constraints
• MySQL PRIMARY KEY Constraint
• MySQL UNIQUE Constraint
• MySQL DEFAULT Constraint
• MySQL CHECK Constraint
• MySQL INDEX Constraint
• MySQL NOT NULL Constraint
  ALTER
• How to Alter a Table in MySQL
• ALTER TABLE – Add a column in a MySQL table
• ALTER TABLE – Drop a column in a MySQL table
• ALTER TABLE – Modify a column in a MySQL table
  MySQL Operators
• AND Operator in MySQL
• OR Operator in MySQL
• NOT Operator in MySQL
• MySQL LIKE Operator
• MySQL IN Operator
• MySQL BETWEEN and NOT BETWEEN Operator
  Built-in Functions
• MySQL AVG() Method
• MySQL SUM() Method
• MySQL MIN() Method
• MySQL MAX() Method
• MySQL COUNT() Method
  Order Records
• Order Records in MySQL
• Descending Order Sort in MySQL
  Statements
• SELECT Statement
• MySQL UPDATE Statement
• MySQL DELETE Statement
• SELECT DISTINCT Statement
• CASE Statement in MySQL
   MySQL Clauses
• MySQL LIMIT Clause
• MySQL WHERE Clause
  DROP Statement
• Drop a Table in MySQL
• Drop a Database in MySQL
  Advanced
• MySQL Indexes
• MySQL Auto Increment
• MySQL Joins
• MySQL Examples