Course Overview
This course is intended for them who need to write queries to retrieve data from the MySQL Server. At the end of this course the course attendees should be able to use SQL for querying data.
Following topics are included in this course:
- Built-In Functions
- Multi-Table Queries
- Grouping Data
- Subqueries
- Stored Procedures
Skills Required
This course is suitable for those who already have basic knowledge on MySQL database and table design, basic SQL. Our Database Design with MySQL Training Courses cover all of the prerequisites.
- Built-In Functions
- Using Built-In Functions
- ISNULL – A System Function
- CONVERT – A Conversion Function
- ROUND: A Mathematical function
- Using String Functions
- Using Date and Time Functions
- GETDATE
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY, MONTH and YEAR
- Using CONVERT to format a date/time
- Multi-Table Queries
- Joining Tables
- INNER JOIN
- INNER JOIN with more than two Tables
- OUTER JOIN
- Grouping Data
- Using Aggregate Functions
- Using GROUP BY Clause
- Using HAVING Clause
- Aggregate Queries with Multiple Tables
- Subqueries
- Introduction of Subqueries
- Subqueries vs Joining Tables
- Subqueries with Comparison Operators
- Subqueries with IN and NOT IN Operators
- Subqueries with EXISTS and NOT EXISTS
- Stored Procedures
- Introduction to Stored Procedures
- Creating Stored Procedure