وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Practical Database Design: Implementing Responsible Data Solutions with SQL Querying

سرفصل های دوره

In this hands-on course, learn the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. Instructor Brandeis Marshall takes you through a practical application of database design, database implementation, and data querying to determine when SQL querying is more appropriate. Learn how to develop effective SQL queries and leverage SQL as part of your responsible/ethical data practices. Brandeis takes you through the full arc of a database project, and finishes the course with a project that lets you apply all you’ve learned.


01 - Introduction
  • 01 - Designing and implementing a data model
  • 02 - What you should know

  • 02 - 1. Business Rule Development
  • 01 - How databases help businesses
  • 02 - The DIKW Model
  • 03 - Whats a business rule
  • 04 - A business rule vs. a business operation
  • 05 - A business rule vs. a business practice
  • 06 - A business rule vs. a business policy
  • 07 - Example business rules

  • 03 - 2. Database Design
  • 01 - Entities and relationships
  • 02 - Cardinalities
  • 03 - Scoping the database requirements
  • 04 - Analyzing the overall data requirements
  • 05 - Connecting entities, relationships, and business rules
  • 06 - Identifying data integrity requirements

  • 04 - 3. Data Generation and Datasets
  • 01 - The data youre given Now what
  • 02 - Asking questions of the data
  • 03 - The data youre creating Pros and cons
  • 04 - Asking questions of your made-up data

  • 05 - 4. Database Implementation
  • 01 - Overview of MySQL Workbench
  • 02 - Creating entities in MySQL Workbench
  • 03 - Creating relationships in MySQL Workbench
  • 04 - Confirming identifying and non-identifying relationships
  • 05 - Creating the database schema

  • 06 - 5. SQL Querying
  • 01 - Overview of the SELECT statement
  • 02 - Another toy dataset
  • 03 - SELECT-FROM clauses
  • 04 - SELECT-FROM-WHERE clauses
  • 05 - GROUP BY and ORDER BY clauses

  • 07 - 6. Final Project
  • 01 - Bringing it all together
  • 02 - Final project The Brainery

  • 08 - Conclusion
  • 01 - Next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 42157
    حجم: 281 مگابایت
    مدت زمان: 136 دقیقه
    تاریخ انتشار: ۷ دی ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید