Database Design with SQL Server

City University London
En Islington (Inglaterra)

Precio a consultar

Información importante

  • Short course
  • Islington (Inglaterra)
  • Cuándo:
    A definir
Descripción

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.

Información importante
Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Islington
Northampton Square, EC1V 0HB , London, Inglaterra
Ver mapa

¿Qué aprendes en este curso?

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

Programa académico

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

Información adicional

Teaching and Assessment