4.2 Read 58 reviews
Overview
What you will learn
This Database Design with SQL Server course offered by City, University of London will teach you:
- How to design databases based on real-world situations
- How to create and populate databases using SQL Server Management Studio
- How to create SQL queries to a professional level
- To understand the capabilities of SQL Server and its relationship with the .NET Framework and languages.
Programme Structure
The program focuses on:
- 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
- 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.
- Pprogramming SQL Server with T-SQL and the .NET Framework
- Client programming with Visual Studio
Key information
Duration
- Part-time
- 1 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
English
Delivered
Online
Disciplines
Data Science & Big Data View 43 other Short Courses in Data Science & Big Data in United KingdomAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- You must be IT literate.
- Applicants must be proficient in written and spoken English.
Tuition Fee
To always see correct tuition fees
-
International
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 1 months. -
National
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 1 months.
Funding
Improve page content