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 Version359msRequest Duration2MBMemory UsageGET en/courses/{slug}Route
    • Booting (222ms)
    • Application (136ms)
    • 1 x Booting (61.91%)
      222.09ms
      1 x Application (37.85%)
      135.76ms
      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 executed7.25ms
      corspedia
      • select * from `courses` where `slug_en` = 'database-design-with-sql-server-management-studio-(ssms)' limit 1
        5.54ms/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-06-04 12:30:31' where `id` = 1979
        690μs/app/Http/Controllers/CourseController.php:21corspedia
        Metadata
        Bindings
        • 0. 2025-06-04 12:30:31
        • 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)
        220μ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
        210μ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
        180μ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
        240μ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
        Oc9qWaPpuB9518SOdvhEkZjuiC9ApJ2sRnRqpkH7
        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-%28ssms%29
        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 => "13.58.229.242"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "13.58.229.242"
  ]
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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 => "94a77124eac1e10c-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"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "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" => "13.58.229.242"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "13.58.229.242"
  "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_CF_RAY" => "94a77124eac1e10c-ORD"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "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" => "59526"
  "REMOTE_ADDR" => "172.70.127.226"
  "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-%28ssms%29"
  "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" => 1749040231.4467
  "REQUEST_TIME" => 1749040231
]
        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 => "Wed, 04 Jun 2025 12:30:31 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVoTUpXOEVENjZFMFhLSWZSV2crYUE9PSIsInZhbHVlIjoiUk1UTWlUU2tyNWZCRy9YTW5kMENUa3RhTHp6YnMzeTlhWEZMTzhWWWN2b2FieG5zY0RtUDd3cDFJMnZOWVltOEVLRzhYT1NHQTE1UEVVakFkaEV0NlpGbnlSN3ZySXFtZDIyUGRFNm5iNUdkSHJsMFFUVnJrSGhEcThkTTYrakEiLCJtYWMiOiJjM2UzNWNhMGQ0ZjI0OGEzNTFjNDRhZmE5ZWU1ODU1OWQ1YjhjMWIzNDM3MDVkNmRlYjQzNmU3MmQ2MDhjYTlhIiwidGFnIjoiIn0%3D; expires=Wed, 04 Jun 2025 14:30:31 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InVoTUpXOEVENjZFMFhLSWZSV2crYUE9PSIsInZhbHVlIjoiUk1UTWlUU2tyNWZCRy9YTW5kMENUa3RhTHp6YnMzeTlhWEZMTzhWWWN2b2FieG5zY0RtUDd3cDFJMnZOWVltOEVLRzhYT ▶"
    1 => "laravel_session=eyJpdiI6Iit6d2Z6SGp4anBvSXJhcjlmYkR1OXc9PSIsInZhbHVlIjoiZCtDeTVzUUpXanh4MlJlNnBPMmNIMi9sVnYzb1Q4OFlsUzk0NVFMZEpTdVJ0N1dNdTczUjh0OHQ5a0REVmNHTDVid01NN0V1L1R4WEhzNmdwOS9qWGVnRUFYSFpxa0UxSjFPUDEvTmIzaXF1Sy9xTXZCVkE5VkE2SlZ4RWZlSkgiLCJtYWMiOiIyZDdlYWZjZmZiM2M4M2Y0ZDcwZTE0NmEyMDQyNGVkMGYyNGQ1MTc3YzFjOGU1ZmRmZWJkNTgzMTBiYzEzMmY1IiwidGFnIjoiIn0%3D; expires=Wed, 04 Jun 2025 14:30:31 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Iit6d2Z6SGp4anBvSXJhcjlmYkR1OXc9PSIsInZhbHVlIjoiZCtDeTVzUUpXanh4MlJlNnBPMmNIMi9sVnYzb1Q4OFlsUzk0NVFMZEpTdVJ0N1dNdTczUjh0OHQ5a0REVmNHTDVi ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVoTUpXOEVENjZFMFhLSWZSV2crYUE9PSIsInZhbHVlIjoiUk1UTWlUU2tyNWZCRy9YTW5kMENUa3RhTHp6YnMzeTlhWEZMTzhWWWN2b2FieG5zY0RtUDd3cDFJMnZOWVltOEVLRzhYT1NHQTE1UEVVakFkaEV0NlpGbnlSN3ZySXFtZDIyUGRFNm5iNUdkSHJsMFFUVnJrSGhEcThkTTYrakEiLCJtYWMiOiJjM2UzNWNhMGQ0ZjI0OGEzNTFjNDRhZmE5ZWU1ODU1OWQ1YjhjMWIzNDM3MDVkNmRlYjQzNmU3MmQ2MDhjYTlhIiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:30:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVoTUpXOEVENjZFMFhLSWZSV2crYUE9PSIsInZhbHVlIjoiUk1UTWlUU2tyNWZCRy9YTW5kMENUa3RhTHp6YnMzeTlhWEZMTzhWWWN2b2FieG5zY0RtUDd3cDFJMnZOWVltOEVLRzhYT ▶"
    1 => "laravel_session=eyJpdiI6Iit6d2Z6SGp4anBvSXJhcjlmYkR1OXc9PSIsInZhbHVlIjoiZCtDeTVzUUpXanh4MlJlNnBPMmNIMi9sVnYzb1Q4OFlsUzk0NVFMZEpTdVJ0N1dNdTczUjh0OHQ5a0REVmNHTDVid01NN0V1L1R4WEhzNmdwOS9qWGVnRUFYSFpxa0UxSjFPUDEvTmIzaXF1Sy9xTXZCVkE5VkE2SlZ4RWZlSkgiLCJtYWMiOiIyZDdlYWZjZmZiM2M4M2Y0ZDcwZTE0NmEyMDQyNGVkMGYyNGQ1MTc3YzFjOGU1ZmRmZWJkNTgzMTBiYzEzMmY1IiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:30:31 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Iit6d2Z6SGp4anBvSXJhcjlmYkR1OXc9PSIsInZhbHVlIjoiZCtDeTVzUUpXanh4MlJlNnBPMmNIMi9sVnYzb1Q4OFlsUzk0NVFMZEpTdVJ0N1dNdTczUjh0OHQ5a0REVmNHTDVi ▶"
  ]
]
        session_attributes
          0 of 0   
        array:5 [▼
  "_token" => "Oc9qWaPpuB9518SOdvhEkZjuiC9ApJ2sRnRqpkH7"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://www.corspedia.com/en/courses/database-design-with-sql-server-management-studio-%28ssms%29"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]