|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-art-of-database-design/
课程评论：没有评论
课程名称：《数据库设计艺术》 概述： 《数据库设计艺术》是一门旨在提升数据库设计技能的课程，尤其适合有一定基础的高级或专家级数据库设计师和开发人员。课程从关系数据库的安装及其工具开始，通过详细介绍及最佳实践，涵盖了多个业务领域的数据库设计。 课程内容包括： - 税onomy、数据仓库、国际化/本地化和数据库测试等重要主题。 - 实战技巧，如实时库存水平计算、位运算、进阶数据搜索、复数形式处理、基础查询优化等。 - 制作自动化数据库测试的各种类型脚本。 此外，课程提供了四种最流行的关系数据库（Oracle、SQL Server、MySQL和PostgreSQL）的完整源代码，所有涉及的数据库和工具均可免费使用。学员可以根据需求选择其他数据库工具，源代码也兼容其他类似数据库。 本课程分享了命名约定和“乌鸦脚标记法”，帮助学员通过每个章节的学习，与讲师同步进行。课程共包含43节讲座，时长约2小时，结合完整的脚本，旨在帮助学员建立强大的实践理解和灵活的解决方案。 学习要求： - 学员需具备在任意关系数据库中创建基本对象（如表、视图、索引、外键及其他约束）的经验。 - 熟悉前三种规范化形式和连接，并有一定的编程经验。 - 通过创建表、视图、索引和存储过程，理解实际问题及未来数据库设计中的可能解决方案。 每个章节均设有练习，鼓励学员灵活运用所学知识。课程最后还提供创建用户、权限和数据库对象的完整脚本，以便学员根据所选的解决方案独立开展项目。
Upgrade your database design skills with new ideas and solutions. Starting with the installation of the relational database and its tools, and with an introduction to each subject, this course will take you through database design best practices in various business domains: taxonomy.warehousing.internationalization/localization and,database testing It shows you the techniques of: a live stock level calculations, bitwise operations on relations, localization, advanced data searching,plural forms, basic query optimization, creating automated database tests of various tests types, etc. It includes the source codes of the complete course for the 4 most popular relational databases: Oracle, SQL Server, MySQL, and PostgreSQL. All the databases (express editions) and tools (freeware or trial) used in the course can be used completely free of charge. You can choose other databases and tools if you think they are more suitable for you. The source code from the scripts will work on some other databases that are more or less compatible with the listed ones. With a help of naming convention and crow's foot notation you'll be able to work alongside the author as you work through each chapter. It is not for beginners!!! Suitable for advanced or expert database designers/developers, through this course of 43 lectures and 2 hours of content and complete scripts for most popular relational databases, you'll learn and establish a strong understanding of the practical and flexible solutions in the field of database design. You need to have experience in creating all the basic objects in any of the relational databases: tables, views, indexes, foreign keys and,other constraints. It would be preferable to know at least first three forms of normalization, joins, as well as that you have some experience in programming. By creating tables, views, indexes, and stored procedures you'll understand practical problems and possible solutions in your future database design practice. Almost every chapter has exercises to encourage you to think of just learned. Complete with full scripts of creating users, privileges, and database objects for each chapter, you'll be able to work on your own solution as a branch of selected solution from the course.
