Computer Science / SSMS (SQL Server Management Studio)

Database Design with SQL Server Management Studio (SSMS)

بواسطة: 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)
الذهاب الي الدورة

Database Design with SQL Server Management Studio (SSMS)

بواسطة: Coursera

  • Coursera
  • مدفوعة
  • الإنجليزية
  • متاح شهادة
  • متاح في أي وقت
  • beginner
  • English
MessagesTimelineExceptionsViews14RouteQueries7Models6GateSessionRequest
8.1.2PHP Version552msRequest Duration2MBMemory UsageGET ar/الدورات/{slug}Route
    • Booting (174ms)
    • Application (377ms)
    • 1 x Application (68.29%)
      376.95ms
      1 x Booting (31.59%)
      174.39ms
      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 ar/الدورات/{slug}
      middleware
      web, localize:ar
      controller
      App\Http\Controllers\CourseController@show
      as
      ar.courses.show
      namespace
      prefix
      /ar
      where
      file
      app/Http/Controllers/CourseController.php:17-35
      7 statements were executed263ms
      corspedia
      • select * from `courses` where `slug_ar` = 'database-design-with-sql-server-management-studio-(ssms)' limit 1
        5.17ms/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-01 22:20:57' where `id` = 1979
        256ms/app/Http/Controllers/CourseController.php:21corspedia
        Metadata
        Bindings
        • 0. 2025-06-01 22:20:57
        • 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)
        240μ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)
        220μ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
        250μ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
        250μ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
        Qnh9dVIzCbp8xkeVUPAaTah3ltXXjnvhRluXWUYd
        locale
        ar
        _previous
        array:1 [ "url" => "https://www.corspedia.com/ar/%D8%A7%D9%84%D8%AF%D9%88%D8%B1%D8%A7%D8%AA/databa...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /ar/%D8%A7%D9%84%D8%AF%D9%88%D8%B1%D8%A7%D8%AA/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 => "3.143.246.80"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.143.246.80"
  ]
  "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 => "949219eb1945f60b-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" => "3.143.246.80"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "3.143.246.80"
  "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" => "949219eb1945f60b-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" => "57372"
  "REMOTE_ADDR" => "172.70.130.35"
  "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" => "/ar/%D8%A7%D9%84%D8%AF%D9%88%D8%B1%D8%A7%D8%AA/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" => 1748816457.7125
  "REQUEST_TIME" => 1748816457
]
        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 => "Sun, 01 Jun 2025 22:20:58 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVYQkFSTmRRU2VEYW92cnBBOTFweGc9PSIsInZhbHVlIjoiYVhwVTU2VXpmLzlpL05oeHFwNHlsUFgzdHA2eHNyUUM0WlgxRkRnMzAwNmxHWnVJTzdiVk9NMTc3L0NqMmt4OXpKRWdQdWlXUmRiWlprVEZoVEFkeXI3Qmd2V3hwVllJcE0wU1VKdDdoV1VMYWRaaUkxeVVkUHIvWnIwaG5CTnYiLCJtYWMiOiI1OWJkNWExOTBkYjdkZmE4MzNmOGJkZTg3ZDc4ZjlhYjJlYTA0MTEwNTc0NTg0MmUwNmM1ZmUzYTNiNWJjMDUwIiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 00:20:58 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InVYQkFSTmRRU2VEYW92cnBBOTFweGc9PSIsInZhbHVlIjoiYVhwVTU2VXpmLzlpL05oeHFwNHlsUFgzdHA2eHNyUUM0WlgxRkRnMzAwNmxHWnVJTzdiVk9NMTc3L0NqMmt4OXpKRWdQd ▶"
    1 => "laravel_session=eyJpdiI6IitGdnVBRTB6aVA4Y2FGbnY1TnJMbXc9PSIsInZhbHVlIjoiWDh4OUdtbm01T21NcTM4ZTNSbHN2UnV3TVFieWtoM0x1ang0bmpqd2lkK3JvVEtPRjNlTUxxelkvbTh5QlJBdGlXRVhMSmRTTzQzd2J1djV3MlQ5bGJMZ3B4enMvc1QwSjBydzJqVFp1RW9SWHNQd3RIQ0hDMFd5bzZuV09tNVEiLCJtYWMiOiI2YzRkOGEzOGZmZGEzYjFiMzAxM2UxMTViMGFkZDIxNTI2Njc3ODUwYzA1MGI5MTQ4YmZlYmI0ZjM1NjY3YTI2IiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 00:20:58 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IitGdnVBRTB6aVA4Y2FGbnY1TnJMbXc9PSIsInZhbHVlIjoiWDh4OUdtbm01T21NcTM4ZTNSbHN2UnV3TVFieWtoM0x1ang0bmpqd2lkK3JvVEtPRjNlTUxxelkvbTh5QlJBdGlX ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVYQkFSTmRRU2VEYW92cnBBOTFweGc9PSIsInZhbHVlIjoiYVhwVTU2VXpmLzlpL05oeHFwNHlsUFgzdHA2eHNyUUM0WlgxRkRnMzAwNmxHWnVJTzdiVk9NMTc3L0NqMmt4OXpKRWdQdWlXUmRiWlprVEZoVEFkeXI3Qmd2V3hwVllJcE0wU1VKdDdoV1VMYWRaaUkxeVVkUHIvWnIwaG5CTnYiLCJtYWMiOiI1OWJkNWExOTBkYjdkZmE4MzNmOGJkZTg3ZDc4ZjlhYjJlYTA0MTEwNTc0NTg0MmUwNmM1ZmUzYTNiNWJjMDUwIiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 00:20:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVYQkFSTmRRU2VEYW92cnBBOTFweGc9PSIsInZhbHVlIjoiYVhwVTU2VXpmLzlpL05oeHFwNHlsUFgzdHA2eHNyUUM0WlgxRkRnMzAwNmxHWnVJTzdiVk9NMTc3L0NqMmt4OXpKRWdQd ▶"
    1 => "laravel_session=eyJpdiI6IitGdnVBRTB6aVA4Y2FGbnY1TnJMbXc9PSIsInZhbHVlIjoiWDh4OUdtbm01T21NcTM4ZTNSbHN2UnV3TVFieWtoM0x1ang0bmpqd2lkK3JvVEtPRjNlTUxxelkvbTh5QlJBdGlXRVhMSmRTTzQzd2J1djV3MlQ5bGJMZ3B4enMvc1QwSjBydzJqVFp1RW9SWHNQd3RIQ0hDMFd5bzZuV09tNVEiLCJtYWMiOiI2YzRkOGEzOGZmZGEzYjFiMzAxM2UxMTViMGFkZDIxNTI2Njc3ODUwYzA1MGI5MTQ4YmZlYmI0ZjM1NjY3YTI2IiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 00:20:58 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IitGdnVBRTB6aVA4Y2FGbnY1TnJMbXc9PSIsInZhbHVlIjoiWDh4OUdtbm01T21NcTM4ZTNSbHN2UnV3TVFieWtoM0x1ang0bmpqd2lkK3JvVEtPRjNlTUxxelkvbTh5QlJBdGlX ▶"
  ]
]
        session_attributes
          0 of 0   
        array:5 [▼
  "_token" => "Qnh9dVIzCbp8xkeVUPAaTah3ltXXjnvhRluXWUYd"
  "locale" => "ar"
  "_previous" => array:1 [▶
    "url" => "https://www.corspedia.com/ar/%D8%A7%D9%84%D8%AF%D9%88%D8%B1%D8%A7%D8%AA/database-design-with-sql-server-management-studio-%28ssms%29"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]