Regular Price: £300 Batch Price: From £300 📅 View Dates & Prices Group Booking Discount: From £200 per person 🧮 Calculate & Book 1-to-1 Training: £500 📋 Booking Request Form 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 Requirements 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. Course Content Built-In Functions Using Built-In Functions ISNULL – A System Function CONVERT – A Conversion Function ROUND: A Mathematical function Using String Functions SUBSTRING LEFT & RIGHT 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 Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Note: Online classes are usually delivered through Zoom video conferencing. Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information