About Lesson
- Create tables and Database.
- How to select data from a single table
- How to select data from multiple tables
- Retrieve data from Database.
- How to code summary queries
- How to Insert, Update, Drop, Truncate/Empty, Alter, Delete table
- Update and where condition
- How to use Joins (Cross joins, Inner joins, Outer Joins, Self joins.)
- Order by and Group by
- Like Patterns
- Import and Export Database
- How to use aggregate functions in MySQL