Everything you ever wanted to know about writing queries in SQL but were afraid to ask!
Writing queries in SQL can seem daunting at first. Even for those who are familiar with the Query Grid in Microsoft Access, moving away from the comfort blanket of the Graphical User Interface and into the cold, unhelpful world of writing your own SQL can be tough!
Our course in writing SQL queries is here to help.
Designed for those with little to no background in using SQL, this course is designed to give you the essentials.
We cover how to use the basic SELECT statement, how to restrict the number of rows you get back by using WHERE and how to use wildcards in SQL.
We also look at some of the functions available when writing SQL, such as LEFT, RIGHT and SUBSTRING for when you’re working with text, and GETDATE, DAY, MONTH, DATENAME and DATEPART for when you’re working with dates.
As you may be aware, SQL isn’t just one language – there are dialects in use, such as Transact SQL, PL-SQL and Jet SQL. In this course, we primarily focus on Transact SQL (used by Microsoft SQL Server), but we will talk about the differences between using SQL within a SQL Server environment and using Jet SQL within a Microsoft Access environment.
Take a look at the full outline on our Guide to writing SQL Queries course page, or why not give us a call on 020 3397 1333 and let’s see if we can’t put something together for you.