A beginner's guide to SQL

City Lit

Course

In London

£ 99 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

We interact with databases nearly everyday of our lives. Examples of these interactions are when we use our Oyster Card to travel on the underground, use Sat Nav to follow a route in our car, search on the internet, buy goods in a supermarket or online, or even look up a contact on our phone, all these tasks use a database to work.

Structured Query Language or SQL for short is the standard language used to manage nearly all database systems. Using the popular and free SQLite database management system used extensively by Apple and Microsoft you will learn how to create, manage and query databases.

Facilities

Location

Start date

London
See map
Keeley Street, Covent Garden, WC2B 4BA

Start date

Different dates availableEnrolment now open

About this course

• Describe the purpose and components of a database
• Use SQL to create a database
• Use SQL to store data in a database
• Use SQL to add, update and delete data
• Use SQL to query our data.

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Systems
  • Database training
  • SQL
  • Database
  • Database Management

Course programme

We will explore the theory behind database managements systems identifying the key concepts and terminology that underpins all database systems. We will also use a database management system to explore the fundamental skills needed to use SQL to create, manage and query a database.

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.

Additional information

Introduction to SQL and Microsoft SQL Server. General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00. See the course guide for term dates and further details

See related categories

A beginner's guide to SQL

£ 99 VAT inc.

The best SQL Server courses

See all

See all