HOME
 

Database Design with SQL Server

City University London
Course summary
5 weeks
560 GBP
English
Part time
Open / Scheduled
Next available date: 25/01/2020 - London
Course Dates
London
25/01/2020   (English)
560 GBP
02/05/2020   (English)
560 GBP
Database Design with SQL Server

Course description

Database Design with SQL Server

The Database Design with SQL server short course is designed for those interested in both designing databases and then implementing them to a professional standard using MS SQL Server.

By the end of the course you 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;
  • Pursue independent study of the subject at second-year undergraduate level and beyond.

Suitability - Who should attend?

Prerequisite knowledge

You must be IT literate.

English requirements

You must be proficient in written and spoken English.

Training Course Content

  • 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

Get Inspired! Watch the Video

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. With courses in business, computing, writing, creative industries, languages and law there is something for everyone. Glimpse inside our short course community: hear from our industry-expert tutors and listen to students as they reflect on their learning experience.

About provider

City University London

City University London

City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...


Read more and show all courses with this provider

Contact info

City University London

Northampton Square
EC1V 0HB London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here