MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

Course Overview

Introduction to SQL
What is SQL
What is Database
What is RDBMS
DBMS vs RDBMS
SQL Syntax
SQL Data Types
SQL Operators
MySql and Workbench
Installing and get starting
SQL Database
SQL CREATE Database
SQL DROP Database
SQL RENAME Database
SQL SELECT Database
SQL Table
What is Table
SQL TABLE Variable
SQL CREATE TABLE
SQL DROP TABLE
SQL DELETE TABLE
SQL RENAME TABLE
SQL TRUNCATE TABLE
SQL COPY TABLE
SQL TEMP TABLE
SQL ALTER TABLE
SQL Select
SELECT Statement
SQL SELECT UNIQUE
SQL SELECT DISTINCT
SQL SELECT COUNT
SQL SELECT TOP
SQL SELECT FIRST
SQL SELECT LAST
SQL SELECT RANDOM
SQL SELECT AS
SQL SELECT IN
SQL SELECT Multiple
SQL SELECT DATE
SQL SELECT SUM
SQL SELECT NULL
SQL Clause
SQL WHERE
SQL AND
SQL OR
SQL WITH
SQL AS

SQL Order By
ORDER BY Clause
ORDER BY ASC
ORDER BY DESC
ORDER BY RANDOM
ORDER BY LIMIT
ORDER BY Multiple Cols
SQL Insert
INSERT Statement
INSERT INTO Values
INSERT INTO SELECT
INSERT Multiple Rows
SQL Update
UPDATE Statement
SQL UPDATE JOIN
SQL UPDATE DATE
SQL Delete
DELETE Statement
SQL DELETE TABLE
SQL DELETE ROW
SQL DELETE All Rows
DELETE Duplicate Rows
SQL DELETE DATABASE
SQL DELETE VIEW
SQL DELETEJOIN
SQL Join
SQL JOIN
SQL Outer Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Cross Join
SQL Keys
Primary Key
Foreign Key
Composite Key
Unique Key
Alternate Key
Difference
SQL vsNoSQL
PL/SQL

Loading...