Robert's profile, diploma and contact details have been verified by our experts
Robert
- Rate £10
- Response 1h
-
Students5
Number of students Robert has accompanied since arriving at Superprof
Number of students Robert has accompanied since arriving at Superprof
£10/hr
See Computer Skills tutors
Unfortunately, this tutor is unavailable
- Computer Skills
- Python
- SQL
- Microsoft Excel
- Microsoft Word
- Databases
Robert is a Qualified accountant with 30 years experience developing, testing and deploying financial systems for international banks using SQL.
- Computer Skills
- Python
- SQL
- Microsoft Excel
- Microsoft Word
- Databases
Lesson location
-
at your home or in a public place : will travel up to 10 km from Witton Le Wear
-
Recommended
Robert is a respected member of our tutor community. He is highly recommended for his commitment and the quality of his lessons. An excellent choice to progress with confidence.
About Robert
Robert is a Qualified accountant with 30 years experiance developing, testing and deploying financial systems for international banks. He has prepared and delivered tutorials/seminars on banking products, accounting systems and new transaction processing software training. He lives just outside Bishop Auckland and can teach Microsoft products (Excel, Word, Powerpoint, etc.), database analysis, SQL and Python 3.
See more
About the lesson
- Primary
- Secondary
- GCSE
- +13
levels :
Primary
Secondary
GCSE
AS Level
A Level
BTEC
Adult Education
Undergraduate
Masters
Diploma
Doctorate
Beginner
Intermediate
Advanced
Professional
Kids
- English
All languages in which the lesson is available :
English
I prefer to teach on a face to face basis. The length of the lessons are flexible and agreed upon prior to commencement of the course. I'll start with why learn the subject and then move on to the basics and then onto advanced subjects. The candidate can dictate the subject matter explicitly if preferred. I am flexible.
I can tutor on SQL for beginners. The course will cover the following topics:
Introduction to SQL
Section 1: Selecting columns
Beginning the SQL journey
Tables
SELECTing single columns
SELECTing multiple columns
SELECT DISTINCT
Learning to COUNT
Section 2: Filtering rows
This chapter builds on the first by teaching you how to filter tables for rows satisfying some criteria of interest. You'll learn how to use basic comparison operators, combine multiple criteria, match patterns in text, and much more.
Simple filtering of numeric values
Simple filtering of text
WHERE AND
WHERE AND OR
BETWEEN
WHERE IN
Introduction to NULL and IS NULL
NULL and IS NULL
LIKE and NOT LIKE
Section 3: Aggregate Functions
This chapter builds on the first by teaching you how to filter tables for rows satisfying some criteria of interest. You'll learn how to use basic comparison operators, combine multiple criteria, match patterns in text, and much more.
Aggregate functions
Aggregate functions practice
Combining aggregate functions with WHERE
A note on arithmetic
It's AS simple AS aliasing
Even more aliasing
Section 4: Sorting, grouping and joins
This chapter provides a brief introduction to sorting and grouping your results, and briefly touches on the concept of joins.
ORDER BY
Sorting single columns
Sorting single columns (DESC)
Sorting multiple columns
GROUP BY groups
HAVING a great time
All together now
See more
Review
All of our reviews are collected by us and are 100% reliable. They correspond to a real experience lived by the students of Robert.
5 (2 reviews)
Perfect! Robert was very understanding about my very low level of computer skills. He was very patient and did not make me feel I was asking stupid questions and did not mind repeating exercises until it stuck. I was really enjoying learning a new skill but unfortunately we have had to pause the lessons because the area we live in has been put back into lockdown as the virus levels are rising.
SheilaPerfect! Robert was very understanding about my very low level of computer skills. He was very patient and did not make me feel I was asking stupid questions and did not mind repeating exercises until it stuck. I was really enjoying learning a new skill but unfortunately we have had to pause the lessons because the area we live in has been put back into lockdown as the virus levels are rising.
Sheila- Sheila was eager to learn and had a hands on, tell me more attitude. She was a pleasure to tutor.Robert's response :
View more reviews
See more
Rates
Rate
- £10
Pack prices
- 5h: £50
- 10h: £100
Details
1.0 hour £10.00
1.5 hour £15.00
2.0 hour £20.00
Similar Computer Skills teachers in Witton Le Wear
Essam
Newton Aycliffe & Online
- £30/hr
- 1st lesson free
Jacob
Durham & Online
- £18/hr
- 1st lesson free
Ross
Newcastle Upon Tyne & Online
- £15/hr
- 1st lesson free
Ana
London & Online
- £100/hr
- 1st lesson free
Andrea, PhD, CQF
London & Online
- £100/hr
Dr Kritaphat
London & Online
- £69/hr
- 1st lesson free
Micheal
Bexley & Online
- £35/hr
Robert
London & Online
- £99/hr
- 1st lesson free
Alan
London & Online
- £40/hr
- 1st lesson free
Juneyt (MA, MSc Oxford)
London & Online
- £110/hr
Manoj
London & Online
- £25/hr
- 1st lesson free
Arron
Enfield & Online
- £40/hr
- 1st lesson free
Andrew K
Manchester & Online
- £35/hr
Purva
& Online
- £30/hr
Toprak
Manchester & Online
- £25/hr
- 1st lesson free
Ashar
Hounslow & Online
- £30/hr
Rajan
Leicester & Online
- £20/hr
Shivam
Kingston upon Thames & Online
- £16/hr
- 1st lesson free
Danilo
London & Online
- £100/hr
- 1st lesson free
Siddhant
Manchester & Online
- £33/hr
- 1st lesson free
-
See Computer Skills tutors
