Advanced Database Design and Management with SQL Server  Short Courses

Advanced Database Design and Management with SQL Server is a short course for those who have some experience of database design and querying and who are now looking to take these skills to a higher level. It will also broaden students' database capabilities by including the areas of advanced management and configuration.

It will also broaden students' database capabilities by including the areas of administration, security, XML and Data Warehousing and Mining.

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Tuesday 4 October 2011 18:30 - 20:30 10 weekly classes £420.00 CE2590 Apply Now
Tuesday 1 May 2012 18:30 - 20:30 10 weekly classes £420.00 CE2590 Apply Now

Tutor Info

Mark Robbins was for many years a freelance 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

Successful completion of Database Design with SQL Server or a good working knowledge of basic database design techniques, SQL querying and basic procedural programming gained using any major RDBMS. 

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

English Requirements

Applicants must be proficient in written and spoken English.

What will I learn?

By the end of the 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 and n-tier architecture
  • Understand how to use the XML capabilities of SQL Server
  • Produce highly advanced SQL queries
  • Write sophisticated T-SQL procedures, UDFs, Triggers and Cursors
  • Appreciate the capabilities of Reporting, Integration and Analysis Services and the other SQL Server add-ons
  • Master a broad range of administration, security and configuration issues.
  • Pursue independent study of the subject at 3rd year undergraduate level.

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

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)

Application Deadline: