A beginner's guide to SQL
Time: 10:00 - 17:00
Location: KS - Keeley Street
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
Course Code: CSQL07
Duration: 1 session
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.