Example HTML page

MySQL Tutorial

MySQL Tutorial

 

MySQL is the most popular Database Management System. It is an Open source and Operates on Relational Data. This tutorial explains some of the basic SQL statements. If you are learning MySQL for the first time, it is the right choice for you. I am going to explain the concepts at a basic level along with Syntax and Example.

Let’s start the topics one by one…

MySQL – Introduction
MySQL – Connection to the Server
MySQL – Importing Database in to MySQL Server
MySQL – CREATE DATABASE
MySQL – Selecting a Database
MySQL – Managing Databases
MySQL – DROP DATABASE
MySQL – Storage Engines
MySQL – CREATE TABLE
MySQL – ALTER TABLE
MySQL – DROP TABLE
MySQL – TRUNCATE TABLE
MySQL – SELECT
MySQL – SELECT DISTINCT
MySQL – WHERE
MySQL – AND 
MySQL – OR
MySQL – IN
MySQL – BETWEEN
MySQL – LIKE
MySQL – LIMIT
MySQL – IS NULL
MySQL – ORDER BY
MySQL – alias
MySQL – Join Operations
MySQL – GROUP BY
MySQL – ROLL UP
MySQL – HAVING
MySQL – Sub Query
MySQL – CTE
MySQL – INSERT
MySQL – UPDATE
MySQL – DELETE
MySQL – TRANSACTION
MySQL – LOCKS
MySQL – Data Types
MySQL – CONSTRAINTS
MySQL – Imports and Exports
MySQL – Union Statement
MySQL – Important Questions

 

 

Quick Links:

MySQL Assignments

Example HTML page

Pin It on Pinterest