Database Design with SQL Server  Short Courses

The Database Design with SQL Server short 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 you will be able to (i) design databases, based on real-world situations; (ii) create and populate databases using SQL Server Management Studio; (iii) create SQL queries to a professional level; (iv) understand the capabilities of SQL Server and its relationship with the .NET Framework and languages; and (v) pursue independent study of the subject at 2nd year undergraduate level and beyond.

Students must bring their own laptop to this class. University computers are not used. Supported operating systems are Windows XP and Windows 7. Please note that there is no support for Windows Vista.

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Monday 3 October 2011 18:30 - 20:30 10 weekly classes £420.00 CE1512 Course Full
Wednesday 5 October 2011 18:30 - 20:30 10 weekly classes £420.00 CE1512 Apply Now
Monday 16 January 2012 18:30 - 20:30 10 weekly classes £420.00 CE1512 Course Full
Wednesday 18 January 2012 18:30 - 20:30 10 weekly classes £420.00 CE1512 Apply Now
Monday 23 April 2012 18:30 - 20:30 10 weekly classes £420.00 CE1512 Apply Now
Saturday 28 April 2012 10:00 - 16:00 5 weekly classes £420.00 CE1512 Apply Now

Tutor Info

Mark Robbins was for many years a Project Manager working for the government, the BBC and the NHS, where he lead 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 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
  • 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, using WHERE to filter data, sorting using ORDER BY
  • Advanced SQL 1: aggregating data using GROUP BY, aggregate functions
  • Advanced SQL 2: joining tables, nesting queries
  • Introduction to programming SQL Server with T-SQL and the .NET Framework
  • Stored Procedures and User-Defined Functions
  • Introduction to Client programming with Visual Studio

Teaching and Assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.

Recommended Reading

The tutor will suggest material during the class.

Application Deadline: