Querying Data from MySQL Server

Batch Price From £300 (approx. $405 USD) View Dates & Prices
Custom Price From £200 (approx. $270 USD) Price Calculator & Booking

Total Duration: 10-Hour
Course level: Intermediate
Delivery Method: Instructor Led Online Training
Certification: Certificate of Completion will be provided after completing the course

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 Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Time Zone:

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.

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

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

Share This Course

Related Courses

Database Design with MySQL

Newsletter Sign-up

First Name

Last Name

Email address

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

☎️ +44 (0)208 432 6218

WhatsApp: +44 0749 461 6045