|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-read-database-like-an-expert/
课程评论：没有评论
Coursera 课程：“像专家一样读取数据库” 总结 本课程旨在教授学员如何高效地理解和操作不熟悉或无文档的数据库。通过掌握一套方法和技术，学员将能够快速定位数据库信息，成为团队中不可或缺的“数据库向导”。 **课程目标:** * **定位与理解:** 快速有效地在数据库中导航，理解其结构和内容。 * **提升效率:** 帮助分析师更快地编写出高质量的查询，并理解数据库对系统功能的影响。 * **设计借鉴:** 为数据库设计者提供利用现有数据库进行学习、评估和模仿的资源。 * **系统文档:** 使开发者能够将数据库视为支持系统的有效文档。 **学习方法:** 课程以一个延伸式教程的形式展开，演示者将使用 Microsoft 的示例数据库，逐步记录自己探索数据库的方法。尽管使用了 SQL Server 工具，但所教授的方法普遍适用于大多数 SQL 数据库。学员可以选择跟随实践，也可以选择观察学习。 **适合人群:** * 数据分析师 * 有志于系统或数据库设计的初学者 * 软件开发者 **核心价值:** 掌握“像专家一样读取数据库”的能力，能够让您自信地应对未知数据库的挑战，显著提升工作效率和专业价值。本课程承诺将带来惊喜和乐趣。
What would you do if you were presented with an unfamiliar database and no documentation? When you have completed this course you will be able to answer this question. You will have a plan, a method and several techniques you can use. This course is for: AnalystsAspiring System or Database DesignersDevelopers. You will learn how to find your way around a database quickly and efficiently. You can become the "go to" person in your specialisation simply by being able to "read a database like a book". You become the person with the map, or the book of instructions! If you are an analyst this course will enable you to write better queries more quickly, and you will learn how the database influences what the system can do.If you are moving into database design, learning to "read" will allow you to use existing databases as a resource which you can understand, criticise and copy.As a developer this course shows you how to use the database as documentation for the system it supports. I wrote this course as an extended tutorial. I started with one of Microsoft's example databases and documented the method I use as I went through it. Although I used SQL Server and the associated tools, the method is applicable to most SQL databases. We will go through the same journey together and you will learn what I discovered along the way. You can choose to repeat what I do yourself to gain experience with the technique, or you can choose simply to observe. Come along! Sign up! There are some surprises and a lot of fun to be had!
