Database Design with SQL Server  Short Courses

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

By the end of the course students 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, and pursue independent study of the subject at second-year undergraduate level and beyond.

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Saturday 7 October 2017 10:00 - 16:00
(Includes 1-hour break)
5 weekly classes £560.00 CS1512 Apply Now
Saturday 20 January 2018 10:00 - 16:00
(Includes 1-hour break)
5 weekly classes £560.00 CS1512 Apply Now
Saturday 5 May 2018 10:00 - 16:00
(Includes 1-hour break)
5 weekly classes £560.00 CS1512 Apply Now

Tutor Info

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. He now works as a freelance academic researcher and author, journalist and IT consultant and teaches a wide range of computer science subjects at City, University of London and London Metropolitan University.

Eligibility

Applicants must be IT literate.

English Requirements

Applicants must be proficient in written and spoken English.

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

Teaching and Assessment

Continuous assessment through weekly design and querying exercises

Recommended Reading

The tutor will suggest material during the class.

Application Deadline: