Design professional databases from the ground up. This course introduces the key concepts of relational databases and shows you how to implement them using Microsoft SQL Server.
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 courses
Timetable
This SQL course takes place over five consecutive Saturdays.
City St George's 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 St George's, 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 St George's, 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.
Tutor
-
Konstantinos Karoudis
Konstantinos Karoudis has a Diploma in Electrical and Computer Engineering from Democritus University of Thrace, Greece, and an MSc in Information Technology from University of Stuttgart, Germany. He has worked on many developer roles for companies such as IBM Germany Research and Development Lab and BMW Research and Innovation Centre.
Konstantinos is currently working towards a PhD at London Knowledge Lab, Birkbeck, University of London, where he is also part of the ‘LIBE: Supporting Lifelong Learning with Enquiry-Based Education’ project developing a personalisation engine that enhances learners’ experience.
