Course Syllabus & Features
Introduction
- Syntax
- Datatypes
- Operators
Built In Numeric Function
- ABS
- Sign
- Mode
- Floor
- Ceiling
- Round
- POW
- SQRT
- Least
- Greatest
- Truncate
Built In Date Function
- Day
- Month
- Year
- Day Of week
- Weekday
- Dayname
- Month Name
- Day of Year
- Quarter
- Hour
- Minute
- Second
- Now
Built in String Fuction
- ASCII
- Char
- Lcase
- Ucase
- Left
- Right
- LPad
- Rpad
- Substring
- Length
Database
- Create
- Drop
- Rename
MySQL Table
- Create
- Drop
- Delete
- Rename
- Truncate
- Alter
Data Defination Language DDL
- Unique
- Distinct
- Top,First
- Last
- Random
- In
- Date
- Sum
- Null
MySQL Clause
- Where
- And
- OR
- As
MSQLOrder By
- Clause
- ASC
- DESC
- LIMIT
Data Manipulation Language DML
- Insert
- Update
- Delete
MySQL Joins
- Inner
- fullouter
- Left
- Right
Fees and Duration
- Duration – 1 Month
- Fees – 12,000/-
Introduction
- Syntax
- Datatypes
- Operators
Built In Numeric Function
- ABS
- Sign
- Mode
- Floor
- Ceiling
- Round
- POW
- SQRT
- Least
- Greatest
- Truncate
Built In Date Function
- Day
- Month
- Year
- Day Of week
- Weekday
- Dayname
- Month Name
- Day of Year
- Quarter
- Hour
- Minute
- Second
- Now
Built in String Fuction
- ASCII
- Char
- Lcase
- Ucase
- Left
- Right
- LPad
- Rpad
- Substring
- Length
Database
- Create
- Drop
- Rename
MySQL Table
- Create
- Drop
- Delete
- Rename
- Truncate
- Alter
Data Defination Language DDL
- Unique
- Distinct
- Top,First
- Last
- Random
- In
- Date
- Sum
- Null
MySQL Clause
- Where
- And
- OR
- As
MSQLOrder By
- Clause
- ASC
- DESC
- LIMIT
Data Manipulation Language DML
- Insert
- Update
- Delete
MySQL Joins
- Inner
- fullouter
- Left
- Right
Fees and Duration
- Duration – 1 Month
- Fees – 12,000/-
