Advanced Database Concepts with SQL Server

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

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. Course Information Start DateStart TimeDurationCostCourse CodeApply Tuesday 2 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS2590 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 London and 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. English Requirements Applicants must be proficient in written and spoken English.

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database Design
  • XML training
  • XML
  • Basic
  • Server
  • IT
  • Basic IT training
  • Database
  • SQL
  • Database training
  • Basic IT
  • English
  • Design
  • University
  • Business Intelligence
  • Programming

Course programme

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
  • 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.

Additional information

Teaching and Assessment