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

Relational Databases Essential Training

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

In today’s big-data world, understanding how to model phenomena with a relational database is an invaluable skill. A variety of different users—from government agency employees to gamers—rely on relational databases for everyday operations. In this course, join Adam Wilbert as he covers the fundamentals of the relational model for creating databases of real-world situations. Adam goes over concepts that are applicable to a wide variety of platforms, including SQL Server, Oracle, Access, MySQL, and PostgreSQL. Learn the basics of data storage, review the structure of a data table, and learn how to plan your relational database using an entity-relationship design tool. Plus, explore data integrity and validation, table relationships, writing queries, and more.


01 - Introduction
  • 01 - Organize data with the relational model
  • 02 - What you should know

  • 02 - 1. Get to Know Relational Databases
  • 01 - A brief introduction to data storage
  • 02 - E.F. Codds relational model
  • 03 - What the CRUD
  • 04 - Relations, tuples, tables, and records

  • 03 - 2. Entity Relationship Diagrams
  • 01 - Develop a model of the real world
  • 02 - Choose an ER design tool
  • 03 - Design a table
  • 04 - Attribute data types
  • 05 - Use primary keys to identify records
  • 06 - Object naming considerations

  • 04 - 3. Data Integrity and Validation
  • 01 - Data constraints
  • 02 - Create a unique constraint
  • 03 - Required attributes and null values
  • 04 - Define a default value
  • 05 - Establish table indexes
  • 06 - Add check constraints

  • 05 - 4. Relationships
  • 01 - Relate tables with foreign keys
  • 02 - Diagram a relationship
  • 03 - Relationship optionality and cardinality
  • 04 - One-to-many relationships
  • 05 - One-to-one relationships
  • 06 - Many-to-many relationships
  • 07 - Self joins
  • 08 - Cascade changes

  • 06 - 5. Normalization
  • 01 - Relational database normal forms
  • 02 - When not to normalize

  • 07 - 6. Structured Query Language
  • 01 - Convert the ER diagram to a database
  • 02 - Data definition queries
  • 03 - Data manipulation queries
  • 04 - Write database select queries
  • 05 - Create a database view

  • 08 - 7. Beyond the Relational Model
  • 01 - Graph databases
  • 02 - Document databases

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

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 22094
    حجم: 249 مگابایت
    مدت زمان: 135 دقیقه
    تاریخ انتشار: 9 آبان 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید