SQL Queries Level 2 Live Online Learning Courses
This one-day SQL (Structured Query Language) workshop is for data analysts who need to summarise and interrogate data. This is a follow up to the introduction course and will continue to develop your skills in writing SQL in order to manipulate data stored in a relational database system.
This workshop is suitable for anyone who needs to learn SQL, whatever database system you use. The training is typically delivered using MS SQL Server and SSMS, so please let us know what system you use.
This course is only available for private bookings, either for groups or as a one-to-one, held online via Zoom or in the classroom. Please get in touch for availability.
This online workshop runs from 9.30am to approximately 4.30pm with regular breaks. It is possible to split the workshop into 2x ½ days. Please let us know your preference. A maximum of six attendees means there is plenty of opportunity for you to ask questions.
What you will learn
By the end of this course you will be able to write SQL SELECT statements confidently. You will be able to retrieve data from one or more tables using a variety of criteria, and know how to write advanced SELECT queries that use union and case statements, and sub queries.
Session 1 – Introduction and Recap
We start by examining the training database and briefly recap SQL the basic SELECT statement and JOINs with a quiz and exercise.
Session 2 – Advanced SQL SELECT Statements
This section includes several useful exercises for querying data from multiple tables. Topics include:
- CASE statements
- Union vs Union All
- Useful string, date and convert functions
Session 3 – Sub Queries and Window Functions
Sub queries allow you to control the data returned from your main query with the results from another query. A typical example might be to first calculate the total that a customer has spent with you during the year, then use this query to return the customers that have spent above average. You can also use sub queries to find duplicate data.
Window functions can be used to combine individual data with aggregate data. For example, in the same query you could display an individual's salary, the average salary for the department/company and calculate the difference. Window functions belong to a type of function known as a ‘set function’, which means a function that applies to a set of rows. The word ‘window’ is used to refer to the set of rows that the function works on.
During the session of the workshop we complete various exercises:
- Examples of useful sub queries
- Introduction to Window functions
- Over() and Over(Partition by)
- Row() v Rank()
If you have any questions about the workshop content or setup please let us know and we’ll arrange for the trainer to give you a call.
Group Learning Events
If you have three or more learners, a private group course could be cheaper.
We can tailor the content to your team, and host the training remotely, at your workplace or here at Happy's HQ in Aldgate, Central London.
What's it like to learn online with Happy?
In this short video, Rachael explains how Happy makes our Live Online Learning IT programmes just as interactive and engaging as our classroom sessions.
The Small Print
This online workshop runs from 9.30am to approximately 4.30pm with regular breaks. It is possible to split the workshop into 2 x ½ days. Please let us know your preference.
The workshop typically uses MS SQL Server and SSMS, so it is important that you have this set up on your own computer prior to the training. It is possible to adapt the workshop for MySQL, for Access or for BigQuery. Please let us know the version you use before booking. A free version of MS SQL Server Express and Tools can be downloaded here.
All learners will need to install Zoom on their machines. Full technical requirements are on the Zoom website. Your link will be included in your joining instructions once you have booked your place — if you haven't received this email then please contact our team.
Your active participation is expected. We recommend you have a headset with a microphone so you can speak to the trainer. It is also important to have a large computer screen, or even two screens, so you can comfortably work whilst referring to the manual or the trainer’s shared screen.
Please ensure you read our Terms and Conditions before booking for our payment terms and cancellation policy.
The happy Guarantee
We want everyone to go away from our courses feeling as though they have learnt useful, practical skills that they can use straight away when they go back to work.
If you don’t feel that your training has been useful or if you are unhappy in any way, just get in touch with our Customer Services team within 30 days of the course. We will be happy to offer you additional support and training free of charge to help you to gain the skills you need, or if you’d prefer, a full refund.
Your post-course support package
- Included in the price of both online and classroom programmes
- 2 years of free access to our IT Helpline
- Unlimited access - call or email our team as often as you need
- Ask about any content covered on your course
Testimonials from happy customers
Trusted Customer24 days ago
I don't know about their service - I only interacted with the training.
Sam Haworth Booth24 days ago
Really interactive training with a facilitator with real-world experience who was able to encourage reflective practice in participants
Mary Murphy27 days ago
It was really interesting and helpful. Darren was so informative!
Diane Hellawell28 days ago
I really enjoyed the day. Very good trainers, easy to understand and a fun interactive day. looked after really well, plenty of Tea, Coffee, Snacks throughout the day, ni...
Roy Wood28 days ago
A well-structured training course, which was really well delivered. Course content (including handouts) sufficiently covered key topics.
Trusted Customer30 days ago
The trainer was engaging and interacted well with the course participants, but the course content didn't feel particularly well tailored to the group's needs, which was f...
Trusted Customer30 days ago
Very upbeat and engaging
Trusted Customer31 days ago
Interesting and informative session. Helped my understanding.
Trusted Customer31 days ago
Very good tutor. I enjoyed the interactive nature and practical exercises.
Tomisin Olumoroti31 days ago
Lovely session and I plan on booking another session in the near future with Happy so that I continue learning and growing in Excel.
Ben Mountford32 days ago
Very good service, patient and polite also able to have a laugh and joke as the course went on. Great to refresh and also learn the new capabilities of excel, especially ...
Liz Mulholland35 days ago
very informative and engaging also being able to connect with people from all over the world