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). 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.
Manisha has been working as an IT Consultant for over 25 years. Manisha has worked for IBM, Shell, Met Police, MoD, DERA and the United Nations amongst others. My career has taken me all over the world and during this time I have held various positions from Computer Programmer to Programme Manager. I found my love for programming after I completed my Computer Science degree at Manchester University, at a time when computers and computing were very different. I started my career as an Oracle Database programmer, using Oracle Forms with PL/SQL. Fast forward 25 years and I now teach computer languages and programming for fun.
Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.