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

Advanced Database Concepts 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.

This Advanced Database Concepts with SQL Server course has been designed to teach you how to produce complex databases using SQL servers.

Why choose this course?

This course is for those who have some experience of database design and querying and who would like to take their skills to a higher level.

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

Students should have completed the Database Design with SQL Server course or have a good working knowledge of basic database design techniques, SQL querying and basic procedural programming gained using any major RDBMS.

Course overview

The short course aims to broaden your database capabilities by including:

  • Advanced design
  • A comprehensive introduction to T-SQL programming
  • XML
  • A review of SQL Server’s business intelligence capabilities
  • Server architecture
  • Administration and advanced querying.

What will I learn?

What will I learn?

By the end of the Advanced Database Concepts with SQL Server course you will be able to:

  • Produce complex database designs based on advanced ERM techniques
  • Understand design concepts in other database areas such as Data Warehousing
  • Understand how to use the XML capabilities of SQL Server
  • Understand the fundamentals of OLAP and Data Mining applications and their implementation using SQL Server Data Tools
  • Write sophisticated T-SQL stored procedures, UDFs, Triggers and Cursors
  • Learn advanced querying techniques for complex data analysis and Business Intelligence requirements
  • Master a broad range of administration, security and configuration issues
  • Pursue independent study of the subject at 3rd year undergraduate level.



Prerequisite knowledge

You should have completed the Database Design with SQL Server short course or have a good working knowledge of basic database design techniques, SQL querying and basic procedural programming gained using any major RDBMS.

English requirements

You must be proficient in written and spoken English.

Teaching & assessment

Teaching & assessment

Continuous assessment through weekly exercises covering the key topics introduced in the lectures.

Recommended reading

Recommended reading

Core Texts:

  • Database Systems - A Practical Approach to Design, Implementation and Management" 5th ed., Thomas Connolly and Carolyn Begg (Addison Wesley)
  • Professional SQL Server 2008 Programming, Robert Vieira (Wrox)

Recommended Texts:

  • A Developer's Guide to SQL Server, Bob Beauchemin and Dan Sullivan (Addison Wesley)
  • Inside Microsoft SQL Server: The Storage Engine, Kalen Delaney (Microsoft Press)
  • Inside Microsoft SQL Server 2008: T-SQL Querying, Itzik Ben-Gan, (Microsoft Press)
  • Professional SQL Server 2008 Administration, Brian Knight et al., (Wrox)
  • Data Mining with Microsoft SQL Server 2008, Jamie MacLellan et al., (Wiley)

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.