Master the basics of SQL on this 1 day introduction to SQL training course.
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.
- Carry out mathematical calculations in SQL.
- Group and Count your data.
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.