This course is for those who have some experience of database design and querying and who would like to take these skills to a higher level.
It broadens student’s 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.
|Start Date||Start Time||Duration||Cost||Course Code||Apply|
|Tuesday 1 May 2018||18:30 - 20:30||10 weekly classes||£560.00||CS2590||Apply Now|
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 London and London Metropolitan University.
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.
Applicants must be proficient in written and spoken English.
What will I learn?
Teaching and Assessment
Continuous assessment through weekly exercises covering the key topics introduced in the lectures
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)
"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)