A beginner's guide to SQL

Course Dates: 03/10/20 - 10/10/20
Time: 10:00 - 13:00
Location: Online

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 will be delivered online. See the ‘What is the course about?’ section in course details for more information.

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.

This is a live online face-to-face course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

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?



This course will be delivered online, and will involve tutor presentation and class discussion. Student preparation and homework outside class times is strongly encouraged. To fully participate in this online class you will need:
- An email address
- A reliable internet connection
- A computer/laptop/tablet with a fully updated browser (preferably google chrome). Your device will need a microphone, and preferably a camera.

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

There are no additional costs.

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

Introduction to SQL and Microsoft SQL Server. You might want to explore courses in programming languages such as: Introduction to Python, Introduction to C#, Introduction to Java, Introduction to R programming.

Reviews
Tutor Biographies
Demetrios Skamiotis

Demetrios is a very experienced educator and software developer. He has a degree and Masters degree in computing and his IT/computing experience spans 20 years. Starting out in languages like Pascal, C++ and Python, Demetrios has worked as a software developer and a very succesful Computing educator and head of department for over 15 years. He has managed to leverage his consultancy work along with his vast teaching experience to design and deliver courses for adults. His courses aim to be cutting edge (including references to modern technologies such as Django, Flask, web scraping). The aim is to design courses which are engaging, fun, and relevant, allowing students to be able to instanlt walk out of the session and be able to implement a solution based on the learning.

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.

Book your place

Course Code: CSQL03

Sat, day, 03 Oct - 10 Oct '20

Duration: 2 sessions (over 2 weeks)

Full fee: £129.00
Senior fee: £129.00
Concession: £129.00

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. 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.