- MySQL Database Administration.
- MySQL Queries.
- Create Tables.
This course provides an exhaustive coverage of SQL, MySQL Certification course is valuable for freshers, those who want to work in databse.
- Students.
- Database Administrators.
- Database Designers.
- Data Warehouse Administrators.
- What is MySQL?.
- History and versions of MySQL..
- Installation and configuration of MySQL.
- Introduction to MySQL Workbench and other client tools.
- Basic SQL syntax.
- Data types in MySQL.
- Creating and deleting databases.
- Creating, modifying, and dropping tables.
- Updating existing data.
- Deleting data from tables.
- Filtering results with WHERE clause.
- Sorting results with ORDER BY.
- Limiting results with LIMIT.
- Writing and executing basic queries.
- COUNT, SUM, AVG, MAX, MIN.
- Grouping results with GROUP BY.
- Filtering groups with HAVING.
- INNER JOIN, OUTER JOIN.
- LEFT JOIN, RIGHT JOIN, FULL JOIN.
- Writing queries with different types of joins.
- Using subqueries in SELECT, FROM, WHERE, and HAVING clauses.
- Writing and executing subqueries.
