Database Design with SQL Server

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

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 8 October 2016 10:00 - 16:00

(Includes 1-hour break) 5 weekly classes £540.00 CS1512 Apply Now Saturday 21 January 2017 10:00 - 16:00

(Includes 1-hour break) 5 weekly classes £540.00 CS1512 Apply Now Saturday 6 May 2017 10:00 - 16:00

(Includes 1-hour break) 5 weekly classes £540.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 London and London Metropolitan University. Eligibility Applicants must be IT literate. 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

  • Management
  • Database Design
  • Server
  • IT
  • Database
  • SQL
  • Database training
  • English
  • Design
  • University
  • IT Management

Course programme

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

Additional information

Teaching and Assessment