Querying Data from MySQL Server Training Course

Regular Course Price: £160.00   
Total Duration: 8 Hours
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

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.

Course Dates, Prices & Enrolment

Training
Method		Dates and Times
(in the UK)		Dates and Times
(if not in the UK)		Price 
Online Training using Zoom 18 Jan 2021 - 29 Jan 2021
2 Mondays & 2 Fridays
11am - 1pm 		Start Date & Time
End Date & Time 		£160
Enrol Now
Online Training using Zoom 08 Mar 2021 - 19 Mar 2021
2 Mondays & 2 Fridays
11am - 1pm 		Start Date & Time
End Date & Time 		£160
Enrol Now
  1. 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
  2. Multi-Table Queries
    • Joining Tables
    • INNER JOIN
    • INNER JOIN with more than two Tables
    • OUTER JOIN
  3. Grouping Data
    • Using Aggregate Functions
    • Using GROUP BY Clause
    • Using HAVING Clause
    • Aggregate Queries with Multiple Tables
  4. 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
  5. Stored Procedures
    • Introduction to Stored Procedures
    • Creating Stored Procedure

Course Tutors

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Related Courses

Newsletter Sign-up

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
Tel: +44 (0)208 432 6218

2012 - 2021 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992. VAT no. GB200 4290 68.