Our Database Design with SQL server short course is designed for those interested in designing databases and then implementing them to a professional standard using MS SQL Server.
2 starting dates
Want to find out more?
Testimonials
Database Design with SQL Server Course overview
This beginners Database Design with SQL short course 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.
Who is it for?
Our Database Design with SQL short course is ideal for beginners looking to learn how databases work and would like to generate and acquire data within companies using MS SQL servers and who wish to attain an educational SQL certificate.
Find out more about our Computer science and computing courses
Timetable
This SQL course takes place over five consecutive Saturdays.
City Short Courses follow the academic year, delivering courses over three terms. These include:
- Autumn - October
- Spring - January
- Summer - April
Benefits
- Our SQL courses are led by an expert tutor, with unmatched experience teaching database design with SQL
- Accessible online classes
- Awarded a City, University of London certificate on completion
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
Assessment and certificates
You will be awarded an official City, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.
Assessment
Continuous assessment through weekly design and querying exercises.
Eligibility
You must be IT literate.
English requirements
Applicants must be proficient in written and spoken English.
Recommended reading
The tutor will suggest material during the class.