Search

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

1 starting date

  • Starting date:

    • Duration: 5 weeks
    • Time: to
    • Fees: £595 (no VAT)

      1hr lunch break (11:30am-12:30pm)

    • Occurs: Saturday
    • Location: Online
    • Booking deadline:

Want to find out more?

Testimonials

  • 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

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

    Danella Welds

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

    Christopher Rentsch

Database Design with SQL Server Course overview

This beginners Database Design with SQL short course will teach you:

  • How to design databases based on real-world situations
  • How to create and populate databases using SQL Server Management Studio
  • How to create SQL queries to a professional level
  • To understand the capabilities of SQL Server and its relationship with the .NET Framework and languages.

Who is it for?

Our Database Design with SQL short course is ideal for beginners looking to learn how databases work and would like to generate and acquire data within companies using MS SQL servers and who wish to attain an educational SQL certificate.

Find out more about our Computer science and computing courses

Timetable

This SQL course takes place over five consecutive Saturdays.

City St George's Short Courses follow the academic year, delivering courses over three terms. These include:

  • Autumn - October
  • Spring - January
  • Summer - April

Benefits

  • Our SQL courses are led by an expert tutor, with unmatched experience teaching database design with SQL
  • Accessible online classes
  • Awarded a City St George's, University of London certificate on completion

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

Assessment and certificates

You will be awarded an official City St George's, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.

Assessment

Continuous assessment through weekly design and querying exercises.

Eligibility

You must be IT literate.

English requirements

Applicants must be proficient in written and spoken English.

Recommended reading

The tutor will suggest material during the class.

Tutor

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

City St George's Short Courses: Why Study at City St George's?

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. Glimpse inside our short course community.

Have a question?

What's Happening