Database Design with SQL Server
Short course
In Islington
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
Start date
Reviews
Subjects
- Management
- Database Design
- Server
- IT
- Database
- SQL
- Database training
- English
- Design
- University
- IT Management
Course programme
- 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