Computer Science / SSMS (SQL Server Management Studio)

Database Design with SQL Server Management Studio (SSMS)

Brought by: Coursera

Overview

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.

Taught by

Ali Amr Souidan

Computer Science / SSMS (SQL Server Management Studio)
Database Design with SQL Server Management Studio (SSMS)
Go to course

Database Design with SQL Server Management Studio (SSMS)

Brought by: Coursera

  • Coursera
  • Paid
  • English
  • Certificate Available
  • Available at any time
  • beginner
  • English
MessagesTimelineExceptionsViews14RouteQueries7Models6GateSessionRequest
8.1.2PHP Version310msRequest Duration2MBMemory UsageGET en/courses/{slug}Route
    • Booting (211ms)
    • Application (98.36ms)
    • 1 x Booting (68.04%)
      210.78ms
      1 x Application (31.75%)
      98.36ms
      14 templates were rendered
      • public.courses.show (resources/views/public/courses/show.blade.php)3bladefile
        Params
        0
        course
        1
        links
        2
        config
      • public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        classes
      • public.courses.partials.details (resources/views/public/courses/partials/details.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        classes
      • public.layouts.main (resources/views/public/layouts/main.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.layouts.partials.meta (resources/views/public/layouts/partials/meta.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.layouts.partials.navbar (resources/views/public/layouts/partials/navbar.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.auth.profile.partials.links (resources/views/public/auth/profile/partials/links.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
        6
        route
        7
        title
      • public.layouts.partials.flash-session (resources/views/public/layouts/partials/flash-session.blade.php)6bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        course
        4
        links
        5
        config
      uri
      GET en/courses/{slug}
      middleware
      web, localize:en
      controller
      App\Http\Controllers\CourseController@show
      as
      en.courses.show
      namespace
      prefix
      /en
      where
      file
      app/Http/Controllers/CourseController.php:17-35
      7 statements were executed6.05ms
      corspedia
      • select * from `courses` where `slug_en` = 'database-design-with-sql-server-management-studio-(ssms)' limit 1
        4.34ms/app/Http/Controllers/CourseController.php:20corspedia
        Metadata
        Bindings
        • 0. database-design-with-sql-server-management-studio-(ssms)
        Backtrace
        • 17. /app/Http/Controllers/CourseController.php:20
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • update `courses` set `visitors` = `visitors` + 1, `courses`.`updated_at` = '2025-04-28 20:56:30' where `id` = 1979
        720μs/app/Http/Controllers/CourseController.php:21corspedia
        Metadata
        Bindings
        • 0. 2025-04-28 20:56:30
        • 1. 1979
        Backtrace
        • 17. /app/Http/Controllers/CourseController.php:21
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `name_en`, `name_ar`, `topic_id`, `slug_en`, `slug_ar` from `subjects` where `subjects`.`id` in (127)
        200μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `name_en`, `name_ar`, `slug_en`, `slug_ar` from `topics` where `topics`.`id` in (1)
        170μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 25. /app/Http/Controllers/CourseController.php:23
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `institutions` where `institutions`.`id` in (106) and `institutions`.`deleted_at` is null
        200μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `providers` where `providers`.`id` in (2) and `providers`.`deleted_at` is null
        200μs/app/Http/Controllers/CourseController.php:23corspedia
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CourseController.php:23
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `html_files` where `html_files`.`id` = 1970 limit 1
        220μs/app/Models/Course.php:84corspedia
        Metadata
        Bindings
        • 0. 1970
        Backtrace
        • 21. /app/Models/Course.php:84
        • 28. view::public.courses.show:29
        • 30. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 31. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 32. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      App\Models\HtmlFile
      1
      App\Models\Provider
      1
      App\Models\Institution
      1
      App\Models\Topic
      1
      App\Models\Subject
      1
      App\Models\Course
      1
        _token
        h5bTHhEcZzklmaN7w4dMi4GNLEW5ivhkvSHqw540
        locale
        en
        _previous
        array:1 [ "url" => "https://www.corspedia.com/en/courses/database-design-with-sql-server-managemen...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/courses/database-design-with-sql-server-management-studio-(ssms)
        status_code
        200
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        request_request
        []
        request_headers
          0 of 0   
        array:24 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.137.184.154"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "cf-ray" => array:1 [▶
    0 => "93797775388761df-ORD"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.137.184.154"
  ]
  "host" => array:1 [▶
    0 => "www.corspedia.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]
        request_server
          0 of 0   
        array:50 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_CF_CONNECTING_IP" => "3.137.184.154"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_CF_RAY" => "93797775388761df-ORD"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_X_FORWARDED_FOR" => "3.137.184.154"
  "HTTP_HOST" => "www.corspedia.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "corspedia.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "141.95.147.152"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "27086"
  "REMOTE_ADDR" => "172.69.6.212"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/corspedia/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/en/courses/database-design-with-sql-server-management-studio-(ssms)"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/corspedia/public/index.php"
  "PATH_INFO" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1745873790.5401
  "REQUEST_TIME" => 1745873790
]
        request_cookies
        []
        response_headers
          0 of 0   
        array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 28 Apr 2025 20:56:30 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJDREFqaTBTSHJwVURJZGZHOEwvb1E9PSIsInZhbHVlIjoidWI5R3RIbjZEaUUzVytzZXl0MXlpeUtlbGVFQVBldWhhN0dNWXlRM2gwNXNSOGhnL09ub0JiT1A1anlYWFdRc0dPSTRMUm5yRDk2YnhOaHVNYUM1UEpUbzliMXJaOEpQQ09YK1VJMU05emNPbnd1bzlNVThtOXRFTkc3bUwxWTAiLCJtYWMiOiIzMWU5YzNhMTdjZmVkMTE2YmE1MThiYTA3OTZmY2ZmMjM5OGYzZTQ5NDA3ODllNGU1NGI4MmI0MWExZjQ0ODBkIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 22:56:30 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJDREFqaTBTSHJwVURJZGZHOEwvb1E9PSIsInZhbHVlIjoidWI5R3RIbjZEaUUzVytzZXl0MXlpeUtlbGVFQVBldWhhN0dNWXlRM2gwNXNSOGhnL09ub0JiT1A1anlYWFdRc0dPSTRMU ▶"
    1 => "laravel_session=eyJpdiI6IkkyZ3g2K2syclhvQ3VYYS9NZk5URHc9PSIsInZhbHVlIjoiZFNEbVh0eVMyZklFNDdqTnRBQ3djTmlXenlXSGs4N2tqT3diZnRSUWlPek42eU5hbTB1OWhHYi82clR4dFp2RENGM0NaUGFPYjdpdzgvTDluL2Z3SFQwUUowLzBSQmRzbktvbE5JakljeTBhaXVNanVCNStWK1hpeXRRaXNCelUiLCJtYWMiOiJhNTQyOWM4ZDAzNzAwNzkxYWYwNTE4NTYxY2ZlZTg3M2Y4NTJkYzMxMGNiZjI4NDdlZmQ0OTUyMWZiM2EzNGJlIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 22:56:30 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkkyZ3g2K2syclhvQ3VYYS9NZk5URHc9PSIsInZhbHVlIjoiZFNEbVh0eVMyZklFNDdqTnRBQ3djTmlXenlXSGs4N2tqT3diZnRSUWlPek42eU5hbTB1OWhHYi82clR4dFp2RENG ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJDREFqaTBTSHJwVURJZGZHOEwvb1E9PSIsInZhbHVlIjoidWI5R3RIbjZEaUUzVytzZXl0MXlpeUtlbGVFQVBldWhhN0dNWXlRM2gwNXNSOGhnL09ub0JiT1A1anlYWFdRc0dPSTRMUm5yRDk2YnhOaHVNYUM1UEpUbzliMXJaOEpQQ09YK1VJMU05emNPbnd1bzlNVThtOXRFTkc3bUwxWTAiLCJtYWMiOiIzMWU5YzNhMTdjZmVkMTE2YmE1MThiYTA3OTZmY2ZmMjM5OGYzZTQ5NDA3ODllNGU1NGI4MmI0MWExZjQ0ODBkIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 22:56:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJDREFqaTBTSHJwVURJZGZHOEwvb1E9PSIsInZhbHVlIjoidWI5R3RIbjZEaUUzVytzZXl0MXlpeUtlbGVFQVBldWhhN0dNWXlRM2gwNXNSOGhnL09ub0JiT1A1anlYWFdRc0dPSTRMU ▶"
    1 => "laravel_session=eyJpdiI6IkkyZ3g2K2syclhvQ3VYYS9NZk5URHc9PSIsInZhbHVlIjoiZFNEbVh0eVMyZklFNDdqTnRBQ3djTmlXenlXSGs4N2tqT3diZnRSUWlPek42eU5hbTB1OWhHYi82clR4dFp2RENGM0NaUGFPYjdpdzgvTDluL2Z3SFQwUUowLzBSQmRzbktvbE5JakljeTBhaXVNanVCNStWK1hpeXRRaXNCelUiLCJtYWMiOiJhNTQyOWM4ZDAzNzAwNzkxYWYwNTE4NTYxY2ZlZTg3M2Y4NTJkYzMxMGNiZjI4NDdlZmQ0OTUyMWZiM2EzNGJlIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 22:56:30 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkkyZ3g2K2syclhvQ3VYYS9NZk5URHc9PSIsInZhbHVlIjoiZFNEbVh0eVMyZklFNDdqTnRBQ3djTmlXenlXSGs4N2tqT3diZnRSUWlPek42eU5hbTB1OWhHYi82clR4dFp2RENG ▶"
  ]
]
        session_attributes
          0 of 0   
        array:5 [▼
  "_token" => "h5bTHhEcZzklmaN7w4dMi4GNLEW5ivhkvSHqw540"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://www.corspedia.com/en/courses/database-design-with-sql-server-management-studio-(ssms)"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]