MySql

MySQL

1.      Database Fundamentals:

·         What is a database? & What is SQL?

·         MySQL Introduction

2.      Database Design

·         What is Normalization?

·         What is ER (Entity-relationship) Modeling?

3.      MySQL Basic:

·         MySQL Create Database & MySQL Data Types

·         MySQL SELECT Statment with Examples

·         MySQL WHERE Clause with Examples - AND, OR, IN, NOT IN

·         MySQL query INSERT INTO Table with Examples

·         MySQL UPDATE & DELETE Query with Example

4.      Data Sorting:

• ·         Sorting in MySQL : ORDER BY, DESC and ASC
• ·         MySQL GROUP BY and HAVING Clause
• ·         MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )

•             MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT
• .      MySQL IS NULL & IS NOT NULL
• .      MySQL AUTO_INCREMENT  with Examples
• .      MYSQL - ALTER, DROP, RENAME, MODIFY
• .      MySQL LIMIT & OFFSET 
•      MySQL SubQuery   with Examples
•      MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
•  .     MySQL UNION
•  .       Views in MySQL Tutorial: Create  & Drop with Examples
•  .       MySQL INDEXES - Create, Drop & Add Index

15.  Mysql Transactions:

• ·         COMMIT and ROLLBACK
•    .Date/Time Functions & SQL Date/Time Types

17.Mathematical Functions

MOD()	Returns the remainder
LN()	Returns the natural logarithm of the argument
LOG10()	Returns the base-10 logarithm of the argument
LOG2()	Returns the base-2 logarithm of the argument
LOG()	Returns the natural logarithm of the first argument
-	Minus operator
%	Modulo operator
PI()	Returns the value of pi
+	Addition operator
POW(), POWER()	Returns the argument raised to the specified power
RADIANS()	Returns argument converted to radians
RAND()	Returns a random floating-point value
ROUND()	Rounds the argument
SIGN()	Returns the sign of the argument
SIN()	Returns the sine of the argument
SQRT()	Returns the square root of the argument