A beginner's guide to SQL

Course Dates: 17/11/19
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutors:
Graeme Mitchell

An SQL database is the invisible but crucial component of many of our core computer systems. Everything from a simple Google Search, using a social network such as Facebook, purchasing goods on Amazon, using Sat Nav to plan a route, or even looking up a contact number on our iPhone, requires database functionality. On this course you will learn Structured Query Language (SQL), the language used to create, maintain and search for information on nearly all database platforms.

Description

What is the course about?

This is very much a hands on course designed for students new to databases. Using a project based approach we will learn to use SQL to create a contact list similar to the one you use on your phone to store the names and details of acquaintances and colleagues.

What will we cover?

We will use the popular and free SQLite database used extensively by Apple and Microsoft and the SQLiteStudio manager to learn the fundamental SQL skills needed to create, manage and find information in a phone contact list.

What will I achieve?
By the end of this course you should be able to...

• Build a contacts list database
• Store contacts in the list
• Amend and delete contact details
• Sort contacts alphabetically
• Search for names and numbers.

What level is the course and do I need any particular skills?

You do not need any previous experience of either SQL or database management systems to study on this course but you do need to have good Microsoft Office skills.

If you have some prior experience in coding, (it doesn’t matter which language), such as having attended one of our many Python or HTML and CSS courses you may wish to consider our follow on course, Introduction to SQL and Microsoft SQL Server.

You should also be able to follow spoken instructions, read written instructions and information, and discuss work with your tutor in English.

How will I be taught, and will there be any work outside the class?

There will be some theoretical underpinning to the course, but the course is mainly practical, through teacher demonstration and student centred exercises and activities. There is no official work set outside the class but it is a good idea to practise the skills you have learnt to reinforce classroom learning.

Are there any other costs? Is there anything I need to bring?

Computers are provided for each student with all the necessary software installed. All the software used on the course is free to download and use and your tutor will recommend where to find this software for home use. Unfortunately due to the range of hardware and software used by students at home, the College is unable to provide advice on installation issues.

If you wish to copy the programs you produce on the course please bring a USB key or have access to a cloud service such as Google Drive or Dropbox. A pen and notepad for note taking is also advised.

When I've finished, what course can I do next?

Introduction to SQL and Microsoft SQL Server.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

Reviews
Tutor Biographies
We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.

Book your place

Course Code: CSQL05

Sun, day, 17 Nov - 17 Nov '19

Duration: 1 session

Full fee: £99.00
Senior fee: £99.00
Concession: £99.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.