Course Content
Web Designing with PHP
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