Mysql
Course Overview
HTML is a good Language
Topics
Introduction to SQL
How to Download MYSQL
How to Install and Configure MYSQL
How to Start MYSQL
Create Database in SQL
Use Database in SQL
Create Table in SQL
Describe Table in SQL
Show Database and Table in SQL
INT and DEC Data Type in SQL
CHAR
DATE
Example of All Data Type in SQL
Help and Support by MYSQL
INSERT INTO in SQL
INSERT INTO without specifying Column Name in SQL
INSERT INTO with Changing order of column in SQL
INSERT INTO Specified Column in SQL
INSERT INTO Multiple rows in SQL
SELECT All or Particular Column records in SQL
Single Quotes Problem in SQL
SELECT with LIMIT in SQL
WHERE Clause and equal operator in SQL
WHERE Clause and Not equal operator in SQL
WHERE Clause and Greater than less than in SQL
IS NULL and IS NOT NULL in SQL
AND operator in SQL
OR operator in SQL
Combination of AND & OR in SQL IN Operator in SQL
NOT IN operator in SQL
BETWEEN Number in SQL
BETWEEN Text in SQL
BETWEEN Date in SQL
NOT BETWEEN Number in SQL
NOT BETWEEN Text in SQL
NOT BETWEEN Date in SQL
BETWEEN with IN SQL
BETWEEN with NOT IN SQL
LIKE with % WildCard in SQL
LIKE with _ Wildcard in SQL
LIKE with [charlist] Wildcard in SQL
NOT LIKE in SQL
ORDER BY decending order in SQL
ORDER BY Asecending order in SQL
NOT NULL in SQL
UNIQUE KEY in SQL
PRIMARY KEY in SQL
AUTO INCREMENT in SQL
Starting AUTO INCREMENT with a particular Number in SQL
AUTO INCREMENT without specifying column name in SQL
Alias in SQL
Arithmetic Operators in SQL
SELECT DISTINCT in SQL
ALTER TABLE for adding one column without constraints in SQL
ALTER TABLE for adding multiple columns without constraints in SQL
ALTER TABLE for Adding Column by Position without constraints in SQL
ALTER TABLE for Adding Column with constraints in SQL
ALTER TABLE for Adding Column by Position with constraints in SQL
ALTER TABLE for Adding Constraint in Column SQL
Change Column Name and Its Data Type WIthout Constraints in SQL
Change more than one column Name and its data type without constraints in SQL
CHANGE COLUMN name and its Data Type with constraint in SQL
MODIFY COLUMN Data Type and Its Size with or Without Constraint in SQL
DROP COLUMN with or without constraint in SQL
DROP TABLE or Delete Table from database in SQL
Delete Data of Table using TRUNCATE TABLE in SQL
Rename Table Name using RENAME TABLE in SQL
Alter Database using ALTER DATABASE in SQL
Delete Database using DROP DATABASE in SQL
SHOW COLUMNS in SQL
SHOW CREATE DATABASE in SQL
SHOW CREATE TABLE in SQL
Update Records in Table Part 1 in SQL
Update Records in Table Part 2 in SQL
UPDATE with CASE in SQL
DELETE recods in Table in SQL
Copy Old Table to New Table within same Database in SQL
Copy Old Table to New Table different Database in SQL
MIN and MAX Function in SQL
SUM and AVG Function in SQL
SQRT Function in SQL
DECIMAL Data Type in SQL
ROUND Function in SQL
COUNT Function in SQL
UPPER and LOWER Function in SQL
MID and LENGTH Function in SQL
CONCAT Function in SQL
REVERSE Function in SQL
NOW Function in SQL
GROUP BY in SQL
HAVING Clause in SQL
Why do we need Multi Table in SQL
Relationship between Tables in SQL
One to One Relationship in SQL
One to Many Relationship in SQL
Many to Many Relationship in SQL
What is Normalization in SQL
First Normal Form 1 NF in SQL
Second Normal Form 2 NF in SQL
Third Normal Form 3 NF in SQL
Short Note about Normalization in SQL
What is Foreign Key in SQL
Create Table with Foreign Key in SQL Theory
Create Table with Foreign Key in SQL Practical
How to find Constraint Name in SQL
Drop Foreign Key from Table in SQL
Add Foreign Key Constraint in a Table SQL
Unable to Delete Parent Table in SQL
Unable to Delete Parent Table records in SQL
ON DELETE Clause in SQL
ON DELETE CASCADE in SQL
ON DELETE SET NULL in SQL
ON DELETE NO ACTION or ON UPDATE RESTRICT in SQL
ON UPDATE Clause in SQL
ON UPDATE CASCADE in SQL
ON UPDATE SET NULL in SQL
ON UPDATE NO ACTION or ON UPDATE RESTRICT in SQL
Composite Key in SQL
Shorthand Notation in SQL
How to Join Tables in SQL
CROSS JOIN in SQL
INNER EQUIJOIN in SQL
INNER NON-EQUIJOIN in SQL
NATURAL JOIN in SQL
Outer Join in SQL
LEFT OUTER JOIN in SQL
RIGHT OUTER JOIN in SQL
FULL OUTER JOIN in SQL
What is Self Join in SQL
Why do we need Self Join in SQL
Self Join Example in SQL
Replacing NULL in SQL
UNION in SQL
UNION ALL in SQL
INTERSECT and EXCEPT in SQL
Solve error can\\\'t connect to mysql server on localhost