关系数据库基础训练

关系数据库基础训练

在当今大数据的时代中,了解如何使用关系数据库为某种现象建模是一项宝贵的技能。从政府机构雇员到游戏玩家,各种各样的用户都依赖于关系数据库来进行日常操作。在本课程中,请与Adam Wilbert一起学习创建用于解决实际问题的数据库的关系模型所需要的基础。Adam讨论了适用于包括SQL Server,Oracle,Access,MySQL和PostgreSQL等多种平台的概念。了解数据存储的基础知识,查看数据表的结构,并学习如何使用实体关系设计工具来设计你的关系数据库。另外,探索数据完整性和验证,表关系,编写查询等。

主题包括:

The basics of data storage Choosing an entity-relationship design tool Using primary keys to identify records What to consider when naming objects Creating a unique constraint Establishing table indexes Relating tables with foreign keys One-to-many and one-to-one relationships Normalization Writing SELECT queries in SQL

课程信息

  • 英文名称:Relational Databases Essential Training
  • 时长:2小时12分
  • 字幕:英语

课程目录

  1. Organize data with the relational model
  2. What you should know
  3. A brief introduction to data storage
  4. E.F. Codd's relational model
  5. What the CRUD?
  6. Relations, tuples, tables, and records
  7. Develop a model of the real world
  8. Choose an ER design tool
  9. Design a table
  10. Attribute data types
  11. Use primary keys to identify records
  12. Object naming considerations
  13. Data constraints
  14. Create a unique constraint
  15. Required attributes and null values
  16. Define a default value
  17. Establish table indexes
  18. Add check constraints
  19. Relate tables with foreign keys
  20. Diagram a relationship
  21. Relationship optionality and cardinality
  22. One-to-many relationships
  23. One-to-one relationships
  24. Many-to-many relationships
  25. Self joins
  26. Cascade changes
  27. Relational database normal forms
  28. When not to normalize
  29. Convert the ER diagram to a database
  30. Data definition queries
  31. Data manipulation queries
  32. Write database select queries
  33. Create a database view
  34. Graph databases
  35. Document databases
  36. Next steps

评论