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