24 Mar MySQL Tutorial

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.

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 Video Course for Beginners

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