Computer Tutoring Logo

Cost Calculator

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

Course price: £ *
Price per head:
£ .

Duration:
1 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

SQL Querying Fundamentals training feedback

Suffolk County Council

"Really good day, Tony is a good trainer and clearly very knowledgeable on the software"

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 Training in Kensington

Kensington Beginners SQL Querying Fundamentals Course Overview

SQL Querying Fundamentals Training Course Beginners training in Kensington

Kensington is a strong location for businesses and individuals looking for high-quality, instructor-led SQL Querying Fundamentals Training Course training in a well-connected part of London.

This setting works well for database querying training, giving delegates time to work through SQL exercises, data structures and reporting examples in a structured way.

We can often deliver the course at your premises, and where needed we can provide laptops, course materials and other equipment to support the session. It is especially helpful for teams who need clearer, more practical confidence with querying and database fundamentals.

Beyond this course, you can also browse our computer training courses in Kensington.

Kensington is well known for its museums, business activity and central location.


SQL Querying Fundamentals training for Kensington teams

We can deliver SQL Querying Fundamentals Beginners training for organisations in Kensington and nearby areas such as Chelsea, Westminster, Hammersmith, Fulham, Notting Hill and central London. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

Kensington is useful for central and West London organisations that need a well-connected training location, with the option to train at your premises where that is more convenient.

Local training use cases

SQL Querying Fundamentals training in Kensington is useful for teams who want skills they can apply quickly in real work. This setting works well for database querying training, giving delegates time to work through SQL exercises, data structures and reporting examples in a structured way. It is especially helpful for teams who need clearer, more practical confidence with querying and database fundamentals. It suits learners who want hands-on database skills they can apply at work.

Our instructor-led SQL Querying Fundamentals Training Course Beginners training in Kensington is designed for teams and individuals who want practical skills they can use straight away. This setting works well for database querying training, giving delegates time to work through SQL exercises, data structures and reporting examples in a structured way. It is especially helpful for teams who need clearer, more practical confidence with querying and database fundamentals.

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

Course Duration: 1 Days

Course Prerequisites for your training in Kensington

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

Location FAQs for Kensington

Where can this training take place in Kensington?

We can deliver this SQL Querying Fundamentals training at your premises in or around Kensington, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Kensington?

Yes. We regularly deliver on-site training for teams in Kensington and can usually tailor the session to your team, your documents and the way you work.

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.