Witton Le Wear
Witton Le Wear
• (2 reviews)
S
SHEILA
« Perfect! Robert was very understanding about my very low level of computer... More »
S
SHEILA
« 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. Sheila »
£10/h
1st lesson free!
Profile and degree verified
Response Time 4h
Lessons offered by Robert
• Individual
The lessons will be held
Taught subjects
• Computer Skills
• Python
• Microsoft Word
• Microsoft Excel
• Databases
• SQL
Levels
• Primary
• Secondary
• GCSE
• AS Level
• A Level
• BTEC
• Masters
• Diploma
• Doctorate
• Beginner
• Intermediate
• Professional
• Kids

# Robert is a Qualified accountant with 30 years experience developing, testing and deploying financial systems for international banks using SQL.

## Methodology

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

## Experience

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.

## Rates

Rate for a 1-hour lesson. : £10/h

## Details

1.0 hour £10.00
1.5 hour £15.00
2.0 hour £20.00

Lessons offered by Robert
Individual
The lessons will be held
Taught subjects
• Computer Skills
• Python
• Microsoft Word
• Microsoft Excel
• Databases
• SQL
Levels
• Primary
• Secondary
• GCSE
• AS Level
• A Level
• BTEC
• Masters
• Diploma
• Doctorate
• Beginner
• Intermediate
• Professional
• Kids

## Robert's CV

Early life
Robert William Davis was born on 28 September 1958 in Anglesey, Wales. His father was a fighter pilot officer in the Royal Air Force and he has lived in: Andover, England; USAF Tyndale, Florida, USA; RAF Gutersloh, Germany; RAF Leuchars, Scotland; British Embassy, Washington DC, USA and Witton Le Wear, Co Durham, England amongst others.

He was educated at Kent College, a public school in Canterbury, Kent, UK. He graduated from Bristol University in June 1979 with a B.Soc.Sci. (Econ/Accy). During his gap year Robert was a member of a team that volunteered to work with UNESCO/UNICEF in Nepal.

Career
Robert began his career with Peat Marwick Mitchell, London as a trainee accountant in April 1980 in the audit and tax specialist banking unit. He qualified as an ACA of the ICAEW in April 1984 having managed audits and tax returns for the London branches of Chase Manhattan Bank, Credit Suisse and Mellon Bank amongst others. Robert moved into mainstream banking in May 1984 as Accounting Manager at Mellon Bank, London Branch and advanced to Regional Financial Controller; Asia Pacific Treasury for National Westminster Bank in Singapore from April 1995 to December 1998.
After the merger of Royal Bank of Scotland and National Westminster Bank in 1998 Robert returned to the UK to work for Misys at Wimbledon, London as Product Analyst and Implementation Consultant and then as Midas Product Marketing Manager, Treasure & Finance Systems for Misys International Banking Systems from January 1999 to October 2002.
For the next eight years Robert was on sabbatical in Pasacao in the Philippines from November 2002 – December 2010 when he built his own house, got married, had a son and set up a few businesses.
From January 2011 to April 2012 Robert consulted for City Software International Ltd, London as a Consultant & Business Analyst for Banking applications. It was at this time that he earnt his Prince2 project management certificate.
In August 2012 he entered into a contract job with Nordea Bank, Copenhagen for 5 months. Robert repeatedly had his contract extended till December 2017 when Nordea cut 2,000 FTE’s and 2,000 contractors as part of cost reduction programme.

## 2 reviews on Robert 5/5

All our ratings are collected by us and are given in confidence, they correspond to a real experience.
S
SHEILA

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.
Sheila

S
SHEILA

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.
Sheila

Robert's response

Sheila was eager to learn and had a hands on, tell me more attitude. She was a pleasure to tutor.

## Similar tutors

computer skills lessons closeby? Here's a selection of tutor listings that you can check out.
Learning isn't a problem, microsoft word lessons for all!
Taking microsoft excel lessons has never been easier: you're going to learn new skills.

Durham
£15
Terrance
1st lesson free!

### My teaching method is based on 'differentiated instruction'. I tailor my instruction to meet individual student needs. I do...

Lessons by webcam Face to face lessons
Annfield Plain
£25
Abutu
• (4 reviews)
1st lesson free!

### My approach to tutoring is to create a lesson plan that will help the student understand the basics including the theories...

Lessons by webcam Face to face lessons Approved profile
Newcastle upon Tyne
£28
Ankit
• (4 reviews)
1st lesson free!

### I like teaching because its my passion. I generally like to teach students by giving them more practical tests because a...

Lessons by webcam Face to face lessons Approved profile
Middlesbrough
£28
Saleh
• (4 reviews)
1st lesson free!

### I have a huge interest in both ICT and mechanical engineering and I expect my student to have that same feeling towards the...

Lessons by webcam Face to face lessons Approved profile
Newcastle upon Tyne
£25
• (4 reviews)
1st lesson free!

### My tutoring experience covers A-level to Masters Level courses in computer science, medical and health science. My tutoring...

Lessons by webcam Face to face lessons Approved profile
North Shields
£25
Hafiz
• (4 reviews)
1st lesson free!

### I am an expert in computer science & accounting tutoring, assignment help, thesis and dissertation assistance for students....

Lessons by webcam Face to face lessons Approved profile
Heysham
£27
Matthew
• (23 reviews)
1st lesson free!

### I will provide support to students outside of tutoring sessions, when necessary, using Email and Zoom. I like to use a...

Lessons by webcam Face to face lessons Approved profile
London
£49
Dr.Kritaphat
• (25 reviews)
1st lesson free!

### *****To help me decide if I can help you and have a more efficient first lesson, can you please list the subject and topics...

Lessons by webcam Approved profile
London
£50
Igor
• (15 reviews)
1st lesson free!

### I am looking forward to sharing my experience and knowledge in computer programming with anyone who wants to improve their...

Lessons by webcam Face to face lessons Approved profile
London
£50
Igor
• (7 reviews)
1st lesson free!

### I am looking forward to sharing my experience and knowledge in computer programming with anyone who wants to improve their...

Lessons by webcam Face to face lessons Approved profile
London
£40
Siddharth
• (13 reviews)
1st lesson free!

### These Java classes are specially curated for those who aspire to get a job or freelance projects. Suitable for college...

Lessons by webcam Approved profile Responds within an hour
London
£30
Danilo
• (11 reviews)
1st lesson free!

### I'm a web developer with 10 years of experience in both front and back-end development. I had the opportunity to work on...

Lessons by webcam Face to face lessons Approved profile
Leicester
£15
Rajan
• (10 reviews)

### My teaching methodology or style is dependent on the needs of my tutee. I am absolutely adaptive to my tutee's needs and I...

Lessons by webcam Approved profile Responds within an hour
Bromley
£25
Micheal
• (15 reviews)

### I am a Computer System and Network Administrator with a couple years’ Experience teaching and delivering technology...

Lessons by webcam Face to face lessons Approved profile
London
£50
Andrea
• (17 reviews)

### EXPERIENCE AND EDUCATION - PhD Candidate, current research focused in Machine Learning for Asset Pricing (Finance) -...

Lessons by webcam Approved profile
London
£50
Andrea
• (17 reviews)

### SERVICES I can offer my assistance with Database languages, querying, designing, prototyping, normalization and data...

Lessons by webcam Approved profile
London
£30
Ankit
• (18 reviews)
1st lesson free!

### Being an IT Engineer, I can easily teach basic skills like Excel, PowerPoint, Access, Word along with skills like Testing...

Lessons by webcam Face to face lessons Approved profile
London
£50
Sumit
• (30 reviews)

### I always start from scratch because I believe that to master something we should be well aquatinted with the roots of that...

Lessons by webcam Face to face lessons Approved profile Responds within an hour
London
£30
Wei Bin
• (13 reviews)
1st lesson free!

### My teaching methodology is very structured and is designed for beginners with no programming experience or experienced...

Lessons by webcam Face to face lessons Approved profile
London
£25
Deepak
• (24 reviews)
1st lesson free!

### I commence the course with basic terminologies & concepts. The course is 100% practical oriented & hands-on sessions will be...

Lessons by webcam Face to face lessons Approved profile Responds within an hour
London
£30
Mudita
• (9 reviews)
1st lesson free!

### **PHD (Computer Science and Mathematics)**AFHEA**5+years university level teaching experience in Computer Science** Hello!...

Lessons by webcam Face to face lessons Approved profile
 at his home at your home By webcam 1 hour Not available £10 Not available