Course Syllabus & Features
Who can enroll?
- Students
- Software Engineers
- Beginners
- Experts
- Any one who want to learn
What will you learn?
- Introduction of MySQL
- Built In Numeric Function
- Built In Date Function
- Built in String Function
- Database
- MySQL Table
- Data Defination Language DDL
- MySQL Clause
- MSQL OrderBy
- Data Manipulation Language DML
- MySQL Joins
What skills you Will gain?
- Understanding database works.
- We use Multiple built-in Function.
- Strong Data Protection.
- Supports multiple programming languages (like. PHP,Python,VBA)
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/-