Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Bournville Village Trust

"Fascinating, thoroughly enjoyed it, SQL makes a lot more sense to me - I just need some time to practice now!"

Rugby School

"Informative, clearly presented and very helpful. It was good to have a trainer of high expertise who was willing to answer specific questions across a variety of fields and software applications."

Just Energy

"Coming from having no background knowledge to SQL I have really benefited from this training course and having the documentation I can't wait to start putting this into practice and learning further"

SQL Querying Fundamentals Training Course Beginners Heathrow

Heathrow Beginners SQL Querying Fundamentals Course Overview

SQL Querying Fundamentals Training Course Beginners training Heathrow

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a SQL Querying Fundamentals Training Course Beginners training course near Heathrow airport could be the ideal solution.

The SQL Querying Fundamentals Training Course Beginners course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Beginners SQL Querying Fundamentals training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.


Course Duration: 1 Day

Course Prerequisites for your training in Heathrow

There are no course prerequisites for this course. However, it would be a good idea to have at least what we would call an intermediate level of Excel knowledge. This would include understanding PivotTables, VLookup.

Complete Course Outline

SQL Querying: Fundamentals

Executing a Simple Query

  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify and Execute a Saved Query

Performing a Conditional Search

  • Search Using One or More Conditions
  • Search for a Range of Values and NULL Values
  • Search Data Based on Patterns

Working with Functions

  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values

Organizing Data

  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

  • Combine the Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables

Exporting Query Results

  • Generate a Text File
  • Generate an XML File