For bookings from established businesses, we do not require payment at the point of booking.
We will send you an invoice which you can submit to your accounts payable system.
Purchase Orders
If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.
If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
We will send you an invoice (without a P.O.) which you can use to generate a P.O..
We will then re-issue your invoice with your P.O. included when you provide us with it
PAYMENT METHODS:
You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.
We accept payment either via direct bank transfer or card
Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.
Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.
This is a hands-on course. Our experienced trainers will have you writing your own SQL queries in no time.
We make sure that you have plenty of time to try things out and ask questions if you’re not sure of anything.
By the time you finish, you’ll have a thorough grounding in SQL.
✔ A complete beginners’ SQL course that covers all of the basics. ✔ Plenty of one to one attention and time to ask questions. ✔ Friendly expert trainers, small groups and a comfortable place to learn.
The Trainer
Our usual trainer for this course is Serena.
Serena began her career as a business analyst before moving into IT training.
She is a Microsoft certified and TPMA qualified trainer and has 20+ years’ experience of leading training courses, managing training projects and writing training materials.
What Will I Learn?
By the end of this course you will be able to write your own basic SQL queries.
This course will give you a thorough introduction to the features and capabilities of Structured Query Language (SQL).
It is suitable for anyone who wants to learn the basics of SQL, and uses Microsoft SQL Server as an example database for you to practise on.
By the end you will be able to:
Write basic SELECT statements including wildcard characters and comparison operators.
We start this session with an overview of relational databases and how SQL works within that context. We also have a look at the database that we will be running out SQL queries on during this course and get comfortable with the interface.
The key topics trained are:
Relational Database Concepts
The role of SQL
Overview of the databases used in the workshop
Understanding Data Types
Data Type Management
The syntax of the SELECT statement
Using the DISTINCT, TOP keywords
ORDER BY
Examples of WHERE criteria including AND, OR, LIKE wildcards, comparison operators and BETWEEN, IN
ISNULL() function v IS NULL criterion
Optimising your SELECT statements
The types of functions available in SQL
Performing mathematical calculations
Performing String manipulations
Conversion functions and their uses
Column aliases
• How to write aggregate queries
• COUNT, SUM(), MAX(), MIN()
• GROUP BY
• HAVING
GetDate()
DatePart()
DateName()
• The principle of including data from multiple tables in queries
Am I Ready For This Course?
This is a beginners’ SQL course, so you do not need prior experience with SQL to attend.
It is recommended that you have good experience of working in Windows and some experience of relational databases.
Please note that for live online courses you are responsible for installing a functioning version of SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.
The Training Day
You don’t need to bring anything with you. We provide everything you’ll need for a really fun, productive day of training.
Our courses run from 9.30 am to roughly 4.30 pm with refreshments throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour manual which covers everything in the course. ✔ Your course exercises so that you can practice at home. ✔ A Certificate of Attendance.
Online Training Requirements
To attend this SQL Training course online, you will need:
✔ MS SQL Server Management Studio connected to a SQL database on your Windows PC/laptop with a camera, speakers & microphone ✔ A stable internet connection capable of running Zoom ✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.
Download full course details