Database Design with SQL Server Management Studio (SSMS)

Overview

Class Central Tips

In this 1-hour 40-minutes long project-based course, you will learn how to design a database system by identifying the entities and their attributes as well as the relations between these entities. Furthermore, you will get to implement the database system that you have designed using Microsoft SQL Server through SQL Server Management Studio. This project will have you explore key concepts of database design and will have you get introduced to the building blocks of the world of databases. Note: This project works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Syllabus

Project Overview

By the end of this project, you will create a database for a digital platform that hosts artists’ work, the platform offers a chance for artists to market their work by displaying their talents. Database design is a skill that is very much required in the job market and is gaining more and more popularity due to the rise of topics such as Data Science and this project will walk you through the first steps of this field. The project will explore key concepts of database design such as identifying entities, attributes, relations, and data insertion. In this project, we will be using Microsoft SQL Server with SQL Server Management Studio to implement the database system, so the learner will get to have a hand on experience with SQL and be familiar with the syntax of Microsoft SQL Server.