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 London

London Beginners SQL Querying Fundamentals Course Overview

SQL Querying Fundamentals Training Course Beginners training London

No matter where you happen to be within London then we can come to you to carry out SQL Querying Fundamentals training in London.

Our courses are:

  • Enjoyable
    • We go out of our way to ensure you enjoy the course. After all if you are in a relaxed mood you are more likely to learn.
  • Flexible
    • Work on your project
    • Create your own book
    • Edit your own photographs

We are able to cover central London and come to your offices to deliver training. Covering areas including Westminster and Parliament square across to the Tower Hamlets. From the top of Oxford Street across to St. Pauls. We can come to you and set everything up at your office or home.

That's right we can also provide laptops with SQL Querying Fundamentals Training Course already loaded on. We can also bring a projector should you need it as we know getting hold of one can sometimes be a hassle. The only thing we really require for SQL Querying Fundamentals training in London is a room.

So we can help you set up by preparing your SQL Querying Fundamentals training course in London. Just let us know what you need.

If however, try as you may, you cannot find room at your place of work then you can use offices close to you. Because we understand how difficult it is to find a free meeting room at work.

London offers endless opportunities for exploration, from historic landmarks to modern skyscrapers.

We can use offices convenient to you.

If SQL Querying Fundamentals training in London outline is not what you require, then have a look at the many other training courses in London. We can also tailor your course using projects you're currently working on.

We now are delivering PowerApps training courses from a 2 days or a 1 day beginners/intermediate PowerApps Forms Training Course.


Course Duration: 1 Day

Course Prerequisites for your training in London

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