Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us & online events
  6. Student support
  7. International students
  8. Order a prospectus
  9. Ask a student
  1. Short courses
  2. Courses
Study at City

Database Design with SQL Server Short Course

Key information

Choose a start date
To be confirmed
To be confirmed
To be confirmed
To be confirmed
Course Code:
To be confirmed
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed
Covid-19 update: The learning doesn't have to stop, join our online community. We will be delivering courses remotely until further notice. Live tutor support and virtual lessons will take place during advertised teaching hours. The classes are taught in small groups, so you'll get lots of support from your tutor. Book now.

The Database Design with SQL server short course is designed for those interested in both designing databases and then implementing them to a professional standard using MS SQL Server.

Why choose this course?

This beginner’s Database Design with SQL short course is ideal for those who wish to learn how databases work and would like to generate and acquire data within companies using MS SQL servers.

Classes take place on Saturdays once a week for five weeks, in our central London location. They are led by an expert tutor, with unmatched experience teaching database design with SQL.

Course overview

By the end of the course you will be able to:

  • Design databases based on real-world situations;
  • Create and populate databases using SQL Server Management Studio;
  • Create SQL queries to a professional level;
  • Understand the capabilities of SQL Server and its relationship with the .NET Framework and languages;
  • Pursue independent study of the subject at second-year undergraduate level and beyond.
  • Tim Sandman

    “ I really learnt a great deal about how databases work which I just did not get from any books I read. The course had an immediate impact on my job where I can now use what I learnt in the course. ”

    Tim Sandman

    Former student

  • “ The course was very well presented with engaging style that provided much in the way of real world examples to apply knowledge ”

    Denella Welds

    Former student

  • “ I would recommend the course to anyone who works with SQL Server on a regular basis. I think it's easily the best classroom based SQL Database Course currently available in London due to its combination of Content, Duration and Price. ”

    Stephen Foy

    Former student

  • “ This class was the perfect beginning to understanding and applying SQL database design and querying to my own work. ”

    Christopher Rentsch

    Former student

What will I learn?

What will I learn?

  • Introduction to Relational Database Theory
  • Database Design
  • Entity relationship modelling
  • Normalisation
  • The Data Dictionary
  • Indexes, Integrity and Constraints
  • Implementing the Design
  • Creating, updating and deleting databases and tables using SQL Server Management Studio
  • Updating tables using SQL Server Management Studio
  • Querying Data
  • Introduction to SQL: the SELECT statement, filtering with the WHERE clause, joining tables with JOIN, sorting with ORDER BY and aggregating with GROUP BY. Basic Boolean logic.
  • Advanced SQL: nested queries, correlated queries, derived queries and UNIONS.
  • Introduction to programming SQL Server with T-SQL and the .NET Framework
  • Introduction to Client programming with Visual Studio



Prerequisite knowledge

You must be IT literate.

English requirements

You must be proficient in written and spoken English.

Teaching & assessment

Teaching & assessment

Continuous assessment through weekly design and querying exercises.

Recommended reading

Recommended reading

The tutor will suggest material during the class.

Tutor information

  • Mark Robbins

    Mark Robbins was for many years a Project Manager working for the government, the BBC and the NHS, where he led large teams that designed and implemented many strategic national networking and messaging systems.

    Mark now works as a freelance academic researcher and author, journalist and IT consultant and teaches a wide range of computer science subjects at London Metropolitan University.

Next steps

This Advanced Database Concepts with SQL Server Short Evening Course takes your pre-existing knowledge of database design and querying to the next level.…