A beginner's guide to SQL

Course Dates: 26/09/21
Time: 10:00 - 17:00
Location: KS - Keeley Street
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.
This course is FREE if a) you live in London and your job is at risk of redundancy or b) you are either on Jobseekers' Allowance (JSA) or Employment & Support Allowance(ESA) or c) you receive other state benefits (including Universal Credit) and your monthly take home pay is less than £343. For more information click here
This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
Book your place
In stock
Full fee £129.00 Senior fee £103.00 Concession £65.00

Course Code: CSQL07

Sun, day, 26 Sep - 26 Sep '21

Duration: 1 session

Or call to enrol:020 7831 7831

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. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

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, Introduction to MongoDb. You might want to explore some programming languages such as: Introduction to Python, Introduction to C#, Introduction to Java, Introduction to R programming.

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.